Reportizer Documentation Contents Index

Creating New Report

Top Previous Next

It is possible to create new report by two main ways:

1. Create report, which is based on the existing one. Select existing report template and choose Report | Save As... menu to save the template with new name. Then change the Data Source properties (if it is needed) and rebuild report objects in Report Builder. In Examples folder, there is a lot of example templates, demonstrating different features of Reportizer reports; you may use them for creating your first reports.

2. Create new report. Click "Create template" button. The new window will appear where you in step-by-step mode can create your report.

On the first step, you specify the data source for your report:

Data source type. Specify database engine (database interface), by which the report should be opened (ADO, BDE, Interbase, or Folders/Files).

Database. Specify database. Click here for more information on how specify the database in Reportizer.

User name and password. Specify user name and password to connect the database, if your database requires that. These parameters are optional. If these parameters are not set, but the database requires them, Reportizer asks to enter them on report preview.

Data set (table name or SQL text). In SQL Editor (at the bottom), specify the data set for the report. It may be a table name from the database, specified above, or SQL query text. You may load the SQL text from file using the corresponding button or simply by dragging file with SQL text into the SQL Editor. If your SQL query contains parameters, clicking Next button will cause the new window appearing, where you will be able to specify parameter data types, default values etc.; click Cancel to skip this (in this case you will be asked to specify parameter data types and values on report preview).

After finishing, click Next to continue.

Note

Moving to next step will cause opening the specified data set. If you use very complex query, which may take long time to open, you may prefer way 1 to create your reports, where you will be able to specify SQL text without needing to open the query.

On the second step, you specify the fields of your data set, which you wish to see in the report. In the left part, you will see all available fields. Use appropriate buttons to select needed fields from this list so that they appear in the list to the right.

After finishing, click Next to continue.

Note

1. For each field you added, Reportizer will create at least two objects: Label (located in "Column header" band) and Database Text (located in Data band) with default size. If the field is numeric, the Expression object may also be added in Totals band. You will be able to resize those objects (as long as delete or create new ones) later, when editing created report template.

2. Fields, which was not added, will still be available to use in report unless you did not change your data set.

On the third step, you specify the the schema (style) of your report. Reportizer will use the specified schema only when creating the report.

On the firth step, you specify the parameters of the printer, which are specific to your report.

On the fivth step, you specify the parameters of the page, which are specific to your report.

On the last step, you specify additional (all are optional) report properties such as report description, grouping records etc.

After finishing, click Finish. Then you will be able to specify the file name for your template. After saving, the template will be automatically opened for editing.

 

See also

 Report Builder

 Grouping Records

 Report Objects

 Building Reports

 Working with Report Template