reporting services - How to hide a tablix based on a specific value in a multiselect parameter -




i need assistance trying hide tablix. scenario: have 2 tables on 1 report has multiselect parameter. need hide 1 table based on selection. need show specific table based on 1 value have used instr()and join() functions work, when select of values still table pertaining 1 specific value. example of code show specific table; =iif(instr(join(parameters!name.value),"name1")>0,false,true) shows table when 'name1' selected.... want show table when only 'name1' selected. appreciated

you should check parameter count on expression below

=iif(instr(join(parameters!name.value),"name1")>0 , parameters!name.count=1 ,false,true) 




wiki

Comments

Popular posts from this blog

Asterisk AGI Python Script to Dialplan does not work -

python - Read npy file directly from S3 StreamingBody -

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -