How to display group aggregations in group headers

[Konrad]

I would like to ask how I can add aggregations to group expressions so that the group headers in  RadGrid display aggregated values.
For example I want to display all count of grouped elements but not in group footer. In custom paging.
And how to display grouped elements on others page. beacuse now it shows grouped  elements per page not whole table.
All in custom paging :)

[Princy]

Hello Konrad,

For your first requirement, you can use custom code to calculate the count and set it as GroupHeader like below.

C#:

int count = 0;

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
   foreach (GridGroupHeaderItem groupHeader in RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader))
    {
       GridItem[] children = groupHeader.GetChildItems();
       count=  children.Count();
       groupHeader.DataCell.Text = "Count=" + count.ToString();
       count = 0;
    }
}

And for the second requirement, as far as I know it is not possible to group the items on other pages. For more information on this please go through the following forum post.
Rad Grid Group and Paging Index

Thanks,
Princy.

[Konrad]

For the first, thank you.:)
For the second, I mean that I would like to have text Group continues on the next page. beacuse, I use now custom paging and it groups elements only per page.
According to this example you just disable custom paging while grid is sorted or grouped.
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx

[Nikolay Rusev]

Hello Konrad,

I am not sure whether I understand your requirements correctly, but here is what RadGrid performs when grouping.

First it requires the whole data source(all records) in order to perform grouping. After the grouping is finished then paging is performed. Thus grouping is performed on all items regardless whether they are on current page or not.

However in case of custom paging - developer is responsible for supplying the data and if only page size items are set as DataSource of RadGrid it will perform grouping only those items.

Regards,
Nikolay
the Telerik team