Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Total Value on a 2-band report
Message
From
18/12/2006 13:33:00
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178103
Message ID:
01178634
Views:
13
>>
>>
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform