Creating reports and dashboards | Stimulsoft community forum

Posted: **Mon Mar 25, 2013 9:21 pm**

When a column value is null, I need to display text such as "No Date Created Defined". I have tried supplying this expression:

Code: Select all

{(Employee.dateCreated == null) ? "No Date Created Defined" : Employee.dateCreated} 
{IIF((Employee.dateCreated == null),"No Date Created Defined",Employee.dateCreated)}

However I then get this error:

Code: Select all

Operator '+' cannot be applied to operands of type 'System.DateTime' and 'object'.

What is the preferred way to customize the display value for null values?

Posted: **Tue Mar 26, 2013 5:55 am**

Hello,

Please check the following expression:

Code: Select all

Employee["dateCreated"] == DBNull.Value

Thank you.

Posted: **Tue Mar 26, 2013 9:09 pm**

Thanks very much. This worked:

Code: Select all

{(Employee["dateCreated"] == DBNull.Value) ? "No Date Created Defined" : Employee["dateCreated"]}

Posted: **Wed Mar 27, 2013 5:46 am**

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Display custom text when a column value is null

Display custom text when a column value is null

Re: Display custom text when a column value is null

Re: Display custom text when a column value is null

Re: Display custom text when a column value is null