SAP Knowledge Base Article - Public

1217520 - Data in formula fields are not exported to Microsoft Excel

Symptom

When exporting a Crystal report that contains formula fields to Microsoft Excel, data in the formula fields are not exported.

 

Cause

The issue has been identified and tracked under ID ADAPT00283852. It affects the following products:

  • Crystal Enterprise (CE) 9
  • Crystal Enterprise Report Application Server (CE RAS) 9
  • Crystal Reports (CR) 9

Resolution

This issue occurs because the Crystal Report Print Engine does not cache spilled formula fields correctly. Hot Fixes or Service Packs address this issue as indicated below. With the update, this issue is resolved.

Unless indicated otherwise, Weekly Hot Fix updates from the FTP site have only been tested with English versions of our products.

Crystal Enterprise 9

--------------------

For Crystal Enterprise 9, the update for this issue is available on the Downloads area of our web site.

If you have made any modifications to ePortfolio or Crystal Server Page (CSP) files, this update may overwrite your custom code in CSP files. If you have customized your CSP files, it is recommended to back up your CSP files in the ePortfolio folder before applying updates.

This issue is addressed in the following components (and later versions):

  • Crpe32.dll, version 9.2.3.1154, dated 7/5/2004
  • Crpe32.pdb, dated 7/5/2004

 

Crystal Enterprise Report Application Server 9

--------------------------------------------

For Crystal Enterprise Report Application Server 9, the update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • Crpe32.dll, version 9.2.3.1154, dated 7/5/2004

 

Crystal Reports 9

-----------------

For Crystal Reports 9, the update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • Crpe32.dll, version 9.2.3.1154, dated 7/5/2004
  • Crw32.exe, version 9.2.3.1154, dated 7/5/2004

 

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CR WHF 283852 Crystal Reports Exporting Microsoft Excel Formula Fields , c2015972 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports 9.0