locked
Conditional Field Background Color in Report Builder 3.0 RRS feed

  • Question

  • i have this Conditional Field

    =iif(Fields!ENTRADA.Value>Fields!Hora_IN.Value,"Yellow", "white")

    But i wanna Add another condition:

    i have another field: abrv

    What i wanna do is:

    Iff abrv.Value=F.C and (DATEDIFF( MI , @ENTRADA.Value , @Hora_IN.Value ) )>15 "Yellow", "white"ELSE =iif(Fields!ENTRADA.Value>Fields!Hora_IN.Value,"Yellow", "white")
    Can i do that?

    Thursday, May 31, 2018 7:28 PM

All replies

  • Hi  neybernal

    According to your expression , you want to use two “iif” syntax to judge the color , you could use “iif” syntax in “Iif” , like this:

    =iif(abrv.Value=F.C and (DATEDIFF( MI , @ENTRADA.Value , @Hora_IN.Value ) )>15,
    Yellow,
    
    iif(Fields!ENTRADA.Value>Fields!Hora_IN.Value,"Yellow","white")
    )


    (be mind the sequence of the condition)

    hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    • Proposed as answer by Mitarai Queen Thursday, June 28, 2018 8:56 AM
    Friday, June 1, 2018 1:23 AM