Post reply

Iif condition in total by descripion

  • September 26, 2013 at 7:59 am

    #280288

    I want o have my total by descripion based on the ISOrder value . If IsOrder = 1 then

    "Total " & Fields!ProjectName.Value & " by " & Fields!SuppNo.Value & " : "

    ELSE

    "Total " & Fields!ProjectName.Value & " test by " &Fields!SuppNo.Value & " (excluding charges) : ")

    I am using the condiion below, but it is not working :

    =Iif(Fields!IsOrder.Value, 1,"Total " & Fields!ProjectName.Value & " by " & Fields!SuppNo.Value & " : ","Total " & Fields!ProjectName.Value & " test by " &Fields!SuppNo.Value & " (excluding charges) : ")

    Please help!

  • September 26, 2013 at 10:45 pm

    #1653846

    try the following:

    =Iif(Fields!IsOrder.Value = 1,"Total " & Fields!ProjectName.Value & " by " & Fields!SuppNo.Value & " : ","Total " & Fields!ProjectName.Value & " test by " &Fields!SuppNo.Value & " (excluding charges) : ")

    The condition "Fields!IsOrder.Value = 1" was incorrect

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

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