I have seen various threads on this issue, but have failed to find a solution.
Using Q3 2009, I am creating an invoice report as a master-detail report. It prints on a pre-printed form.
There is a page header set to print on each page. There is a page footer which (ideally) I would like printed on the last page only, and contains the totals. At present it prints on each page, if there is more than one, and I can't find a way of suppressing print on all but last page in code.
I could perhaps delete the page footer, and put the totals in a report footer, which would obviously print on the last page, but then the footer appears immediately after the detail lines, whereas I am printing on a preprinted form, and the totals must be at the bottom of the page.
You have a demo on creating an invoice report, but it seems to me too simplistic. Most invoices will want running totals (c/f and b/f) and many will want the final totals at the foot of the final page instead of at a random position.
Can anyone advise please?