SSRS Expression Help

Jeff S
Jeff S used Ask the Experts™
on
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"))
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
=IIF(Fields!IsRunning.Value ="Processing" , "DimGray", IIF(Fields!MostRecent.Value
>= TODAY(), "GREEN", "RED"))

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial