In Crystal Reports IX, I have a report which has two group sections one in the other). In the "inner group", the data is similar to the below:
The group is unordered and groups on the first column (A-C). I want to change the report so that group 'B' always has its own page, but the rest of the groups can and should share.
I've tried a number of combinations such as 'new page before/after' and set the formula to be 'onlastrecord', but onlastrecord seems to then split the rows within the group onto different pages (e.g. 1563 on one, 255 on the other). All the combinations I've tried seem to give varied results and there are a surprising number of things to consider too e.g. if B comes out first, don't put a page before it (otherwise it will waste a page, etc). Any ideas?