title: Crystal Report Sum total for each date in date range
body: <p>this is my first attempt at Stack overflow, so hopefully you all can help me.  I'd be happy to start contributing here, it's been such a useful tool in the past.</p>
  
  <p>Okay, so I am trying to write a report that charts the total past due hours of a manufacturing facitility.  What I have is a conglomaration of tables, that list each manufacturing order and give a due date and a completion date.  The person running the report enters a date range and I want to generate a chart with dates along the x-axis and the sum of past due hours on the y-axis.  Maybe I am missing something with an eimplementation of the three-formule trick, but i can't get this to work.  I can group by due date, but that only gives me the total orders that went past due on a given date.</p>
  
  <p>What I need is something like the following, that is chartable:</p>
  
  <pre><code>    For each (date in DateRange) {
         If (Due Date &lt; i) &amp;&amp; (Comp Date &gt; i) {
            Past Due Hours = Past Due Hours + manufacturing order Hours
         }
      }
  </code></pre>
  
  <p>I know it's not in Crystal Syntax, I was just trying to get the picture across.  Any help?</p>