Neet Group Footer at bottom of page

[Michael Russell]

Hi all,
Been scratching my head on this one. I have a report with grouping set
up, and all the number and formatting look fine. It's an invoicing
report, one invoice per customer (this is the grouping).

What I need to be able to do, though, is put the group summary at the
same location, at the bottom of each page. The way it works now, the
group footer comes directly after the last Detail entry.

I considered using the Page Footer, but not sure how to handle the
situation where one customer spills onto a second page. I'm comfortable
working with VBA, but don't know where I need to look to make the changes.

Thanks,
Michael

 

[Guest]

It's always tricky to get it to work right.

One way is to use the page footer, and hide the footer on pages
that don't include a group footer.

One way to do that is to use the group header format event to
turn off the page footer, and the group footer format event to
turn on the page footer.

Another way is to move the controls in the format event
so that the group fills down to the bottom of the page.

But it is always tricky to get it to work right.

(david)

 

[fredg]

Hi all,
Been scratching my head on this one. I have a report with grouping set
up, and all the number and formatting look fine. It's an invoicing
report, one invoice per customer (this is the grouping).

What I need to be able to do, though, is put the group summary at the
same location, at the bottom of each page. The way it works now, the
group footer comes directly after the last Detail entry.

I considered using the Page Footer, but not sure how to handle the
situation where one customer spills onto a second page. I'm comfortable
working with VBA, but don't know where I need to look to make the changes.

Thanks,
Michael

See Microsoft KnowledgeBase article:
119655 "How to print group footer at a specific location"