0

I am trying to show visibility of the map layer in SSRS based on multi valued Parameter. below expression is giving me errors because of multi valued parameter

=iif(Parameters!DataLayer.Value ="LeadStatus", "Visible", "Hidden")

i have the following parameters "LeadStatus" and "Industry".

Can you help me how i can write the above expression for multi valued parameter

SqlLearner
  • 763
  • 8
  • 23
  • 37

1 Answers1

0

Try this : - 

=iif(Parameters!DataLayer.Value ="LeadStatus", False, True)

In the visibility settings you use boolean values for hidden attribute. True when you want it hidden, False when you want it visible.

KrazzyNefarious
  • 3,202
  • 3
  • 20
  • 32