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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Thanks

    Friday, August 5, 2016 10:22 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote 
    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)

    rajivkumar.bala@yahoo.co.in




    • 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