Showing posts with label hianother. Show all posts
Showing posts with label hianother. Show all posts

Monday, March 26, 2012

Report deploment to multiple servers SQL Reporting 2005

Hi

Another issue I would like your help:

We are writing reports for different clients. We need to deploy the same reports to different clients (thus also different DataSources). What is the best way to handle this? The folder names would probably be the same.

Andre

Sounds like you need a custom installer that will accept the required input (database name, credentials, folder path) and deploy the reports by calling down to the Report Server APIs. Or, you can script the objects and use the rs.exe utility to deploy. You may also find the RSScripter utility useful.sql