Export numeric column to excel become string cell

rbuser

Hi,

I have a report that contain some numeric columns. These column become
string cell after export to excel. I am very sure the columns are of
type double. After export to excel, I can't apply excel formula like
SUM to these columns.

I am using ReportBuilder 12.


--
Best regards,
Chau Chee Yang

nardmoseley

Check the Help | About of the report designer and make sure it says version
12.01, build 197. If not, then please update to the latest release and
retest. If you have the issue with the latest release, then please generate
the report to an archive file (.raf) and send in zip format to support@ and
we can check it out here.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

nardmoseley

This issue was resolved by the developer setting the field's datatype to
dtDouble rather than dtString. For elements such as DBText the exported
DataType is derived from the DataField (i.e. the TppField.DataType).

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com