Smartstaff
1,385
edits
Changes
→See Also
==Overview==
Any two reports can be combined into a report/sub-report format, provided the two reports have a common fieldand the two reports are in [[Reports#Classic_Report_Builder_-_Column_Settings|Classic builder type]]. In this exercise you will:
* Create a report that lists all the departments in the system.
The report now displays the contacts for each department below the department heading. This heading only appears once for each contact.
'''NOTE:''' System administrators can also specify that the reports should be are linked using values from a column of in the parent reportand child reports. This allows for a greater flexibility in creating sub-reports, as administrators are no longer limited to using standard fields to link main the parent and the child reports and subreports, and but can now specify a instead use custom fieldfields.
In the example below the field '''Grant Type - codes''' is a custom field that has been included as a column in the parent and child report. As a result the System Administrator is able to select this column option when trying to link linking the 2 reports.
[[Image:ColumnSubReports.png]]
==See Also==
* [[Passing Prompt Criteria to a Sub-Report]]
{{PrevNextStart}} [[Using an Outer Join]]{{PrevNextMid}} [[Creating Charts and Dashboards - Overview]] {{PrevNextEnd}}
[[Category:Reports]]