Sub-reports

To show the contents of a table and its child table in a single row, you can use a sub-report.

In this example, the dates of all inventory scans performed on this computer are shown. The data is found in the tHosts and tDocu tables.

First, create a header band with the System Name and Scan Date headings. Then, add a data band using the tHosts table as the data source and add a text box containing the HostName.

Next, create a sub-report. To create the sub-report, use the icon from the Toolbox.

Docusnap automatically adds an additional page where you can define the sub-report.

Create a data band, in this example the data band with the tDocu data source, on the sub-report page. Add the text boxes for the data of this child data band here. In this example, add a text box for the Scan Date from the tDocu table.

As the master component of the data band, you can use the data band where the sub-report will be inserted. Create the connection to the master component using a relation or a parameter. After the tHosts and tDocu tables have been connected to the database, the report can be executed.