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

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

Other recent topics Other recent topics