GridViewDataColumnSettings.GroupInterval Property
Specifies how the control combines data rows when they are grouped by the current column.
Namespace: DevExpress.Web
Assembly: DevExpress.Web.v24.1.dll
NuGet Package: DevExpress.Web
#Declaration
[DefaultValue(ColumnGroupInterval.Default)]
public ColumnGroupInterval GroupInterval { get; set; }
#Property Value
Type | Default | Description |
---|---|---|
Column |
Default | One of the Column |
Available values:
Name | Description |
---|---|
Default | For columns which store date/time values, this option is the same as the Column |
Value | Rows are grouped by values of grouping columns. The number of groups matches the number of unique values within the grouping column. For date/time columns, both the date and time portions are taken into account for value comparison. To specify how date/time values are presented in group rows in Win |
Date | This option is in effect only for columns that store date/time values. Rows are grouped by the date part of their values, the time portion is ignored in this grouping mode. |
Date |
This option is in effect only for columns that store date/time values. Rows are grouped by the month part of their values. |
Date |
This option is in effect only for columns that store date/time values. Rows are grouped by the year part of their values. |
Date |
This option is in effect for columns that store date/time values. Rows are combined into the following non-overlapping groups according to their date value as compared with today’s date: “Beyond Next Month”, “Next Month”, “Later this Month”, “Three Weeks Away”, “Two Weeks Away”, “Next Week”, “Today”, “Tomorrow”, “Yesterday”, “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”, “Last Week”, “Two Weeks Ago”, “Three Weeks Ago”, “Earlier this Month”, “Last Month”, “Older”. |
Alphabetical | Rows are grouped by the character that grouping column values start with. Note Not supported in server mode for numeric and date/time columns. |
Display |
Rows are grouped by display values of the grouping column. In specific instances, column cells can have different edit values, but the same display value. To combine these rows into the same group, use the Display Note Not supported in server mode. |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Group |
---|---|
Grid |
|
#Remarks
Specify the GroupInterval
property to define the column’s grouping algorithm.
Use the SortOrder and SortMode properties to specify how the grid sorts group rows.
To apply a custom grouping algorithm, set the SortMode property to Custom
and handle the CustomColumnGroup event.
For more information on grouping in the grid, refer to the following topic: ASPxGridView - Group Data.
#Limitation
- The grid’s server mode does not support group modes and custom grouping. In this mode, the control groups its data by the values of grouped rows.
#Example
The code sample below sets the GroupInterval
property to DateYear
to group data rows within the Order Date column.
<dx:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" KeyFieldName="OrderID"
AutoGenerateColumns="False">
<Columns>
<dx:GridViewDataTextColumn FieldName="ProductName" />
<dx:GridViewDataTextColumn FieldName="CategoryName" />
<dx:GridViewDataTextColumn FieldName="Country" />
<dx:GridViewDataDateColumn FieldName="OrderDate" GroupIndex="0">
<Settings GroupInterval="DateYear" />
</dx:GridViewDataDateColumn>
<%--...--%>
</Columns>
<Settings ShowGroupPanel="True" />
</dx:ASPxGridView>