Expand a report using sub-reports
A report is always based on one specific data collection, but you can expand a report using sub-reports that are based on other data collections.
A sub-report is always part of a (main) report. If you display a main report, Profit shows one report and you often will not even notice that sub-reports have been used. You cannot display a sub-report separately, only from the main report.
Example:
The 'Sales invoice' report is based on the Sales invoice lines data collection. From now on, you also want to print a list of outstanding items and the total balance for each invoice, but the required fields are not part of the data collection. That is why you add a sub-report based on the Outstanding items debtor data collection.
The Employees current salary (Profit) report only shows the current salary of each employee. However, you also want to see the contract and salary history of each employee. To achieve this, you use two sub-reports, one for the salary history and one for the contract history.
You can add as many sub-reports as you want, but a large number of sub-reports may negatively impact the performance of the report.
Procedure
- Add a sub-report
You expand a report using a sub-report.
- Lay out a sub-report
You add the fields that you want to show to the sub-report.