Divide data into sections

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.

Procedure

  1. Click the column to make a section heading.
  2. In the report object toolbar, click the Section/subsection icon section icon.

    If the column is in a list or repeater, sections are created without creating a master detail relationship. This can improve performance when running the report.

    If the column is in a crosstab or chart, sections are created by 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.
  3. To add or remove section headers and footers, from the report object toolbar, click the More icon the more icon, click Headers & footers > List headers & footers, and then select or clear the appropriate check boxes.

    The section header and footer check boxes appear under Overall header.