hide page footer if not last page

on crystal report, i use pagenumber<>totalpagecount if my memory serves me right.

I use that code on selection expert suppress. If i use that code it will suppress that page footer and leave blank section with height corresponding to that footer height.

What i want to achieve is that, even if i suppress that, it wont leave a blank area with height of that page footer.

Any ways to do that?

It's my understanding that the space designated for the page is always allocated, whether it shows or not. Sorry, I don't know of any reliable way to get rid of it.

The only thing that comes close in this case is to use the Report footer instead and force it to show at the bottom of the page.