Thanks Lutz for your reply...
I cannot use it in the sql part. The requiremment is such that i should get the raw data from the tables and perform all others transformations from the ssrs side. Also I need to display these credit and debit totals in the report footer.
I tried something like :
Iif (ReportItems!textbox1.Value < 0,Sum(ReportITems!textbox1.Value,0) in txtCRTotal textbox.
Iif(ReportItems!,textbox1.Value =0 OR ReportItems!.textbox1.Value>0, Sum(ReportITems!textbox1.Value),0)
But it is giving the error that multiple report items cannot be used.
If i pass a numeric values to the iif statement like,
IIF(ReportItems!textbox1.Value <0 , 1, 0) it works fine.
Is it something like we cannot pass reportitems in the iif statement ?
Any clue...?
With Regards,
Anu..;-):hehe: