Saturday, December 24, 2016

How to fix SSRS Page Count issue Page 1 of 2 ? where the page count is missing for some bizzare reason

SSRS Page Count issue "Page 1 of 2 ?", where the page count is missing is really due to a feature that was included since SQL Server 2008 Reporting Services called "On Demand Processing", which renders one page at a time to handle load and improve performance (especially for large reports)

You can fix this issue easily by adding a textbox to the report footer, set the textbox properties to "Hidden=true". Now set the textbox expression to "=Globals!TotalPages" (don't use quotes).

Voila!! Just like that when you refresh / re-run your report, it should now show the total number of pages in the SSRS report action bar

No comments: