Condition if value is null ?

Jennypi · Post by **Jennypi** » Thu Dec 01, 2011 11:22 am

Hi all,

In a report, some fields contain no value, so they are (null) in the DB.
If I put no condition, the report shows "0" instead of null.
I don't want to display the 0, so I defined a condition with expression:

Code: Select all

DataSource1.field1==null

but it has no effect.

What should I put in the condition box?

Thanks

Post by **HighAley** » Fri Dec 02, 2011 8:41 am

Jennypi wrote:In a report, some fields contain no value, so they are (null) in the DB.
If I put no condition, the report shows "0" instead of null.
I don't want to display the 0, so I defined a condition with expression:
Code: Select all
DataSource1.field1==null
but it has no effect.

What should I put in the condition box?

Please, try to use next expression:

Code: Select all

DataSource1.field1==DBNull.Value

Thank you.

Jennypi · Post by **Jennypi** » Fri Dec 02, 2011 1:24 pm

Perfect, thank you!

Post by **Andrew** » Sat Dec 03, 2011 3:00 am

Hello,

Have a great weekend!

Thank you.