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
Copy[C#]
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);Copy[VB.NET]
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)Copy[C#]
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);Copy[VB.NET]
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)