Crystal Reports  

Subtotaling Grouped Data

A subtotal is a summary that totals or sums numeric values in a group.

To subtotal data

  1. Right-click in the Crystal Reports ActiveX Designer to access the shortcut menu.
  2. Point to Insert and click Summary.
  3. In the Insert Summary dialog box, click the top drop-down list and select the field you want to subtotal.
  4. Click the Insert Group button.

    The Insert Group dialog box appears so you can specify the group you want to add to your report.

  5. Choose the field you want the data grouped by, specify a sort direction and then click OK when finished.
  6. On the Insert Summary dialog box, select the group you just created from the Summary location list and then click OK.

    The values in each group are now subtotaled.

  7. Click OK.

See Also

Grouping Data | Adding Percentages to a Report