Specifications

CHAPTER 11 Using Nested Reports
Users Guide 359
The Modify Expression dialog box displays. In this dialog box, you can
easily select one of the columns or develop an expression. In the example,
the column named
id from the base report will supply the value for the
argument :customerid in the nested report.
When you run the report now, you are not prompted for retrieval argument
values for the nested report. The base report supplies the retrieval
argument values automatically.
Specifying criteria to relate a nested report to its base report
If you do not have arguments defined for the nested report and if database
efficiency is not an issue, you can place a nested report in another report and
specify criteria to pass values to the related nested report.
How the DBMS
processes SQL if you
use the specify criteria
technique
If you use the specify criteria technique, the DBMS repeatedly recompiles the
SELECT statement and then executes it. The recompilation is necessary for
each possible variation of the
WHERE clause.
❖ 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.