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 .