“Creating Report By Using SQL Server Reporting Services (SSRS)”
4 min readJan 28, 2020
SSRS is basically used for data displayed out to the end-user. SSRS is a reporting service that fetches the data from the SSAS as well as SQL Server.
Report Server Project is an empty report template that means he has to build things from scratch. Users can create reports in various forms such as tabular, matrix, free form, charts, etc.
Reports exist on your server and can be accessed on any web browser. SSRS has a report server.
Steps for creating SQL Server Reporting Service as follows -
- Go to the Visual Studio → Click on File → Click on New → Project.
- Choose the Reporting Services → Choose the Report Server Project, Wizard.
- If you want to browse the path then click on the browser and select the path and rename the project name then click on the OK.
- When we click on ok then it will open the following wizard → Click on Next.
- Then it will open the following wizard in which we have to select the data source from which to obtain data for this report → Select the data source.
- SSRS provides us many different types of data sources. Here I have selected Microsoft SQL Server.
- After that click on Edit → Give the Server name → Select the database → Click on OK → Then we get the connection string → to click on next.
- It will give a connection string →Click on Next.
- Then it pops up the Query Builder window → We need to specify a query to get the data for the report → Click on the query builder.
- It will pop up the query designer → Right click on blank space → Add the table → Add → OK.
- He has written a SQL query here →Click next.
- Select the type of report that you want to create Tabular or Matrix→Here I have selected Tabular.
- The tabular report is the most basic type of report. Each column relates to a column chosen from the database.
- A matrix report is a cross-tabulation of four groups of data.
- Reports have three types like the page is like header or number→Group is a listwise or country wise data→Details is actual data.
- Here I will add or data in detail as follows →Click on Details →Next.
- Give a name to the Report →Click Finish.
- Finally, the report is created.
If you are new to MSBI start with the following must-watch video: -