Values > 0 in Expression

Question

Values > 0 in Expression

sharonsql2013

SSCertifiable

Points: 5908
More actions
February 26, 2014 at 9:41 am

#396333

I only want to see all the values in the column which are greater than 0. I don't want to put it in the where clause(Query) because there is a lookup based on that . But want to display in the table only the one's which are > 0.
How can I achieve this?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

sharonsql2013 (2/26/2014)
I only want to see all the values in the column which are greater than 0. I don't want to put it in the where clause(Query) because there is a lookup based on that . But want to display in the table only the one's which are > 0.
How can I achieve this?

Use an expression, give IIF() a look. Something like:

=IIF(Fields!YourColumn.Value > 0, Fields!YourColumn.Value, "")

HTH,

Rob

Edit -- I can't get the > (greater than) sign to display above. Just replace the > with a > sign.

sharonsql2013 SSCertifiable Points: 5908 More actions · Answer 2

Thanks.

The Thing is the IIF Clause returns blank row if the value is not meeting the condition. I am looking for it to not to display that row if the condition is not met.

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 3

Try putting that expression in the Visibility for that group. You want the IIF() to evaluate as either True or False (for visible or not).

HTH,

Rob