I have following table named table1 with following data

Ac#     Date            Debit     Credit
1     1-Jan-15                    100
1     1-Jan-15                    100
1     2-Jan-15          200     
1     2-Jan-15          300     
1     3-Jan-15                    200
1     3-Jan-15                    100

Now User gives parameter date range as following
Date >= 2-Jan-15 and Date<= 3-Jan-15
Now the data will be display in report as following

Ac#     Date            Debit     Credit
1     2-Jan-15          200     
1     2-Jan-15          300     
1     3-Jan-15                    200
1     3-Jan-15                    100



My problem is how can i find the opening balance.

for example in this case opening balance will be
sum (Debit) - Sum(Credit) where Date < 2-Jan-15

Opening balance= -200

Please guide me how to calculate opening balance
i hope you will understand my problem.

please help me.







Edited by RoniDxb - 13 Aug 2015 at 9:25am

My question is very clear.
if you just see a ledger , you give date range and an account no. so what does happen

you get the ledger of give date range of a give account no and you get the opening balance which is actually

< you start date and is sum of debit and credit