March 1, 2017 at 10:13 am
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"
)
March 1, 2017 at 11:02 am
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"
))
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply