SSRS - Displaying the page number in the body shows previous page number.

Question

Hi,

I have a report containing a tablix with a textbox (TextBox25) that needs to display the current page number.

In the report code I have:

Public Shared PageNumber as Integer

Public Function ChangePageNumber(ByVal PageNum As Integer)

PageNumber = PageNum

End Function

Public Function GetPageNumber()

Return PageNumber

End Function

In the header I have a hidden textbox with: =Code.ChangePageNumber(Globals!PageNumber)

And in TextBox25 I have: =Code.GetPageNumber()

This results in:

Where the first page number in the list should match the page number shown in the footer.

Can you please tell me why this is failing to work as expected? All sources tell me that the header event should always be processed first, then the body event.

I am previewing the report in Microsoft Visual Studio Professional 2022 (64-bit) using Microsoft SQL Server Reporting Services Version 16.0.20143.0.

Regards

Mike

Answer 1

Hi @Michael Allen (SXS UK)，

The incrementation of page numbers relies on the triggering of page breaks. If the pagination logic is not configured correctly (e.g., group-based pagination or table-based pagination), it may result in incorrect page numbering.

Per my research, it is a bit hard to use page number in the body.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.