I have a column of type Double. I want to display Blank where the Value is 0. I can convert the column to String and do it but the values involve complex calculations and I really want to avoid this approach. Please help!
You can achieve this very easily using the Format property on the column. The Format simply calls the ToString method on the value. So the DotNet framework supports formats with three sections for positive, negative and zero, and you can leave the last section blank.
For example, you could use a Format like: "##;-##;"
For more info on the custom numeric formats in DotNet, you can check out MSDN:
Custom Numeric Format Strings
This looks promising. Will apply it tomorrow and confirm.
Thanks Mike.