Home Forums Reporting Services Reporting Services Color code RE: Color code

  • April 24, 2018 at 11:07 pm

    #1988142

    Joe Torre - Wednesday, April 18, 2018 12:17 PM

    Please have a look here.
    You my need to nest you IIF

    Iif(Fields!DBName.Value <> "tempdb",
          Iif(Fields!State_desc.Value = "ONLINE", IsNothing(Fields!Physical_device_name.Value),"Orange"
                                                                        , "LightGreen"),
             "LightGreen"),
       "LightGreen")

    HTH

    Thank you but the code is not working