lookahead calculations

rbuser

I'm trying to create a report that looks something like this:

item a, group x $20 (23.0%)
item b, group x $30 (34.5%)
-----------------------
subtotal group x $50 (57.5%)

item c, group y $10 (11.5%)
item d, group y $15 (17.2%)
item e, group y $12 (13.8%)
-----------------------
subtotal group y $37 (42.5%)

-----------------------
-----------------------
grand total $87 (100.0%)

My difficulty arises when computing the percentages since they are dependent
upon the grand total. What properties need to be set for the report (e.g.
two-pass), the subtotal dbcalc's, etc. More importantly, what should the
timing configuration look like for the percentage calculations?

Thanks

nicocizik

Hi Tyler,

Check out the following example on calculating the percentage of a group
total and a grand total. It should get you on the right track toward your
requirements.

http://www.digital-metaphors.com/tips/PercentageOfGroupTotal.zip

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com