Microsoft Access 2010 Bible

(Rick Simeone) #1

Chapter 9: Presenting Data with Access Reports


343


The Report Header section
Controls in the Report Header section are printed only once, at the beginning of the report. A com-
mon use of a Report Header section is as a cover page or a cover letter or for information that
needs to be communicated only once to the user of the report.

You can also have controls in the Report Header section print on a page that is separate from the
rest of the report, which enables you to create a title page and include a graphic or picture in the
Report Header. The Force New Page property in the Report Header section can be set to After
Section to place the information in the report header in a separate page.

In Figure 9.23, the Report Header section is not used. Notice that the Report Header’s height is 0.

Note
Only data from the first record can be placed in a report header.


The Page Header section
Controls in the Page Header section normally print at the top of every page. If a report header on
the first page is not on a page of its own, the information in the Page Header section prints just
below the report header information. Typically, page headers contain column headers in group/
total reports. Page headers often contain a title for the report that appears on every page.

The Page Header section shown in Figure 9.23 contains horizontal lines above and below the
label controls. Each label control can be moved or sized individually. You can also change special
effects (such as color, shading, borders, line thickness, font type, and font size) for each control.

Both the Page Header and Page Footer sections can be set to one of four settings (found in the
Report’s properties, not the section properties):

l (^) All Pages: The page header and page footer print on every page.
l Not with Report Header: Neither the page header nor footer prints on a page with the
report header.
l Not with Report Footer: The page header does not print with the report footer. The
report footer prints on a new page.
l Not with Report Header/Footer: Neither the page header nor the footer prints on a page
with the report header or footer.
The Group Header section
A Group Header section normally displays the name of the group, such as “Trucks” or
“Motorcycles.” Access knows when all the records in a group have been displayed in a Detail sec-
tion when the group name changes. In this example, the detail records are all about individual
products. The Category control in the Category Header tells you that the products within the

Free download pdf