Create a Page Break or Page Set

You can create simple page breaks, or you can create advanced page sets to associate pages with a query structure to force page breaks. For example, a query contains the data item Product line, which is grouped. Creating a page set that is associated with this query adds page breaks for each product line. When working with dimensional data, you can use the Page layers area to show values on a separate page for each member .

Tip: The Global Bonus Report sample report in the GO Data Warehouse (analysis) package includes page sets. For more information about The Great Outdoors Company samples, see Sample Reports and Packages.

Steps to Create Simple Page Breaks

1. Click the data item at which the report should break to a new page.

2. From the Structure menu, do one of the following:

   • To create a page break without creating a master detail relationship, click Set Page Break.

     This option only works if the data item is in a list or repeater. If the data item is in a crosstab or chart, Report Studio creates a page break using a master detail relationship. Setting page breaks without using master detail relationships can improve performance when running the report.

   • To create a page break using a master detail relationship, click Set Page Break Using Master/Detail.

   Report Studio confirms the page break setting.

   Tip: To modify simple page break settings, pause the pointer over the page explorer button  and click Report Pages, and then select and modify the page set.

Steps to Create Advanced Page Sets

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

2. Create the report pages .

3. In the Insertable Objects pane, on the Toolbox tab , drag the Page Set object to the Report Pages pane.

4. In the Properties pane, set the Query property to the query to associate with the page set.

5. Organize the pages in the report by dragging report pages to page sets.

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

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

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

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.