Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Total Value on a 2-band report
Message
De
18/12/2006 13:33:00
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01178103
Message ID:
01178634
Vues:
14
>>
>>
>>Are you SUMming the variable twice? In other words, if you create a report variable and set the calculate option to SUM ... and then when you use the report variable in the Data Group Footer you also mark that as SUM .. you have now told it to SUM and already SUMmed variable which will give you way more than you want.
>
>No, I am not SUMing the value twice. I have a variable nTotAmt which is set to SUM() field/expression PO_AMOUNT (name of the field). Then in the Group Footer I display this variable. The variable correctly SUMs the value but it does it for every record, both the PO Header and PO Item.

How about qualifying it with an alias?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform