Invoice Report Footer

[richard]

Hi

I have created an invoice in my database using a report which works fine,
however I want the totals (which are in the report footer) to appear at the
bottom of the last page rather than at the end of the detail section.
Is there a way I can force the report footer to appear at the bottom of the
page rather than straight after the end of the detail section

 

[Mathieu Pagé]

Hi

I have created an invoice in my database using a report which works fine,
however I want the totals (which are in the report footer) to appear at
the bottom of the last page rather than at the end of the detail section.
Is there a way I can force the report footer to appear at the bottom of
the page rather than straight after the end of the detail section

Hi Richard,

I had the very same problem some years ago. The way I solved it is to put
the totals in the page footer. Doing so will put partial totals on every
pages and the real total on the last page. To prevent the totals to appear
on any pages except the last one you can use this formula in data field :

=iif([pages] = [page];Sum(ItemCost);null)

"pages" is the number of pages in the reports while page is the number of
the "page" currently printed.

Mathieu Pagé