Sections

Sections dictate how the data appears in a report. There are five types of sections: page, report, details, group, and repeating group.

Page Header and Page Footer

The rows in the Page Header section appear at the top of every page of a report. Typically, the Page Header section is used to designate column headers for a report. The rows in the Page Footer section appear at the bottom of every page of a report. Typically, the Page Footer sections are used to display the page number and/or confidentiality notices for a report.

Page Headers and Page Footers are not intended to perform calculations or display data fields. For this reason, a Page Header populated with a data field will only return the first line of data in that field; a Page Footer will return only the last line of data.

If you are printing a report, remember that Excel output does not have pages. Page Headers will appear only once at the beginning of the report. Reports run via the Report Viewer will display Page Headers similarly unless Simulate PDF is checked in the Options menu.

Report Header and Report Footer

The rows in the Report Header appear at the beginning of a report. Typically, these rows display the title of a report. The rows in the Report Footer appear at the end of a report. Typically, the Report Footer displays grand totals and summary information for the report.

Detail Section

The Detail section is the main section of most reports. When a report is executed, the Details Section creates a row for each element in the Data Categories. For example, if the Detail section contains the Data Field Orders.OrderId, the report will display each Order Id on a separate row.

Group Header and Group Footer

Group Header/Footer sections require a sort on a Data Field or formula. The rows in a Group Header section will appear above the Detail section for each unique value of the sorted item. Typically, Group Header sections are used to display data as labels. For example, a report may contain a Group Header on Orders.OrderDate and display Orders.OrderId in the Detail section. The output would display each date with orders that occurred on that date below them.

The rows in a Group Footer section will appear below the Detail section for each unique value of the sorted item. Typically, Group Footer sections are used to calculate subtotals. For example, a report may contain a Group Footer on Orders.OrderDate which displays the number of orders made on each date.

Repeating Groups

Repeating Groups require a sort on a Data Field or formula. Repeating Groups have their own header, details and footer subsections. Repeating Groups should only be used when the data has multiple one-to-many relationships and each should be rendered completely before the other.