Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to make this Total
Message
 
 
À
20/01/2004 17:53:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00867338
Message ID:
00869336
Vues:
29
Hi, João.

>>Let's say you have tax at 10%, 15% and 20%. you have to declare 3 report >variables:
>>Tax10, Tax15, Tax20. In value to store, you have to enter, respectively:
>
>>iif( tax_percent=10, amount, 0 )
>>iif( tax_percent=15, amount, 0 )
>>iif( tax_percent=20, amount, 0 )
>
>>and mark it as Sum (calculate option group) for all. Then, at the end of >the report, you'll have the amount for each tax in the 3 variables.

>Thanks for your help, but, like i say in my first question, In the footer page i only want to print once, the 8 Tax, 19 Tax...
>
>If i have 2 times 19 Tax with value = 32.32 this is already the sum of the all 19 Tax in my detail lines doing by the select statement.
>
I don't understand this. What I explained could produce the following result:
Product   Amount   Tax    Subtotal
------------------------------------  (detail band)
 AAA         100   19%        19
 BBB        1000    8%        80
 CCC        2000    8%       160
 DDD        1000   19%       190
------------------------------------  (footer)
 Total      4100             449

Taxes detail: 19% = 209      - - - - - - - - -> tax19 report variable
               8% = 240      - - - - - - - - -> tax8  report variable
If I got the example wrong, please make the corrections and resend.

Até,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform