Sometimes when you attempt to print existing Crystal-based reports after you have installed Sage 2018 Fixed Assets.1, you see errors appearing. There are issues that may be like: “Sage 50 Crystal reports failed to retrieve data from the database“. Though this is not the only error that you may see while working with Sage 50, other errors similar to the same would be like:
‘Sage 50 cannot retrieve data from the database”,
“Error while operating report,”
“The report you entered is not a valid Crystal Report Design.”
So no matter what error you may see, the whole point would be to get rid of the issue as soon as possible. If the problem is continuous and it is hindering in the working of your Sage then connect with help.
Warning: You need to have a sound knowledge of your network. You may need to contact the system administrator to help you out. Do not indulge in the process if you do not have sufficient technical knowledge. We suggest you get in touch with Sage tech support phone number. They can help you resolve the problem instantly.
How to Fix Crystal Reports Failed to Retrieve Data from the Database
Crystal Runtime Components installed are not compatible. If that is the scenario then we need to go to the installed Crystal Runtime Components one by one and reinstall them. This will solve our problem for good. Follow the next steps to troubleshoot the error.
Follow the below given steps to resolve the issue. Ensure that you follow each step carefully and follow all the instructions:
Total Time: 15 minutes
Step 1: Remove the Prerequisite of Sage
You need to remove the prerequisite of Sage 300 CRE Accounting installed on the error-bearing workstation, and then install it again. These are:
🔹 Sage 300 CRE Accounting version 15.1 installs v184.108.40.2066 of the SAP Crystal Runtime
🔹 Sage 300 CRE Accounting version 16.1 installs v220.127.116.116 of the SAP Crystal Runtime
🔹 Sage 300 CRE Accounting version 17.1 installs v18.104.22.1682 of the SAP Crystal Runtime
Step 2: SAP Crystal Runtime Installer V15.1
You can find the SAP Crystal Runtime Installer for both v15.1 and v16.1 by going to these locations on the Sage 300 CRE Server:
🔹 Go to the C: drive of your computer and then go to Program Data.
🔹 Open the Sage Folder and follow this address: TIMBERLINE OFFICE9.5AccountingWinInstPrerequisitesCrystal Runtime Engine (x86)CRRuntime_32bit_13_0_8.msi
Step 3: SAP Crystal Runtime Installer V17.1
Similarly, you can find the SAP Crystal Runtime Installer for v17.1 by going to these locations on the sage 300 CRE server: Go to the C: drive of your computer and then go to Program Data.
🔹 Open the Sage Folder and follow this address:TIMBERLINE OFFICE9.5AccountingWinInstPrerequisitesCrystal Runtime Engine (x86)CRRuntime_32bit_13_0_19.msi
🔹 Check if the problem is resolved by printing a Crystal printing report in Sage.
Once the problem has been resolved, you can go to printing your Crystal based printing reports. If you are unable to print a report even after going through the process, you can get in touch with the Sage 50 Technical Support team.
The process involves technical nuances to ensure the proper troubleshooting of the issue “Crystal Reports Failed Sage 50”. Sage 50 Support Experts can help you out in the scenario. Our helpdesk has well-experienced professionals. You can give us a call us toll-free and ask for help almost instantly.