title: using conditionals in SSRS for visibility
body: <p>In a SSRS (BIDS) 2008 report that I have created, I have a conditional statement I'm trying to use to determine the Visibility of items in a column.</p>
  
  <p>An expression almost identical to this works on the General tab, but not on the Visibility tab. I get the following error when trying to preview the report</p>
  
  <blockquote>
    <p>An error occurred during local report processing. The Hidden
    expression used in textbox 'Status' returned a data type that is not
    valid.</p>
  </blockquote>
  
  <p>I have pasted the conditional below for your reference. Do the rules/formatting for Visibility expressions differ from those of the General tab? Thanks!</p>
  
  <pre><code>=IIf(Fields!tagname.Value="3981.CompA1.Bool.CompA1StatusOnline"
  And Fields!Status.Value="0","True",
  iif(Fields!tagname.Value="3981.CompA1.Bool.CompA1StatusFaulted"
  And Fields!Status.Value="1","True",
  iif(Fields!tagname.Value="3981.CompA1.Bool.CompA1StatusOffline"
  And Fields!Status.Value="0","True","False")))
  </code></pre>