- 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
- In Crystal Reports, create a report based on MS SQL Server
- Insert numeric fields on the report.
- When viewing the report, the numeric fields show values, like: 2.01, -1.01, ...
- Perform a set data source location to SnowFlake database.
- 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.
This issue is fixed in the patches listed in the "Support Packages & Patches" section below.
Due to different internal processes, the "Support Packages & Patches" section of the SAP Note will be populated as below:
- for fixes delivered in "Support Packages": immediately (even if the "Support Package" is planned to be released several months later)
- for fixes delivered in "Patches": ONLY once the "Patch" is released AND available on SAP ONE Support Launchpad (not before)
For Business Intelligence Platform maintenance schedule and strategy see the Knowledge Base Article 2144559 in References section.
Snowflake, supression formula, decimal, exponential , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem