Expression for visibility property based on parameter multi-value
SSRS 2005
Hi guys, I need your help
I have a multi-value parameter
Then 2 tables, the table must be show depending on parameter passed.
If in the visibilty prop for each table I write:
1 table
=IIF(Parameters!ParName.Label =
"1",
false,
true)
2 table
=IIF(Parameters!cars.Label = "2",
false,
true)
SSRS outputs with error.
If the parameter is single value, SSRS works.
My question is: How can I write
the right expression for a visibility property in case of multi-value parameter?
Many
thanks
June 27th, 2011 8:26pm
Hi fasttrack,
You cannot make use a multiple value parameter like that, you should use Join and Instr function to decide which value has been selected, so please
modify your first table's expression like this:
=IIF(Instr(Join(Parameters!ParName.Label),"1")>0,false,true)
Modify your second table's visibility expression like this:
=IIF(Instr(Join(Parameters!cars.Label),"2")>0,false,true)
If the issue still exist, please feel free to let us know.
Thanks,
Challen Fu
Forum Support
If you have feedback for TechNet Subscriber Support, please contact
us
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 8:11am