Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
0 Kudos
This blog talks about few issues that were encountered with respect to SAP crystal reports’ behavior post upgrade and its resolution/fix.

Upgrade platform

SAP Crystal Reports 2011 (Business Objects 4.0 SP9) to SAP Crystal Reports 2016 (Business Objects 4.2 SP4) in Windows 2008 R2 servers (In-place Upgrade)

Column misalignment


Observed column shifting in report. Refer the below screenshot.
Issue Screenshot

Version 4.2 before SAP Private fix is applied             Version 4.2 after SAP Private fix is applied

Solution Provided

SAP private fix implemented.

Steps followed:

  • Stop SIA

  • Copy crxf_xls.dll file (which was received from SAP) to the directory C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

  • Start SIA

Schedule not working for Essbase reports


Crystal Report Schedule Job getting failed after upgrade to 4.2 SP4.Noticed that this error is appearing in the crystal report schedule which is based on Essbase database and other DB based schedules (Oracle, Teradata and Sybase) are running fine.
Issue text

“Object failed to run due to an error while processing on the Job Server“.
Solution Provided

SAP private fix implemented by upgrade team.

  • Stop SIA

  • Copy the files (Which was received from SAP):C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

  • mda_essbase.dll ; mda_sap.dll ; sofa_essbase.dll ; sofa_sap.dll in below directory:

  • Start SIA

Report rendering issue


Report column header changes in CR report after upgrade from BI 4.0 to BI 4.2 SP4. There was a minor alignment change in the column header of the report in CR after server upgrade which also impacted the exported PDF format.
Issue Screenshot

4.0 Version                                         4.2 Version

Solution Provided

There is a minor variance in rendering in BI 4.0 and BI 4.2 which resulted in difference.  Difference is negligible and can be ignored.

Printing issue


Labels and Letters aren't printing in correct format. Letter body is printing from the top of page overlapping with the logo.
Solution Provided

  • Login to BI Launchpad

  • Navigate to Preference icon

  • Click on Crystal reports

  • Select PDF one click printing  settings and save & close

  • Logoff and re login

Swap in data values


Swap in row values is observed in Customer related columns and data columns

Below screenshot shows swap in row values
Issue screenshot

Version 4.0:

Version 4.2:

Solution Provided

There is no sorting order (ascending/descending) in the report and the records difference appear because of row swap and data is getting displayed based on the behavior of crystal versions.  No Data issues observed.


Above fixes are based on our follow up with SAP and always get concurrence from SAP support and proceed of the supportive note referred during the issue
Labels in this area