Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    285
    Provided Answers: 1

    Unanswered: SSRS 2005 table paging

    Good day,

    I have been trying and trying but can't seem to get this right.

    I have 2 tables on my report. Each linked to a different datasource. What I want to do is have each table show not more than 10 rows at a time and should there be more have an option to display the next 10 rows in the table. Is this even possible in SSRS?

    I know it is possible in other applications but I want to do it in SSRS.

    So for example:
    Table A only returns 7 rows from the database for what ever reason, but table B returns 34. What I want table B to do is show the first 10 rows and then a little button to click to the next 10 and so on. And if possible have the ability to show how many "pages" of 10 there are.

    Is this even possible?

    Please help.

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Nov 2004
    Posts
    285
    Provided Answers: 1
    Thanks roac, appreciate it, that didn't help me one little bit, thanks.

  4. #4
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    The first google result, approximately one screen down:

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

    Code:
    =Floor((RowNumber(Nothing) - 1) / 10)

    Also set the 'Page break at and' property for the group.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  5. #5
    Join Date
    Nov 2004
    Posts
    285
    Provided Answers: 1
    That merely adds a group of 10 rows that can be expanded but if there are 100 groups shows all 100 groups which are expandable and therefore not usable as it still scrolls for WAY to long. I have since learnt that what I am wanting to do is not possible in SSRS, so will have to look at a standrd ASPX page solution or some other software.

  6. #6
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    The Method works just fine, see attached report (zipped).
    Attached Files Attached Files
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •