Hi List - I have a report with a band that has two DBCalcs, one sums
miles (inte) and one sums Gallons (real).
I'm trying to GETPROPERTY the values of the DBCalcs to calc MPG.
The values I get are waaaay off (858 million miles and 4.006 E-11
gallons - good mileage, but not accurate :)
Here's the EEP that is located in the F3 band with the DBCalcs:
--BeforeGenerate EEP; F3 Band; StateMonth report
SET TRACE ON
SET VARIABLE vSumF3Miles INTEGER = 0
SET VARIABLE vSumF3Gals REAL = 0
SET VARIABLE vF3MPG REAL = 0
GETPROPERTY cidSumF3Miles VALUE vSumF3Miles
GETPROPERTY cidSumF3Gals VALUE vSumF3Gals
SET VAR vF3MPG = (.vSumF3Miles/.vSumF3Gals)
PROPERTY cidF3MPG CAPTION .vF3MPG
SET TRACE OFF
RETURN
Any ideas why the GETPROPERTYs are returning the wrong values?
TIA
Doug
