Highlight the field when error occurs

Question

I have an rdl report with a description field I want to emphasize the field when it contains "error". What am I supposed to do?

Thanks

Answer 1

Hi @Xiaowen Dong

If you say "error" in a fixed way, then you only need to use an expression like the following in the background color.

=iif(Fields!Description.Value.ToString.Contains("Error"),"yellow",nothing)

If you want "error" in the field to be case-insensitive, then you can use LCASE to convert the string to all lowercase first, and then look for "error", like this:

=iif(LCASE(Fields!Description.Value).ToString.Contains("error"),"yellow",nothing)

Preview:

Best regards,

Aniya