SAP Knowledge Base Article - Public

3072173 - Exponential values display for numeric fields after converting reports from MS SQL Server to SnowFlake database in Crystal Reports

Symptom

  • Number shows in exponential values.
  • Before setting the report data source from MS SQL Server to SnowFlake, reports displayed  the numeric values as expected.
  • After converting reports connecting to MS SQL Server to Snowflake database, numeric values show in Exponential format in Crystal Reports.

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, create a report based on MS SQL Server
  2. Insert numeric fields on the report.
  3. When viewing the report, the numeric fields show values, like: 2.01, -1.01, ...
  4. Perform a set data source location to SnowFlake database.
  5. When refreshing the report, the numeric show up in exponential values.

Cause

  • Numeric fields in the database are converted from DECIMAL field type in MS SQL Server, to Double type in SnowFlake, which causes the numeric values to display an exponential value. 

Resolution

  • The issue is resolved in the following product updates, and above:
       
    • SAP Crystal Reports 2016:
      • Support Pack 08 - Patch 12
      • Support Pack 09 - Patch 4
          
    • SAP Crystal Reports 2020:
      • Support Pack 01 - Patch 7
      • Support Pack 02

Keywords

CR, Snowflake, supression formula, decimal, exponential , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020