Setting Visibility expression based on another field value being present RRS feed

  • Question

  • Hello.

    I have a Text Box that has two fields contained within.  The first field will always have data, but the second could or could not.

    I want to have the entire textbox to be hidden if there is no data in the second field.

    I'm thinking the expression should be something along the lines of...

    =Fields!SecondField.Value <> NULL


    Friday, August 5, 2016 10:22 PM


  • Can you Change "Hidden" Property of TEXTBOX to have this Expression =IIF( First(Fields!Field_2_Optional.Value, "DataSet2") = NOTHING OR 

     First(Fields!Field_2_Optional.Value, "DataSet2")   = ""

    , TRUE , FALSE ) note : 1. change the Fields!Field_2_Optional.Value to your field name 2. First( ..) function was used since a textBox can show only one value(assuming TextBox is not part of table) . IF you are using textBox in a Table (ReportItem) remove this Function (so it works for Row)


    • Edited by msbi_Dev Friday, August 5, 2016 10:42 PM
    • Proposed as answer by Xi Jin Monday, August 8, 2016 3:08 AM
    • Marked as answer by Xi Jin Tuesday, August 16, 2016 8:08 AM
    Friday, August 5, 2016 10:38 PM