sum in page footer

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I am doing a calculation on the report =sum[producttotal].
When I put it in the Client Footer it is fine but I would
like it to be displayed at the BOTTOM of the page for the
invoice no matter how many line items. When I put it in
the page footer I get #error. Please help what do I need
to do for it to be at the BOTTOM of the page.

Thanks
 
I am doing a calculation on the report =sum[producttotal].
When I put it in the Client Footer it is fine but I would
like it to be displayed at the BOTTOM of the page for the
invoice no matter how many line items. When I put it in
the page footer I get #error. Please help what do I need
to do for it to be at the BOTTOM of the page.

Thanks
Click to expand...

See Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
 
tom said:
I am doing a calculation on the report =sum[producttotal].
When I put it in the Client Footer it is fine but I would
like it to be displayed at the BOTTOM of the page for the
invoice no matter how many line items. When I put it in
the page footer I get #error. Please help what do I need
to do for it to be at the BOTTOM of the page.
Click to expand...

If you just want the invoice grand total (not a page
subtotal) in the page footer, then use a text box n the
group header with =Sum( ... ). The page footer can refer to
the text box in the group header to display the total.
 
Back
Top