Grid / Footer Aggregates

Enable footer aggregates in header context menu new

ProductID	Product name	Unit price	In Stock	Units On Order	Reorder Level	Discontinued

1	Chai	$18.00	39	0	10	False
2	Chang	$19.00	17	40	25	False
3	Aniseed Syrup	$10.00	13	70	25	False
4	Chef Anton's Cajun Seasoning	$22.00	53	0	0	False
5	Chef Anton's Gumbo Mix	$21.35	0	0	0	True
6	Grandma's Boysenberry Spread	$25.00	120	0	25	False
7	Uncle Bob's Organic Dried Pears	$30.00	15	0	10	False
8	Northwoods Cranberry Sauce	$40.00	6	0	0	False
9	Mishi Kobe Niku	$97.00	29	0	0	True
10	Ikura	$31.00	31	0	0	False
11	Queso Cabrales	$21.00	22	30	30	False
12	Queso Manchego La Pastora	$38.00	86	0	0	False
13	Konbu	$6.00	24	0	5	False
14	Tofu	$23.25	35	0	0	False
15	Genen Shouyu	$15.50	39	0	5	False
16	Pavlova	$17.45	29	0	10	False
17	Alice Mutton	$39.00	0	0	0	True
18	Carnarvon Tigers	$62.50	42	0	0	False
19	Teatime Chocolate Biscuits	$9.20	25	0	5	False
20	Sir Rodney's Marmalade	$81.00	40	0	0	False
21	Sir Rodney's Scones	$10.00	3	40	5	False
22	Gustaf's Knäckebröd	$21.00	104	0	25	False
23	Tunnbröd	$9.00	61	0	25	False
24	Guaraná Fantástica	$4.50	20	0	0	True
25	NuNuCa Nuß-Nougat-Creme	$14.00	76	0	30	False
26	Gumbär Gummibärchen	$31.23	15	0	0	False
27	Schoggi Schokolade	$43.90	49	0	30	False
28	Rössle Sauerkraut	$45.60	26	0	0	True
29	Thüringer Rostbratwurst	$123.79	0	0	0	True
30	Nord-Ost Matjeshering	$25.89	10	0	15	False
31	Gorgonzola Telino	$12.50	0	70	20	False
32	Mascarpone Fabioli	$32.00	9	40	25	False
33	Geitost	$2.50	112	0	20	False
34	Sasquatch Ale	$14.00	111	0	15	False
35	Steeleye Stout	$18.00	20	0	15	False
36	Inlagd Sill	$19.00	112	0	20	False
37	Gravad lax	$26.00	11	50	25	False
38	Côte de Blaye	$263.50	17	0	15	False
39	Chartreuse verte	$18.00	69	0	5	False
40	Boston Crab Meat	$18.40	123	0	30	False
41	Jack's New England Clam Chowder	$9.65	85	0	10	False
42	Singaporean Hokkien Fried Mee	$14.00	26	0	0	True
43	Ipoh Coffee	$46.00	17	10	25	False
44	Gula Malacca	$19.45	27	0	15	False
45	Rogede sild	$9.50	5	70	15	False
46	Spegesild	$12.00	95	0	0	False
47	Zaanse koeken	$9.50	36	0	0	False
48	Chocolade	$12.75	15	70	25	False
49	Maxilaku	$20.00	10	60	15	False
50	Valkoinen suklaa	$16.25	65	0	30	False
51	Manjimup Dried Apples	$53.00	20	0	10	False
52	Filo Mix	$7.00	38	0	25	False
53	Perth Pasties	$32.80	0	0	0	True
54	Tourtière	$7.45	21	0	10	False
55	Pâté chinois	$24.00	115	0	20	False
56	Gnocchi di nonna Alice	$38.00	21	10	30	False
57	Ravioli Angelo	$19.50	36	0	20	False
58	Escargots de Bourgogne	$13.25	62	0	20	False
59	Raclette Courdavault	$55.00	79	0	0	False
60	Camembert Pierrot	$34.00	19	0	0	False
61	Sirop d'érable	$28.50	113	0	25	False
62	Tarte au sucre	$49.30	17	0	0	False
63	Vegie-spread	$43.90	24	0	5	False
64	Wimmers gute Semmelknödel	$33.25	22	80	30	False
65	Louisiana Fiery Hot Pepper Sauce	$21.05	76	0	0	False
66	Louisiana Hot Spiced Okra	$17.00	4	100	20	False
67	Laughing Lumberjack Lager	$14.00	52	0	10	False
68	Scottish Longbreads	$12.50	6	10	15	False
69	Gudbrandsdalsost	$36.00	26	0	15	False
70	Outback Lager	$15.00	15	10	30	False
71	Flotemysost	$21.50	26	0	0	False
72	Mozzarella di Giovanni	$34.80	14	0	0	False
73	Röd Kaviar	$15.00	101	0	5	False
74	Longlife Tofu	$10.00	4	20	5	False
75	Rhönbräu Klosterbier	$7.75	125	0	25	False
76	Lakkalikööri	$18.00	57	0	20	False
77	Original Frankfurter grüne Soße	$13.00	32	0	15	False

Count : 77

Avg: $28.87

Sum : 3119

Max : 100

Min units: 0

8 items discontinued, 69 not

Click PostBack to see the state of the grid is preserved.

There are various cases in which you may want to display results from aggregate functions performed over the columns in the grid in their footer.

