calculating percent, I didn't understand
Hi,
I need a help with calculate percents. In detail band I need print a percent
based on a total located in group footer band.
group header product value percent of group percent of
total
-----------------------------------------------------------
---
detail X 400,00 40 %
20%
Y 600,00 60 %
30%
-----------------------------------------------------------
--
group footer Total 1.000,00 100 % 50%
-----------------------------------------------------------
--
summary Grand total 2.000,00
footer
"Percent of total" column is a Variable component with this in OnCalc event
value:= Orc['VALUE'] * 100 / DbcTotal.value;
The "percent of total" and "percent of group"column is not printing with
correct value. I tried to
set LookAhead variable property to true and make a two-pass report. What
must I set in variable field "moment of action" event?
Thanks,
Elena.
I need a help with calculate percents. In detail band I need print a percent
based on a total located in group footer band.
group header product value percent of group percent of
total
-----------------------------------------------------------
---
detail X 400,00 40 %
20%
Y 600,00 60 %
30%
-----------------------------------------------------------
--
group footer Total 1.000,00 100 % 50%
-----------------------------------------------------------
--
summary Grand total 2.000,00
footer
"Percent of total" column is a Variable component with this in OnCalc event
value:= Orc['VALUE'] * 100 / DbcTotal.value;
The "percent of total" and "percent of group"column is not printing with
correct value. I tried to
set LookAhead variable property to true and make a two-pass report. What
must I set in variable field "moment of action" event?
Thanks,
Elena.
This discussion has been closed.
Comments
engine updates the draw command for the look ahead component as the engine
conitnues generating bands in the first pass.
In order to calculate percentage, take a look at this demo:
http://www.digital-metaphors.com/tips/PercentageOfGroupTotal.zip
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com