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.