Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Unanswered: Get Balance Value From Previous Date

    I have a report grouped by EventDate and by "Income" / "Payment". I've got a few totals for incomes and payments. This is what i need:

    EventDate: 3/3/2012 3/4/2012 3/5/2012 and so on...
    txtBalance = txtStartBalance + (Sum(Income) - Sum(Payment)) (for a particular date - let's say 3/3/2012)
    txtStartBalance (for 3/4/2012 - the next day) = txtBalance (from the previous date 3/3/2012)

    Having my report group by EventDate is it possible to get the previous value for my txtStartBalance ? If so, how?
    Thank you guys!

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    I would amend the source query of the report to do this for you. Can you post the SQL?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts