Report Writer

Previous  Index  Next  How To Use

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:


1.Report Data


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. Make sure to link a data band to a data set.


Report Writer, tab Report Data


You can view the report query or modify it using the Visual Query Builder button on the right.



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.



A report consists of 'report bands', by default there's a Report Title, Master Data and Page Footer band. Make sure to link each data band to a data set. Available bands:

Report Title

Printed once, at the beginning of the report

Report Summary

Printed once, at the end of the report

Page Header

Printed at the top of each page

Page Footer

Printed at the bottom of each page


Printed once before a set of data, eg the Master Data


Printed after a set of data

Master Data

The main data set

Detail Data

Additional data set based on/linked to the previous data set

Additional Data Bands

More data bands can be added

Group Header

Printed before a data group

Group Footer

Printed after a data group


A child band is printed directly after its linked parent band, this can be useful when an object distorts the layout of your items vertically: move the items below it to a child band.



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 Insert Band button.


This will open the Group Dialog.

Group Dialog


Once a group has been created, a Group Header will be added, for each group, a Group Footer band can be added to the report. A group will put several 'detail bands' together under a group, eg, multiple orders per customer.



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