print only once for each group

[jys]

print only once for each group

 

for example,result set having the following,

 

fruits place consumption(tonnes)

 

Mangoes UK 24

Tomatoes UK 33

Tomatoes USA 30

Apple UK 30

PineApple UK 12

PineApple RSA 11

 

Now i want to sum up the consumption for each fruits,and print only once on report like the following.

 

Mangoes 24

Tomatoes 63

Apple 30

PineApple 23

 

Can anyone know the way to achieve this.if so,let me know .