title: Report Viewer - convert any 0 value to display blank or null value
body: <p>How do I make any 0 value display blank or null?
  Can I do a condition expression in report viewer perhaps</p>
  
  <p>Update: here is what I have tried</p>
  
  <pre><code>=IIf(FormatNumber(Fields!totalnetamaount.Value, 2) is 0, "", FormatNumber(Fields!totalnetamaount.Value, 2))
  </code></pre>
  
  <p>It threw the exception</p>
  
  <blockquote>
    <p>Error 1   The Value expression for the textrun
    ‘totalnetamaount.Paragraphs[0].TextRuns[0]’ contains an error:
    [BC30020] 'Is' operator does not accept operands of type 'Integer'.
    Operands must be reference or nullable
    types.</p>
  </blockquote>