.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

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

Posted By:Karthikeyan Anbarasan       Posted Date: March 31, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

SQL Server Reporting services are very good features 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 in Basics on how to create a report - SQL Server Reporting Services (SSRS).
 

Introduction

SQL Server Reporting services are very good features 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 of 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; if it opens then just skip that window by clicking Next. It will open a new window which shows the basic configuration as shown in the screen below:


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 screen below.


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


Clicking on Next will open the window below; 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 options to design the report based on the templates available as shown in the screen below:

 
Now when clicking on the button an interesting thing appears, 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 screen below. Here we can give our customized report name:


Clicking on Finish will open a window as shown in the screen below, 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 figure below:


Conclusion

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

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend