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