views:

403

answers:

0

I need to set page break for Report Viewer having 3 groups. Need to set page break for every 20 rows including group headers and footers...

already i have completed following steps

  • Right click on the table - and choose properties.
  • Select Groups - Add
  • Enter a name for the new group.
  • Enter the expression, you already have: '=Ceiling(RowNumber(Nothing)/3)'.
  • Check "Include group header" and "Include group footer"
  • Check "Page break at start". Click OK

But I need to set page break including group headers and footers... not in rows count only.

ex: if need page break in each 10 rows

  1. group heade1
  2. row 1
  3. row 2
  4. row 3
  5. row 4
  6. group header total 1
  7. group header 2
  8. row 5
  9. row 6
  10. group header total 2

page break----------------------- (start next page)

  1. group heade3
  2. row 7
  3. row 8
  4. row 9
  5. row 10
  6. group header total 3 ......

Is it possible.