Calculate a Running Balance on SSRS

• Emz

  SSC-Addicted

  Points: 458

  More actions

  May 8, 2011 at 12:24 pm

  #389473

  Hi,

  I'm still new to reporting services, I'm trying to add a column in my report to calculate the running balance based on my list of transaction amounts for the month. How do I go about doing this?

  e.g.Report

  TransactionDate DescriptionAmountBalance

  01-May PaymentReceivedR 500 R 500

  02-May DataExpenseR -20R 480

  02-May TelExpenseR -75R 405

  04-May PaymentReceivedR 350R 755

  05-May PaymentReceivedR 700R 1,455

  05-May DataExpenseR -80R 1,375

  07-May TelExpenseR -120R 1,255

  THANKS!!!!

• Emz

  SSC-Addicted

  Points: 458

  More actions

  May 8, 2011 at 12:49 pm

  #1321482

  I figured it out...im using the RunningValue function and it works fine.