SSRS Lookup Expression

• SQLPain

  Hall of Fame

  Points: 3522

  More actions

  March 1, 2017 at 10:13 am

  #335414

  I have the following expression for a column. I am trying to hide the row if the result is " " or "None". What expression can be used under visibility?

  Using Report builder 3.0

  =Lookup("|"& Fields!Enrollment_Number.Value & "|Quantity Bathroom Faucets|"
            , "|" & Fields!Enrollment_Number.Value & "|" & Fields!Property_Name.Value & "|"
            , Fields!Installation_Property_Value.Value
            , "DataSet2"
        )

• SQLPain

  Hall of Fame

  Points: 3522

  More actions

  March 1, 2017 at 11:02 am

  #1931039

  Also How would I SUM the following expression, I am trying the following:

  =SUM(Lookup("|"& Fields!Enrollment_Number.Value & "|Quantity Bathroom Faucets|"
            , "|" & Fields!Enrollment_Number.Value & "|" & Fields!Property_Name.Value & "|"
            , Fields!Installation_Property_Value.Value
            , "DataSet2"
        ))