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
- group heade1
- row 1
- row 2
- row 3
- row 4
- group header total 1
- group header 2
- row 5
- row 6
- group header total 2
page break----------------------- (start next page)
- group heade3
- row 7
- row 8
- row 9
- row 10
- group header total 3 ......
Is it possible.