Someone help me em using rdlc in asp.net
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