Not on last page

[DBL]

How do I stop a page footer from appearing on the last page of a report? I've tried setting the Not With Rpt Footer but all that does it takes the report footer onto another page.

And I suppose the other question is, is there any way to get a report footer to appear after every Group footer?

 

[shudini]

don't know if this is the best method, but it's always worked for me. Also, if you have a lot of controls in the page footer it can be a pain.

Assuming you have a single text box in the page footer, use an iif statement to say

iif([page]<>[pages],"YOUR TEXT HERE",null)

why would you want to add the report footer to the end of a group footer, that's what you have the group footer for?