I am working on a project that is involved in financial reports.
Here is what I want to accomplish
I have a table (tbl_receivables) with id, accoundID, transDetails, debit, credit columns.
When I publish my receivables report I would like to see a balance field along with the table columns. Balance field value should be generated runtime and would give value of: current row credit - current row debit + previous row balance total.
Should this calculation be handled in SQL server side or asp.net side? Is there any tutorial link that you can share with me?
View Complete Post