I have a requirement to hide tablix based on condition
in the properties of tablix I am using below
=iif(Fields!ClosedDate.Value<"2015-07-01","True","False")
whenever ClosedDate is less than 2015-07-01 I want to show tablix to load data into report. whenever ClosedDate is greater than 2015-07-01 I want to hide tablix to load data into report
but when I am doing preview I am seeing error "the hide expression used in tablix 'Tablix2' returned a data type that is not valid"
please can anyone suggest what is the error in the expression?
Iif evaluates an expression to return True or False which are Boolean values not strings. Remove the quotes!
=iif(Fields!ClosedDate.Value<"2015-07-01",True,False)
Also, make sure to set the language property on your report, otherwise you may find 2nd Jan being evaluated as 1st Feb
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments