GridSummaryColumnDescription Format

[Navaneeth Rajkumar]

Hi,
I am using the GridSummarycolumnDescription to sum up the columns in my GGC. I would like to specify the format in which the summary should be displayed. $1000000.00 as $1,000,000.00, $-1000 as $(1,000)(in red) etc... the below is the code that I am currently using..

GridSummaryColumnDescriptor total_summary = new GridSummaryColumnDescriptor();
total_summary.DataMember = "Test";
total_summary.DisplayColumn = "Test";
total_summary.Format = "{Sum:#.00}";
total_summary.SummaryType = SummaryType.DoubleAggregate;

Thanks

[Administrator]

Hi Navaneeth,

Thanks for being patience.

This can be achieved by changing the Format and Appearance property of the summary column accordingly. The following is the code snippet.
>>>>>>>> Code Snippet <<<<<<<<<
total_summary.Format = "{Sum:$0,0.00}";
total_summary.Appearance.SummaryFieldCell.TextColor = Color.Red;
>>>>>>>>>>>>>><<<<<<<<<<<<<<<

Kindly let us know if you need any further assistance.
Have a nice day.

Best regards,
Madhan

[Navaneeth Rajkumar]

Madhan,
Thanks for your reply. The text color is supposed to be red only if the sum is negative. So is there a way to capture the sum and check for its value? or is there a property which does that?

Thanks

>Hi Navaneeth,

Thanks for being patience.

This can be achieved by changing the Format and Appearance property of the summary column accordingly. The following is the code snippet.
>>>>>>>> Code Snippet <<<<<<<<<
total_summary.Format = "{Sum:$0,0.00}";
total_summary.Appearance.SummaryFieldCell.TextColor = Color.Red;
>>>>>>>>>>>>>><<<<<<<<<<<<<<<

Kindly let us know if you need any further assistance.
Have a nice day.

Best regards,
Madhan

[Administrator]

Hi Navaneeth,

Thank you for being patience.

Please refer to the following code snippet which demonstrates the way to achieve the intend behavior by using the QueryCellStyleInfo event.

>>>>>>>>>>>>>>>>>>>>>>>
void gridGroupingControl1_QueryCellStyleInfo(object sender, Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellStyleInfoEventArgs e)
{
if (e.TableCellIdentity.TableCellType == Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellType.SummaryFieldCell)
{
if( e.TableCellIdentity.SummaryColumn.Name == "Lost")
{
GridTable table = e.TableCellIdentity.Table;
GridSummaryRow row = e.TableCellIdentity.DisplayElement as GridSummaryRow;
GridSummaryRowDescriptor summaryRowDescriptor = row.SummaryRowDescriptor;
GridSummaryColumnDescriptor sumCol1 = summaryRowDescriptor.SummaryColumns["Lost"];
if (sumCol1 != null)
{
string text1 = sumCol1.GetDisplayText(table, row);

System.Globalization.CultureInfo culture = table.Appearance.AnyCell.GetCulture(true);
double d1;
if (double.TryParse(text1, System.Globalization.NumberStyles.Any, culture, out d1))
{
if (d1 < 0)
e.Style.TextColor = Color.Red;
}
}
}
}
}
>>>>>>>>>>>>>>>>>>>>>>>

Kindly let us know if you need any further assistance.
Have a nice day.

Best regards,
Madhan