[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

Specify Summary Options (Multi-Query Version)

On this wizard page, you can specify summaries to calculate in the selected reports.

Use the drop-down list at the top of the wizard page to choose a required report.

In the Fields table column, you can select an available numerical or date-time field. To specify which functions should be calculated for the selected field, enable the corresponding check boxes in the Summary functions drop-down.

The specified summaries are displayed in the report footer and after corresponding groups (if you have grouped report data on the previous wizard page).

If data fields can contain empty values and you do not want to take these values into account when calculating totals, select the Ignore null values check box. Otherwise, these values are treated as zeros for numeric fields and the earliest system date for date-time fields.

You can stop the wizard at this step by clicking Finish. The created report looks similar to the image below.

If you want to customize the report further, click Next to proceed to the next wizard page: Set the Report Title.

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