Creating a Database Report - Reportizer Documentation

Database report is a report which is based on data from a database.

It is possible to create a new report either by cloning an existing report or by creating a new report from scratch. Here, the latter option is described.

Click Create Report button.
Specify the database. In the list of registered database, select the needed database. If the database not in the list, register it using these steps:
1. Click '...' button to invoke a Open Data Source dialog.
2. Choose needed database interface (except FileSystem).
3. If you chose FD or Interbase, select the database type and fill the connection parameters in the table below. For other interfaces, specify the database file or folder; for folders, chose a corresponding database driver from the drop-down list.
4. Choose a friendly alias for your database and click OK.
Choose the dataset type:
- Table Specify a table from the selected database.
- SQL Query (recommended to use wherever possible) Specify SQL query code, returning a dataset, for example:
```
SELECT payment_date, payments_sum, payment_details
FROM payments
WHERE payment_sum >= 1000
ORDER BY 1
```
Select fields of the data source, for which you wish to automatically create headers, data showing objects and totals expressions. Note, that not selected fields will still available for you later, when you will edit the created report. Click Next.
Select other options (if you wish) and click Finish.

After saving the report, the corresponding repository refreshes its report list and the last created report will be automatically selected, so, you can finish with the visual part of the report in the report builder.

See also

Creating Reports

Report Builder