Export (0) Print
Expand All

How to: Add or Remove a Page Header or Footer (Report Builder 3.0 and SSRS)

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.

NoteNote

Each rendering extension processes page headers and footers differently. For more information, see Adding Page Headers and Footers (Report Builder 3.0 and SSRS) and Understanding Pagination in Reporting Services (Report Builder 3.0 and SSRS).

NoteNote

You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.

To add a page header or footer

  1. Open a report.

  2. On the design surface, right-click the report, point to Insert, and then click Header or Footer.

NoteNote

The Header and Footer options appear only when a header or footer is not already part of the report.

To configure a page header or footer

  1. On the design surface, right-click the page header or footer.

  2. Point to Insert, and then click one of the following items to add it to the header or footer area:

    • Textbox

    • Line

    • Rectangle

    • Image

  3. Right-click the page header, and then click Header Properties to add borders, background images, or colors, or to adjust the width of the header. Then click OK.

  4. Right-click the page footer, and then click Footer Properties to add borders, background images, or colors, or to adjust the width of the footer. Then click OK.

To remove a page header or footer

  1. Open a report.

  2. On the design surface, right-click the page header or footer, and then click Delete.

NoteNote

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 the header or footer again.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft