Group Footer - Bottom of page shows in the middle

John McGovern
John McGovern used Ask the Experts™
on
We need to have the Group Footer to be on the bottom of the page.

Group 1A, 1B (Keep Together)
Group 1A, 1B (Print at Bottom of Page is selected)
Group 1C (New Page Before is selected)
Group 1A & 1B are not on the bottom. Sometimes it shows in the middle of the page.  Group 1C works fine.

Group 1A  & 1B - Are the Invoice Totals and need to be on the bottom.
Group 1C is on another page like it should be. That is the terms and conditions.

I noticed that if I take the Group 1C out of there then it works like it should.  Not sure on how to fix this.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
I modified a report I had that used groups and was able to replicate your problem

I was not able to resolve the problem using any combination of print at bottom.

Here is a trick that works

Add another group based on the same field as Group 1
It will be added as an inner group.
On the design screen move it up so it is now group 1.
Move the objects from the now GF2C to the new GF1
Set the NEW PAGE BEFORE on GF1
Delete GF2C
Set GF2 to print at the bottom of the page
Suppress or hide GH1

mlmcc

Author

Commented:
Thank you so very much. This worked very well.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial