<div>
&gt;I'm hoping for it to skip if the textbox23 is 0, since that's what I'm hiding.<br />
If that's the Hidden/Visible logic, then then you should be able to pull off a 'count of grouped rows' with an expression like SUM(IIF(textbox23 &gt;&nbsp;0, 1, 0)).
</div>


>I'm hoping for it to skip if the textbox23 is 0, since that's what I'm hiding.
If that's the Hidden/Visible logic, then then you should be able to pull off a 'count of grouped rows' with an expression like SUM(IIF(textbox23 > 0, 1, 0)).

<div>
When I use that expression, I'm getting the following error.<br />
<br />
&quot;The Value expression for the textbox 'textbox63' uses an aggregate function on a report item. &nbsp;Aggregate functions can be used only on report items contained in page headers and footers.&quot;
</div>


When I use that expression, I'm getting the following error.

"The Value expression for the textbox 'textbox63' uses an aggregate function on a report item.  Aggregate functions can be used only on report items contained in page headers and footers."

<div>
<div class="content wysiwyg-content">
I have a report that has some rows hidden from my table. &nbsp;It is also grouped. &nbsp;I would like to count each grouped rows, but it is also counting the hidden rows as well. &nbsp;<br />
<br />
I'm hoping for it to skip if the textbox23 is 0, since that's what I'm hiding. &nbsp;Anything with a value zero, I want to hide, and then do the row number.<br />
<br />
=IIF(ReportItems!textbox23<wbr />.Value &lt;&gt;&nbsp;0, RowNumber(&quot;table1_Group1&quot;)<wbr />, Nothing)<br />
<br />
Any way I can get same result and excluding hidden rows?
</div>
</div>


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?

SSRS - Row Number excluding hidden rows

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.