Home Forums Reporting Services Reporting Services CAlculate debits and credit total in ssrs report RE: CAlculate debits and credit total in ssrs report

  • September 6, 2010 at 8:50 am

    #1216957

    anuhya.mudumba (9/5/2010)

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

    I think you want to sum the result of the conditional like this...

    Sum(Iif (ReportItems!textbox1.Value < 0,ReportITems!textbox1.Value,0)) in txtCRTotal textbox.

    Sum(Iif (ReportItems!textbox1.Value > 0,ReportITems!textbox1.Value,0)) in txtDBTotal textbox.

    I hope I got it right, but I couldn't test it. I hope you get the idea though.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers