How you deploy your reports (with Reporting Services)

Question

Which one you choose?

• Use the Deploy feature in VS
• Build a rss script and execute it through rs.exe
• Build a deployment package
• Another option

Keep in mind that in many of your environments the report developers/designers don't have publish role in Reporting Server.

Solution

In Dev, we use the deploy feature in VS. In Prod, our Prod support team will either upload them manually from the ReportServer website (if it's just one or two reports) or use a simple report upload utility that we wrote. The utility uses the SSRS web service.