Edit this page

Group Aggregates

The text of the group header row is a formatted string with the following parameters:

  • {0}Property name –the name of the RadGridView column by which the grouping is performed;

  • {1}Group value

  • {2}, {3} … - Aggregates values

You can define the format of the group header row by using the GroupDescriptor Format property. Its default value is “{0}: {1}”. The following two examples demonstrate how you can use the group aggregates. Full list of the available expressions can be found here:http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx

Example 1: adding the count aggregate.

GroupDescriptor descriptor = new GroupDescriptor();
descriptor.GroupNames.Add("Country", ListSortDirection.Ascending);
descriptor.Aggregates.Add("Count(Country)");
descriptor.Format = "{0}: {1} has {2} records in its group.";
this.radGridView1.GroupDescriptors.Add(descriptor);

Dim descriptor As New GroupDescriptor()
descriptor.GroupNames.Add("Country", ListSortDirection.Ascending)
descriptor.Aggregates.Add("Count(Country)")
descriptor.Format = "{0}: {1} has {2} records in its group."
Me.RadGridView1.GroupDescriptors.Add(descriptor)

gridview-group-aggregates 001

Example 2: Adding and formatting several aggregates.

GroupDescriptor descriptor = new GroupDescriptor();
descriptor.GroupNames.Add("ShipName", ListSortDirection.Ascending);
descriptor.Aggregates.Add("Count(ShipName)");
descriptor.Aggregates.Add("Max(Freight)");
descriptor.Aggregates.Add("Avg(Freight)");
descriptor.Format = "The ship {1} has {2} item(s) with maximum freight {3} and avarage freight of {4:c2} per ship.";
this.radGridView1.GroupDescriptors.Add(descriptor);

Dim descriptor As New GroupDescriptor()
descriptor.GroupNames.Add("ShipName", ListSortDirection.Ascending)
descriptor.Aggregates.Add("Count(ShipName)")
descriptor.Aggregates.Add("Max(Freight)")
descriptor.Aggregates.Add("Avg(Freight)")
descriptor.Format = "The ship {1} has {2} item(s) with maximum freight {3} and avarage freight of {4:c2} per ship."
Me.RadGridView1.GroupDescriptors.Add(descriptor)

gridview-group-aggregates 002

See Also