Placing a related nested report in another report – PB Docs 125

To place a related nested report in another report:

1. Create the nested report (DataWindow object) 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.

   The WHERE clause in this example tells
   the DBMS to retrieve rows where the value in the column cust_id equals
   the value of the argument :customerid:

   

   At this point, when you run the report to retrieve data, you
   are prompted to enter a value for :customerid.
   Later in these steps, you will specify that the base report supply
   the values for :customerid instead of prompting
   for values.

4. Open or create the report you want to have as
   the base report.

   In the example, the base report is one that lists customers
   and has a place for the order history of each customer:

   

5. Select Insert>Control>Report
   from the menu bar.

6. In the Design view, click where you want to place
   the report.

   The Select Report dialog box displays, listing defined reports (DataWindow
   objects) in the current target’s library search path.

7. Select the report you want, and click OK.

   A box representing the report displays in the Design view.

8. With the report still selected, select the General
   page of the Properties view.

   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 be used to supply the values of arguments to the nested
   report.

   

9. Supply the base report column or the expression
   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.

10. Select File>Save from the menu bar and
    assign a name to the report.

11. In the Preview view, you can see what your report
    looks like: