Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Interval Grouping

Order Date Ascending
Product Name 
Category Name 
Unit Price 
ExpandOrder Date: 2018 (Count=405, Sum=9581, Sum=$226,298.50)
ExpandOrder Date: 2019 (Count=1,059, Sum=25489, Sum=$658,388.75)
ExpandOrder Date: 2020 (Count=691, Sum=16247, Sum=$469,771.34)
   Count=2,155  Sum=$1,354,458.59

To help provide total control over the display of information within its container, the DevExpress ASP.NET Grid View (ASPxGridView) supports interval grouping. This powerful feature allows you to group the values within text columns against individual characters, or group date-time columns by month, year, or date.

In this demo, the Order Date column uses interval grouping. By default, the Order Date is grouped by Year, and summaries are automatically computed for values stored within the group. You can modify the manner in which group interval order is displayed on-screen by selecting values from the Date group interval combo box.

Interval grouping is controlled by a column's Settings.GroupInterval property.

See Also:
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos