Calculate an Advanced Summary

This document describes how to calculate an advanced summary (a summary for report groups that uses a built-in summary function and arithmetical or logical functions).

  1. Create a new report or open an existing report and bind it to a data source.
  2. Switch to the Group and Sort panel and group the report's data by a field. Display the footer for the new group.

    expressions-custom-summary-group-footer

  3. Prepare the report layout.

  4. Drop an XRLabel onto the group footer to display the summary result.

    Click the label's smart tag and set its Summary property to Group.

    expressions-custom-summary-running-group

  5. Click the ellipsis button for the label's Expression property.

    expressions-custom-summary-label-smart-tag

  6. This invokes the Summary Expression Editor where you can specify a custom expression with the required summary functions and other logical or arithmetical functions. For example:

    expressions-custom-summary-sum

    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's value:

    expressions-custom-summary-format-string

When switching to Print Preview, you can view the specified range's custom summary result:

expressions-custom-summary-preview-result