Multiple Records In One Group

[bpxmas]

Crystal 9

I'm creating a Crystal report grouped by TicketNumber. So all the codes below are in the same TicketNumber. I've tried grouping by Code as well.

There can be multiple records for one code (see below)

21857
21857
21342
63427

I want to add the $ for both records that have the same code see below.
21857 = 1,137
21857 = 1,137
21342 = 235
63427 = 4,705

So, total for code 21857 should be $2,274 and on my report it's only showing $1,137.

If anyone has some suggestions that would be great. If you need more information, please let me know.

 

[lbass]

If you place the amount field in the detail section and right click on it->insert summary->sum, you should get a result that includes all records. You can insert this as a total at any group level.

-LB