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é,