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


  • 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.


  • 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.


  • 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. 


  • 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


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


SAP Crystal Reports 2016 ; SAP Crystal Reports 2020