sqlreporting-servicesexpressionreportbuilder3.0ssrs-expression

Using 'like' in ssrs expressions

I'm trying to highlight a field when the value has the word 'deadline' in it. I'm trying to use the expression:

=IIf(Fields!Notes.Value like "%deadline%","Yellow","Transparent")

in the BackgroundColor property.

It's not highlighting the field (not changing the background color). The 'Notes' field is a text datatype and I'm using Report Builder 3.0 if that makes a difference. What am I doing wrong?

Solution

  • SSRS does NOT use SQL syntax, but instead uses Visual Basic.

    Use something like this:

    =IIf(Fields!Notes.Value.IndexOf("deadline") >= 0,"Yellow","Transparent")

    Or .Contains instead of .IndexOf

    =IIf(Fields!Notes.Value.ToLowerInvariant().Contains("deadline"),"Yellow","Transparent")