Post reply

implementing paging in SSRS 2008

  • December 6, 2010 at 3:58 am

    #227856

    I am having a table in my SSRS 2008 report.

    The table contains more than 100 rows. the user has to scroll down to view the data. In order to avoid this, i want to implement paging in the table so that each page on the report shows 20 records in the table and the data of the table is split in 5 pages.

    Thanks.

  • December 13, 2010 at 2:13 am

    #1261568

    Neharika,

    Add a group to your report and use the following expression to group on:

    =Floor((RowNumber(Nothing) - 1) / 10) or Ceiling function =Ceiling((RowNumber(Nothing)/10))

    To set 10 records per page

    Also set the 'Page break at and' property for the group.

    Hope this helps!!

    Raunak J

  • December 13, 2010 at 2:34 am

    #1261576

    Hi Neharika,

    Also you can go through the below link, same question was discussed already. And at the end you can see how to do this in SSRS 2008.

    http://www.sqlservercentral.com/Forums/Topic490774-147-1.aspx

    Special thanks to Peter Brinkhaus,Daniel Bowlin and all others who repled and helped to solve the issue.

    Thanks & Regards,
    MC

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply