Cross summation or manipulation in SSRS reports.
Consider the below image has credits and debit, The Balance is calculated by
=Credit – Debit + Balance.
From my knowledge it is not possible in Visual Studio. Instead we can make this possible by below procedure.
1.Create a field in the temp table as balance.
2. In contract class just in the insert method make this
TmpTableName.Balance = TmpTableName.Balance + TmpTableName.Credit – TmpTableName.Debit ;
3.Refresh the dataset add the fields in to the expected position then observe the application.