Cross row manipulation of SSRS reports 2012

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.
Enjoy it 

Leave a Reply

Your email address will not be published. Required fields are marked *