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.
There are two ways to add page numbering to a report.
Usually a page number is added to a report header or footer, but you can add it anywhere on the layout page.
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 |
Use the following steps to create your own page numbering format.
To create a custom page numbering format
=Globals!PageNumber & "/" & Globals!TotalPages