Summary
Error: "Unable to cast COM object of type 'CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass' to interface type CrystalDecisions.ReportAppServer.Controllers.'SCRReportSource' when attempting to print or preview reports from Sage 500
Description
Cause
The issue was caused after installing Sage Fixed Assets 2018.1 due to an incompatible version of Crystal included with that release.
Resolution
Below are 3 different scenarios that might be encountered. See Figures 1-6
If Sage 500 reports are returning error messages
- Close all Sage 500 report tasks
- Download and extract the Crystal Configuration Utility
- Right-click CrystalConfig.exe and select “Run As Administrator” to launch the utility
- The upper left-hand corner the shows the version of Crystal that was installed last
- Click on the Sage 500 Reports button
- The screen should now be populated with a list of all the report file executables for Sage 500 that will be affected. Scroll down the list and confirm all have a checkmark in the Select box
- Click the Apply Config Files button and click Yes to the “Are you sure you would like to set the .config files to SP21 or greater?”
- The list of report files should now show Success under the Status column
- You can now launch report tasks in Sage 500 and preview/print without error
If Sage Fixed Asset reports are returning error messages
- Close all Sage Fixed Asset report tasks
- Download and extract the Crystal Configuration Utility
- Right-click CrystalConfig.exe and select “Run As Administrator” to launch the utility
- The upper left-hand corner the shows the version of Crystal that was installed last
- Click on the Sage SFA Reports button
- The screen should now be populated with a list of all the report file executables for Sage Fixed Assets that will be affected. Scroll down the list and confirm all have a checkmark in the Select box
- Click the Apply Config Files button and click Yes to the “Are you sure you would like to set the .config files to SP21 or greater?”
- The list of report files should now show Success under the Status column
- You can now launch report tasks in Sage Fixed Assets and preview/print without error
If both Sage 500 and Sage Fixed Assets reports are returning error messages
- Close all Sage Fixed Asset report tasks and close down all Sage 500 report tasks
- Download and extract the Crystal Configuration Utility
- Right-click CrystalConfig.exe and select “Run As Administrator” to launch the utility
- In the upper left-hand corner the version of Crystal installed last will be displayed
- Click on the Advanced box at the bottom of the utility, so that it has a checkmark. This will enable both Sage 500 Reports and SFA Reports buttons
- Click on the Sage 500 Reports button
- The screen should now be populated with a list of all the report file executables for Sage 500 that will be affected. Scroll down the list and confirm all have a checkmark in the Select box
- Click the Apply Config Files button and click Yes to the “Are you sure you would like to set the .config files to SP21 or greater?”
- The list of report files should now show Success under the Status column
- Click on the SFA Reports button
- The screen should now be populated with a list of all the report file executables for Sage Fixed Assets that will be affected. Scroll down the list and confirm all have a checkmark in the Select box
- Click the Apply Config Files button and click Yes to the “Are you sure you would like to set the .config files to SP21 or greater?”
- The list of report files should now show Success under the Status column
- You can now launch report tasks in Sage Fixed Assets and Sage 500 and preview/print without error
FIGURE 1
FIGURE 2
FIGURE 3
FIGURE 4
FIGURE 5
FIGURE 6
DocLink: How to Install Sage 500 ERP client on Windows 2012 and Windows 8 architecture
DocLink: Crystal Runtime Version Conflict
DocLink: Crystal Configuration Utility
Attachment: 381_20230425125319_CrystalConfigUtility.zip