Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Collapse]Grid View
   [Expand]Product Information
    Getting Started
   [Expand]Fundamentals
   [Collapse]Concepts
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Collapse]Data Shaping and Manipulation
     [Expand]Data Summaries
     [Expand]Filtering
     [Collapse]Grouping
       Grouping Overview
       Grouping in Code
       Grouping Modes and Custom Grouping
       Expanding and Collapsing Group Rows
     [Expand]Sorting
      Cell Merging
    [Expand]Data Formatting
    [Expand]Master-Detail Relationship
     Appearance Customization
     Adaptivity
     Save and Restore Layout
    [Expand]Templates
     Export
     Toolbars
    [Expand]ASPxGridLookup
    ASPxGridView Designer
   [Expand]Visual Elements
   [Expand]Examples
   [Expand]Member Tables
   [Expand]ASPxGridView - Animated Images
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Grouping Overview

To apply grouping, end-users can drag a column header and drop it on the Group Panel. Column GridDataColumnSettings.AllowSort and GridViewDataColumnSettings.AllowGroup options must be set to 'True', just as the ASPxGridViewSettings.ShowGroupPanel property must also be set to true. Otherwise, end-users will not be permitted to group data.

Note

If column AllowSort and AllowGroup properties are set to Default, column behavior is controlled by ASPxGridView. In this case, grouping is allowed if the ASPxGridViewBehaviorSettings.AllowGroup and ASPxGridBehaviorSettings.AllowSort options are enabled.

 

When ASPxGridView data is grouped by a single column, data rows that have identical values in this column are arranged into groups. Each group is identified by a group row. Expand the group to access its underlying data rows.

If ASPxGridView is grouped by another column, data rows within each group are arranged into second level groups based on the values of the new grouping column.

Rows that belong to one group can be displayed on different pages. This occurs when the number of rows contained within a group exceeds the maximum number of rows that can be displayed on a page. In this instance, the image is displayed within the top data row(s) to indicate that rows belong to a group. Hovering over this image displays parent group rows.

ASPxGridView allows you to replace this image with a custom one. To do this, use the GridViewImages.ParentGroupRows property.

 

The number of columns used to group data is returned by the ASPxGridView.GroupCount property.

Data rows are always sorted against grouping columns. If data is grouped against a column that isn't sorted, ASPxGridView automatically applies sorting in ascending order to the column.

The style settings used to paint group rows can be accessed and customized using the GridViewStyles.GroupRow property.

To create a custom layout for group rows, create a template and assign it to the GridViewTemplates.GroupRow or GridViewTemplates.GroupRowContent property. For more information on templates, see Templates.

How would you rate this topic?​​​​​​​