RS.exe ; use 1 rss inputfile for processing reports with different number of parameters

Question

Hello,

we are using the rs utlity to automate a large number of report . The number of parameters for a report changes, sometimes  2 or 3. But in most cases more then 4.  Some parameters are single value other are multivalue.  This means i have to create a significant number of rss files. Is there a way to use just one rss file? Does anyone have an example?

grtz Gerben

Answer 1

Hi Gerben,
Just as you said, we can use rs utility to automate a large number of reports. The rs utility is a command line utility that is driven by a Visual Basic (VB) .NET script file that can be used to manage your Reporting Services environment. The VB script file can exploit the Report Services web service to perform many different methods against your Reporting Services environment, or across multiple environments. In you scenario, different report has different numbers of parameters, so I am afraid you have to change the rss file base on the report, the link below may be helpful for you, please see:
http://geekswithblogs.net/WTFNext/archive/2012/03/31/automated-ssrs-deployment-with-the-rs-utility-again.aspx
http://www.databasejournal.com/features/mssql/article.php/3889376/How-to-Automate-Report-Deployment-Using-SSRS-Web-Service.htm

Hope this helps.

Regards,
Charlie Liao

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.