• Article

How to: Display Page Numbers or Other Report Properties (Report Builder 2.0)

It's easy to add page numbers, a report title, file name, and other report properties to the page headers or footers of your report. These properties are stored as fields in the Built-in Fields folder in the Report Data pane:

  • Execution time

  • Page number

  • Report folder

  • Report name

  • Report server URL

  • Total pages

  • User ID

  • Language

For a page number, you may want to add the word "Page" before the number. You may also want to show the total number of pages.

Note

Adding the total number of pages to the footer may slow performance when you run or preview your report.

To add a page number or other report properties

  1. In the Report Data pane, expand the Built-in Fields folder.

    Note

    If you don't see the Report Data pane, on the View tab, check Report Data.

  2. Drag the field that you want from the Report Data pane to the report header or footer.

    Note

    The page footer is added to the report automatically. To add a page header, on the Insert tab, click Header, and then click Add Header.

To add the word "Page" before the page number

  1. On the Insert tab, click Text Box.

  2. Click and drag a small text box in the page header or footer to the left of the page number.

  3. Type Page in the text box.

To add total number of pages after the page number

  1. On the Insert tab, click Text Box.

  2. Click and drag a small text box in the page header or footer to the right of the page number.

  3. Type of in the text box.

  4. Drag the Total Pages field from the Built-in Fields folder in the Report Data pane and place it to the right of the word "of".