SSRS: Can I exclude Report rows based on a Report calculation?
<p>I inherited a report where the Grouping and Aggregation is done in the Report. The Dataset is a SQL Server 2008 Query.</p>

<p>This raw Data:</p>

<pre><code>ID           Budget Amount    Spent Amount
A              1,500            20 
A              1,500            20
A              1,500            60
B              2,000            50
B              2,000            75
B              2,000            75
</code></pre>

<p>Shows like this on the report:</p>

<pre><code>ID           Budget Amount    Spent Amount
A              1,500            100 
B              2,000            200
</code></pre>

<p>I added a calculated field to the Report to get this:</p>

<pre><code>ID           Budget Amount    Spent Amount      Balance
A              1,500            100              1,400
B              2,000            200              1,800
</code></pre>

<p>Can I do something <em>in the report</em> to exclude rows that have a balance less than 1,500?
If not, what are my other options?</p>

<pre><code>  ****************************
</code></pre>

<p>. . . the next day . . .</p>

<p>Having tried suggestions to add a Filter Exp. to the Tablix and a Row Visibility Exp. to the row - unsuccessfully - here is what I found:</p>

<p>My actual report has two Row Groups on the row for which I want to limit the rows that show.</p>

<p>I tried the same suggestions made in this thread on another report [with no Row Groups] ... and the Tablix Filter and the Row Visibility both worked fine.</p>

<p>I have to assume that the fact that my 'problem' report has two levels of Grouping is the cause of the Expressions not working.</p>

<p>BUT . . . is there a way to overcome this?</p>

<pre><code>  ****************************
</code></pre>

<p>I just realized [while researching this same issue elsewhere] that the report I am working with does not have a 'Details' row. </p>

<p>What I was thinking of as a Details row is not. There is no Details Row in this report. I have been trying all your suggestions on a row that is not a Details row.</p>