Microsoft SSRS 2008 and the wrong paging- Page 1 of 2?

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:

= “Page # ” & Globals!PageNumber & ” of ” & Globals!TotalPages & ” pages.”

And here is the working report header with paging:

Print Friendly

3 thoughts on “Microsoft SSRS 2008 and the wrong paging- Page 1 of 2?

  1. I’m amazed, I have to admit. Rarely do I encounter a blog that’s both educative and entertaining, and without
    a doubt, you have hit the nail on the head. The issue is something that too
    few folks are speaking intelligently about.
    I’m very happy I found this during my hunt for something relating to this.

Leave a Reply