Skip to Content

The main purpose of this article is to show the process of connecting MySQL Database with SAP Crystal Report 2013 using 32 bit release of MySQL Connector/ODBC. Following steps might guide you through the process of connecting to a MySQL Database:

1. Install Wamp or XAMPP and create database “dbmysql” using phpMyAdmin

2. Download and Install MySQL Connector/ODBC (x86, 32-bit) – MySQL :: Download Connector/ODBC

3. Go to Control Panel > ODBC Data Sources.

4. Select the type of DSN you would like to create (User, System, File). Next, click Add.

MySQL to SAP Crystal Report.png

5. Provide Data Source

MySQL to SAP Crystal Report - 2.png

6. Create New Connection – ODBC (RDO)

MySQL to SAP Crystal Report - 3.png

7. Select the newly created connection and through the arrow button push it to the Selected Table block

8. Select Next and then select the fields to be viewed in the report

9. Select the available template this is optional and then click on Finish.


MySQL to SAP Crystal Report - 4.png


10. Click on View in the menu bar select Preview or Preview Sample and you can find the data in the Crystal Report

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply