I have a table called "account_trans", and in that, there are fields like date, credit, debit, company code, account code.
In a report, the user will input Date-1 to Date-2, so it must calculate the opening balance of each and every date. How can I do this?