Filter
Top Products
Working with nested reports
330 DataWindow .NET
❖ To specify criteria to relate a nested report to its base report:
1 Select the nested report and then select the Criteria page in the Properties
view.
The Criteria property page provides a way for you to specify how
information from the base report will supply the retrieval criteria to the
nested report.
2 Click the button next to the criteria box.
The Specify Retrieval Criteria dialog box displays.
3 Enter the retrieval criteria and click OK.
The rules for specifying criteria are the same as for specifying criteria in
the Quick Select data source. Multiple criteria in one line are
ANDed
together. Criteria entered on separate lines are ORed together.
In this example, the customer ID (the
id column) is the retrieval criterion
being supplied to the nested report. Notice that the
id column is preceded
by a colon (:), which is required:
When you run the report now, DataWindow Designer retrieves rows in the
nested report based on the criteria you have specified. In the example, the
customer ID column in the base report determines which rows from the
sales_order table are included for each customer.
Using options for nested reports
Using the Autosize
Height option
Autosize Height should be on for all nested reports except graphs. This option
ensures that the height of the nested report can change to accommodate the
rows that are returned.
This option is on by default for all nested reports except graphs. Usually there
is no reason to change it. If you do want to force a nested report to have a fixed
height, you can turn this option off.