Generic report totals

[drazeni]

Hi,

I have a generic report (invoice) which prints the customers details on top of each page and has detail records and totals (standard invoice layout). It also prints on preprinted stationery.

My problem is such, how can I get the totals to print on the last page (if > 1 page) in a specific place on the report. I have tried shifting the totals (3 fields) from the "report footer" to the "page footer" and vice versa without success.

The page footer wants to print the report on every page, the report footer does only print on the last page, but immediately after the last detail line of the report, whereas I require it to be in a specific position on the report.

Any help will be appreciated.
Thanks

 

[drazeni]

Oh yes, I forgot to mention (if it's relevant) that my detail records are contained in a subreport in the main report because I use 2 queries to create the report.