SAP Knowledge Base Article - Public

3274262 - Fields Change to Memo Datatype in Crystal Reports After Adding MapToLongVarchar Registry Key

Symptom

  • Added the MapToLongVarchar registry key to avoid fields with >254 characters being truncated, as suggested by Snowflake
  • Any fields with >254 characters change to "memo" datatype in Crystal Reports designer, which can't be used in formulas

Environment

  • Database: Snowflake ODBC
  • Driver: Snowflake ODBC Version 2.25.4
  • SAP Crystal Reports 2020 SP02 Patch 300 

Reproducing the Issue

  1. Create a Crystal Report on a Snowflake ODBC database which has fields with more than 254 characters. 
  2. See that the fields get truncated when exporting to Excel data-only (xlsx).
  3. Add the MapToLongVarchar registry key in HKEY_LOCAL_MACHINE\SOFTWARE per Snowflake's suggestion here, to resolve the truncation issue. Set the value to 254.
  4. Go back to Crystal Reports and see that the fields are not truncated anymore, but instead have changed to a "memo" datatype if they have more than 254 characters.

Cause

  • This behavior is by design

Resolution

  • This behavior is by design

Keywords

snowflake, odbc, driver, truncate, cut, off, memo, datatype , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports all versions