Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make this Total
Message
From
21/01/2004 20:56:47
 
 
To
20/01/2004 17:53:59
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00867338
Message ID:
00869336
Views:
30
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é,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform