SQL Server Reporting Services (SSRS) – Part 1- Basics on how to create a report

Karthikanbarasan
Posted by in Sql Server category on for Intermediate level | Points: 250 | Views : 10744 red flag
Rating: 5 out of 5  
 2 vote(s)

This is part 1 of series of article on SSRS and we shall know basics on how to create a report in SSRS.

Introduction

SQL Server Reporting services are very good feature provided in SQL to build a report of user choice and deploy it to make use of it anywhere as per the requirement. In this article we are going to see on how to create a simple report then build and execute the report. Reports can be exported to multiple formats including delimited text, XML format, pdf format and Microsoft Excel as well.

Let s jump into the process and see the step by step process on how to create and execute an SSRS report.


Steps:


Go to SQL Server Business Intelligence Development Studio and create a new project as shown below


Now a wizard will / may open based on the existing option selected just skip that window if it opens by giving Next. It will open a new window which shows the basic configuration as shown in the below screen


Next window will show an option to build a query based on which the result set will be displayed as a report. We can write our own query to fetch the output as shown in the below screen.


Clicking on Next will open a window which have the option to select on how the result should display as shown in the below screen


Clicking on Next will open the below window, if you can see the option here to group the data and show as per our requirement


Clicking on the Next button will open a window which gives option to design the report based on the templates available as shown in the below screen


Now clicking on the button the interesting thing comes over, which is nothing but where to deploy the report. We can give as per our requirement


Clicking on Next will open a window as shown in the below screen. Here we can give our customized report name


Clicking on Finish will open a window as shown in the below screen, which shows the structure of the report as shown below


Now press F5 to build and execute the process. It will show the result as shown in the below figure




Conclusion

So in this article we have seen on how to create, build and execute a basic report using SQL reporting services.

Page copy protected against web site content infringement by Copyscape

About the Author

Karthikanbarasan
Full Name: Karthikeyan Anbarasan
Member Level: Silver
Member Status: Member,Moderator,Microsoft_MVP,MVP
Member Since: 1/2/2011 3:00:14 AM
Country: India
Thanks Karthik www.f5Debug.net
www.f5Debug.net
www.f5Debug.net Around 5 years of experience in Microsoft technologies like ASP.Net, VB.Net, C#.net, SQL server, Biztalk Server, WCF, WPF, SSIS, SSRS, SSAS, AJAX and working as Senior Analyst in a US based MNC.

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)