I am trying to format the totals in the summary field cell as "{Sum:#,###;(#,###);0}" which is working fine. Also, I am trying to change the color to red if the value is less than zero.
I am using the code snippet in the attachment in the QueryCellStyleInfo event handler of the grid.
But that code is never executed because the celltype never equates to SummaryFieldCell for some reason.
As a work around - I changed the SummaryFieldCell cell type to Currency. This does what I am looking for except that the DecimalGroupSeparator shows up as "." instead of "," even though I explicitly set the CurrencyGroupSeparator as ",".
Any help is appreciated.
Thanks,
Code17.zip