shahid
Nov 21st, 2006, 03:59 AM
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
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