Click here to Skip to main content
15,794,275 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Someone help me em using rdlc in

My report will fetch data from the table that has BankId ,Amount and Trans-Type fields. Report has only two columns that is BankId and Amount I have grouped by Bankid column. but I want if the field has trans-type "Bill" so it exempt the amount from the group ; if it has trans-type = "Payment" so it add amuont. I used this...
=IIF(Fields!TransType.Value="Bill-PMT" , RunningValue(Fields!DrAmt.Value,sum,"Group1") , RunningValue(Fields!DrAmt.Value,sum,"Group1")-(Fields!DrAmt.Value) )

like Bank1 25000 Bank2 15000 plz help me

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900