In addition to the Body section which is contained in every report definition, you can add Header and Footer sections. From the Report menu, choose Page Header or Page Footer.
You can add any of the following controls to the Page Header or Page Footer:
You cannot use expressions which refer to any of the report's fields in the Page Header or Page Footer, and you cannot use data regions or subreports in these sections.
You can, however, use expressions based on global values such as page number, date, report name, etc. in the Page Header or Page Footer. To add page numbering, use an expression like the following in the Value property of a textbox:
= "Page " & Globals!PageNumber & " of " & Globals!TotalPages
|Note: Page numbering can only be added in the Page Header and Page Footer sections of the report. In the Body section of the report, the pagination fields of the Globals collection are not accessible.|
By default, the Page Header and Page Footer are rendered on the first and last pages of the report. However, if you do not want these sections to appear on every page of a report, change the PrintOnFirstPage and PrintOnLastPage properties to False. For more information, see Hiding Page Headers and Footers.