Blog

Stimulsoft Reporting using SQL Server

SQL Server

Stimulsoft Designer is a tool where you don’t need any technical skills must have an idea about basic calculations. Stimulsoft supports most of the DB Platform 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:

Step 1:

Open SQL Server Management Studio and connect to your local server

SQL Server

Step 2:

Create new database “Stimulsoft” and table “Employees”

SQL Server

Step 3:

Open Stimulsoft Desktop Designer and click on Blank Report

SQL Server

Step 4:

View of Stimulsoft Designer

SQL Server

Step 5:

Click on the right Dictionary button, highlighted in the screenshot

SQL Server

Step 6:

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

SQL Server

Step 7:

Next, select “MS SQL”

Stimulsoft Reporting using SQL Server

Step 8:

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

Stimulsoft Reporting Using SQL Server

Step 9:

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

Stimulsoft Reporting Using SQL Server

Step 10:

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

Stimulsoft Reporting Using SQL Server

Step 11:

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

Stimulsoft Reporting Using SQL Server

Step 12:

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

Stimulsoft Reporting Using SQL Server

Step 13:

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

Stimulsoft Reporting Using SQL Server

Conclusion:

In this blog, we have have tried our best to walk you guys through the detailed process of creating a Stimulsoft Report, get data from SQL Server and display 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.  

Share This Post

Your email address will not published. Require fields are marked *