Filter on nullable property

[Justin Lee]

Hello.
I have a table in a report that is bound to a list of objects.  I would like to add a filter to only display rows where a certain property is not null.  The property is a nullable decimal (C#: Decimal?)

How would I set this filter up?  (is it possible?)

I tried:
    Expression:    =Fields.Property
    Operator:        <>
    Value:            =Null
And
    Expression:    =CStr(=Fields.Property)
    Operator:        <>
    Value:            <left the value blank>

but neither worked.

Thanks,
Justin

[Peter]

Hello Justin Lee,

In order to filter table rows when certain value is null our suggestion is to use the following Table.Filter:

Expression	Operator	Value
= IIF(Fields.Property is null, false, true)	=	=true

All the best,
Peter
the Telerik team

[Justin Lee]

Perfect. Works great. Thanks.