General information
Category:
Reports & Report designer
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only