[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]Get Started with DevExpress Reporting
 [Expand]Create Popular Reports
 [Expand]Detailed Guide to DevExpress Reporting
 [Collapse]Visual Studio Report Designer
  [Expand]Dock Panels and Designer Options
  [Collapse]Report Wizard
    Choose a Report Type
    Blank Report
   [Collapse]Table Report
     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)
     Specify Report Page Settings
     Choose a Report Color Scheme
     Choose a Report Layout (Obsolete)
     Choose a Report Style (Obsolete)
     Set the Report Title
    Vertical Report
   [Expand]Labels
   [Expand]Template
    Inherited Report
  [Expand]Data Source Wizard
   Query Builder
 [Expand]Create End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on 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: Specify Report Page Settings.

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