{"id":75273,"date":"2022-02-16T09:30:00","date_gmt":"2022-02-16T13:30:00","guid":{"rendered":"https:\/\/www.askforaccounting.com\/2020\/03\/31\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/"},"modified":"2022-02-16T09:30:00","modified_gmt":"2022-02-16T13:30:00","slug":"crystal-reports-failed-to-retrieve-data-from-the-database-sage-50","status":"publish","type":"post","link":"https:\/\/www.askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/","title":{"rendered":"Sage 300 Error Crystal-based Reports Failed to Retrieve Data from the Database"},"content":{"rendered":"\n<p>Sometimes when you try to print existing Crystal-based reports after you have installed <a href=\"https:\/\/askforaccounting.com\/sage\/sage-50-2018-download\/\">Sage 2018<\/a> Fixed Assets.1, you see errors appearing. Some issues may be like Sage 300 failing to retrieve data from the database. Though this is not the only error that you may see while working with Sage, other errors similar to the same would be like.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Failed to retrieve data from the database<\/p>\n\n\n\n<p>Error occurred while opening report<\/p>\n\n\n\n<p>Report is not a valid Crystal report design<\/p>\n<\/blockquote>\n\n\n\n<p>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 the working of your Sage, then connect with help.<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><strong><span style=\"color: #ff0000;\">Warning:<\/span> <\/strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-black-color\">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.<\/mark><\/pre>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/#How_to_Fix_Sage_300_Failed_to_Retrieve_Data_from_the_Database\" >How to Fix Sage 300 Failed to Retrieve Data from the Database<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/#Step_1_Remove_the_Prerequisite_of_Sage\" >Step 1: Remove the Prerequisite of Sage<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/#Step_2_SAP_Crystal_Runtime_Installer_V151\" >Step 2: SAP Crystal Runtime Installer V15.1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/#Step_3_SAP_Crystal_Runtime_Installer_V171\" >Step 3: SAP Crystal Runtime Installer V17.1<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"how-to-fix-sage-300-crystal-reports-failed-to-retrieve-data-from-the-database\"><span class=\"ez-toc-section\" id=\"How_to_Fix_Sage_300_Failed_to_Retrieve_Data_from_the_Database\"><\/span>How to Fix Sage 300 Failed to Retrieve Data from the Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>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 Sage 300 failed to retrieve data from the database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/askforaccounting.com\/sage\/wp-content\/uploads\/2021\/03\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50.png\" alt=\"crystal reports failed to retrieve data from database\" class=\"wp-image-84472\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1_Remove_the_Prerequisite_of_Sage\"><\/span>Step 1: Remove the Prerequisite of Sage<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You need to remove the prerequisite of Sage 300 CRE Accounting installed on the error-bearing workstation, and then install it again. These are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sage 300 CRE Accounting version 15.1 installs v13.0.8.1216 of the SAP Crystal Runtime.<\/li>\n\n\n\n<li>Sage 300 CRE Accounting version 16.1 installs v13.0.8.1216 of the SAP Crystal Runtime.<\/li>\n\n\n\n<li>Sage 300 CRE Accounting version 17.1 installs v13.0.19.2312 of the SAP Crystal Runtime.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2_SAP_Crystal_Runtime_Installer_V151\"><\/span>Step 2: SAP Crystal Runtime Installer V15.1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>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.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the C: drive of your computer and then go to <strong>Program Data<\/strong>.<\/li>\n\n\n\n<li>Open the Sage Folder and follow this address: <strong>TIMBERLINE <\/strong>OFFICE9.5AccountingWinInstPrerequisitesCrystal Runtime Engine (x86)CRRuntime_32bit_13_0_8.msi.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_3_SAP_Crystal_Runtime_Installer_V171\"><\/span>Step 3: SAP Crystal Runtime Installer V17.1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>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.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the Sage Folder and follow this address: TIMBERLINE OFFICE9.5AccountingWinInstPrerequisitesCrystal Runtime Engine (x86)CRRuntime_32bit_13_0_19.msi<\/li>\n\n\n\n<li>Check if the problem is resolved by printing a Crystal printing report in Sage.<\/li>\n<\/ul>\n\n\n\n<p>Once the Sage 300 crystal reports failed to retrieve data from the database 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. The process involves technical nuances to ensure the proper troubleshooting of the issue Sage 300 crystal reports failed. <a href=\"https:\/\/askforaccounting.com\/sage\/sage-chat-support\/\">Sage chat Consultant experts<\/a> can help you out in the scenario. Our helpdesk has well-experienced professionals. You can give us call us toll-free and ask for help almost instantly.<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Sometimes when you try to print existing Crystal-based reports after you have installed Sage 2018 Fixed Assets.1, you see errors appearing. Some issues may be like Sage 300 failing to retrieve data from the database. Though this is not the only error that you may see while working with Sage, other errors similar to the &#8230; <a title=\"Sage 300 Error Crystal-based Reports Failed to Retrieve Data from the Database\" class=\"read-more\" href=\"https:\/\/www.askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/\" aria-label=\"Read more about Sage 300 Error Crystal-based Reports Failed to Retrieve Data from the Database\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":111765,"comment_status":"open","ping_status":"open","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[21,22,23,38,54,153],"class_list":["post-75273","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-accounting","tag-crystal-reports-failed","tag-crystal-reports-failed-to-retrieve-data","tag-crystal-reports-failed-to-retrieve-data-from-the-database","tag-failed-to-retrieve-data-from-the-database-details-database-vendor-code-3621","tag-how-to-fetch-data-from-database-in-crystal-report","tag-sage-50-crystal-reports-failed"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"Lawrence Flanagan","author_link":"https:\/\/www.askforaccounting.com\/sage\/author\/openfolderbin\/"},"_links":{"self":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/75273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/comments?post=75273"}],"version-history":[{"count":0,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/75273\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/media?parent=75273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/categories?post=75273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/tags?post=75273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}