title: rdlc skip hidden rows on condition
body: <p>I know this may sound trivial but I just can't find an answer to it.
  I have a rdlc report in which I like to alternate row background color and for this I've used the following formula:</p>
  
  <pre><code>    =iif(RowNumber(Nothing) Mod 2, "#e5e5e5", "White")
  </code></pre>
  
  <p>I also need to hide some rows and for this I use the following formula:</p>
  
  <pre><code>    = Fields!MeanAeb.Value &lt;&gt; ""
  </code></pre>
  
  <p>where MeanAeb is a field in my report. My problem is that rowNumber also counts the hidden rows, so my table may have two consecutive rows with the same background. is there a way to take only visible rows into account?</p>