Perfect timing, Les. I'm trying to do the same thing - I'm using DBCalc
in a report footer to sum miles & gallons, the using those totals
to do some calculations in a break footer above but I couldn't get it to
work - even set for two passes, the totals weren't showing above..
Then I found the trick after studying the SalesSumAndSubTot report in
RRBYW14.
Place the DBCalcs in the HEADER and use the GETPROPERTY to snag the
values in a Before Generate EEP in the RH. Not sure if that's the most
correct way but its working.
I was muckin' around with the Pass setting and Lookahead but they're
unnecessary. I changed the Two Pass (Report|PassSetting) to One. I
thought Lookahead was needed but apparently not (in this case).
I'm gonna keep pluggin' away but wanted to get this out hoping it will
help you.
Doug
Les Stark wrote:
I tried calculating it in report footer, page footer, detail, etc,
.... nothing worked and I cannot use the dbcalc because this variable
is used as part of another variable in a calculation.
