title: Crystal Report Running Total
body: <p>I am creating a report (screenshot is attached below) in which I have to show running total of column <code>Balance</code>. This <code>balance</code> column value is generated by adding or subtracting <code>dr</code> and <code>cr</code> column value. For more explanation, if <code>dr</code> is <code>0</code> then <code>cr</code> value will be subtracted from <code>balance</code> value and if <code>cr</code> is <code>0</code> then <code>dr</code> value will be added to <code>balance</code> value, and the <code>balance</code> column first value will come from <code>particulars (=opening)</code> column's <code>dr</code> or <code>cr</code> value then the calculation will start and running total of <code>balance</code> will be made.</p>
  
  <p>I have attempted some Crystal Report formulas to accomplish this but failed to get the required values. I have also attached snapshot of my attempted formulas.</p>
  
  <p>First page of report
  <img src="https://i.stack.imgur.com/3Q0EM.jpg" alt="this image is first page of report"></p>
  
  <p>This image is the formula I used in this report for running total. But this approach is not calculating the correct sum and this formula is not working on next page of report as it starts from the beginning on next page</p>
  
  <p><img src="https://i.stack.imgur.com/eAZ7n.jpg" alt="this image is the formulas in this report"></p>
  
  <p>If anyone knows any other useful and easy way to calculate running total which is suitable in my current situation then please guide me.</p>