How do you format Groupfooter?

[Steve]

Adding the groupfooter and calculating a total for a column was pretty easy, but how can I format the output so that it shows something besides "Sum: 9999"?

[Yavor]

Hi Steve,

You can alter the text, as shown in the code sample below:

.cs

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridGroupFooterItem)
        {
            GridGroupFooterItem groupFooter = (GridGroupFooterItem)e.Item;
            groupFooter.Cells[4].Text = "Custom TEXT for agregate count: ";
        }
    }

I hope this helps.

All the best,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Steve]

Cool.  Thanks!

[Gino Suarez]

Hi, this is really cool, but how can i know the groupheadertext or name to put it on its own groupfooter , something like this

GroupHeadetext:  "SuperTelerik"
                                                some data1
                                                some data 2
              footertext:   "SubTotal of SuperTelerik"

Best Regards

Gino

[Princy]

Hello Gino,

Try out the following code and see if it helps achieve your scenario:
c#:

string headertext;
protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridGroupHeaderItem)
        {
            GridGroupHeaderItem groupheaderItem = (GridGroupHeaderItem)e.Item;
            headertext = groupheaderItem.DataCell.Text.Substring(groupheaderItem.DataCell.Text.IndexOf(':') + 1);
        }

        if (e.Item is GridGroupFooterItem)
        {
            GridGroupFooterItem groupFooterItem = (GridGroupFooterItem)e.Item;
            string strtxt = groupFooterItem["ColumnUniqueName"].Text.Substring(groupFooterItem["ColumnUniqueName"].Text.IndexOf(':') + 1);
            if (headertext != null)
              groupFooterItem["ColumnUniqueName"].Text = "SubTotal of " + headertext + ":" + strtxt;
        }

Thanks
Princy.

[Shawn Clabough]

I used this recently, but found one issue with it.  I thought I'd share my solution.

The issue is that this only works properly with one group level.  If there is more than one group level, the footers for the parent groups get the label from the last child.  To solve this, I changed to this.

Private _headerText As New List(Of String)

Private Sub RadGrid1_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
    If TypeOf e.Item Is GridGroupHeaderItem Then
        Dim groupheaderItem As GridGroupHeaderItem = DirectCast(e.Item, GridGroupHeaderItem)
        _headerText.Add(groupHeaderItem.DataCell.Text.Substring(groupHeaderItem.DataCell.Text.IndexOf(":") + 1))
    End If

    If TypeOf e.Item Is GridGroupFooterItem Then
        Dim groupFooterItem As GridGroupFooterItem = DirectCast(e.Item, GridGroupFooterItem)
        Dim txt As String = groupFooterItem("ColumnUniqueName").Text.Substring(groupFooterItem("ColumnUniqueName").Text.IndexOf(":"c) + 1)
        If _headerText IsNot Nothing Then
            groupFooterItem("ColumnUniqueName").Text = _headerText.Item(_headerText.Count - 1) & " Subtotal: " & txt.Trim()
            _headerText.RemoveAt(_headerText.Count - 1)
        End If
    End If
End Sub