ASP.NET Grid - Aggregates


 
ORDER ID
 
SHIP NAME
 
SHIPPED DATE
 
SHIP COUNTRY
 
FREIGHT
 
Vins et alcools Chevalier
7/16/1996 12:00:00 AM
16-Jul-1996
Brazil
32.3800
Toms Spezialitäten
7/10/1996 12:00:00 AM
10-Jul-1996
Germany
11.6100
Hanari Carnes
7/12/1996 12:00:00 AM
12-Jul-1996
Austria
65.8300
Victuailles en stock
7/15/1996 12:00:00 AM
15-Jul-1996
France
41.3400
Suprêmes délices
7/11/1996 12:00:00 AM
11-Jul-1996
Belgium
51.3000
Hanari Carnes
7/16/1996 12:00:00 AM
16-Jul-1996
Brazil
58.1700
Chop-suey Chinese
7/23/1996 12:00:00 AM
23-Jul-1996
Switzerland
22.9800
Richter Supermarkt
7/15/1996 12:00:00 AM
15-Jul-1996
Switzerland
148.3300
Wellington Importadora
7/17/1996 12:00:00 AM
17-Jul-1996
Brazil
13.9700
HILARION-Abastos
7/22/1996 12:00:00 AM
22-Jul-1996
Venezuela
81.9100
Count: 10
First Shipping: 10 Jul 1996
Last Shipping: 23 Jul 1996
Most Orders: Brazil
Total: $527.82
Average: $52.782
Records per page:
Records: 1 - 10 of 25 - Pages: 
1
|
2
|
3
 


You can easily display aggregates in the footer of the Grid using the RowDataBound event and the ShowColumnsFooter property.

"Thank you!!! ... Awesome customer service!! :)"

Romi Kovacs

