Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subtotals and totals
Message
From
12/07/2006 13:14:53
 
 
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:
01135779
Views:
12
This message has been marked as the solution to the initial question of the thread.
>(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.

Add a report variable, Order_Total, and have it calculate the total of the extended line totals. That is, Initial Value = 0, Value to Store = qty_Select*Unit_Price, Calculate-Sum.

In the Group Footer, use:

Misc_Chg + Sales_Tax + Frt_Chg + Order_Total

with no calculation set.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform