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:
Follow the steps below to calculate a summary:
Create a report bound to a data source.
Use the Group and Sort Panel to group report data by the key data field and construct a layout like the following:
- Right-click the report's Detail band and select Insert Band / Group Footer from the context menu.
- Drop a Label control onto the Group Footer band.
- Click the label's smart tag, then click the Summary field's ellipsis button to open the Summary Editor form.
- 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.
Tip
See the Expression Operators, Functions and Constants topic for a complete list of supported summary functions.
You can use the Format String property to format the summary value:
Switch to Print Preview mode to see the result: