TechNet
Export (0) Print
Expand All

Hide a Page Header or Footer on the First or Last Page (Report Builder and SSRS)

 

Applies To: SQL Server 2016

A report can contain a page header and page footer that run along the top and bottom of each page, respectively. After you a add a header or footer, you can selectively hide it on the first and last pages of a report.

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

To hide a page header on the first or last page

  1. Open a report in Design view.

  2. Right-click the page header, and then click Header Properties. The Report Header Properties dialog box opens.

  3. Verify that Display header for this report is not selected.

  4. In the Print options section, clear the check box for each option to hide the display on the first or last page of the report.

  5. Click OK.

To hide a page footer on the first or last page

  1. Open a report in Design view.

  2. Right-click the page footer, and then click Footer Properties. The Report Footer Properties dialog box opens.

  3. Verify that Display footer for this report is not selected.

  4. In the Print options section, clear the check box for each option to hide the display on the first or last page of the report.

  5. Click OK.

Page Headers and Footers (Report Builder and SSRS)
Pagination in Reporting Services (Report Builder and SSRS)
Add or Remove a Page Header or Footer (Report Builder and SSRS)

Community Additions

ADD
Show:
© 2016 Microsoft