Calc Issue

rbuser

Hi,

Calc timings is one of the things in ReportBuilder that often confuses me.
I have the following scenario which I cannot get to calculate correctly:

A group footer with the following 2 items:

DBCalc and a DBText, calc is a sum of detail records of a field

I want to subtract DBText from DBCalc so I have a 3rd item Variable1, with
the following:

calculated has DBCalc.DataField - DBText.DataField

I would have thought in timings, calculate on group footer and reset on
group header would work. I get zero. I have tried other combinations, and
all give me zero.

Any advice appreciated.

Regards

Alex

rbuser

Sorry DataField should read FieldValue

Alex

nardmoseley

DBCalc.DataField and DBText.DataField are string values that indicate the
field to which the component is assigned.

You can try using DBCalc.Value. For the DBText you will need to typecase
DBText.Text into the appropriate datatype - Integer or Double, etc.

If the above approach does not work, try using TppVariable rather than
DBCalc.




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

rbuser

Yep I meant DataValue not DataField. Anyway I managed to use Value but was
still having problems with timings. Eventually I got it to work using
BeforeFooter timing rather than OnFooter.

Regards

Alex