Specifications

CHAPTER 11 Using Nested Reports
Users Guide 351
Placing a nested report in another report
When you place a nested report in another report, the two reports can be
independent of each other, or they can be related in the database sense by
sharing some common data such as a customer number or a department
number. If the reports are related, you need to do some extra things to both the
base report and the related nested report.
Usually, when you place a report within a report rather than create a composite
report, you want to relate the reports. Those instructions are first.
Placing a related nested report in another report
Typically, a related nested report provides the details for a master report. For
example, a master report might provide information about customers. A related
nested report placed in the master report could provide information about all
the orders that belong to each customer.
❖ To place a related nested report in another report:
1 Create the nested report that you plan to place in the base report.
2 Define a retrieval argument for the nested report.
For example, suppose the nested report lists orders and you want to list
orders for a particular customer. To define a retrieval argument, you
would:
• Select Design>Data Source to go to the SQL Select painter.
• Select Design>Retrieval Arguments from the menu bar in the SQL
Select painter.
• Define a retrieval argument in the Specify Retrieval Arguments
dialog box. In the example, customerID is the name assigned to the
retrieval argument.
3 Specify the retrieval argument in a
WHERE clause for the SELECT
statement.