The Report Writer can be reached via the Report Manager or a Workspace Report.
Report Writer with an example report
The Report Writer has 3 tabs:
2.Report
3.Preview
Each of these will be explained below.
Report Data
When you create a new report, the Visual Query Builder will open, you can create a new query or paste a query from the SQL Editor into the bottom part of the Visual Query Builder.
Report Writer, tab Report Data
You can view the report query or modify it using the Visual Query Builder button on the right.
Report
The Report tab has several sections. On the left you find the report outline and object properties, the top holds the toolbars with items you can add to the report and at the right you have the data items.
The center holds the report design itself.
 |
| Report Writer, click to expand |
A report consists of 'report bands', there are several bands available:
Title |
Printed once, at the beginning of the report |
|---|---|
Header |
Printed at top of each page, before data rows |
Detail |
Printed for each data row |
Footer |
Printed at the bottom of each page, after data rows |
Summary |
Printed once, at the end of the report |
When you create a new report, the Header, Detail and Footer bands will be available by default. You can add the Title and Summary band using the Report Sections menu button or the Report menu.
Report Sections button
You can add labels, lines, graphics, page numbers, bar codes and tables to the bands of the report.
In addition to these report bands, you can create groups of data via the Report Sections menu button or the Report menu.
This will open the Groups Dialog.
Groups Dialog
Once a group has been created, a Group Header and Footer band will be added to the report. A group will put several 'detail bands' together under a group, eg, multiple addresses per customer.
Preview
The Preview tab shows the report with the data, here you can try-out your report and see if it shows the data how you like it. You can also use this tab to print the report.
Report Writer, tab Preview
The toolbar has several buttons related to zoom-factor and page-navigation. At the left there's a list of available pages, the large area on the right shows the actual report pages with your data.
By using the Print button, you can either send the report on a printer or create a file, like PDF, HTML, Excel or Word.
Print Report dialog