Include related records in a report to provide a more in-depth look at your data. Related reports can be inserted below the details subsection of a report section only. These related reports include the same subsections as a stand-alone report, such as the Report Header and Page Footer. The Report Header, Report Footer, Page Header, and Page Footer subsections are added, but they are turned off by default.
To include a related report in your report, do the following:
- Click the details subsection in the report view or select it in the Contents pane to activate the details subsection.
- On the Insert tab, in the Report group, click Related Report to open the Create New Related Report pane.
Optionally, right-click the details subsection in the Contents pane and click Related Report to open the pane.
- In the Create New Related Report pane, type a name in the Related Report Name text box.
- Expand the Relate or relationship class drop-down menu to see a list of all recognized in-map relates and relationship classes.
Only relationships that originate from the existing report data source are listed.
- Click Next to filter the data and specify the fields to include in the related report.
- Choose an option from the Rows menu to set the data filtering:
- All rows—All related data is used in the related records report.
- Filter by expression—Only data defined by a custom query is used in the related records report.
- Click Next to optionally group the related data and add sorting rules.
By default, grouping is sorted in ascending order. Summary statistics (count, minimum, maximum, sum, mean, and standard deviation) can be added to the related reports group and report footer.
- Click Next to design the related report template and styling.
- Click Finish to insert the related report.
The related report appears below the details subsection of the primary report. In addition to the details subsection, the report includes a report header and footer as well as any defined group headers and footers.
You can add related reports by selecting the details subsection of the primary report, another subreport, or an existing related report. The newly inserted related report is added beneath the selected subsection.
If the related data source is broken, it must be redefined. If you change the main data source, the relate may no longer exist and the related records won't be exported when you share the report.