[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Collapse]Reporting
 [Expand]Product Information
 [Expand]Getting Started with DevExpress Reporting
 [Expand]Creating Popular Reports
 [Expand]Detailed Guide to DevExpress Reporting
 [Collapse]Visual Studio Report Designer
  [Expand]Dock Panels and Designer Options
  [Collapse]Report Wizard
   [Collapse]Wizard Pages
     Choose a Report Type
     Empty Report
    [Collapse]Data-bound Report
     [Expand]Connect to a Database
     [Expand]Connect to an Entity Framework Data Source
     [Expand]Connect to an Object Data Source
     [Expand]Connect to an Excel Data Source
      Select the Data Source Type
      Choose Fields to Display in a Report (Multi-Query Version)
      Choose Fields to Display in a Report (Single-Query Version)
      Add Grouping Levels (Multi-Query Version)
      Add Grouping Levels (Single-Query Version)
      Specify Summary Options (Multi-Query Version)
      Specify Summary Options (Single-Query Version)
      Choose a Report Layout
      Choose a Report Style
      Set the Report Title
    [Expand]Template Report
    [Expand]Label Report
     Inherited Report
   Data Source Wizard
   Query Builder
 [Expand]Creating End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
This documentation page describes implementations made in our v17.2 release cycle. To learn about functionality shipping with v18.1, navigate to our updated help file experience at docs.devexpress.com. Learn More

Add Grouping Levels (Single-Query Version)

This page allows you to group data in a report. If you don't need to group your data, simply click Next on this page to skip this step.

Nested grouping and grouping against multiple fields are fully supported. The following image illustrates all basic grouping types.

The list on the left-hand side displays data fields that can be used to group data. To apply grouping, double-click the required field or select it, and click the right arrow button. To group data against multiple columns, use the button.

To remove a grouping field, double-click it in the list on the right-hand side, or select it and click the left arrow button. You can also change the order of grouping fields using the up arrow and down arrow buttons.

You can stop the wizard on this step by clicking Finish. In this case, the report will look similar to the image below.

If you want to customize the report further, click Next. If data grouping has been applied on this page, you will proceed to the Specify Summary Options (Single-Query Version) page. If you haven't group your data, you will skip the summaries step and go to the Choose a Report Layout page.

Note

This wizard page is no longer used in the default Report Wizard implementation. The following master-detail page is used instead: Add Grouping Levels (Multi-Query Version).

To learn how to switch back to using the standard Report Wizard version in your WinForms application, see the following example online: How to disable the master-detail functionality in the Report Wizard.

Is this topic helpful?​​​​​​​