Add or remove a page header or footer in a paginated report (Report Builder)
Article
Applies to:
Microsoft Report Builder (SSRS)
Power BI Report Builder
Report Designer in SQL Server Data Tools
You can add static text, images, lines, rectangles, and borders to paginated report 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.
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
Add a page header or footer
Open a report.
On the design surface, right-click the report, point to Insert, and then select Header or Footer.
Note
The Header and Footer options appear only when a header or footer is not already part of the report.
Configure a page header or footer
On the design surface, right-click the page header or footer.
Point to Insert, and then select one of the following items to add it to the header or footer area:
Textbox
Line
Rectangle
Image
Right-click the page header, and then select Header Properties to add borders, background images, or colors, or to adjust the width of the header. Then, select OK.
Right-click the page footer, and then select Footer Properties to add borders, background images, or colors, or to adjust the width of the footer. Then, select OK.
Remove a page header or footer
Open a report.
On the design surface, right-click the page header or footer, and then select Delete.
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 don't reappear if you subsequently add the header or footer again.
Do you want to learn how to add a layout to a report in Microsoft Dynamics 365 Business Central? In this module, you'll learn about the client report definition (RDLC) layout and Word layout formats and how to create them.