Connecting to MySQL DB from the report

2017-08-15

It is known that FastReport.Net can work with almost any database. And quite often the users the question arises, how to connect MySQL database to your report. In this article we will look at the process inside and out, and in two versions:

 1. In the first method, you can use special plugin to connect to the MySQL database. This plug-in is a dll library. To obtain this library, you need to build the project from FastReport.Net delivery. It is located in the folder: FastReport.Net\Extras\Connections\FastReport.MySQL. After assembly in the bin folder you will find FastReport.MySQL.dll library.

Open the report designer. Open the File-> Options menu:

On the Plugins tab add our library by using the Add button. Now restart the designer.

Add a new data source in the report. In the Data Wizard create a new connection:

 

In the list of connection types there is a new one - MySQL connection. Choose it:

Fill the fields and click Ok. In the Data Wizard, select the table from the database “world”. For example, city:

 

Click Finish to complete the wizard. That's all. The obtained data can be used in the report.

 

 2. Consider the second method - use the native connector ODBC Driver for MySQL.

You can download it from the developer - http://dev.mysql.com/downloads/connector/odbc/.

The installation does not cause problems - everything is simple and clear.

Next, run the report designer and create a new report. On the Report tab, add a new data source using the icon .

In the Data Wizard, create a new connection (New connection ...):

In the connection editor, select the type of connection - ODBC connection:

Switch the radio button to "Use connection string:". And press the button  to create a connection string. In this case you will be prompted to select a data source:

 

Click the button "New ...". The wizard of creation data source will be launched:

Choose one of the two available: MySQL ODBC. Ansi or Unicode encodings depends on your database. Click "Next." And set the connection options:

After closing this window, select the created connection in the "Select Data Source" box.

Once again we see the connection settings. Enter your password and click Ok.

Thus we get the customized connection in our Data Wizard:

Click OK. In the wizard, click Next and proceed to the tables selection:

We have considered two ways to create a connection to the database MySQL. The first method is a little more complicated in the beginning, when you want to build a library, but more convenient for subsequent reuse plugin. The second method seemed to me less convenient for subsequent use.

.NET FastReport Data Source .NET FastReport Data Source
February 20, 2025

Using Dot Matrix Printers for Printing Receipts

This article will explore how to integrate a dot matrix printer into the process of creating and outputting reports using FastReport .NET.
February 17, 2025

Adding New Users to FastReport Cloud

In the Business edition of the FastReport Cloud service, you can add users to a single workspace for simultaneous collaboration.
February 10, 2025

How to Try FastReport .NET WEB Before Purchase

By testing the WEB pack before purchasing, you can make an informed choice about whether FastReport is suitable for you.NET for your tasks.
Fast Reports
  • 800-985-8986 (English, US)
  • +31 97 01025-8466 (English, EU)
  • +49 30 56837-3928 (German, DE)
  • +55 19 98147-8148 (Portuguese, BR)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2025 Fast Reports Inc.