dividing row values with grand total to get % of grand total

rbuser

hi, so i have a problem and i do not know how to start on it, let me
explain:

main report
-sub rows total in % of grand total
-subsub with specific values
-sub rows total in % of grand total
-sub rows total in % of grand total
-subsub with specific values
-sub ...
-sub ...
grandtotal 999999

the sub reports work on seperate datasets, no problem there but i have to
calc the % of each row in respect to the grand total
also, some sub reports get a specific value out of stored procs and they
need to be taken into account to
the grand total is the sum of all values printed in all sub reports
so how do i get to the grand total on each individual row in each subreport?

any suggestions?
thx
marc

nicocizik

Marc,

The following examples should get you on the right track in solving this
problem. The first one is assuming you are not using RAP. The second one
assumes that you are.

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

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

--

rbuser

nico,
i'll look into it, thx!

rbuser

Nico,
i suppose i'm missing something cause i do not see Rap being used in the
second example
i also goes through the oncalc event in code
is there another example available for the % of grand total using RAP
tia,
marc

nicocizik

Sorry about that, here is a better example.

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

--

rbuser

nico, i haven't looked at it but i want to have the total in the header, and
i just seem not to be able to get this
although through showmessages i see that the values are being set and
although lookahead is turned on it still prints 0,0