Group name along with footer total?

[John St. Amant]

How can I place the 'Group' name among each footer total?

For example, I have a group defined:  GridGroupByField FieldName="GroupRegion".  The group will be text such as "East Coast", "West Coast", etc. 

I want to use that group value in each Footer total. i.e.  "East Coast Total = 99", West Coast Total = 101".

I thought maybe something I could add via code in the ItemDataBound event?:

If (TypeOf e.Item Is GridFooterItem) Then
   Dim footerItem As GridFooterItem = CType(e.Item, GridFooterItem)
   footerItem("SumOfRegion").Text = ??
End If

But, I don't know how to get the current group value / name the footer total is working with...?

Thanks.

[Veli]

Hello John,

You are correct in your supposition, you need to get the GridGroupFooterItem in ItemDataBound:

void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridGroupFooterItem)
    {
        GridGroupFooterItem item = e.Item as GridGroupFooterItem;
        string newValue = item.OwnerTableView.Items[item.OwnerTableView.Items.Count - 2]["GroupRegion"].Text;
        item.Cells[6].Text = item.Cells[6].Text.Replace("Sum", "GroupRegion:" + newValue);
    }
}

The above code gets a reference to the currently created GridGroupFooterItem, references the needed data cell by index and replaces the default footer text (the name of the aggregate) with a custom text derived from the previous item's "GroupRegion" field value.

Greetings,
Veli
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.