Disable or Enable 2nd Parameter based on 1st Parameter Value
Experts, I have my 1st report parameter (ID Selection - Parameter Name) with two value "Specifc Values" & "All". (Dro-down menu with default as "Specific Values") My 2nd report parameter (ID - Parameter Name), here users will end ID values into the text box ( No Avaliable nor any Default Values as it is user entery text-box). Upto here everything is working fine. My question is how can I enable or disable 2nd report parameter based on the 1st report parameter value, suppose if is "Specific Values" than 2nd parameter stay as it is, meaning whether users can enter id values, but if they change the 1st report parameter value from "Specific Values" to "All" in that case 2nd report parameter should be disable (meaning should be graded out). How can I achieve it? Thanks in advance KumarKG, MCTS
March 29th, 2011 3:58pm

I think hiding or disabling parameters at run time isn't possible. Instead of that you can populate values in your second parameter based on selection in first parameter with expression.
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 7:02am

As ursshula suggested, Enable and Disable of parameters based on values is not possible, however Textbox parameter in SSRS will not refreshed every time. Instead you can use second parameter as Dropdownlist and add DefaultValue and available values. It will refresh as per the First parameter selection. Nanda
March 30th, 2011 7:24am

Hi ursshula/BeharaVenkata/Experts, I'm still unable to complete the process successfully. So I'm update my rdl file, can anybody help me out to make this work successfully, here is the rdl file:- http://cid-15e0e13bd0545504.office.live.com/self.aspx/.Public/DependentParameter.rdl Everything is working perfectly fine as per my requirement, except one additional functionality, here is my req:- - If the user change the FirstParameter drop down menu from "Specific" -->> "All", my SecondParameter should be disable Please let me know if you have any questions or concerns. If anybody can complete this rdl file and send me back with above required functionality that will be great. Thanks in advance. KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 4:18pm

Hi Kumar, hiding or disabling parameters at run time isn't possible. You can set only set the default value for second one if the first one is ALL. Look at this tread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0b20ea58-0a55-4c65-ba3c-2e80b7162ab6/
March 31st, 2011 3:06am

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

Other recent topics Other recent topics