To seta number for thenumber of rows to be diplayed in s ingle page in a report

• Alicia Rose

  Ten Centuries

  Points: 1044

  More actions

  August 18, 2008 at 1:08 pm

  #382293

  Hi All,

  For accomodating maximum rows in a single page and reducing the number of pages for a particular report, i change thE size number for column width and font size.

  Is there any other way to set a fixed number of rows to be displayed on a single page like 100 rows per page etc.

  Any pointers/suggestions would be highly appreciated.

  Thanks

  -A

  Alicia Rose

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 19, 2008 at 6:52 am

  #859970

  What control(s) are you using?

  In a table you could add this to your a group (the details row has a group as well):

  =RowNumber(Nothing) Mod 100 = 0

  If you have a page break at the end of the group this will cause a break every 100 rows.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question