SAP Knowledge Base Article - Public

1874525 - Number field shown in exponential format if the digits are more than 18 in Crystal Reports

Symptom

In Crystal Reports if the number field more than 18 digits is displayed in Exponential format.

For ex: the number "1452354879654258746" is displayed as "5.28e+087"

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. Create a report in Crystal Reports designer.
  2. Drag a number field with digits more than 18 and drop it into the report.
  3. The number is displayed in format like "5.28e+087".

Cause

This is expected behavior.

Resolution

Workaround 1:

Create a View on this field such that you get the field converted into String.

Workaround 2:

  1. Create a report using the number field with more than 18 digits.
  2. Create a formula for the Number Field, @test : "cstr(Number Field)"
  3. Drag and drop the number field into the report, numbers will be shown in correct format.

Keywords

Field type issue, Number field not showing correctly , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03