Post reply

Reporting Services usingIIF expression

  • September 15, 2008 at 6:41 am

    #192824

    I'm using reporting services and build a report with visual studio, on expression I put

    =IIf(Fields!Currency.Value="USD",Sum(Fields!TOTAL.Value),Nothing) meaning if found USD

    then sum the total field, works fine but I add another text box and change it to EUR

    =IIf(Fields!Currency.Value="EUR",Sum(Fields!TOTAL.Value),Nothing)

    and it didn't sum only sum for USD

    anybody know why?

    thanks

  • September 19, 2008 at 7:28 am

    #874194

    Try this

    =Sum(IIf(Fields!Currency.Value="USD",Fields!TOTAL.Value,Nothing)

    =Sum(IIf(Fields!Currency.Value="EUR",Fields!TOTAL.Value,Nothing)

  • September 19, 2008 at 8:18 am

    #874254

    works !!!!!!!!!!!!!!! THANK YOU !!!!!!!!!!!!!!!!!! 🙂

  • September 19, 2008 at 8:51 am

    #874284

    Welcome.

    I would recommend to post reporting services issue at following page.

    http://www.sqlservercentral.com/Forums/Forum150-1.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply