Dataset filtering in a SSRS report - how to hide records with 0s only

2
votes

Based on the http://www.mssqltips.com/sqlservertip/2597/dataset-and-tablix-filtering-in-sql-server-reporting-services/, I created a dataset in a SSRS report which returns results like this:

enter image description here

I want to hide rows which contain only 0 using the dataset filtering feature, so that the tablix shows something like this:

5     178
399   141
0     750 
12    6
0     26

How do I do that?

2
sql-serverreporting-services
I used a solution from stackoverflow.com/questions/7838927/…. I set Visibility expression on the Row Group using this formula: =IIF(SUM(Fields!Field1.Value) > 0 OR (SUM(Fields!Field2.Value) > 0), false, true) and the result was magical – AFD

2 Answers

3
votes

Set the expression (click the fx button) in your filter to be:

=Fields!ColumnA.Value + Fields!ColumnB.Value

Operator: >

and Value: 0

2
votes

Try to add Filters to dataset..Following link will help you.. http://technet.microsoft.com/en-us/library/dd255287.aspx