Creating page breaks

Create page breaks in a report by adding page sets.

About this task

Page sets define sets of pages within a report. You customize the grouping and sorting of each page set to produce the results that you want.

You cannot create page sets if you set the option to show report pages as tabs in HTML output (Show properties > View pages as tabs).

Procedure

  1. Click the Pages icon Pages icon, and click Report pages.
  2. Create the report pages.
  3. Click the Toolbox icon The toolbox icon and drag the Page set object to the Report pages pane.
  4. Click the Show properties icon Show properties icon, and in the Properties pane, set the Query property to the query that you want to associate with the page set.
    Tip: You can also create a page set and associate it to a query by clicking the Data icon Data icon, right-clicking a query and clicking Insert.
  5. Organize the pages in the report by dragging report pages to the page set.
  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 sort icon 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.
  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.