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
Open SQL Server Management Studio and connect to your local server
Create new database “Stimulsoft” and table “Employees”
Open Stimulsoft Desktop Designer and click on Blank Report
View of Stimulsoft Designer
Click on the right Dictionary button, highlighted in the screenshot
Now, click on the dropdown and select “New Data Source”
Next, select “MS SQL”
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”
Next, enter server name, select Database and press “OK”
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”
After the last step, your “Dictionary” will showing Employees table fields
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
After above step, click on Top Preview tab and your report will be displayed
In this blog, I have tried my 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.