views:

184

answers:

3

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.

A: 
KSwift87
A: 

Not 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

gbn
I'm confused as to how this would help me (although I thank you for trying). Would this then allow me to feed something to the report like "FieldID=43" in the query string?
KSwift87
KSwift87
Just got done testing, and it turns out not the whole bar itself.
KSwift87
A: 

(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!

Amal Khezami
I appreciate the response AmalK, and I must admit I found it interesting. However this unfortunately doesn't help me because I need to be able to dynamically set whether it's hidden or not through the URL query string.
KSwift87