Conditional formatting of null string value

[Felice]

I have a report where I would like to format in red all values that are null in the column "Unit" and fill in the field "!!!"
I have tried the following but I am not succeeding:

The value "Unit" is a string

Expression:IIF(IsNull(Fields.Unit,True),True,False) 
Operator: =
Value: =Null

How can I achieve the needed result?

Thanks,
Felice

[Stef]

Hi Felice,

You can use an expression as follows for the conditional formatting rule filter:

Expression: =Fields.test is  Null OR Fields.test like ''
Operator: =
Value: =True

For more details check the Operators article.

Regards,
Stef
Telerik

 

 

[Michael]

This helped me! Thank you!