Page 1 of 1

TextFormat - Zero value

Posted: Wed Sep 09, 2009 10:59 am
by dikan
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?



TextFormat - Zero value

Posted: Wed Sep 09, 2009 12:43 pm
by Jan
Hello,

You can use following expression:

Code: Select all

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

TextFormat - Zero value

Posted: Wed Sep 09, 2009 2:07 pm
by Brendan
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.

TextFormat - Zero value

Posted: Wed Sep 09, 2009 4:51 pm
by dikan
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. ;-)