How can I PageBreak after every two instances of a Group? 1

[hneal98]

I would like to have a page break after two members show on my report. I have a group by Member Fullname and would only like two members to show on the each page of the report.

Thanks.

 

[BobSuruncle]

Create a Running Total field (call it GrpCounter).
Set it to do a DistinctCount of the Member Fullname field and have it Evaluate on change of the Member Fullname group.
Make sure that the Reset is set to Never.

In the Section Expert, highlight the Group Footer section for your Member Fullname group.
Click on the X-2 button beside the "New Page After" property and enter the following:
Remainder( {#GrpCounter},2 ) = 0 AND NOT OnLastRecord



Bob Suruncle

 

[hneal98]

It works. Thank you very much.