Report Studio

Joining 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

To Join Nested Page Sets:

Pause the pointer over the page explorer button and click Report Pages.
In the Report Pages pane, click the nested page set.
In the Properties pane, double-click the Master Detail Relationships property.
Click the New Link button.
In the Master Query box, click the data item that provides the primary information.
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.

Repeat steps 5 to 7 to create other links.

Note: To delete a link, click it and press the Delete key.
Click OK.

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