Creating Sub Query Reports

Alchemex

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.
Next-->