Join Nested Page Sets

If you have nested page sets in your report, define a master detail relationship between them to see data in the nested page set that is related to the data in the parent page set. For example, you have a page set that shows pages of product line information. The page set contains a nested page set that shows pages of product type information. For each product line page, you want to see the related product type pages, as shown below:

Product line_1

• Product type_1

• Product type_2

• Product type_3

Product line_2

• Product type_4

• Product type_5

• Product type_6

Steps

1. Pause the pointer over the page explorer button  and click Report Pages.

2. In the Report Pages pane, click the nested page set.

3. In the Properties pane, double-click the Master Detail Relationships property.

4. Click the New Link button.

5. In the Master Query box, click the data item that provides the primary information.

6. Link the master data item to the details by doing one of the following:

   • To link to another data item in the detail query, in the Detail Query box, click the data item that provides the detailed information.

   • To link to a parameter, in the Parameters box, click the parameter that provides the detailed information.

7. Repeat steps 4 to 6 to create other links.

   Tip: To delete a link, select it and press the Delete key.

For more information about master detail relationships, see Create a Master Detail Relationship.