It is possible
to create new report by two main ways:
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.
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:
Specify a database.
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).
finishing, click Next to continue.
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.
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.
finishing, click Next to continue.
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.
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
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
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.