Crystal Reports Grouping sum by Date

Question

Hi I'm using Crystal Reports 2008. And I have an output of like this:

    Date (dd/mm/yyyy)     Weight
   -----------------------------------------
    01-01-2013            5000
    01-01-2013            1500
    02-01-2013            2000
    02-01-2013            4500
    03-01-2013            5700
    03-01-2013            5800

Now, my question how can I sum it and group by Date and the output should be:

    Date (dd/mm/yyyy)     Weight
   -----------------------------------------
    01-01-2013            6500
    02-01-2013            6500
    03-01-2013            11500

Thanks,

Captain16

craig craig · Accepted Answer · 2013-01-07T15:20:19

Select Weight field.
Select Insert | Summary...

enter image description here

Change 'Calculate this summary:' to Sum
Click Insert Group... to create a group on the date field

enter image description here

Select date field and set 'This section will be printed' to 'for each month'
Click OK to close Insert Group dialog
Select new group from the Summary location (if not already chosen), then OK

Crystal Reports Grouping sum by Date

2 Answers