Skip to Content
0
Former Member
Aug 28, 2009 at 03:41 PM

Crystal Reports XI: formatting and exporting to Excel (VB 6)

56 Views

Hi.

I have a VERY simple report that all I want it to do is display the numbers from a table EXACTLY as formatted and be able to export them to Excel, as NUMBER (not STRINGS).

Example:

My fields may contains the following values in a single column:

45.02

0.04454

215

And I want them to be displayed as entered in the source table.

Initially, to maintain the formatting, I set the field's data type to a STRING.

The problem is that when I then export the data to Excel, all the numerical values are treated as TEXT and we need to "Convert Text to Numbers".

When I changed the field's data type to a DOUBLE, the data in the table is correct, but the report formats all the numbers in one way. I want to be able to retain the formatting of the field (as-is) but have them exported as numbers, rather than text.

Can this be done?

Please advise!

Thanks.

AK