I have a running total that only updates (counts) on a certain condition. So I end up with several records where the running total is 1, several records with a running total of 2 and so on.
Now I want to group on that running total so I can print a summary of the 1 records, a summary of the 2 records, etc. However, the running total field is not available to group by.
Is there a way to do this? PS: I don't have access to the database to put the number there, it must be done in Crystal.