locked
IFF condition to hide TABLE RRS feed

  • Question

  • 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<sup>nd</sup> 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

    Wednesday, February 9, 2011 2:51 PM

Answers

  • 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
    • Marked as answer by Tony Chain Thursday, February 17, 2011 1:31 AM
    Wednesday, February 9, 2011 3:02 PM

All replies

  • Try below :

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

    Wednesday, February 9, 2011 2:57 PM
  • 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
    • Marked as answer by Tony Chain Thursday, February 17, 2011 1:31 AM
    Wednesday, February 9, 2011 3:02 PM
  • 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.....?

    Wednesday, February 9, 2011 7:16 PM
  • can you try putting these expressions in your report and test out if they work.
    Thursday, February 10, 2011 9:08 AM
  • 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

    Friday, February 11, 2011 4:28 AM