Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

All about my Learnings & Experience on SQL Server, Business Intelligence (Microsoft BI) and Life...!!!
Browse by Tags · View All
- All Tech Articles - 22
SQL Server 10
About Me 5
Code Snippets 3
Data Profiling 2

Archive · View All
January 2012 5
March 2011 3
June 2011 3
December 2011 3
October 2011 3
February 2012 2
May 2011 2
July 2011 2
August 2011 2
March 2012 1

Datta's Ramblings on Business Intelligence 'N' Life

Deploying Multiple Reports to Report Manager in One Go in SSRS

Mar 10 2011 12:00AM by Dattatrey Sindol (Datta)   

I was deploying few SQL Server Reporting Services (SSRS) reports to Report Manager today and accidentally discovered something very interesting. Not sure if someone else has already discovered it, but just putting it on my blog so that it might help somebody out there reading this blog post.

I had about ten reports in my SSRS project and I wanted to deploy only six of them. I knew that SSRS offers deploying reports one-by-one or all the reports in a particular project to Report Manager in on go. However, in this case, I wanted to deploy a considerable number of reports from the project, but not all of them. Deploying one-by-one was a hectic task and on the other hand if I deploy all of them then I will end up overwriting the rest four reports which I do not want to.

So I just tried selecting multiple reports from the project, clicked deploy and it worked like charm :) Let's see a quick example as shown below.

1. Open your SSRS Project/Solution in Business Intelligence Development Studio (BIDS)

2. Now select the first report from the group of reports which you want to deploy, hold the Ctrl key and select the rest of the reports one-by-one, which you want to deploy. Right-Click and select Deploy from the Context Menu as shown below.

3. Now only those reports which you selected will be deployed to the Report Manager as shown below.

And that's it! It's as simple as that :)

Also, the same trick works for deploying subset of data sources to Report Manager as shown below.

Leave your comments below to let me know if you know of any other shortcuts related to SSRS reports deployment.

Note: This demonstration is based on SQL Server 2008 R2 Reporting Services.

Republished from Datta's Ramblings on Business Intelligence 'N' Life [21 clicks].  Read the original version here [3 clicks].

Dattatrey Sindol (Datta)
42 · 4% · 1336


Your Comment

Sign Up or Login to post a comment.

"Deploying Multiple Reports to Report Manager in One Go in SSRS" rated 5 out of 5 by 4 readers
Deploying Multiple Reports to Report Manager in One Go in SSRS , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]