Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subtotals and totals
Message
 
To
12/07/2006 10:15:55
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135680
Message ID:
01135687
Views:
11
frt_chg? What is it? A field from your cursor or report variable? If this is a field from your cursor what is the value in it for each record? If it is the total value for the group that just porint the value, do not put any calculations on it.
(I suspect that you have 100 in frt_chg in both records, that's why you get 600 as Grand total)

>Hi all,
>
>If I had any hair, I'd be pulling it out over this one.
>
>On my Invoice form, I have the following fields:
>
>(in the Detail band)
>qty_select unit_price qty_select*unit_price (for the extended line total)
>
>In the Group Footer band, I have the extended line total summed. It's perfectly fine. I also have three other fields there:
>
>misc_chg
>sales_tax
>frt_chg
>
>And a fourth field that adds those three fields to the subtotal for a grand invoice total.
>
>The problem: it doesn't just add the above three fields one time. It adds them one time for each line of detail on the invoice. For example, for an invoice with two detail lines, I get this:
>
>Sub : $400
>Misc: 0
>Tax : 0
>Frt : 100
>Tot : $600
>
>If I display the misc_chg, sales_tax and frt_chg fields on the form for testing purposes, they're correct (just $100 for frt). But why is it adding those lines once for each line of detail, even though it's displaying correctly on the form? I want to add my subtotal, then each of the other three displayed items (misc, tax, frt) to get my grand total.
>
>This oughta be simple. In fact, it probably is. But I'm just not seeing it.
>
>Thanks!
>
>John
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform