title: Handle #Error in SSRS with missing data
body: <p>I'm writing a report in SSRS 2008 R2, and I have a field that sometimes contains no value, ie. NULL. I just want to display the value, and for populated entries, this is fine. The problem is, I can't get rid of the #Error in my report if it's a null entry!</p>
  
  <p>I've tried handling the field with multiple expressions, and none of them work.</p>
  
  <p>I've tried </p>
  
  <pre><code>=Fields!Example.IsMissing
  </code></pre>
  
  <p>but it returns false, meaning that SSRS doesn't think the field is missing. The value itself</p>
  
  <pre><code>=Fields!Example.Value
  </code></pre>
  
  <p>gives an #Error. I've tried</p>
  
  <pre><code>=iif(IsError(Fields!Example.Value), 0, Fields!Example.Value)
  =iif(Fields!Example.Value is nothing, 0, Fields!Example.Value)
  </code></pre>
  
  <p>all of which still give me #Error! Also, if I do this:</p>
  
  <pre><code>=IsNothing(Fields!Example.Value)
  </code></pre>
  
  <p>it returns false, so it doesn't think it's nothing. Frustrating! Any suggestions on what else I should try?</p>