This may be a bit awkward, but...

Rather than having the Report Writer look at one (or more) tables;

Create a temporary table RPTTEMP with the fields needed for the report as well as a dummy field called BREAK.

Then write some code to go through RPTTEMP and determine where you want the breaks based on the number of records in each group and replace BREAK with eg "0001", "0002", etc.

INDEX RPTTEMP ON BREAK + (whatever the original index data was) TAG MAIN

Change your report to look at the data in RPTTEMP and add a GROUP based on BREAK.

Actually I seldom use production tables directly into REPORT WRITER. I almost always create a single temporary table or cursor and use that in the REPORT WRITER.

Regards,

Rudy