Error: "Failed to retrieve data from the Database" (Troubleshooting)

Determine if the error persists for all Crystal reports
- How to troubleshoot Crystal Reports in Sage 300 CRE: Troubleshooting Crystal Reports in Sage 300 Construction and Real Estate
  If the above article does not resolve the issue, continue with the options below:
- User does not have ODBC access: Error: "Failed to retrieve data from database" / "Failed to retrieve data set" / "Report operation failed" (Role does not have ODBC Read access)
- ODBC DSN is not configured properly: Error: "Failed to retrieve data from the database" (ODBC DSN not configured properly)
- ODBC DSN is corrupt: Error: "Failed to retrieve data from the database Details: [Database Vendor Code: 31740]" (DSN is corrupt)
- Incompatible Crystal Runtime components installed: Error: "Failed to retrieve data from the database"
The error displays when printing or previewing invoices in Billing
- Project Management is not installed: Error: "Failed to retrieve data from database" (non-Application Administrators unable to print Billing invoice formats)
- Subreport based on invoice formats will not preview in the Billing application: Error: "Failed to retrieve data from database" when previewing Billing invoice (Error in BLNP.crs or BLCP.crs)
- Invoice format is setup incorrectly: Error: "Failed to retrieve data from the Database" (Invoice format not setup correctly)
- Simba ODBC driver compatibility issues in version 16.1: Error: "Failed to retrieve data from the database Details: [Database Vendor Code: 10001]" (Previewing an invoice in Billing)
- Temporary data sources used to preview Crystal Reports did not get removed: Error: "Failed to retrieve data from the database Details: [Database Vendor Code: 31740]" (previewing an invoice in Billing)
The error displays when printing or previewing purchase order or purchase order change order forms
- Verify the header field names for purchase orders: Error: "Failed to retrieve data from the database" (PJ Purchase order forms)
The error displays when printing reports in Service Management
- Service Management DSN is corrupt:Error: "Failed to retrieve data from the database". (Service Management DSN is corrupt)
- Report is using invalid DDF files: Error: data object cannot be opened/accessed. Database Connector Error: "Data Object cannot be opened/accessed. Failed to retrieve data from the database. Error in File [ReportName] {string}.rpt: the table could not be found." (In Service Management)
- User does not have access to ODBC in Security Administration: Error: “Failed to retrieve data from the database. Details: [Database Vendor Code: 31837] “
The error displays when printing Compliance reports in Accounts Payable
- The field name of Project Manager was changed to a different name in the JC Job Setup window: Error: "Failed to retrieve data from the database" (on AP Misc Compliance Items reports)
The error displays when printing commitments in Job Cost or Project Management:
- Crystal Report design needs to be upgraded: Error: "Failed to retrieve data from the database" when printing commitments in Job Cost or Project Management