Hi. I'm trying to figure out how I can dynamically hide/unhide parameters for a Reporting Services report I've created via a URL query string. I've tried reading a whole bunch of stuff I found through a Google search and I've also tried reading various MSDN documents regarding SQL Server, but I have yet to find a way how I can pull this off. Does anyone know how I can accomplish this? Thanks in advance.
views:
184answers:
3Not sure if you still want this, but you'd use the &rc:Parameters=false
setting in the URL
Edit: that hides/unhides the parameter block as you mentioned.
To set parameters you'd have something like &EmployeeID=1234&FieldID=43
in the URL
So you can set parameters and hide them
Edit2: you can only do this at design time. I forget the option, but you can have hidden parameters in the report parameter page that can be set via URL access or via Report manager
(DISCLAIMER: May depend on the version of SSRS you're using, if you're using 2005 & up, you should be good, I believe)
This is possible, in the xml definition for the report, find the definition for the parameter, it should look something like this
<ReportParameter Name="YourParameterNameHere">
<DataType>String</DataType>
<Prompt>YourParameterNameHere</Prompt>
</ReportParameter>
And you can add this line to set hidden to true:
<ReportParameter Name="YourParameterNameHere">
<DataType>String</DataType>
<Prompt>YourParameterNameHere</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
Hope this solves your issue!