dear all

i want to build a summary report with crystal report..but i have some problem
the data is like:

code name amount1 amount2 amount3 date
----- ----- -------- -------- -------- ---------
10 a 100 50 30 any date
10 a 100 50 30 any date
20 b 200 50 30 any date
20 b 200 50 30 any date
30 c 300 50 30 any date
30 c 300 50 30 any date


now i need the summary group by code


code amount1_sum amount2_sum amount3_sum
----- -------------- ------------- --------------
10 200 100 60
20 400 100 60
30 600 100 60

shuld be between the dates which i select by parameter.


please help me i am unable to manage how to do it.
any hint,tip etc
thank you