How to have different text in the GroupFooters and the GridFooter

RELATED TO:

AUTHOR: Richard Hellwege

DATE POSTED: May 25, 2018

PROBLEM

How do I show different descriptions for the Group Footer and Grid Footer in the RadGrid? When I set a FooterAggregateFormatString on a column, the same FormatString is used for both the Group Footer and Grid Footer.

DESCRIPTION

The RadGrid uses a single format string for both the GridFooterItem and GridGroupFooterItem, so the same string will be used in both footers. In some situations it may be desirable to have different strings for those sections, such as a Subtotal and Grand Total configuration.                 

SOLUTION

The ItemDataBound event can be used to override the text in the RadGrid column footer. The first step is to define the FooterAggregateFormatString so that it only contains the aggregate value, see below.

<telerik:GridBoundColumn DataField="SampleColumn" Aggregate="Sum" FooterAggregateFormatString="{0}" />

The ItemDataBound event can then to used to modify the footer text based on whether it is a GroupFooterItem or GirdFooterItem.

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridFooterItem)
    {
        var valueFooterCell = (e.Item as GridFooterItem)["SampleColumn"];
        valueFooterCell.Text = "Grand Total: " + valueFooterCell.Text;
    }
    else if (e.Item is GridGroupFooterItem)
    {
        var valueFooterCell = (e.Item as GridGroupFooterItem)["SampleColumn"];
        valueFooterCell.Text = "Subtotal: " + valueFooterCell.Text;
    }
}

ADDITIONAL INFORMATION

RadGrid ItemDataBound Event

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community.

  • Demos

    Browse 1,200+ demos with source code covering basic and advanced scenarios.

  • Sample Applications

    Learn how to integrate the controls in real-world examples.

  • Feedback Portal

    Vote and follow the features you want to see added to Telerik UI for ASP.NET AJAX.

  • User Voice

    Get answers directly from the people who build the product.

  • Documentation

    Benefit from detailed help articles and API references for all controls.

  • Knowledge Base

    Learn how to achieve common scenarios from a multitude of tutorials and working examples.

  • Code Library

    Browse sample projects submitted by Telerik staff and community members.

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends.

  • Release History

    Up-to-date release notes for all new features and improvements.