Customizing Summary Rows

[Mohan Ranganna]

Hi,

I am using Syncfusion Grouping Grid Control 3.3.0.0 in a windows application running on .NET 1.1.

The grouping grid supports multiple groups (not using nested tables). A summary row in the grid displays the sum of the values for each group. To achieve the desired functionality, I am making use of the grid's default totalling with the use of SummaryType.DoubleAggregate.

I now need to ensure that the sum for the outermost group should not be shown if the group's displayed text is "XYZ".

I believe I could customize it using SummaryType.Custom and doing a custom totalling. Is there any other approach to achieve this?

Regards,
Mohan

[Administrator]

Hi Mohan,

Thanks for being patience.

You can handle the QueryCellStyleInfo event and customize the summary value for the required group. Please refer to the following code snippet for more details.

>>>>>>>>>> Code Snippet <<<<<<<<<<<<
//QueryCellStyleInfo event
if (e.TableCellIdentity.TableCellType == GridTableCellType.SummaryFieldCell)
{
Element el = e.TableCellIdentity.DisplayElement;
if (el != null)
{
Group g = el.ParentGroup;
if (g.Category != null && g.Category.ToString() == "xyz")
{
===
}
}
}
>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<

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

Best regards,
Madhan