Calculate a Summary

This tutorial describes the steps required to calculate one of the built-in summary functions in your report.

Note

Use this approach if data bindings are enabled in the Report Designer (the Label's smart tag includes the Data Binding property).

See the Calculate a Summary topic in the Shape Data (Expression Bindings) section to learn about an alternative approach.

1. Create a new report or open an existing one and bind it to a data source.

2. Switch to the Group and Sort panel and group the report's data by the required field. Display the footer for the created group.

   

3. Prepare the report layout and drop a required data field onto the group footer to display the summary result.

4. Click the label's smart tag and invoke its Summary Running drop-down list. Select the range for which to calculate a summary (the entire report, a specific report group or document page).

   

5. Set the Summary Func property to Sum and use the Format String property to format the summary's value.

   

Switch to Print Preview to see the result.