Getting Sum To Show in Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an invoice I need to print showing the sum of item amount in the
report header. I can get the sum in details and footer, but not in the
header. The layout of this invoice cannot be changed.

Any suggestions would be appreciated.
 
You already have a text box in the Invoice group footer.
I will assume that its properties are something like this:
Control Source: =Sum([Amount])
Format Currency
Name txtTotalAmount
Visible No

In the Invoice group header, you should be able to add a text box that picks
up the total from the group footer, i.e. its properties will be:
Control Source: =[txtTotalAmount]
Format Currency
 
Back
Top