Previous value in a table

[haseebhm]

I want to make a ledger report using vb.net2008(report designer). My first row will be from accounts table which will opening balance from there. The further rows will get data from LEDGER TABLE which has {"Transaction Type", "Transaction Time", "Credit", "Debit"} fields. I want the report to automatically calculate the balance of the account. In second row the balance field should have value = "opening balance" + "Credit"- "Debit". In third row the balance field = "2nd row balance value" + "Credit"- "Debit" and so on.

I m new with reporting. I Know about Previous() Function but cant figure out how to use it in this case.