How do I hide the display value of a column in a datawindow when the column value is zero

The question says it all. To clarify: I am not trying to hide the whole column, I just want to hide the display value when it is being equal to zero.

Any help is appreciated!!!

Thanks in advance.


One interpretation of what you're saying is to make the format mask end in a pound sign, like #,###. Another interpretation would be to make a Visible expression dependent on the value of the column, like (untested) if (*colname*=0, '0', '1'). I'm guessing you're after the former.

Good luck,


It is worth knowing that you can specify four different format masks for one datawindow column. You simply create up to four masks separated by semicolon.

Sample Format Mask: $#,##0.00;RED;#;'null'

  1. Positive Values use $#,##0.00
  2. Negative Values use RED
  3. Zero Value use #
  4. Null Value uses 'null'

Produces These Result:

123.01 --> $123.01

-123.01 --> ($123.01) in red text

0 -->

null --> null

Need Your Help

How to set the UITableViewCell height based on component within it

ios objective-c uitableview

I have created a subclass of UITableViewCell which contains a UITextView. When the text in the UITextView is set, it automatically resizes so that the height increases but the width stays the same....

CreateProcess and CreatePipe to execute a process and return output as a string in VC++

c++ visual-c++ createprocess

I am trying to use CreateProcess and CreatePipe to execute a process from within a Windows Forms C++/CLR application in Visual Studio 2010.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.