in

Scientific Notation Issue in Crystal Reports 9.  18 Digit number turned into Scientific Notation.

I am querying a field in ORACLE 9 that is 18 characters long.  


Example This number: 800010100000005040
Turns into this in CR: 8.00e+017

I think it is something pretty easy if someone has run into this before, I am just new to crystal and don't know what options I have at my disposal at this time.  I have done a google search for things also and con't find anything too close.

Thanks in advance.

-Mark

Solution: Scientific Notation Issue in Crystal Reports 9.  18 Digit number turned into Scientific Notation.

There is a document at:

http://support.businessobjects.com/library/kbase/articles/c2009789.asp

which says, amongst other things, "Numbers and currencies are represented in Crystal Reports as double-precision floating-point values with a precision of 15 decimal digits."

The document refers to CR8.0 - which version are you using?