BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« PPS 2007: Add link to detail report to KPI in scorecard | Main

December 12, 2009

SSRS: Deploy same report to multiple SP sites

Last week I re-discovered a very handy function of the good old Visual Source Safe: Sharing files among multiple projects.

The case was that we wanted to be able to deploy the same report to multiple SharePoint sites, but just have one version in our Visual Studio projects to maintain.

Because you can only configure deployment settings per URL where you want to deploy the reports to, I created a project within my solution for each report library I wanted to deploy to.

Most sites get the same reports, sometimes a report should not be deployed to one site only and there are also reports only for a specific site. For the first category I didn't want to make just copies, because if there is a change in the report I have to manually copy this change to all other projects.

Since we just started using VSS again I remembered the option "Share to...". I did a little test, sharing reports from one VSS project to another, and this went perfect. The only thing I had to do after sharing is adding the shared files to the VS project I shared them to. Now I can deploy the whole solution, knowing for sure that a change in a shared report is automatically replicated to all sites that uses that report.

Maybe not rocket science or even a trick, but just a tip for when you're using the same tools and have the same requirement.

Posted by Ben de Ridder at December 12, 2009 4:45 PM


Hey I like your post, is there any post on SSRS tutorial for novice

Posted by: Kuldeep at June 3, 2010 6:24 AM

hey there and thank you for your information – I’ve certainly picked up anything new from right here. I did however expertise a few technical issues using this site, since I experienced to reload the website a lot of times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I'm complaining, but sluggish loading instances times will often affect your placement in google and could damage your quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and can look out for much more of your respective exciting content. Make sure you update this again soon..

Posted by: escort London at May 16, 2011 3:56 PM

It’s actually a nice and useful piece of information. I am glad that you shared this helpful info with us. Please keep us informed like this. Thanks for sharing.

Posted by: London escort service at May 16, 2011 11:24 PM

I simply wished to thank you very much once more. I am not sure what I would've accomplished without the entire solutions documented by you on this subject matter. It became a very troublesome circumstance for me, however , being able to see the well-written strategy you processed the issue took me to jump with delight. Now i'm grateful for your information and as well , trust you recognize what a powerful job you are providing instructing some other people with the aid of your blog post. More than likely you've never got to know all of us.

Posted by: at May 17, 2011 3:17 AM

Post a comment

Remember Me?