Filter
Top Products
CHAPTER 11 Using Nested Reports
DataWindow Designer User’s Guide 329
The Arguments box lists arguments defined for the nested report and
provides a way for you to specify how information from the base report
will supply the value of the argument to the nested report.
3 Supply the base report column that will supply the argument’s value. To
do this, click the button in the Expression column.
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.