title: How to generate Rownumber for records in SSRS when using RowVisibility based on a condition
body: <p>I am using SQL 2008 R2. I want to generete row number for the records. I can use expression <code>RowNumber(Nothing)</code></p>
  
  <p>But the rowvisibilty property is set to true based on the condition specified. My Row numbers are not correct. </p>
  
  <p>How do I generate correct row numbers when using rowvisibility?. I am using SP List data so filtering has bit problem as my filter condition takes a complex condition.</p>
  
  <p>Thank you</p>