Getting Sum To Show in Report Header

T

T'Kai

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.
 
A

Allen Browne

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
 
Top