Put it in the On Exit Expression of the Group Footer. If you use the Header and it reprints when it overflows to a new page, you'll get the wrong total.

Double check that the Value to Store is zero and NOT your tax field. Also, double check that you don't have an On Entry or On Exit expression in the Detail band that is messing with the report variable.




>Hi Cathy,
>
>This is what I did:
>
>- created a report var named nTAXTOT
>- set Value To Store to ZERO (0)
>- set Initial Value to ZERO (0)
>- set the Calculate to SUM
>- then, I put the following in On Exit Expression of the Group HEADER:
> _VFP.SetVar('nTAXTOT', nTAXTOT + Invh.Tax)
>
>It still resulted in SUMming the Tax values for every occurrence of the child table!
>
>I moved the '_VFP.SetVar...' expression to On Entry instead - still the same.
>
>I made an error in my thread: THIS IS ON VFP 6, NOT VFP 9... could this an issue?
>
>Anything I could have done wrong?
>
>Thanks
>Dennis
>