SAP Crystal Report Upgrade – Quick reference on few issues
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
Description
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
Description
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
Description
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
Description
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
Description
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.
Note
Above fixes are based on our follow up with SAP and always get concurrence from SAP support and proceed further.one of the supportive note referred during the issue