that can still be done in t-sql.

Put the results into #temp table.

Then delete where grouping in (SELECT Group from #tmp group by Group HAVING SUM(transaction) > 0)

The filter is still doable in ssrs, I just don't have it on top of my head...