Home > Tutorials > Report Manager Tutorial > Creating Advanced Reports > Creating Sub-Query Reports > Creating Sub Query Reports
Sub-Query Reports
Sub-Query Reports Scenario
You have been asked to create a report to list all sales invoices, excluding those where a credit note has been raised, for the six months from July to December 2003. You want to include the Customer's name.
Creating a sub-query report is a two part process:
- Part 1: Create a sub-query report whose output will be used as the criteria in a subsequent report. In this scenario, a list of order numbers where the DocType is equal to CRN.
- Part 2: Use the sub-query report's results as the basis of a filter in a new report.