Create sections in a report to show a data item as the heading of a section. When you run the report, separate sections appear for each value.
Creating sections is similar to creating headers by
grouping on a data item . The difference is that section headers appear
outside the list, crosstab, chart, or repeater. In addition, you
can group data items only in lists.
When working with dimensional data, you can also create page
layers to show values on a separate page for each member .
Click the column that you want to show as a section heading.
Do one of the following:
From the Structure menu,
click Section .
If the column is in a list or repeater, this menu option will create sections without creating a master detail relationship. This can improve performance when running the report.
If the column is in a crosstab or chart, this menu option will create sections using a master detail relationship.
From the Structure menu, click Section using Master/Detail.
This menu option creates sections using a master detail relationship.
Sections are created, and a section header appears. The data container that contains the column used to create sections is embedded in a list.
To add or remove section headers and footers, from the Structure menu, click List Headers & Footers, select or clear the appropriate check boxes, and click OK.
The section header and footer check boxes appear under Overall header.
To remove sections and reinsert the data item used to create the sections to the data container, do the following:
From the View menu, click Page Structure.
Expand the page containing the data container with the section.
Expand Page Body until you see the data container in which you added the section.
The data container is nested in the List Column Body object of the List object that is created when you add a section.
Drag the data container to Page Body.
The data container appears as a node of Page Body.
Delete the List object.
From the View menu, click Page Design.
In the Insertable Objects pane, click
the Data Items tab .
Drag the data item that was used as a section header back into the data container.
If you created sections in a list without creating a master
detail relationship, click the data item and then click the
group/ungroup button to ungroup the item.
For information about the page structure view, see The Page Structure View.
When working with dimensional data, you can create page layers in a report to show values on a separate page for each member. For example, your report contains payroll information for the entire company. You want to filter your report so that values for each department appear on a separate page.
After you create page layers, a caption appears in the header to indicate the contents of each page. You can navigate between the different pages using links below the report.
Creating page layers is similar to filtering using context .
However, with context filters, values are filtered according to
the member you add to the Context filter area.
With page layers, the report is split into a separate page for each
child of the member you add to the Page layers area.
If you want to create more complex page
layers in your reports, such as a report book with title and end
pages, create page sets .
In the source tree, select or search for one or more items to filter on.
Drag the item that you want to filter on into the Page layers section of the overview area.
The crosstab shows the results for the children of the selected item on separate pages and a drop-down list appears under Page layers.
Tip: To navigate between pages, click the Page down and Page up links below the report.
If you want to replace the page breaks with items from the same dimension, select an item from the drop-down list. If you want to delete the page breaks, from the drop-down list, click Delete. If you want to delete all the page breaks, right-click the Page layers area and click Delete All.