Sub-Reports Tab
The Sub-Reports tab of the Report Setup window allows you to define sub-reports to display below each primary record in your report. The sub-reports display additional details about each record in the report. Up to five sub-reports can be defined for each report.
Define a sub-report to appear below each primary record in your report:
-
Select the Sub-Report tab.
-
Select how you want the sub-report content displayed when the report is opened in the Report Preview window from the Sub-Report Display field.
This option is typically set to Browser (Sub-Reports Collapsed) for optimum performance and control. This option allows you to open available sub-reports only when needed.
-
Select the first Sub-Report sub-tab not in use.
Five Report sub-tabs are available.
-
Select the report you want to have displayed from the Sub-Report field.
Reports are listed in alphabetical order.
-
Select the field that should be used to connect the primary report record to the records from the sub-report from the Sub-Report Criteria field.
The fields are listed in [Table] Field order. For example, for an asset report with a specification sub-report, you would specify that the [Asset] Asset field should be used to connect the asset to the asset specifications.
-
Enter the label to be shown adjacent to the Sub-Report Expand / Collapse control in the Sub-Report Caption field.
If no value is listed, the Report Name will be used.
-
If you want to view or modify the Report Setup for the sub-report, click the Setup button to the immediate right of the report name.
The Report Setup window opens for the specified report.
-
Click the Apply button.
Your changes are saved. The Report Preview window opens. If you accessed the Report Setup window from the Report List, you are returned to the Report List.
When the display option of Server (Sub-Report Expanded) is used, the Report Preview window only displays 10 base-report rows per HTML display page (section). In this circumstance, if a base report using sub-reports has more than 10 rows, additional sections of the report can be accessed using the section control in the Reports toolbar.