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...?