[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1809
  • Last Modified:

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
0
cmgtech
Asked:
cmgtech
  • 2
1 Solution
 
mlmccCommented:
Is the field width in the report wide enough for 18 digits?

Select the field
Click FORMAT --> FORMAT FIELD
Select the appropriate number format

mlmcc
0
 
Ken TurnerCommented:
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?

0
 
Ken TurnerCommented:
Sorry, I missed your mention of CR9 in the title of your question.

Not sure whether the limitation has been changed in CR9.0
0
 
cmgtechAuthor Commented:
What I ended up doing was to insert a substr(*field name*) in the select statement.  While kind of bush league, it works for my purposes... hope it helps someone sometime.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now