SAP Knowledge Base Article - Public

1205622 - Could not able to see Memo field data. Truncated to first few characters

Symptom

In Crystal Reports, Oracle long field shows as Memo Field. When trying to retrieve data from this field it shows only first few characters.

Cause

It is because of using an old version (3.50.00.00) of ODBC connection.

Resolution

Update the ODBC connection to 5.00 or change the data source to OLE DB then it will pull data from Memo field.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2