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: 321
crystal-reports
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