SSRS - Row Number excluding hidden rows
Posted on 2014-11-07
I have a report that has some rows hidden from my table. It is also grouped. I would like to count each grouped rows, but it is also counting the hidden rows as well.
I'm hoping for it to skip if the textbox23 is 0, since that's what I'm hiding. Anything with a value zero, I want to hide, and then do the row number.
=IIF(ReportItems!textbox23.Value <> 0, RowNumber("table1_Group1"), Nothing)
Any way I can get same result and excluding hidden rows?