TextFormat - Zero value

dikan · Post by **dikan** » Wed Sep 09, 2009 10:59 am

Hi,

I would like to represent values as blank field if numeric value is zero but I could not find any appropriate picture.

Is this possible?

Post by **Jan** » Wed Sep 09, 2009 12:43 pm

Hello,

You can use following expression:

{MyDataSource["MyField"] == null || MyDataSource["MyField"] == DBNull.Value ? "" : MyDataSource.MyField.ToString()}

Thank you.

Brendan · Post by **Brendan** » Wed Sep 09, 2009 2:07 pm

There's also a property on the text component called HideZeros. Setting this to true will hide the value if it is the number zero.

dikan · Post by **dikan** » Wed Sep 09, 2009 4:51 pm

Brendan wrote:There's also a property on the text component called HideZeros. Setting this to true will hide the value if it is the number zero.

Thanks Brendan,
I believed that answer is simple but I could not find it. Options with coding is always possible but not desirable.