Report footer positioning help

[addy]

Hi

On my report I would like the Report Footer to appear at the very bottom of the page, rather than after my 'Details' section. Is this possible?

At the moment, I have the info I require in my Page Footer section but it appears on every page, not just the last.

Basically all I need is a few particular labels appearing at the bottom of the last page and can't work out how to do it.

Thanks.

 

[RoyVidar]

Not that I'm that much of a report hack, but if you're not using the Page Footer for other stuff, I think you could use the following tweak - cancel the display of it unless the page count = number of pages - in the page footer on format event, try:

[tt]private sub pagefootersection_format(cancel as integer, formatcount as integer)
cancel = (me.page <> me.pages)
end sub[/tt]

Roy-Vidar

 

[addy]

Roy

That's certainly a start for what I want and works pretty well. Unfortunately, what I get on the pages which don't display the page footer is a big white space where the footer woudl normally display. I am hoping to have my 'Details' section fill up the pages and then on the final page, have a footer which appears at the bottom of the page.

 

[addy]

OK

Using the idea from Roy's post I now have:

If Me.Page <> Me.Pages Then

PageFooterSection.Visible = False

Else

PageFooterSection.Visible = True

End If

Which works to a point. All pages except the last page now don't show the page footer and also my details section fills the whole page. Unfortunatley, the last page doesn't display the page footer but just leaves a white space.

ANy ideas?