Create advanced page sets

You can use advanced page sets to define sets of pages within your report, and then customize the grouping and sorting for each page set.

About this task

You cannot create page sets if you set the option to show report pages as tabs in HTML output (File > Report Properties).

Procedure

Pause the pointer over the page explorer button and click Report Pages.
Create the report pages.
From the Toolbox tab , drag the Page Set object to the Report Pages pane.
In the Properties pane, set the Query property to the query to associate with the page set.
Organize the pages in the report by dragging report pages to page sets.
Insert the page containing details in the Detail Pages folder.
Detail pages are the pages that repeat based on the items by which you group in the following step.

Tip: You can insert multiple detail pages into the same page set and link them using a master detail relationship.
Define the grouping structure for the page set:
- Click the page set.
- In the Properties pane, double-click the Grouping & Sorting property.
- In the Data Items pane, drag the data item by which to group data items to the Groups folder in the Groups pane.
- To sort the data within each group, in the Data Items pane, drag the data item by which to sort to the Detail Sort List folder, and then click the sort order button to specify the sort order. For more information about sorting data, see Sorting Relational Data or Sorting Dimensional Data.
Note: Grouping an item for a page set is not the same as grouping a column in the layout. Grouping a column in the layout visually shows groups in a report. Grouping an item for a page set groups the item in the query. If you want to use an item that is already grouped in the layout, you must still perform step 7.
Repeat steps 3 to 7 to create other page sets.
Tip: You can nest page sets and join them by defining a master detail relationship. Create nested page sets to have pages occur within other pages. For example, you want pages containing product type information to occur within pages containing product line information.