Cross Tab Sum Integer Problem
Hi,
DElphi Ent 2010, Latest RB Ent and Firebird.
I am having problems which may be a bug in the Cross Tab Component.
I create an SQL on an integer field (Sum(QTY)). This correctly returns
an integer.
The Cross Tab configurator however refuses to sum this value. It only
allows the Count function.
I have found that by changing the field type in the datapipeline from
ftinteger to ftdouble corrects the problem.
Am I doing something wrong or have I located a bug ?
Mike
DElphi Ent 2010, Latest RB Ent and Firebird.
I am having problems which may be a bug in the Cross Tab Component.
I create an SQL on an integer field (Sum(QTY)). This correctly returns
an integer.
The Cross Tab configurator however refuses to sum this value. It only
allows the Count function.
I have found that by changing the field type in the datapipeline from
ftinteger to ftdouble corrects the problem.
Am I doing something wrong or have I located a bug ?
Mike
This discussion has been closed.
Comments
There is now a patch available for RB 12.03 that fixes this issue. Send a
message to support@digital-metaphors.com to receive the patch.
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com