Can I enable grid column total ?

[Ivan]

Dear Sir,

Can I enable grid column total function like below screen? thanks

 

[Rumen]

Hi Ivan,

Yes, in Telerik's RadGrid for ASP.NET AJAX, you can enable column totals by using the ShowFooter property on the MasterTableView. The footer will display the sum (or another aggregate function like average, count, etc.) of the column's data.

Here's a basic example of how you might define this in your ASPX file:

        <telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource" AllowPaging="true">
            <MasterTableView AutoGenerateColumns="false" ShowFooter="true">
                <Columns>
                    <telerik:GridBoundColumn DataField="Id" HeaderText="ID" ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="Item" HeaderText="Item"  />
                    <telerik:GridBoundColumn DataField="Quantity" HeaderText="Quantity" Aggregate="Sum" FooterAggregateFormatString="Total: {0:N0}" DataType="System.Int32" />
                    <telerik:GridBoundColumn DataField="Price" HeaderText="Price" Aggregate="Sum" FooterAggregateFormatString="Total: {0:C}" DataType="System.Decimal" />
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

 

ASPX.CS

 

public partial class Default : System.Web.UI.Page 
{
    protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
    {
        // Dummy data source
        RadGrid1.DataSource = new List<DummyItem>
            {
                new DummyItem { Id = 1, Item = "Item 1", Quantity = 10, Price = 23.00m },
                new DummyItem { Id = 2, Item = "Item 2", Quantity = 15, Price = 42.75m },
                new DummyItem { Id = 3, Item = "Item 3", Quantity = 5,  Price = 15.50m }
            };
    }
}

// Dummy data class
public class DummyItem
{
    public int Id { get; set; }
    public string Item { get; set; }
    public int Quantity { get; set; }
    public decimal Price { get; set; }
}

For more information, take a look into the following help documentation which describes an intuitive method to define aggregates on a per-column basis from design time and render the results inside the respective column's footer:
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/columns/aggregates.

Regards,
Rumen
Progress Telerik