Hi I have an rdl file where in I have 2 tables. I want to write in the table visibility expression 2 conditions. If any one of the 2 conditions are met then the table should become invisible. if the first condition is true then the table should become invisible or if the first condition is false then it should check the 2^nd condition – which if also true then the table should become invisible. If either of the 2 conditions are false then only the table should be visible. How could this be done 1 st condition to check : = IIF(COUNT(Fields!DATE.Value, "EMPLOYEE_DS")=0,true, false) 2nd condition to check : = IIF(Parameters!EMPLOYEE_ID_Int.Value > 0, TRUE, FALSE) HOW CAN I JOIN BOTH THESE SO THAT IF ANY ONE OF THE TWO ARE MET OR IF BOTHA ARE MET THE TABLE BECOME INVISIBLE. THANKS JUSTIN

Try below : IIF(COUNT(Fields!DATE.Value, "EMPLOYEE_DS")=0,IIF(Parameters!EMPLOYEE_ID_Int.Value > 0,TRUE,FALSE),FALSE)

Can you test the following expression? =IIF(COUNT(Fields!DATE.Value, "EMPLOYEE_DS")=0 or Parameters!EMPLOYEE_ID_Int.Value > 0,true, false) Kalman Toth, Business Intelligence Developer; SQL 2008 GRAND SLAM

would this imply that it will check both the statements. i want to put something where it will check any of the two and if any one of the two is true than it will hide the table.....?

would this imply that it will check both the statements. i want to put something where it will check any of the two and if any one of the two is true than it will hide the table.....?

can you try putting these expressions in your report and test out if they work.

Hi, Please use or condition between the two expresiion if any one of the conditions or both become true the table will not be visible otherwise it will become visible. Thanks, Shobhit Please mark an answer if this post helps