Hi, I have two parameters, ParmA and ParmB. I can pick only one of the items from ParmA. ParmB is only for user to enter a code. But what I want to do is based on one of the values of ParmA, I want place the word NONE in the ParmB. I have created a generic ParmC and it is located between both ParmA and ParmB. On the Available Values and Default values I have place the exact same code like IIF(Split(Parameters!ParmA.value.Tostring(),$$)(1) = 0, NONE, nothing) It works very well for me but I need to hide ParmC and as soon as I hide it or set it to Internal my ParmB is always gray. Would appreciate any help or thought on this. Thanks

I have never done this, but the logical conclusion is if ParamC drives anything related to ParamB then if ParamC is hidden how can the user change the value in ParamC to interact with ParamB? I don't think this is possibleRobert Attaway The SQLMDX Dude sqlmdxdude@gmail.com

thank you SQLMdxDude, I don't want user even see the ParamC. I have created for place holder. I can do this not even using the ParamC but the problem is that then ParamB becomes like a dropdown list box. It looks like you can not hide or unhide a parameters on the fly either!!!

thank you SQLMdxDude, I don't want user even see the ParamC. I have created for place holder. I can do this not even using the ParamC but the problem is that then ParamB becomes like a dropdown list box. It looks like you can not hide or unhide a parameters on the fly either!!!

Could you try just keeping the ParamC as hidden and not internal? Also are the parameters ParamB and ParamA multi-value?

Could you try just keeping the ParamC as hidden and not internal? Also are the parameters ParamB and ParamA multi-value?

ParamA is multi value but rest are not. If I set the ParamC to hidden and not internal, when deploy report to sharepoint it will show the parameter. thanks

ParamA is multi value but rest are not. If I set the ParamC to hidden and not internal, when deploy report to sharepoint it will show the parameter. thanks