CODEWITHSUNDEEP
reporting-services
Amelia
Amelia

Reputation: 159

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

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?

Upvotes: 0

Views: 133

Answers (1)

Paul Bambury
Paul Bambury

Reputation: 1312

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

Upvotes: 0

Related Questions