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, "")
-- I can't get the > (greater than) sign to display above. Just replace the > with a > sign.