How to use group clause in Crystal Report?

[anshul.15]

column1    column2 .....  column8        Sum        diff

a                dd     .....       12

a                dd     .....       11            23

a                ee     .....       33            33         -10

b                dd     .....       25            25     

b                cc     .....       10            

b                ss      .....      22            32         -7

c                aa      .....      30            30         30

I want to populate my report as the above way using Crystal report (visual studio 2005). Here we do summition of column8 by grouping of column1 where column2 ='dd'
and same where column2<>'dd'. but if i use query direct then i get single line output whereas i want to show all the rows for column1...column8 and then field sum and field diff.

May anyone suggest how to print report in above way?

Thanks in advance.