.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

Deploying a Report - SQL Server Reporting Services (SSRS) - Part 2

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

In this article we are going to see on how to deploy a report which is created and executed using SQL Server Reporting Services (SSRS)
 

Introduction

In this article we are going to see on how to deploy a report which is created and executed using SSRS. Once the report design is completed now we can follow the below steps to deploy the report and use it online. Check for my previous article on how to create a basic report.

you can refer my 1st part of this articles series here

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

Steps


Once the report is created now we need to do some basic configuration as shown in the below steps

Right click on the project name in the Solution Explorer and then select the Properties from the popup menu. You will see the window as shown in the below screen


In the options available OverwriteDataSources make it always false since if there is already an available data source it will get override and close the existing data source.

Once we are done with this configuration and checking the options now we are in the process of deploying the application. For this go to the Solution Explorer and right click on the same. There is an option given as Deploy, click on deploy as shown in the below screen


Clicking on the deploy button will deploy the report and shows the output in the Output window at the bottom as shown in the below output.

Deploying to http://localhost/reportserver

Deploying data source '/Data Sources/AdventureWorksLT'.

Warning : Cannot deploy data source AdventureWorksLT to

the server because it already exists and OverwriteDataSources

is not specified.

Deploying report '/SSRS Sample/ReportDesignerExample'.

Deploy complete -- 0 errors, 1 warnings

== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==

== Deploy: 1 succeeded, 0 failed, 0 skipped ==


After successful deployment of the REPORT we can see the output in the browser window as shown in the below screen


Note - this is a sample image, since IIS is not deployed in my system I couldn't able to take a screen shot of the report.

So we can navigate to the uri http://localhost/reportserver and check the report online

Conclusion

So in this article we have seen on how to deploy the report and how to configure the deployment process. Hope this was useful, do let me know your comment on this article.


 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