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
Post a Comment