none
HOw to fix No of Rows per page in SSRS RRS feed

  • Question


  • HI,

    I have 400 records in my report , i  want display 20 records per page , how can i do the same in ssrs.

    Thanks in Advance.
    Wednesday, December 10, 2008 2:16 PM

Answers

  • Pavan,

     

    As mentioned by Sivilian, you need to do this at the group level. If you do not have group, then add one but uncheck the 'Include Group Header' and 'Include Group Footer'. Also, check 'Page Break at Start'. But when ask to group by what, use:

    =Ceiling(RowNumber(Nothing)/20)

    This will break it every 20 rows. Good luck.

    Thursday, December 11, 2008 3:11 PM
    Answerer

All replies

  • Create a group that contains the groups or detail records you want, add a page break to the group, and then add a group expression to group by a specified number of rows

     

    Look under Page Breaks in Expression Examples (Reporting Services)

     

    hope this helps

    • Proposed as answer by Lavanya10 Friday, July 2, 2010 12:25 PM
    Wednesday, December 10, 2008 2:40 PM
  • Pavan,

     

    As mentioned by Sivilian, you need to do this at the group level. If you do not have group, then add one but uncheck the 'Include Group Header' and 'Include Group Footer'. Also, check 'Page Break at Start'. But when ask to group by what, use:

    =Ceiling(RowNumber(Nothing)/20)

    This will break it every 20 rows. Good luck.

    Thursday, December 11, 2008 3:11 PM
    Answerer
  • I need to do 100 rows per page.  I tried the technique above but I am still just getting about 16 rows per page.  (I believe I followed the instructions correctly.)

    I know...100 rows is a ton but the users want it (and, thus, my boss wants it).  They only display the report; they do not print it.



    Here is what I did...

    1. Right click on the table
    2. Select Properties
    3. Select the Groups tab
    4. Select Add...
    5. Enter a group Name: "Group_for_PageBreak" (I have no other groups)
    6. Enter an expression:  =Ceiling(RowNumber(Nothing)/100)
    7. Uncheck "Include group header" and "Include group footer"
    8. Check "Page break at start"
    9. Select "OK"

    Re #6, I also read to try this so I did: =CInt(Ceiling(RowNumber(Nothing)/100))
    Re #8, I also tried "Page break at end"

    Is "Details grouping..." relevant?


    Thanks.



    • Proposed as answer by smile108 Monday, January 16, 2012 11:54 AM
    Wednesday, July 15, 2009 8:47 PM
  • Do you know the paper size are you using? (report definition)...

    Remember if your detail gouping goes to end of paper, a page break is lauched... without care about expression formula...
    Wednesday, July 15, 2009 9:55 PM
  • I wish I had mentioned that.  I had also tried changing the page height from 8.5" to absurdly large heights such as 80" or 100".  I do not see any other way to set the "paper size".
    Thursday, July 16, 2009 12:03 PM
  • Set the interactive page to 80" or 100" and see what comes out.
    Chicagoan ...
    Thursday, July 16, 2009 12:37 PM
    Answerer
  • Set the interactive page to 80" or 100" and see what comes out.
    Chicagoan ...

    That did it.  Thanks much.
    Thursday, July 16, 2009 1:47 PM
  • The method (above) to get 100 records per page works nicely.  However, I am 99% sure that it is causing a problem with the interactive sorting.  Certainly when I remove this method, the interactive sorting works.

    Does anybody see an obvious problem with the two (i.e. the method and interactive sorting)?  I am not seeing the connection -- nor a solution.  (I started a separate thread on my interactive sorting issue.)

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b6530344-4e48-438b-aace-7847226eb174
    Tuesday, August 4, 2009 6:18 PM
  • Is there another method to achieve X records per page?  Using a group causes a problem with the interactive sorting.  This would seem to be a basic requirement.  Surely SSRS can handle this.
    Wednesday, August 5, 2009 1:39 PM
  • Thanks a lot, i tried a lot previously but no success
    your explanation is best, it  is working

    Thanks 
    Thursday, February 4, 2010 7:00 AM
  • Thanks
    Thursday, February 4, 2010 3:49 PM
  • Hi dglane,

    Thanks for your answer. Now my requirement is " I have already applied Group, by Department for employee report", Which is controversy to your point number 5.

    And number of rows per page are by default (Let us say 40).

    Now i want to display 100 records per page without disturbing already existing Department group.

    can you suggest me to fulfill this requirement?


    Prawin
    Tuesday, January 4, 2011 2:52 PM
  • I postd an artcile on controling the number of rows per page in SSRS                                                                                   http://gauravsqlserver.blogspot.com/2011/03/how-to-fix-number-of-rows-per-page-in.html
    Thanks, Gaurav
    http://gauravsqlserver.blogspot.com
    • Edited by Gaurav 17 Friday, March 18, 2011 5:43 PM url
    Saturday, March 12, 2011 7:19 PM
  • Hi

    I have 200 records in my report how do i get 20 in the first page only in my report and 30 for the rest of pages i'm using ssrs 2005

    Please any help !

    Wednesday, August 10, 2011 7:59 PM
  • hi,

    where i can find interactive page size?


    Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
    Tuesday, September 27, 2011 11:47 AM
  • Hi ,

    I have specified row page break group to display 15 records per page =CEILING(RowNumber(Nothing)/15). I did the same procedure what you have written, But it displays only one record per page.please advise


    Thanks in advance

    Monday, January 16, 2012 11:55 AM
  • This is a crucial part of the answer...Not just setting the expression etc...

    Thanks Isham


    Akki

    Wednesday, May 16, 2012 10:30 PM
  • I postd an artcile on controling the number of rows per page in SSRS                                                                                   http://gauravsqlserver.blogspot.com/2011/03/how-to-fix-number-of-rows-per-page-in.html
    Thanks, Gaurav
    http://gauravsqlserver.blogspot.com

    This is now a dead link: 
    "Sorry, the page you were looking for in this blog does not exist."

    Doug Ivison

    Thursday, April 30, 2015 7:28 PM