In this article, we will discuss in detail how to connect a MySQL data source in the Stimulsoft reporting tool.

---

Introduction

A report primarily serves to visualize and present existing data in the required format. With Stimulsoft products, you can connect to almost any type of data to create various types of reports. Today, we will focus on connecting to a MySQL data source.

---

A window will appear displaying all available data sources. Select the SQL tab and choose the appropriate type.

Important!

At this stage, the report writer automatically checks for installed adapters located at C:\Users\%username%\AppData\Local\Stimulsoft\DataAdapters\. If the adapter is not detected, click the Download button. The report generator will then download and install the adapter.

Once the adapter is installed, the window for creating a connection to the data storage will open.

---

Connection

Next, you need to specify the connection string and test it using the Test Connection control. The test result will be displayed in a message. If the connection is successful, click OK.

---

---

Editing queries using filtering as an example

Sometimes, it is necessary to edit a query to retrieve data, such as for filtering. This is typically done to reduce the size of the data transferred from storage to the reporting tool. Consequently, the processing by the report writer and the display in the viewer will be much faster.

Let's look at how to edit queries directly, using filtering as an example. Data filtering is performed as follows:

• Select the data source;
• Click the Edit button;
• Change the query in the Edit Data Source window by adding a filtering parameter.

For more information about filtering, the Parameter object, and using variables in a query, read this article.



Press the Run button or the View Data button. If the required columns are not listed, execute the Retrieve Columns command.

---