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

Posted on 2004-11-29
Last Modified: 2011-09-20
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.

Question by:cmgtech
    LVL 100

    Expert Comment

    Is the field width in the report wide enough for 18 digits?

    Select the field
    Select the appropriate number format

    LVL 6

    Accepted Solution

    There is a document at:

    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?

    LVL 6

    Expert Comment

    by:Ken Turner
    Sorry, I missed your mention of CR9 in the title of your question.

    Not sure whether the limitation has been changed in CR9.0

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now