DBCalc doesnt sum

rbuser

Hi!

I have strange problem that TppDBCalc with CalcType dcSum doesn't work
- it shows 0 for each row while there is underlaing field with value >
0 (so that sum can't be 0, it must be greater than 0).

Report is linked to TppDBPipeline which is linked to TDataSource which
is linked to TIBDataSet. Query (built at runtime, so there is no
persistent fields in DataSet) returns four fields:

Labisoidud : INTEGER
Kulud : NUMERIC(16,2)
TalituseNimi : CHAR(70)
YksuseNimi : CHAR(70)

Report setup:
There is one group: Break on custom field DBText2: TalituseNimi

On detail band there is three TppDBText components, linked to fields
YksuseNimi, Labisoidud and Kulud. Those show in report OK (including
one which is linked to Labisoidud).

Now on group footer band there is one TppDBText component linked to
field TalituseNimi and two TppDBCalc components of CalcType dcSum. One
is set to sum Kulud field and it works OK. Other is set to sum
Labisoidud field and this one shows 0 no matter what I do...
Any idea what is wrong?
I'm using Delphi 5.1 Pro, RB 7.0 Pro, IBX 5.03


TIA
ain

digitalmetaphors

There was a bug in RB 7.0 related to the DBCalc and Variables not computing
and resulting in zero. Please upgrade to RB 7.02 (free since you already
have 7.0) and the problem should go away.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

On Wed, 19 Mar 2003 15:03:42 -0600, "Jim Bennett \(Digital