ASP.NET Grid - Aggregates


ORDER ID
SHIP NAME
SHIPPED DATE
SHIP COUNTRY
FREIGHT
 
 
 
 
 
 
10248
Vins et alcools Chevalier
16-Jul-1996
7/16/1996 12:00:00 AM
Brazil
32.3800
10249
Toms Spezialitäten
10-Jul-1996
7/10/1996 12:00:00 AM
Germany
11.6100
10250
Hanari Carnes
12-Jul-1996
7/12/1996 12:00:00 AM
Austria
65.8300
10251
Victuailles en stock
15-Jul-1996
7/15/1996 12:00:00 AM
France
41.3400
10252
Suprêmes délices
11-Jul-1996
7/11/1996 12:00:00 AM
Belgium
51.3000
10253
Hanari Carnes
16-Jul-1996
7/16/1996 12:00:00 AM
Brazil
58.1700
10254
Chop-suey Chinese
23-Jul-1996
7/23/1996 12:00:00 AM
Switzerland
22.9800
10255
Richter Supermarkt
15-Jul-1996
7/15/1996 12:00:00 AM
Switzerland
148.3300
10256
Wellington Importadora
17-Jul-1996
7/17/1996 12:00:00 AM
Brazil
13.9700
10257
HILARION-Abastos
22-Jul-1996
7/22/1996 12:00:00 AM
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:
1
|
2
|
3
Records: 1 - 10 of 25 - Pages: 


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

"You really do a terrific job with this stuff - well worth the price of admission!"

Coral Amende
RescueConnection Software

Products Downloads
obout.com
obout.com Home
News
Grid Home 
Grid Home
Download
Site Map
Examples - 232
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 - 16
Add/Edit/Delete Records
Type Validation
Edit on Double-Click
Add/Edit Default Values
Auto-Save & Dbl-Click
Edit using Context Menu
Multi-Record
Using Custom Forms
Sliding Row Editor New
Automatic Updates
Using Flyout
Add to empty table
Edit all Cells
Declarative (no coding)
Excel-Style Editing
Using ObjectDataSource
Select Records - 12
Select Records
Keep Selected Records
Find Selected on Client-Side
Find Selected on Server-Side
Select/Deselect Record
Set the SelectedRecords
Using Checkboxes
Select All using Checkboxes New
AutoPostBackOnSelect
Using Radio-Buttons
With Checkmark
Select All Records
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
Column sets
Paging- 6
Paging
Customize Paging
Change Page on Client
The Numbers of Pages
Manual Paging
Show ALL records
Sorting - 3
Sorting
Multi-Column Sorting
Sorting Week Days New
Filtering - 18
Filtering Records
Enable/Disable Filter
Show/Hide Criterias
Autosuggest Filtering
Customize Filtering Options
Programmatic Filter - Client-Side
Alphabetic Filter
Keeping Filter State
Initial State New
Filter Position New
Initial Filter New
Custom Filter Options New
Between, By Year, By Month New
Filtering Localized Dates New
ALL vs. ANY New
Validate Filters New
Filtering Millions of Records New
Master/Detail with External Filters New
Templates - 28
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
Different Input Fields for Add/Edit New
Different Row Fields for Add/Edit
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
Get values from textboxes New
Detail View New
Scrolling - 11
Vertical
Horizontal
Vertical & Horizontal
Automatic Scroll
Horizontal & Filter
Using Percentages New
Full Window Width / Height New
Automatic Resize with Splitter New
Fixed (Frozen) Columns
Fixed Height New
Fixed Height in Percentages 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
Customize the Group Headers
Totals / Sub-Totals - 5
Totals
Groups Sub-Totals
Aggregates
Totals of Selected Records
Summary Row New
Master / Detail - 21
Load At Once (OnLoad)
Load On Demand (OnCallback)
Load On PostBack New
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
Templates for Action Buttons
Client-Side Manipulation
Get Selected Records
Expand/Collapse on Select
Different Styles
Select on Expand / Collapse
Expand a single detail grid
Expand on client side
Detail Grid inside Row Template New
Separated Master/Detail Grids
Exporting - 12
Export to Excel / Word New
Export on Server Side New
Export Master/Detail Grids New
Export Groups New
Export Totals / Subtotals New
Export Templates New
Export Title / Footer New
Customize Exported files
Customize Individual Rows New
Exported files Life Time
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
Server-Side Events - 3
RowCreated/RowDataBound
ColumnsCreated
Row Title
Printing - 2
Printing the Grid
Printing All Pages
Integration - 23
E-Mail Client
File Browser
D-n-D to Tree
D-n-D to Grid
Customers
With Easy Menu
With DatePicker
With File Upload Progress
With Flyout
AJAX Autosuggest
Linked with TreeView
Using ASP.NET ValidatorsNew
With Window
Purchase Order
Task List
Using Tooltips
With Multilevel Combobox
With Tab Strip
With HTML Editor
Inside Window
Context menu and CheckBoxes
With Color Picker
With File Upload Progress
ASP.NET AJAX - 7
Live Quotes
With AJAX MaskedEditExtender
With AJAX AlwaysVisible
Millions of Records New
Populate Edit Fields New
View Row Details New
Cascading ComboBoxes New
Other Features - 13
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
Find and Replace
Using ASP.NET Themes/Skins New
Mode - 2
Callback Mode
Postback Mode
Appearance Customization- 2
Knowledge Base - 1
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 AJAX Page
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
Custom readonly column
Validate unknown columns
Auto-scroll during postback
Delete button
Inline validation
Move records between grids