Microsoft Office Tutorials and References
In Depth Information
Creating and Managing Report Sections
Sections provide headers and footers for your pages and allow you to group
data by using a particular field. If you have several reports with the same
value in a field, you can display those records together in the report. If your
record source has a Date/Time field, for example, you can create a section
for that field and group records that have the same date, with subtotals
Table 1-2 lists the sections that a report can include, with tips for using the
Sections of Reports
Where the Sections Appear and How to Use Them
Appear at the beginning and end of the report. These
sections are for summary information about the entire report.
The report header can include a title page, and the report
footer can include totals for all the records in the report.
Appear at the top and bottom of each page. These sections
usually include the report name, the date, and the page number.
Appear at the top and bottom of each grouping (before the
first record and after the last record) in a group that has the
same value for a specific field. Your report may have more
than one grouping header and footer (one pair for each
grouping). The footer may include subtotals. Format your
grouping headers and footers to make the hierarchy of the
report obvious (using larger fonts for first-level groups and
smaller fonts for second-level groups, for example).
Displays values for each record.
In Design view, the white bar names the section, and the controls below the
bar appear every time that section of the report prints. In the report shown
in Figure 1-8, earlier in this chapter, the report header prints only once: at
the beginning of the report. The Page Header contains only one line. Records
are grouped by order number. The Detail section prints information about
each product in the order. The Order ID Footer section contains the total
number of items in each order. The Page Footer section includes the current
date and time, the page number, and the total number of pages in the report.
The Report Footer section has a grand total of the extended price for all
records in the report.
Figure 1-9 shows the top of the first page of the report when printed. Group
headers are printed at the top of each group. In the example in Figure 1-8,
earlier in this chapter, the OrderID group header is empty, so nothing is
printed for it. The Detail section prints once for each product ordered in
each order. The Page Header and Page Footer sections print once each