Symptom
- CR XML ODBC driver missing.
- In Microsoft ODBC Data Source Administrator, the CR XML ODBC Driver is not listed.
- Installing Crystal Reports 2020 on a computer, does not install the CR XML ODBC Driver.
- When refreshing a report based on XML data source, it fails in Crystal Reports 2020.
- The same report based on an XML data source refreshed successfully in older version of Crystal Reports.
Environment
- SAP Crystal Reports 2020
Reproducing the Issue
- Install Crystal Reports 2016, or earlier.
- In Microsoft ODBC Data Source Administrator, create an ODBC DSN to XML using the ODBC driver: CR XML ODBC Driver
- In Crystal Reports, create a report based on an ODBC DSN.
- Add at least one database field to the report.
- The report refresh successfully.
- Save the report.
- On a computer with Crystal Reports 2020 installed, open a report based on XML that was created in earlier version of Crystal Reports.
- When refreshing the report, it fails.
- In the Microsoft ODBC Data Source Administrator, the CR XML ODBC Driver is not listed.
Cause
- Crystal Reports 2020 does not install a CR XML ODBC Driver, because Crystal Reports 2020 is a 64bit application, and the third party provider for the XML ODBC driver that was installed with older versions of Crystal Reports, does not have a 64bit version of the XML ODBC driver.
Resolution
- In Crystal Reports 2020, to connect to XML, use the direct connection: XML and Web Services
- For reports created in older version of Crystal Reports that used the CR XML ODBC driver, perform a set datasource location to the connection: "XML and Web Services"
- In Crystal Reports, open a report based on an XML data source using the CR XML ODBC Driver.
- Under the menu "Database", select "Set Datasource Location..."
- In "Set Datasource Location", in the section "Replace with", expand "Create New Connection"
- Under "Create New Connection", double click on: "XML and Web Services"
- In "XML and Web Services", point to the XML data source the report was based on, and click "Finish"
- In the section: "Current Data Source", select the report ODBC connection. ( Yellow cylinder )
- Click the button: "Update"
- Click "Close"
- Save the report.
Now the report uses the XML and Web Services connection.
Keywords
CR, XML, DataDirect XML ODBC driver , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2020