I want to view the table 1 and sum of table2 report

Question

 in Crystal Report Windows application

table 1

 id name

001 raja

002 vijay

003 suresh

 

table 2

id value 

 001 100 

001 200 

001 150 

002 200 

003 150 

003 200 ...

 Expected Out Put:

 

id name value 

001 raja 450

002 vijay 200 

003 suresh 350