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.