Format Display of Formula 1

[question911]

In Crystal Reports 9, how do I change the format of my formula to display a integer value to 20 decimal places?

 

[synapsevampire]

You don't, in fact you shouldn't expect a PC to handle 20 digits of decimal precision math correctly.

You can fake it by setting the precision to 10, and then appending on 10 additional digits of zeroes if you'd like using a text field or by converting it to text, as in:

totext({table.field})+"0000000000"

-k

 

[bdreed35]

You can use the ToText function and specify the number of places to carry the decimal to without having to concatenate a string of zeros.

totext({table.field},10)

To decimal places is the max you can go out as any more will be too large.

~Brian