How to: Add or Remove a Page Header or Footer (Report Designer)

You can add static text, images, lines, rectangles, and borders to page headers or footers. You can place expressions and data-bound images in a textbox if you want variable or computed data in a header or footer.

Note

Each rendering extension processes page headers and footers differently. For more information, see Adding a Page Header and Footer to a Report and Controlling Report Pagination.

  1. Open a report in Layout view.

  2. On the Report menu, click Page Header or Page Footer. Page Header and Page Footer are toggle items on the Report menu. When enabled, a Page Header or Page Footer section appears on the design surface.

    Alternatively, right-click in the empty area outside of the design surface, and then click Page Header or Page Footer.

  3. Drag any of the following items from the Toolbox to the Page Header or Page Footer area:

    • Textbox
    • Line
    • Rectangle
    • Image
  4. Set properties on the Page Header or Page Footer to add borders, background images or colors, adjust width, or suppress headers or footers on the first page. To set these properties, right-click the Page Header or Page Footer area and select Properties.

  1. Open a report in Layout view.

  2. On the Report menu, click Page Header or Page Footer to remove it from the report.

    Alternatively, right-click in the empty area outside of the design surface, and then click Page Header or Page Footer.

    Note

    When you remove a page header or footer, you delete it from the report. Any items that you previously added to the page header or footer will not reappear if you subsequently add them again.

See Also

Concepts

Adding a Page Header and Footer to a Report
Report Designer How-to Topics

Other Resources

Report Designer F1 Help

Help and Information

Getting SQL Server 2005 Assistance