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.
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