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.