SAP Knowledge Base Article - Preview

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.


Read more...

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.