Stimulsoft Reporting Using SQL Server

Stimulsoft Designer is a tool where you don’t need any technical skills — you must just have an idea about basic calculations. Stimulsoft supports most of the DB platforms where you can get data, create analytics reports/dashboards and deploy on any server. You can also share your stunning reports with your clients and business partners.

In this blog, we will create a simple Stimulsoft report with SQL Server data and display data on the report.

Pre-Requisites

• Stimulsoft Designer Desktop Version. Download
• Microsoft SQL Server. Download

Step 1

Open SQL Server Management Studio and connect to your local server.

Step 2

Create new database “Stimulsoft” and table “Employees”.

Step 3

Open Stimulsoft Desktop Designer and click on Blank Report.

Step 4

View of Stimulsoft Designer.

Step 5

Click on the right Dictionary button, highlighted in the screenshot.

Step 6

Now, click on the dropdown and select “New Data Source”.

Step 7

Next, select “MS SQL”.

Step 8

After this, the New Connection window will be opened. Now you can enter Name and Alias and then click on the “Build” button for connection with SQL and create a “Connection String”.

Step 9

Next, enter server name, select Database and press “OK”.

Step 10

After, the Edit Data Source window will be opened. Now you can enter a select query and to get fields from SQL you need to click on the Retrieve Columns and Parameters button. Then click “OK”.

Step 11

After the last step, your “Dictionary” will be showing the Employees table fields.

Step 12

You can drag the DataSource1 table to the report view. It will open a “Data” popup. Now you can select all data source fields and also check-mark the fields highlighted in the image.

Step 13

After the above step, click on the Top Preview tab and your report will be displayed.

Conclusion

In this blog, we have tried our best to walk you through the detailed process of creating a Stimulsoft Report, getting data from SQL Server and displaying it on the report.

BI reporting can help modern enterprises in numerous ways. We have utilized this while working on Nexus/TicketMaster integrated solution. In case you need any help regarding the process or you want a customized reporting solution for your enterprise, feel free to contact the reporting and analytics experts at Al Rafay Consulting any time.