Microsoft

How To Create Reports Using SQL Server Reporting Service(SSRS)

Istock 1194430859

 

SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, Mobile and printed reports using SQL Server and other data sources. It is part of Microsoft SQL Server Services suite. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications.  It produces formatted reports with the tables of data, graph, and reports. Reports are hosted on a server and can be configured to run using parameters supplied by users.

Here, are prime reasons for using SSRS tool:

1.SSRS is an enhanced tool compared to Crystal Reports

2.Faster processing of reports on both relational and multidimensional data

3.Allows better and more accurate Decision-making mechanism for the users

4.It provides a World Wide Web-based connection for deploying reports. Hence, reports can be accessed over the internet

5.SSRS allows reports to be exported in different formats. You can deliver SSRS     reports using emails

6.SSRS provides a host of security features, which helps you to control, who can access which report

How SSRS Works?

The report users are the peoples who work with the data as well as want some insights from data. They send a request to the SSRS server.

SSRS server finds the metadata of the report and sends a request for data to the data sources.

Data returned by the data source is merged with the report definition into a report.

When the report is generated, it is returned to the client.

As we know now what SSRS, Let’s see how to use SSRS to create a Reports –

Step1 –

           First we open “Visual Studio(SSDT) and  click on “Create new project “.

Step2 –

           Select Reporting Services and create Report project name.

2create Project Name

Step3 –

           This is the home page of SSRS

3home Screen For Ssrs

Step 4 –

           Now we check our dataset in SQL server for that we have to create a report.

4data

Step 5 –

                Now we Right click on shared data sources. First we create data source name and select type Microsoft SQL Server and in the connection string connect with your local server name .

 

5create Data Source

Step 6 –

                Now we Right click on shared data sources and select add data sources . First we create data source name and select type Microsoft SQL Server and in the connection string connect with your local server name and select database name of your dataset(table).

5.11

 

Step 7 –

                Now we Right click on shared data sets. First we create data set name and select data source that we already created and in the query type select text and write a select statement for the table.

5create Data Source 1

Step 8 –

                Now we Right click on Reports and select add then new item.

And new window is open, select Report and it will take to design page of reports.

7

Step 9 –

                Now we Right click on design page then insert and click on any required reporting type, in our case we are using chart.

 

8

Step 10 –

                Now chart type window is open and we can select any required chart type. In our case we are using under shape category.

 

9

Step 11 –

                Now select shape and it will come in our design window.

10

Step 12 –

                Now we right click on chart and new popup window will come and we can

Add columns on our report requirements.

11

Step 13 –

                After selecting proper columns for report we can preview our Report in a preview page and now we can send this report.

 

Final

Here we have successfully generated Report using SSRS.

Please share your thoughts and suggestions in the space below, and I’ll do my best to respond to all of them as time allows.

for more such blogs click here

Happy Reading!

 

 

Thoughts on “How To Create Reports Using SQL Server Reporting Service(SSRS)”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Shobhit Bisen

Shobhit Bisen works at Perficient as an associate technical consultant. He has a firm grasp of SSIS, SSRS, Python, and SQL. Shobhit also has a good knowledge of Snowflake and ADF. He is always ready to learn new things.

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Follow Us
TwitterLinkedinFacebookYoutubeInstagram