Report Header and Footer

Add a Page footer is SSRS Report

How to add a page footer that displays the user name for the report and page numbers.

  • In the Report Designer, click the Design tab.
  • On the Report menu, select Add Page Footer. A new design area is added to the Report Designer.
  • Drag a Textbox report item from the Toolbox window to the page footer area. Position the text box in the top-left corner of the footer. Configure the properties of the text box, as shown in the following table.

    Property Value
    Name txtUser
    Width 3 in
       
  • In the Report Data window, expand Built-in Fields. (If the window is not visible, open it from the View menu by choosing Report Data.) Drag the User ID field to the txtUser box. BIDS creates the full expression for you. You can verify the full expression by rightclicking the text box and then clicking Expression.


  • Drag another Textbox report item from the Toolbox window to the page footer area. Position the text box in the bottom-left corner of the footer, under the UserId box.
  • Configure the properties of the text box, as shown in the following table.

    Property Value
    Name txtPage
    Width 3 in
       
  • Type page: in the txtPage box. (Important: Be sure to type a colon and a space following the label text.)
  • Drag the Page Number field after the space following the colon. Type of (with a space before and after the text) after the Page Number field, and then drag the Total Pages field to the end of the expression.