title: How to make a sum of total for each id
body: <p>Using Crystal report 7</p>
  
  <p>I want to view the table 1 and sum of table2</p>
  
  <p>table1</p>
  
  <pre><code>id name
  
  001 raja
  002 vijay
  003 suresh
  ....
  </code></pre>
  
  <p>table2</p>
  
  <pre><code>id value
  
  001 100
  001 200
  001 150
  002 200
  003 150
  003 200
  ...
  </code></pre>
  
  <p>I want to display all the rows from table1 and sum(values) from table2.  How to do this 
  in crystal report</p>
  
  <p>Expected Output</p>
  
  <pre><code>id name value
  
  001 raja 450
  002 vijay 200
  003 suresh 350
  ................
             1000 (sum of value)
  </code></pre>
  
  <p>Note: I add the table field directly to the report, i am not added store procedure or views or query in the report.</p>
  
  <p>How to do this.</p>
  
  <p>Need Crystal report help</p>