i have 1 tablix,which has field in 1 row,ex name so when the report run my tablix would be name1 0.0 12.34 23.43 name2 45.32 21.23 34.43 now i want to filter name who has all the value 0.0 if i just put in row visibility all the name are gone ,as it comes from 1 field. i want to show whatever name has all the value 0 ,should not show plz help?

Change your query to select only the good rows. select name from YourTable where name = '0,0' <--If you only want name value at 0.0 select name from YourTable where name <> '0,0' <--If you don't want name value at 0.0 Else, if you can't change your query, go in Tablix property, in the Filters Tab. Add a filter, choose your field, set the operator to =, and write your value in the value field.

alright but in my filter i have 3 field that i need to check if the value is 0 ,then dont show. how to write that

Click on the Fx next to the expression in the filter expression. Add following code : =IIF(Fields!YourFirstField.value = 0 AND Fields!SecondFIeld.Value = 0 AND Fields!ThirdField.Value = 0 , False , True) Set the type to Boolean, write True in 'Value'

getting error "hiddien expression used in tablix returns invalid datatype, i m using this =IIF(Fields!YourFirstField.value = 0.0 AND Fields!SecondFIeld.Value = 0 AND Fields!ThirdField.Value = 0.0 , False , True) true

Delete your expression in the visibility Tab of the Tablix and try again!Also, make sure you only added this : =IIF(Fields!YourFirstField.value = 0.0 AND Fields!SecondFIeld.Value = 0 AND Fields!ThirdField.Value = 0.0 , False , True) To the Filter expression. And change the YourFirstField, SecondField and ThirdField to your correct field names.