paginationssrs-2008webclient

SSRS Url Access and Paging


I have an app that executes and displays reports from SSRS retrieved through URL Access (http://msdn.microsoft.com/en-us/library/ms153586.aspx) Unfortunately, one of these reports is HUGE, resulting in a lot of generated HTML, causing the WebClient to timeout during the call, or the browser to choke on the amount of HTML coming back.

Is there a way to specify what page of data I want to view, as well as know how many pages there are in the result?

Thanks

EDIT

Did a little more searching, and found that there is a rc:Section parameter that can be passed on the URL. It returns that page number. The problem now is, how do I know how many pages there are?

Jump to specific page in reporting services


Solution

  • It depends on how you are specifically displaying the report. Are you building the report URL dynamically and then serving up the page? If so, you can add a couple of hidden parameters for paging and which page of the report you wish to display and customize the resulting URL. It's a bit of work on your part because you'll need to do some manual work but it will give you total control over the end result.

    Update

    SSRS has an expression for determining the total number of pages in a report:

    =Globals!TotalPages
    

    Unfortunately, this can only be used in the header/footer of a report however it is only available after the report has been rendered. You can see a good exploration of this global variable here. The article is for SSRS2005 but it still applies to 2008/R2. If you only need to display the page number in the header/footer then this should work for you.