RadGrid provides an intuitive method to define aggregates on a per-column basis from design time and render the results inside the respective column's footer. Aggregate calculations are supported for GridBoundColumns and the rest of the built-in columns which extend from GridBoundColumn (GridDateTimeColumn, GridNumericColumn, GridCalculatedColumn, etc.). In order to specify how the group aggregates will be evaluated, specify in every GridBoundColumn (or the rest of the columns which extend it) the Aggregate property which accepts values from the GridAggregateFunction enumeration. Moreover, you have the ability to set format string for the calculated value that will be displayed in the footer using the FooterAggregateFormatString property of the corresponding column (its default value will match the DataFormatString for the column if set).

In the Q3 2010 release of Telerik RadControls for ASP.NET AJAX, we have added a handy set of options for selecting aggregate values from RadGrid's header context menu. Setting the RadGrid.EnableHeaderContextAggregatesMenu property to true will enable the aggregate options in the header context menu.

Source Code

C# VB.NET

Show code in new window Demo isolation steps

<%@ Page Language="vb" AutoEventWireup="false" CodeFile="DefaultVB.aspx.vb" Inherits="Telerik.GridExamplesCSharp.GeneralFeatures.Aggregates.DefaultVB" %> <%@ Register TagPrefix="telerik" Namespace="Telerik.QuickStart" %> <%@ Register TagPrefix="telerik" TagName="Header" Src="~/Common/Header.ascx" %> <%@ Register TagPrefix="telerik" TagName="HeadTag" Src="~/Common/HeadTag.ascx" %> <%@ Register TagPrefix="telerik" TagName="Footer" Src="~/Common/Footer.ascx" %> <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/tr/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <telerik:HeadTag runat="server" ID="Headtag2"></telerik:HeadTag> </head> <body class="BODY"> <form runat="server" id="mainForm" method="post"> <telerik:Header runat="server" ID="Header1" NavigationLanguage="VB"></telerik:Header> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" />  <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="EnableAggregatesInHCMCheckBox"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" /> <telerik:ConfiguratorPanel ID="ConfiguratorPanel1" runat="server" Expanded="true"> <div class="title"> <asp:CheckBox ID="EnableAggregatesInHCMCheckBox" runat="server" AutoPostBack="true" OnCheckedChanged="EnableAggregatesInHCMCheckBox_CheckChanged" Text="Enable footer aggregates in header context menu" /> <img alt="new" src="~/Common/Img/new.gif" runat="server" style="background-color:#002E3D; padding:2px 3px" /> </div> </telerik:ConfiguratorPanel> <telerik:RadGrid AutoGenerateColumns="false" ID="RadGrid1" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" ShowFooter="True" runat="server" EnableLinqExpressions="false" GridLines="None"> <PagerStyle Mode="NextPrevAndNumeric" /> <HeaderStyle Width="150px" /> <MasterTableView TableLayout="Fixed" OnDataBinding="MasterTableView_DataBinding"> <Columns> <telerik:GridNumericColumn Aggregate="Count" DataField="ProductID" HeaderText="ProductID" SortExpression="ProductID" UniqueName="ProductID" HeaderStyle-Width="60px" FilterControlWidth="30px"> </telerik:GridNumericColumn> <telerik:GridBoundColumn DataField="ProductName" HeaderText="Product name" SortExpression="ProductName" UniqueName="ProductName"> </telerik:GridBoundColumn> <telerik:GridNumericColumn Aggregate="Avg" DataField="UnitPrice" HeaderText="Unit price" SortExpression="UnitPrice" UniqueName="UnitPrice" DataFormatString="{0:C}" HeaderStyle-Width="80px" FilterControlWidth="50px"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Sum" DataField="UnitsInStock" HeaderText="In Stock" SortExpression="UnitsInStock" UniqueName="UnitsInStock" HeaderStyle-Width="70px" FilterControlWidth="40px"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Max" DataField="UnitsOnOrder" HeaderText="Units On Order" SortExpression="UnitsOnOrder" UniqueName="UnitsOnOrder" HeaderStyle-Width="100px" FilterControlWidth="50px"> </telerik:GridNumericColumn> <telerik:GridNumericColumn Aggregate="Min" DataField="ReorderLevel" HeaderText="Reorder Level" FooterText="Min units: " SortExpression="ReorderLevel" UniqueName="ReorderLevel" HeaderStyle-Width="80px" FilterControlWidth="50px"> </telerik:GridNumericColumn> <telerik:GridBoundColumn Aggregate="Custom" DataField="Discontinued" FooterText=" " HeaderText="Discontinued" SortExpression="Discontinued" UniqueName="Discontinued" HeaderStyle-Width="70px" AllowFiltering="false"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <ClientSettings> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> </ClientSettings> </telerik:RadGrid> <asp:Button ID="Button1" Text="PostBack!" CssClass="button" Style="margin: 10px 22px 10px 0px" runat="server"></asp:Button> Click PostBack to see the state of the grid is preserved. <br /> <asp:SqlDataSource ID="SqlDataSource1" SelectCommand="SELECT ProductID, ProductName, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" ProviderName="System.Data.SqlClient" runat="server"></asp:SqlDataSource>  <telerik:Footer runat="server" ID="Footer1"></telerik:Footer> </form> </body> </html>

Get more than expected!

Take your time to truly experience the power of RadControls for ASP.NET AJAX with a free 60-day trial backed up by Telerik’s unlimited dedicated support.

Download your RadControls for ASP.NET AJAX trial and jumpstart your development with the available Getting Started resources.

If you have any questions, do not hesitate to contact us at sales@telerik.com.

Developer Tools

Web UI Controls & Components

Desktop UI Controls & Components

Mobile UI Controls & Components

Report Designer & Viewer

Data Access

Visual Studio Productivity Plugins

HTML5/JavaScript Widgets

Agile Project Management

Automated Testing

Web Content Management

SharePoint

Give your Feedback:

Choose Skin

Want more?

Grid / Footer Aggregates

Source Code

Get more than expected!