Stimulsoft Reporting using SQL Server

Blog

You are here:
sql server reporting

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

step 1 1

Step 2:

Create new database “Stimulsoft” and table “Employees”

step 2a

Step 3:

Open Stimulsoft Desktop Designer and click on Blank Report

step 3 1

Step 4:

View of Stimulsoft Designer

step 4 1

Step 5:

Click on the right Dictionary button, highlighted in the screenshot

step 5 1

Step 6:

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

step 6 1

Step 7:

Next, select “MS SQL”

step 7 1

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”

step 8 2

Step 9:

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

step 9 1

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”

step 10 1

Step 11:

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

step 11 1

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

step 12 1

Step 13:

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

step 13 2

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.  

Latest Posts

Recent Posts

Sign Up for Our Newsletter and Stay Ahead of the Curve

Stay updated with the latest technology trends with our weekly newsletter

Blog

You are here:

Stimulsoft Reporting using SQL Server

sql server reporting

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

step 1 1

Step 2:

Create new database “Stimulsoft” and table “Employees”

step 2a

Step 3:

Open Stimulsoft Desktop Designer and click on Blank Report

step 3 1

Step 4:

View of Stimulsoft Designer

step 4 1

Step 5:

Click on the right Dictionary button, highlighted in the screenshot

step 5 1

Step 6:

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

step 6 1

Step 7:

Next, select “MS SQL”

step 7 1

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”

step 8 2

Step 9:

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

step 9 1

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”

step 10 1

Step 11:

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

step 11 1

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

step 12 1

Step 13:

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

step 13 2

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 *

Contact Information

Have any questions or interested in our services? We’re here to help! Reach out to us, and our dedicated team will swiftly respond to your inquiries. 

Contact Information

Ready to Explore? Whether You Want to Discuss Our Services or Have Queries, Feel Free to Send Us a Message and Let’s Get Started.