formula to start each subgroup on a separate page.

[wasouthpnt]

Hi all wizards of crystal report formulas

I am trying to put each subgroup on a separate page. I am grouping by a main group which I want to appear on the top of each page and then by a subgroup which I want each subgroup to appear on a separate page.

For example my Main grouping is by City field. I want that to appear at the top of each page.
My subgroup is a packing slip number. Multiple records appear for each packing slip number.
I want each different group of packing slip number to appear on a separate page.

I have tried various things like:
in group section using new page after with "not onfirstrecord"
and
in same section using new page after with "NthSmallest (1,{yourField},{theGrouping})" Or "NthLargest (1,{yourField},{theGrouping})"

nothing seems to work completely. When I get it to partially work there is always a new page at the start of each subgroup with nothing but the headers on it.

Any help is much appreciated.

 

[BettyJ]

In Section Expert,
select Group Footer #2
In New Page After formula, use [tt]NOT OnLastRecord[/tt]. This should create a new page after each subgroup.

If you want the main group to be displayed in the top of each page, I believe you should be able to get it by just moving the city field to the page header.