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.

How to Clean Up Your Computer's Temporary Files

There many software out there that can be used to clean up your computer and free some hard disk space. In this example we are going to use the CCleaner Tool. For me, it is the best application for cleaning those temporary files and fixing registry issues. It is easy to use and requires minimal requirements so it won't make any heavy impact to your system unlike other applications.

CCleaner offers Three Editions. In this example, we will use the free edition.

Follow the steps below on how to get and use CCleaner.

1. First you need to download CCleaner. Click here for the link.

2. After the download has finished, click the installer package to continue with the installation of CCleaner.

3. Run the CCleaner from the Desktop or from the Start Menu. 

4. Make sure you checked the files you want to delete. By default it will delete all the files in your recycle bin so you might want to double check your recycle bin, your browsers' files such as download, cookies, history, temporary internet files. 

NOTE: Please make sure your browsers are closed before proceeding.

WARNING: Files will be deleted permanently. Double check everything before proceeding.

5. Wait for cleanup to finish.6. Congratulations! You successfully cleaned up your computer. You might want to do this on a regular basis to maintain your computer's free space and performance.Thank you for reading. You can explore more of CCleaner's other features such as registry cleaner and tools that can help you uninstall programs and applications.