You can choose the page numbering format for your Page reports/RDL reports by selecting from a list of pre-defined formats or by creating a custom page numbering expression.

Adding page numbers to a report

There are two ways to add page numbering to a report.

From the Report Explorer, under the Common Values node, drag a pre-defined page numbering format and drop it directly onto the report design surface.
Or add a TextBox control to the report design surface and in the Value property of the control, use the Expression Editor Dialog to select a page numbering expression from the Common Values node.

Usually a page number is added to a report header or footer, but you can add it anywhere on the layout page.

Pre-defined page numbering formats

You can find the pre-defined page numbering formats listed in the Report Explorer under the Common Values node, and in the Expression Editor under the Common Values field.

Predefined Format Descriptions

Numbering Format	Description
Page N of M	This format displays the current page out of the total number of pages in the report. Here N signifies the current page of a report and M the total number of report pages. Use the following expression to set this page numbering format: `="Page " & Globals!PageNumber & " of " & Globals!TotalPages`
Page N of M (Section)	This format displays the current page out of the total number of pages of a grouped report section. Here N signifies the current page of a grouped report section and M signifies the total number of pages in a grouped report section. Use the following expression to set this page numbering format: `="Page " & Globals!PageNumberInSection & " of " & Globals!TotalPagesInSection`
Page N of M (Cumulative)	This format displays the current page out of the total number of cumulative pages in a report. Here N signifies the current page of the report and M signifies the total number of cumulative pages in a report. Use the following expression to set this page numbering format: `="Page " & Globals!CumulativePageNumber & " of " & Globals!CumulativeTotalPages`
Page Number	This format displays only the current page number of a report. Use the following expression to set this page numbering format: `=Globals!PageNumber`
Page Number (Section)	This format displays only the current page number of a specific grouped report section. Use the following expression to set this page numbering format: `=Globals!PageNumberInSection`
Total Pages	This format displays only the total number of pages in the report. Use the following expression to set this page numbering format: `=Globals!TotalPages`
Total Pages (Section)	This format displays only the total number of pages in specific grouped report section. Use the following expression to set this page numbering format: `=Globals!TotalPagesInSection`
Cumulative Page Number	This format displays only the current cumulative page number of the report. Use the following expression to set this page numbering format: `=Globals!CumulativePageNumber`
Cumulative Total Pages	This format displays only the total number of cumulative pages in a report. Use the following expression to set this page numbering format: `=Globals!CumulativeTotalPages`

Tip: In addition to modifying the page numbering expression in the Expression Editor, you can also modify the pre-defined formats directly in the control on the design surface.

Custom page numbering formats

Use the following steps to create your own page numbering format.

To create a custom page numbering format

Concepts

Common Values

Expressions