The requested page is not available for the requested platform. You are viewing the content for Default platform.

Calculate a Summary

This document shows how to use a report control's Expression property to calculate a group summary, as shown in the image below:

xtrareports-summary

Note

This topic assumes that the UserDesignerOptions.DataBindingMode property is set to DataBindingMode.Expressions (the default value) or DataBindingMode.ExpressionsAdvanced.

Refer to Calculate a Summary in the Shape Data (Legacy Data Bindings) section for the legacy approach.

See Data Binding Modes for information on available binding modes.

Follow the steps below to calculate a summary:

  1. Create a report bound to the sample Northwind database's Products table (the nwind.mdb file is included in the XtraReports installation).

  2. Use the Group and Sort Panel to group report data by the CategoryName data field and construct a layout like the following:

    xtrareports-summary-report-layout

  3. Right-click the report's Detail band and select Insert Band / Group Footer from the context menu.

    xtrareports-summary-add-group-footer

  4. Drop an XRLabel control onto the Group Footer band.

    xtrareports-summary-drop-label

  5. Click the label's smart tag, then click the Summary field's ellipsis button to open the Summary Editor form.

    summary-expressions-label-smart-tag

  6. In the Summary Editor form, use the following options:

    • Summary running - specifies summary calculation range (the entire report, current report group, or current document page).
    • Summary function - specifies a summary function.
    • Argument expression - specifies a data field or a complex expression.

    summary-expressions-label-smart-tag

    Tip

    See the Expression Constants, Operators, and Functions topic for a complete list of supported summary functions.

  7. You can use the FormatString property to format the summary value:

    summary-format-string-label-smart-tag

Switch to Print Preview mode to see the result:

summary-report-group-result-preview