This is a migrated thread and some comments may be shown as answers.

conditional formatting check for that date is null.

1 Answer 881 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Ole
Top achievements
Rank 1
Ole asked on 08 Dec 2010, 03:30 PM
Hi,

I have a problem , I can not figurer out / it is not working how to change the background when a date field is not set.(is null)

Here is what I have come yp with so far.....

realizing that the datetime value will be datetime.minvalue when the underlying data is null, I made the following in an formatting rules expression.

=Fields.SyncDate.Date.Ticks < :=1  but nothing happens, 

Any ideas on how to make this happen ?.

Best Ole

1 Answer, 1 is accepted

Sort by
0
Accepted
Peter
Telerik team
answered on 13 Dec 2010, 06:11 PM
Hello Ole,

Generally for checking null data our suggestion is to use the IsNull(Expression, ReplacementValue) build in Function that checks an expression and either returns the checked expression or a replacement value. 
Thus your formatting rule should look like:

 Expression Operator  Value 
= IsNull(Fields.SellEndDate.Ticks,0)   =  =0

All the best,
Peter
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
Tags
General Discussions
Asked by
Ole
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or