title: hiding rows that contain no values
body: <p>I would like to hide rows in my report that contain no values in a certain set of fields.</p>
  
  <p>This question is helpful</p>
  
  <p><a href="https://stackoverflow.com/questions/12814117/how-to-filter-rows-with-null-values-in-any-of-its-columns-in-ssrs">How to filter rows with null values in any of its columns in SSRS</a></p>
  
  <p>i do not understand how to check whether multiple fields are null.</p>
  
  <p>currently, i am doing this:</p>
  
  <p><img src="https://i.stack.imgur.com/e4rY2.png" alt="enter image description here"></p>
  
  <p>and under the <strong>visibility</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/xeTqN.png" alt="enter image description here"></p>
  
  <p>and i typed this expression:</p>
  
  <pre><code>=iif(fields!Jan.Value
  +fields!Feb.Value
  +fields!Mar.Value
  +fields!April.Value
  +fields!May.Value
  +fields!June.Value
  +fields!July.Value
  +Fields!Aug.Value
  +Fields!Sept.Value
  +Fields!Oct.Value
  +Fields!Nov.Value
  +Fields!Dec.Value="",TRUE,FALSE)
  </code></pre>
  
  <p>but i am getting this error:</p>
  
  <p><img src="https://i.stack.imgur.com/X2FWZ.png" alt="enter image description here"></p>
  
  <p><strong>how do i hide a row if the values are null or blank?</strong></p>