Post reply

SSRS Expression Help

  • October 8, 2019 at 2:34 pm

    #3687023

    I need assistance with the following requirements:

    I need the font on my text to equal "DimGray" when IsRunning = "Processing" else if the MostRecent.Value > today = Red else Green. With what I have below, its making them all DimGray.

     

    =Switch(Fields!IsRunning.Value ="Processing" , "DimGray", IIF(Fields!MostRecent.Value

    >= TODAY(), "GREEN", "RED"))

  • October 9, 2019 at 3:10 pm

    #3687431

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • October 11, 2019 at 2:20 pm

    #3688049

    Change the Switch to IIf.

    =IIf(Fields!IsRunning.Value ="Processing" , "DimGray", IIF(Fields!MostRecent.Value >= TODAY(), "GREEN", "RED"))

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

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