Post reply

formula fields ssrs 2008

  • April 21, 2010 at 7:45 am

    #219501

    we've been using crystal reports and now changing to Reporting Services. i'm trying to create formula fields and i'm not sure how to go about it, here's an example i used in crystal.

    if ({vw_wrkWorkOrders.BaseStateDescription} = "Cancelled") = true

    then 1

    else 0

  • April 21, 2010 at 8:44 pm

    #1155822

    Write this in expression

    =iif(ivw_wrkWorkOrders.BaseStateDescription = "Cancelled", 1, 0 )

  • April 22, 2010 at 5:33 am

    #1155990

    thanks, it worked perfectly

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

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