reporting services - Use a multiselectbox to hide or show chosen tablix -


i have 3 tablix (tablix1,tablix2,tablix3). got parameter (selectbox) user can select tablix wants see. other tablix should hidden. can dropdown menu 1 option choose, not multiple choices. dont know how this, please. similar topic no answer works me

you can easily.

assuming multi-value parameter called myparameter , parameter values follows

label      value "tablix 1"   1 "tablix 2"   2 "tablix 3"   3 

then can set visibility property of each tablix follows

=join(parameters!myparameter.value,",").contains(1)=false 

change (1) (2) or (3) each tablix.

the expression joins selected parameter values single string "contains" check if value exists.

note: work 0-9, if had value of '10' , checked '1' incorrectly return true have 3 tablix you'll fine.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -