Hi,
<igtbl:UltraGridColumn Key="TEST" BaseColumnName="TEST" Format="$###,###.00">
<Header Caption="TEST>
</igtbl:UltraGridColumn>
If a cell has 0.00 for this column, I need to replace it with - .I do not want to show $0.00.
Quick responses are highly appreciated.
Thanks in advance.
You could set the .Format string for the column to an advanced formatting string for a numeric datatype
e.Layout.Bands[0].Columns[0].Format = "###,##0.00;(###,##0.00);-";
Basically the format string can take multiple masks for +ve values ; -ve values ; zero
Check out the InitializeRow event:
http://help.infragistics.com/Help/NetAdvantage/NET/2007.3/CLR2.0/html/WebGrid_Using_the_InitializeRow_Event.html
Devin