Products Downloads
obout.com
obout.com Home
News New
Grid Home 
Grid Home
Download
Site Map
Examples - 197
Appearance - 2
Live Styles
Populating with data - 11
Binding to DataSet
Binding to DataReader
Binding to DataTable
Binding to ObjectDataSource
Binding to SqlDataSource
Binding to XmlDataSource
Binding to Linq
Binding to LinqDataSource
Binding to Generic Collections
Maximum Performance
Partial Load
Add/Edit/Delete - 14
Add/Edit/Delete Records
Type Validation
Edit on Double-Click
Add/Edit Default Values
Auto-Save & Dbl-Click
Edit using Context-Menu
Multi-Record
Use Add/Edit Forms
Automatic Updates
Using Flyout
Add to empty table
Edit all Cells
Declarative (no coding)
Excel-Style Editing
Using ObjectDataSource New
Select Records - 10
Select Records
Keep Selected Records
Find Selected on Client-Side
Find Selected on Server-Side
Select/Deselect Record
Set the SelectedRecords
Using Checkboxes
AutoPostBackOnSelect
Using Radio-Buttons
With Checkmark New
Columns - 18
Resizing Columns
Align / HeaderAlign
AllowEdit / AllowDelete
DataFormatString
ApplyFormatInEditMode
Index
NullDisplayText
ParseHTML
ReadOnly
Show/Hide Columns
Visible
Width
Wrap
AutoGenerateColumns
Relative Widths
Resize the Grid Width
Different Styles New
Column sets New
Paging- 6
Paging
Customize Paging
Change Page on Client
The Numbers of Pages
Manual Paging
Show ALL records
Sorting - 2
Sorting
Multi-Column Sorting
Filtering - 9
Filtering Records
Enable/Disable Filter
Show/Hide Criterias
Autosuggest Filtering
Customize Filtering Options
Programmatic Filter - Client-Side
Initial Filter
Alphabetic Filter
Keeping Filter State New
Templates - 25
Templates for Add/Edit
Templates for the Filter
Format Dates
Format Currencies
Grid With Images
Add/Edit/Delete Buttons
Filter Buttons
Combine Columns
Wrap the Headers
Custom Formatting
Manual Paging
Number the records
GroupHeaderTemplateId
Multi-Record Add/Edit/Del.
Customized Row Templates
Templates for Edit-Delete
Reports and Row Templates
Access checkboxes inside
Access radio buttons inside
With Multiselect Listbox
With Databound Controls
DropDownList with 'New'
View / Edit Details
Customize for Mobile Devices New
Scrolling - 9
Vertical
Horizontal
Vertical & Horizontal
Automatic Scroll
Horizontal & Filter
Automatic Resize
Fixed (Frozen) Columns
Automatic Resize With Window
Fixed Height New
Grouping - 11
Grouping the Records
Allow Grouping for Columns
Initial Grouping
Groups Information
Multi-Page Groups Information
Collapsed Groups
Expand/Collapse Groups
Hide Columns
Keep Expanded
Format the Group Headers New
Customize the Group Headers New
Totals / Sub-Totals - 4
Totals
Groups Sub-Totals
Aggregates
Totals of Selected Records New
Master / Detail - 17
Load At Once (OnLoad)
Load On Demand (OnCallback)
Detail Grid State
Multiple Details on the Same Lev
Self-Reference Display
Unlimited Number of Levels
Show Empty Details
Full Set of Features
Expand/Collapse All
Multiple Foreign Keys New
Templates for Action Buttons New
Client-Side Manipulation New
Get Selected Records New
Expand/Collapse on Select New
Different Styles New
Select on Expand / Collapse New
Expand a single detail grid New
Expand on client side New
Exporting - 6
To Excel and Word
Customize Exported files
Exported files Life Time
Server-Side Exporting
OnClientExportStart/Finish
ExportedFilesTargetWindow
Accessibility - 2
Key Navigation
Customize the Keys
Localization - 2
Localization
Custom Localization
Client-Side Events - 2
Add / Edit / Delete
Expose the Sender New
Server-Side Events - 3
RowCreated/RowDataBound
ColumnsCreated
Row Title
Printing - 1
Printing the Grid
Integration - 24
E-Mail Client
File Browser
D-n-D to Tree
D-n-D to Grid
Customers
With EasyMenu
With DatePicker
With FileUpload
With Flyout
With SuperButton
AJAX Autosuggest
Linked with TreeView
Using Validation Controls
With Window
Purchase Order
Task List
Using Tooltips
With Multilevel Combobox
With AJAX TabStrip
With HTML Editor
Inside Window
Context menu and CheckBoxes
With ColorPicker
With FileUploadProgress New
ASP.NET AJAX - 3
Live Quotes
With AJAX MaskedEditExtender
With AJAX AlwaysVisible New
Other Features - 14
ShowLoadingMessage
Hover Effects
Millions of Records
Multiple Grids
Refresh the Records
Generate IDs
Client-Side Model
Get Values on Server-Side
Clear the records
Re-order the rows
Handling errors
Master/Detail
Find and Replace
Mode - 2
Callback Mode
Postback Mode
Knowledge Base - 2
How-To and Help
Knowledge Base
Documentation - 24
Server-Side
Column
ColumnCollection
ColumnTemplateSettings
DetailGridLoadingMode
DetailGridState
FilterOption
FilterOptionsCollection
FilterOptionType
Grid
GridClientSideEvents
GridCssSettings
GridGroupInformation
GridLocalizationSettings
GridMasterDetailSettings
GridRecordEventArgs
GridRuntimeTemplate
GridRuntimeTemplateEventArgs
GridScrollingSettings
GridTemplate
GridTemplateSettings
SortOrderType
TemplateContainer
TemplatesCollection
Client-Side
Client-Side API
Changelog
Tutorials - 18
Add/Edit/Delete
Updating the Database
Updating using Linq
Appearance
Styles
Styles - Advanced
CSS Tutorial
Client-Side API
Client-Side Events
Columns
Columns
Configuration
Using the correct path
Design-Time Support
All Tutorials
Choosing Data Source
Changing Appearance
Populating with Data
Data-Binding
Serialize
Maximum Performance
Selecting Records
Access Selected Records
Templates
Templates
Runtime Templates
Templates for Buttons
Miscellaneous Tutorials - 24
Getting the Generated ID
Multi columns validation
Loading the details with AjaxPages
Selecting the inserted/updated record
Server-side validation using Ajax
Edit on Click
Hide "no-records" message
Using radios inside edit template
Keep Current Page
Keep Current Paging/Sorting
External buttons
Sending parameters
Disable combobox in Edit mode
Bind data after specified the filter
Get Column Index in template
Client-Side Events & Window
Export with loading message
Custom readonly column
Validate unknown columns
Auto-scroll during postback
Delete button
Inline validation
Move records between grids New