CODEWITHSUNDEEP
sql-serverreporting-services
Andrei Drynov
Andrei Drynov

Reputation: 8592

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

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?

Upvotes: 2

Views: 2260

Answers (2)

anakulk
anakulk

Reputation: 196

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

Upvotes: 2

Jamie F
Jamie F

Reputation: 23809

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

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

Operator: >

and Value: 0

Upvotes: 3

Related Questions