Group page spacing problem

[bjplayer]

I have a report with 3 groups - group C is the innermost,
group B is in the middle and group A is outermost. I would
like a page break to occur whenever group A changes, OR
whenever group B changes, for example:

Pg 1 - Grp A1 Grp B1
Pg 2 - Grp A1 Grp B2
Pg 3 - Grp A2 Grp B2
Pg 4 - Grp A2 Grp B3
Pg 5 - Grp A3 Grp B1
Pg 6 - Grp A3 Grp B2

I have tried every combination of New Page Before and New
Page After, both in the Group Headers and Group Footers and
cannot get the report to print with the correct page spacing.

The closest I can get is with New Page Before for Group A,
and nothing for Group B, but then the mulitple Group B's
print on the same page, which I don't want.

I got the correct spacing by using a concatenated formula
for both Group A and Group B, but then I cannot reset the
page number whenever Group A changes, because Group A is
now no longer present.

Any ideas?
TIA.

 

[rogar]

You can use a conditional formula to reset page numbering in your combined AB group footer: {fieldA} <> Next({fieldA})

 

[bjplayer]

That works!

Thanks.