Calculating fields

rbuser

Is there away to multiply and subtract with a DbCalc field? It seams as it
can only sum, find the average, the max, the min, and count.

nicocizik

Hi Jonas,

Unfortunately the DBCalc component is fairly limited in its functionality.
If you would like to customize how you make calculations on your report
data, I suggest using TppVariables. For instance, if you wanted to multiply
all the values in a field you would use two TppVariable objects, one inside
the Detail band and one inside your group footer or summary band. Then
inside the OnCalc event of the first TppVariable you would add the following
code to update the second variable (ppVariable2).

ppVariable2.Value := ppVariable2.Value * Report.DataPipeline['myfield'];

--
Regards,

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

rbuser

I am trying to calculate 3 different fields for a profit on each line. How
do you get the variables to be set to the values of the Fields in the
Pipeline?

nardmoseley

Please see the tutorials in the Learning RAP end-user guide. You can
download Learning RAP from the following page....

http://www.digital-metaphors.com/Subpages/Downloads/LearningRB.html



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com