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

Click the column to make 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 Headers & Footers, click List Headers & Footers, and select or clear the appropriate check boxes.
The section header and footer check boxes appear under Overall header.