Creating reports and dashboards | Stimulsoft community forum

Posted: **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

Posted: **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.

Posted: **Fri Dec 02, 2011 1:24 pm**

Perfect, thank you!

Posted: **Sat Dec 03, 2011 3:00 am**

Hello,

Have a great weekend!

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Condition if value is null ?

Condition if value is null ?

Condition if value is null ?

Condition if value is null ?

Condition if value is null ?