How convert number field (floating) to text

[Former Member]

I have this field number. When I use function Cstr or ToText, alway display on reporte on floating format. Ex. 5e+018. How I do display real number 512121221458478514.

[Former Member · Accepted solution]

Hi,

I had a similar issue before. So i discussed that in the same forum, Here is the conclusion i got.

Crystal reports is built with C++ and the numeric field type used is limited to 15 digits plus 1 for the sign of the number.

Only option is to use a stored procedure and break that field into 2 parts and put them back together in a text object by

dropping the fields in next to each other.

And here is the LInk:

Regards,

Salah

[Former Member]

try quotes..."512121221458478514"

HTH,

Jyothi

[Former Member]

Just a guess here, but did you try

cstr({number},"0")

?

HTH,

Carl