Search This Blog

Paging Issue in SSRS Report adds a question mark instead of display the total number of pages

Paging Issue in SSRS Report adds a question mark instead of  displaying the total number of pages

While working with SSRS reports,We had one report where we have limited the no. of row to 5 .
but the report was showing question mark  like in below screenshot.
if you will see the screenshot  there is a question mark after 2 .we had a total of 2 pages only in the report 
but instead of displaying the last page it was showing a question mark and we cannot show question mark as it was client request.
So i researched on this then i came to know that in 

In SSRS 2005, if a report had 100 pages of records all  pages were rendered as a whole.

In 2008,if a report had 100 pages  only a page of data is rendered.

And the Reason was like rendering 100 pages as a whole will have more  load on client machine so in order to avoid this a single page is rendered .

but as it was client request so we have provided a solution for this.

So here is the solution just add a textbox in your header and footer of the Report.
Write expression- =Globals!TotalPages
Hide the text box.by changing hidden property of Text box to true.


Preview the Report it will have no question mark as in above screenshot..



No comments:

Post a Comment