Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Subtotals and totals
Message
De
12/07/2006 13:29:06
 
 
À
12/07/2006 13:14:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01135680
Message ID:
01135789
Vues:
13
So simple, and yet so elusive. :) I SWEAR I had it this way somewhere along the way. In fact, I think this is what I did initially. But after following what you said to the letter, all is well.

Thanks very much to all who helped!

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

Click here to load this message in the networking platform