title: Crystal - add running total field from subreport
body: <p>I have a Crystal Report that lists information by item number based on selection criteria and includes sum of ordered quantity.  Since I don't know how to do a nested query to a DB2 database in Crystal, I created a sub-report to total quantity on hand by item number.  How do I get the total of the quantity on hand from the sub-report into the main report where the item numbers match?</p>
  
  <p>I do have a left join between F4211 and F41021 on F4211.SDITM=F41021.LIITM. </p>
  
  <p>Data selection for main report.</p>
  
  <pre><code>{F4211.SDNXTR} &lt; "999" and
  {F4211.SDUORG} &lt;&gt; 0.00 and
  {F4211.SDAN8} = 200038.00 and
  {F4211.SDLNTY} = "S" and
  {F4211.SDDCTO} = "SO" and
  {F4211.SDSOBK} &gt;= 0.00
  </code></pre>
  
  <p>Data Selection for sub-report</p>
  
  <pre><code>{F41021.LILOTS} = "" and
  {F41021.LIPQOH} &gt; 0.00
  </code></pre>