CODEWITHSUNDEEP
crystal-reportssummary
yoyie yoyie
yoyie yoyie

Reputation: 415

How to get sum by groups in Crystal Report

I want to get the sum by the groups in Crystal Reports.

Group OVERALL
-----------------
      group 1
     --------------
          5.00
          5.00
         10.00
     --------------
     total group 1      20.00
     --------------
      group 2
      --------------
         10.00
         25.00
         15.00
      --------------
     total group 2      50.00
-------------------
Total Group OVERALL     70.00

Using this formula sum({field.amount}, {field.group}) I only get sum for OVERALL but not for group 1 and 2.

Upvotes: 5

Views: 33191

Answers (1)

Arsalan Khan
Arsalan Khan

Reputation: 423

  1. Right Click field which you want to Sum
  2. Select Insert -> Summary and select Group On field below on the same dialog window
  3. Click Ok

Upvotes: 9

Related Questions