How to make a sum of total for each id

Posted by JetJack on Stack Overflow See other posts from Stack Overflow or by JetJack
Published on 2012-06-25T09:14:22Z Indexed on 2012/06/25 9:15 UTC
Read the original article Hit count: 294

Filed under:

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
....

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

© Stack Overflow or respective owner

Related posts about crystal-reports