>In my report, I want to calculate the %Sale value.
>For that, I need to divide Sale by Total of Sales.
>The problem is when each row is printing the total
>of sales is not completly calculated. How can I do
>that? Does I need to calculate it before printing?
>
>Description Qty Sale %Sale
>------------ ----- --------- ---------
>Product 1 200 $5000.00 50.00
>Product 2 150 $2000.00 20.00
>Product 3 150 $3000.00 30.00
>TOTAL 500 $10000.00 100.00
>
>
>Thank you for your help.
Yes it would be to easy to place total before report in an array :
select sum(..) ... into array arrTot
Cetin