How to hide tablix in ssrs? getting error message when doing preview

1
votes

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?

1
reporting-services

1 Answers

0
votes

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