Reporting Services - Change default parameter values from a command line tool
I have 40 reports and growing which constitute a large dashboard type website that I am deploying using the report viewer and ASP.NET 4. Because of end user requirements and other issues I cannot show the end user the default parameter pane. Instead I have an ASP.NET page that collects those and passes the values on. My biggest issue is I have a bunch of parameters that I need to change based on deployment requirements. So going to 40+ reports one by one in IE is just not time friendly. I tried downloading a bunch of examples from Codeplex here but the MSI says it only works on 64 bit systems. So I am unable to install the examples to determine if they solve my issues. I have standardized all of the report parameters across all reports so here is my scenario: I have a parameter called FOO and its default is BAR I want to change all of FOO's values from BAR to BAR1 using a command line tool or some other thing that I can just run it against the report server using FOO and BAR1 and let the script or tool change all of the reports that contain FOO to the new value BAR1. I have searched over and over again and have not found anything. Any help is much appreciated. Thanks Rob Attaway sqlmdxdude@gmail.com
August 12th, 2012 10:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics