title: How do I set the visibility of a text box in SSRS using an expression?
body: <p>I have a subtotal field for a calculated column that I want to hide when my report has not ran yet because on days with no data it shows up as <code>NaN</code> on the report.</p>
  
  <p>I have tried two methods but neither are working and I am sure it is almost correct. I just don't know what is wrong with the expression.</p>
  
  <p>I tried hiding if my dataset had no rows.</p>
  
  <pre><code>=IIf((CountRows("ScannerStatisticsData")=0),False,True)
  </code></pre>
  
  <p>I also tried making a calculation </p>
  
  <pre><code>=iif((fields!Scans.Value / fields!numberOfCases.Value) = 0, False, True)
  </code></pre>
  
  <p>I also tried checking isnothing on one of the columns in the calculation</p>
  
  <pre><code>=iif(IsNothing(fields!Scans.Value), False, True)
  </code></pre>
  
  <p>What am I doing wrong? </p>