Hiding column(s) with multi-value parameter
I have searched the forum and while I have found some threads relating to this I can not find a definitive answer to my problem.
Here is my issue:
I have a multi-value parameter dropdown with 22 values, I have a column I want to be visible if any one of 3 values are selected (R82, R85 or R93).
I have tried the following in the column side/hide properties
=Iif(Parameters!TCN.Value(0) =
"R82" OR Parameters!TCN.Value(0) =
"R85" OR Parameters!TCN.Value(0) =
"R93", False,
True)
This seems to work the best out of all the solutions I have found but it is not perfect.
If a value in the the list before R82 is selected as well as R82, R85 or R93, the column remains hidden. If R82 or any of the other values above are the first selection in the list then the column is visible as required. I need the column to be visible
when any of the 3 values above are selected regardless of any other values selected before of after them the drop down list.
May 8th, 2012 9:16pm
Hi There
You will be able to do this Just put this expression inside your column visibility and it will work for you
I am putting screenshot for your help
Many thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
-- please change the values with your one
=iif(INSTR(join(Parameters!Employee.Value,","),"003") >0
OR INSTR(join(Parameters!Employee.Value,","),"001") >0
OR INSTR(join(Parameters!Employee.Value,","),"002") >0,FALSE,TRUE)
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2012 11:15pm
Many thanks, that worked perfectly
May 9th, 2012 7:38pm
hey Syed!...
U have been always helpful..Thanks for ur responses, the above solution worked!!!ak
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2012 1:26pm


