1554236 - Text truncated at 65,534 characters, for Memo Fields, Text Objects, Formula, SQL Expression and Command Object, in Crystal Reports

• Long text truncated.
• Not all the text display.
• Large SQL code cannot be fully copied in SQL Expression Field, or Command Object.
• In Crystal Reports, the content of Memo Fields, Text Objects, SQL Expression Fields, Formula Fields, Command Objects is partially displayed or cut after 64k (65,534 characters )

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020

1. In Crystal Reports, create a report based on any data source.
2. Add a Table that contains a database field that contains more than 65,534 characters.
3. Add the Memo Fields to the report, and set the format option to "Can Grow".
4. When previewing the report, notice the text is truncated.

• This is normal behavior because the maximum number of characters the following objects can display in Crystal Reports is 65,534 characters:  
• Memo Fields,
• Formula Fields,
• SQL Expression Fields, 
• Text Objects,
• Command Object

• For Crystal Reports, a potential workaround to this limitation is to create a Stored Procedure that split long text fields at the database level to less then 65,534 characters each, then add each database fields separately on the report.  
     
• SAP Crystal Reports for Enterprise is a Java application, and it does not have this limitation, therefore, Database Fields, Formula Fields and Text Objects can display more than 65,534 characters.
     
• Important Note: Database fields length may be limited by the middleware used to connect. For example, the ODBC driver used may have a limitation.

Crystal Memo Text 64k 65534 truncate truncated Memo CLOB Access Oracle Shortened , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020