Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to sum header field?
Message
De
01/06/2006 01:00:17
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01125187
Message ID:
01126383
Vues:
14
Cathy,

I made a stupid mistake - when I placed a field with the variable as expression I still had it calculate for SUM! - hence the double effect.

Cheers for the Report Guru! Thanks for the help! =)

Dennis

>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
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform