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 
Share on email
Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Leave a Reply

Your email address will not be published.