Using TppVariable in Detailband

rbuser

I haven't quite figured out the ppVariable component just yet. Hopefully I
can explain my situation correctly:

In a DetailBand I have two ppVariables called ppCnt and ppPercent. ppCnt
maintains a running count of various ppDBText componets in the DetailBand
(this I have working). ppPercent I want to be a percentage of ppCnt compared
to all ppCnt records within the group (this I don't have working). I have
another ppVariable (ppSum) in the GroupFooter that shows the sum of all
ppCnt varaibles.

How can I get the ppPercent (in the Detailband) to show the value based on
DetailBand's ppCnt and the GroupFooterBand's ppSum? Or is there a better way
to handle this?

mbd

nicocizik

Hi Michael,

In order to calculate the percentage of a group or grand total, you need to
create a two pass report, calculating the group, or grand total in the first
pass, then calculating the percentage of those totals in the second pass.
Check out the demo below for an example of this.

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

--
Regards,

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

rbuser

> In order to calculate the percentage of a group or grand total, you need
to
first

Your example helped me tremendously. Many thanks.

mbd