This document describes how to calculate various summaries across a report and its groups.

  • Insert the Group Header band, select the Group Fields section in the Actions category and add a new group field to group the report’s data by the required field.
  • Insert the Group Footer band. Prepare the report layout and drop a required data field onto the group footer to display the summary result.
  • Select the label, expand the Summary section and invoke the Running drop-down list. Select the range for which to calculate a summary (the entire report, a specific report group or document page).
  • Click the Expression property’s ellipsis button.
  • This invokes the Expression Editor where you can select the required summary in the Functions | Summary section. Report summary functions start with the “sum” prefix to make it easy to differentiate them from aggregate functions.
TIP: See the Expression Constants, Operators, and Functions topic for a complete list of supported summary functions.
  • You can use the Text Format String property to format the summary’s value.

Switch to Print Preview to see the result.

Revision: 2
Last modified: Aug 26, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment