How to Connect Samples of Telerik Reporting to MySQL


Some of our customers don’t use Microsoft SQL Server as their database. What is not well known is that Telerik Reporting supports MySQL database out of the box.

Below, I detail the steps that are required to design reports using Telerik Report Designer from MySQL database.

  • First, install MySQL Connecter from below link.

https://dev.mysql.com/downloads/connector/net/

  • Please download AdventureWorks database for MySQL from below link and import this to your MySQL.

https://sourceforge.net/projects/awmysql/

This image has an empty alt attribute; its file name is image-6.png
  • After installing MySQL Connector you can see the “MySQL Data Provider” in drop-down list please select this. 
This image has an empty alt attribute; its file name is 1.png
  • Enter the connection string of Adventureworks database according to the below picture and click on the next button.
This image has an empty alt attribute; its file name is 2.png
  • Change the Alias if you want and click on the next button.
This image has an empty alt attribute; its file name is 3.png
  • Change query according to DB and click on the Next button.
This image has an empty alt attribute; its file name is 4.png
  • Below the screen comes and click on the Execute Query button.
This image has an empty alt attribute; its file name is 5.png
  • After clicking on the Execute Query button, If data appears on a Screen the task completed click on the Finish button or not check the query again.
This image has an empty alt attribute; its file name is 6.png

Above, we have seen how to enable Telerik Reporting Designer to fetch data from MySQL using the MySQL ADO.NET connector. There is one additional step that you need to do to render the report.

This step is to add MySQL nuget package into the host application. The package to add is MySQL.Data . This adds the capability to connect with MySQL from Telerik Reporting Host application.

Now your report is able to render data from MySQL database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s