Report/Page footer at bottom of last page - handle more lines on first page
I have an report listing lines on an Quote with a subtotal and large footer to handle terms an conditions.
Works fine with one page with page footer set to bottom of page but does not work when the number of lines means more than one page.
I realise I cannot set a report footer to bottom of page and need to use page footer for this.
I can force the page footer to invisible or cancel = true on the first page but this leaves a gap - i.e. I think the report works out the number of lines that will print on the first page before making the footer not visible. Also I have tried changing the height on the footer (which would be the best option) but still leaves a gap.
I know there is a lot of information on this on EE and I have looked through a lot but most deal with this as cancel = true on page footer.
I guess needs to work out how many pages first and needs to know how many lines in each but perhaps there is a way with a
Appreciate any ideas on printing more lines on the first page where no footer.