Appear in Online Interview to test your skills and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Make friends on DotNetFunda.com and expand your network!
Winners

Win Prizes

Announcements
Like us on Facebook
Sponsor
Top Articles Author
Fri, 25-Apr-2014 Authors
All Time Authors
Sourav.Kayal
39750
Sheonarayan
34800
Niladri.Biswas
33350

Latest members | More ...


(Statistics delayed by 5 minutes)
Ads

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

Karthikanbarasan
Posted by under Sql Server category on for Intermediate level | Points: 250 | Views : 13930 red flag
If you found plagiarised (copied) or inappropriate content,
please let us know the original source along with your correct email id (to communicate) for further action.
Rating: 5 out of 5
1 vote(s)


This is part 2 of series of article on SSRS where we shall see how to deploy a Report.

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.


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.

Page copy protected against web site content infringement by Copyscape
Found interesting? Add this to:




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

Posted by: Manikandanps@Zsl.Com on: 2/6/2013 | Points: 25

While i am deploying my new SSRS report i got error like "The permissions granted to user 'SystemName' are insufficient for performing this operation". How to resolve this?




Login to post response.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.

Comment using Facebook