Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group page spacing problem

Status
Not open for further replies.

bjplayer

Programmer
May 14, 2002
11
US
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.

 
You can use a conditional formula to reset page numbering in your combined AB group footer: {fieldA} <> Next({fieldA})
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top