Conditional Formatting OR condition

[Jon Morris]

Hi,

I am trying to use conditional formatting for a report and what I want to do is compare a field to 2 static values and if TRUE, highlight the text. I am unable to get the syntax correct for the condition. This is what I am trying to achieve.

Compare the field "Type" to both an empty string and also to static text "Upset". I tried to do the following the Conditional Formatting Rules dialog

=Fields.Type = Upset

This works fine. But, if I add NULL to this(to compare to empty string)

=Fields.Type = Upset OR = Null

nothing happens. I tried to use the "IN" operator, but no luck in figuring out the syntax. Is there some documentation that I can use as  a reference or can you point me to the correct syntax?

Thanks

[Peter]

Hi Jon Morris,

You have to nest IsNull Function into an IIF function. Check out the following example :

Expression                                                                                               Operator                                       Value
===============================================================================
=IIF(Fields.Type= "Upset",True,IsNull(Fields.Type,True))                            =                                               True

Hope this helps.

Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Brad Williams]

I to am having trouble figuring Telerik report conditional formating.  It is so much backward thinking.  Sometimes you use Expressions, sometimes conditional formating and who know when to use either.  I can't find any documention on syntix or detail instructions for learning conditional formating.  They need to put a whole training series on it if then can't do a better job explaining it.

[Jayesh Goyani]

Hello Peter ,

i got this Error "An error has occurred while processing TextBox 'textBox3': Cannot perform '='  " when i use following expression for handling DBnull / Null value in Report.

1)
Expression ->  = IsNull(Fields.Saturday, "True")   
Operator ->      =
Value ->          = True

2)
Expression ->  =IIF(Fields.Saturday= "Test",True,IsNull(Fields.Saturday,True)) 
Operator ->      =
Value ->          = True

i want to set background color in TextBox when Fields.Saturday.value is DBNull or "Test".

how can i do this ?