How to Connect MySQL to Crystal Report

Using SAP Crystal Reports is best for its flexibility when it comes to handling data sources. Unlike other Reporting Services, Crystal Reports can be connected to a vast number of data sources. But with all the data sources available, MySQL is not available in SAP Crystal Reports. Fortunately, there is a way on how to connect MySQL to Crystal Reports.

Follow the instructions below on how to connect MySQL to Crystal Reports.

1. First, you need to download the MySQL to ODBC connector from here. Next pick the suitable installer for your system whether it is a x86 or x64 bit Windows Operating System.

You need to have an account before you can download the installer. If you want to save some time, you can also download the 5.2.2 version from here. (This may not be the latest version).

2. After downloading the file, run the installer package to continue with the installation. Please read carefully the instructions on how to install the ODBC connector.

3. After the installation is finished. Search for the ODBC Data Sources and run it from the Start Menu.

4. Navigate to the System DSN tab then click Add.

5. Select the MySQL ODBC <version number> Driver. Click Finish to continue.

6. Enter the proper Connection Parameters. Click Test to verify the parameters provided. Click OK to Continue.

7. Open SAP Crystal Reports and create a blank report. 

8. Expand the Create New Connection to view the various connections you can use.
   Select ODBC(RDO).

9. Select your desired MySQL Database then click Next. 

You need to provide the necessary information to log on to the chosen data source. Click Finish to continue.

10. Congratulations! You can now design a report for your MySQL Database.