If you are working with SQL Server Reporting Services (SSRS 2008 or SSRS 2008R2) you have probably experienced incorrect paging. We didn’t have this problem is SSRS 2005.
On all our reports (with more than a page of data) in SSRS 2008 and SSRS 2008R2 we have the following report header. Page 1 of 2?
I found a solution accidentally. I added a footer with the page number and that actually corrects the report header. It’s almost like SSRS needs us to put the code for calculating the pages.
Right mouse click on the report background and select Add Header or Add Footer (it doesn’t matter which one you choose):
From the toolbox get a textbox and place it in the Header (or the Footer). Right mouse click on the textbox and select Expression. Enter the following code:
And here is the working report header with paging: