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

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:

   1. Select Design>Data Source to go to the SQL Select
      painter.

   2. Select Design>Retrieval Arguments from the menu bar
      in the SQL Select painter.

   3. Define a retrieval argument in the Specify Retrieval
      Arguments dialog box. In the example, customerID is the name
      assigned to the retrieval argument.

   4. 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.

3. 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:

   

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

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

6. 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.

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