SAP Knowledge Base Article - Public

1204189 - Text is not wrapped when exporting to Excel Data Only and field is set to "Can Grow" in Crystal Reports

Symptom

  • 'Wrap text' option is not automatically checked in Excel

Environment

  • Crystal Reports (CR)
  • Microsoft Excel

Reproducing the Issue

  • In CR, set 'Can Grow' option on a database field or on a formula field
  • From File menu, select 'Export' and 'Report Export Options'
  • Select 'Microsoft Excel (97-2003) Data-only' format and click 'OK'
  • Check the options 'Export object formatting' and 'Maintain relative object position' 

Cause

  • 'Wrap text' option cannot be used with 'Maintain relative object position' option
  • 'Wrap text' may modify the object position which conflicts with the requirement of 'Maintain relative object position' option

Resolution

***WARNING***: The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems. Use the Registry Editor at your own risk. Refer to Note 1323322 for more information.
  • Locate the registry 'Excel' at the below paths based on the CR version:

For CR XI Release 1: HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Export\Excel

For CR XI Release 2: HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\Export\Excel

For CR 2008: HKEY_CURRENT_USER\Software\Business Objects\Suite 12\Crystal Reports\Export\Excel

  • Create a new DWORD value key ‘WrapTextInDataOnly’
  • Set it is value to 1
  • Restart CR

See Also

SAP knowledge Base Article 1608265 - Wrap Text is applied to any database fields and formula fields when Can Grow option is unchecked in Crystal Reports

Keywords

WrapText, export, WrapTextInDataOnly, Export Object Formatting , 7427056 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2