none
Set page break after a number of rows RRS feed

  • Question

  • I am trying to set the page break of a table to occur every 200 rows. By default it generates a page break once the report size grows larger than the page length. When I set the property KeepTogether = true, it no longer generates the page breaks but then I have the issue of over 2000 lines on a single page.

    I created a group based on the following function:
    =CInt(Ceiling(RowNumber(Nothing)/200))
    I added a page break between each group instance. The first page now shows 200 lines but all remaining pages continue to page break once the length of the page has been hit  (around 22 rows).
    Friday, January 29, 2010 6:04 PM

All replies