Skip to Content
Author's profile photo m fahim

Quick Start Guide to MySQL Database and SAP Crystal Reports 2013

The main purpose of this post 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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.