Crystal Reports XI / 2008 : NUMBER formatting with more than 10-decimals

[former_member183781]

Crystal Reports XI or 2008

The NUMBER formatting options for decimals supports a MAXIMUM of Ten (10) decimals.

1.0000000000

We have database fields that have up to Fifteen (15) decimals that can be used.

1.000000000000000

Is there any way to support that increased level of decimal-detail in Crystal Report NUMBER formatting...?

Maybe a REGEDIT setting...?

Thanks in advance!

[former_member183781 · Accepted solution]

The cstr function will alter the display on the page, but the problem is that then the field is a STRING - not a NUMBER any more, so when you send it to EXCEL or CSV the format is incorrect.

Need the 15-decimals to show while still in NUMBER format.

[Former Member · Accepted solution]

Hi Mark,

We cant keep Number with 15 decimal digits in crystal report,

I had this issue before. so i posted one thread in this forum itself.

Here is the conclusion from that,

"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".

Post link:

regards,

Salah

[Former Member]

Guessing here, but will

cstr({value}, "0.00000000000000000")

work?

HTH,

Carl