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. If the opened repository is based on a physical folder, choose Report | Save As... menu to save the report as a new file in this folder. If the opened repository is based on a database, choose Report | Duplicate... menu to save the report in a new database record. 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 examples of 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.

Creating Report (Step 1)

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

Database. Specify a database.

Data set (SQL Query or Table). If your dataset is a table, enter the name of the table from the selected database. If your dataset is a SQL query, type its text in SQL Editor (at the bottom) or load it from file using the corresponding button or simply by dragging and dropping a 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 the way 1 to create your report, where you will be able to specify SQL text without needing to open the query.

Creating Report (Step 2)

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: a Label (located on Column header band) and a 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.

Creating Report (Step 3)

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

Creating Report (Step 4)

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

Creating Report (Step 5)

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

Creating Report (Step 6)

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

When everything is done, click Finish.

Then the program will save the new report to the current repository (if any) or to the folder of your choice. If the repository represents a database, the program will save the new report in the new record of the corresponding database table, so you will be asked to enter key field values to uniquely identify this record and other mandatory fields (if any). If the repository represents a folder from your file system or if there is no open repository yet, then you will be able to save the report as a new file.

After saving the report, the corresponding repository refreshes its report list and the last created report will be automatically opened for editing.

 

See also

 Report Builder

 Grouping Records

 Report Objects

 Building Reports

 Working with Report Template