How to make a sum of total for each id

Question

Using Crystal report 7

I want to view the table 1 and sum of table2

table1

id name

001 raja
002 vijay
003 suresh
....

table2

id value

001 100
001 200
001 150
002 200
003 150
003 200
...

I want to display all the rows from table1 and sum(values) from table2. How to do this in crystal report

Expected Output

id name value

001 raja 450
002 vijay 200
003 suresh 350
................
           1000 (sum of value)

Note: I add the table field directly to the report, i am not added store procedure or views or query in the report.

How to do this.

Need Crystal report help

Answer 1

Try this it will work for you

1) Add a Group in your crystal report i.e. by Name

2) Add a running total

3) your report will be as follow

4) Your output will be