how to code and formula in crystal report to get opening balance and closing balance ?
I Am try to make school software where a report are there are some expense and some income amount like a credit and debit as bellow
opening balance
opening balance credit debit balance
opening balance 220000
20000 0 240000
0 5000 235000
0 1000 234000
6000 0 240000
0 100000 140000
0 80000 60000 Closing Balance
how to get this opening balance where i select date like this
from 01-01-2016 To 30-01-2016 and so on it hows last balance as opening and end with closing balance
What I have tried:
how to code and formula in crystal report to get opening balance and closing balance ?
I Am try to make school software where a report are there are some expense and some income amount like a credit and debit as bellow
opening balance
opening balance credit debit balance
opening balance 220000
20000 0 240000
0 5000 235000
0 1000 234000
6000 0 240000
0 100000 140000
0 80000 60000 Closing Balance
how to get this opening balance where i select date like this
from 01-01-2016 To 30-01-2016 and so on it hows last balance as opening and end with closing balance