Applying a sum within a group’s records.

As I illustrated in my Grouping article, grouping records that share an identical value for a column is a very helpful method to avoid repeating data and provide the user with a more intuitive manner to view records similar to each other.

In this example, I will show how to provide within each group a running sub total.

As you can see in the report, all records have a Quantity value for products in each order.

First, I’ll select the field for which I want to provide a sum of its values and add a new Total field after it.

Now I have a new Total field in the designer under the Quantity field.

I’ll right-align it and change its font weight to BOLD.

Executing the report show a product sub total for each company’s products in orders.

rptCustomerOrders
(right-click, Save As)