Avatar of CCIDover

asked on 

Multiple IIF statements SSRS expression

I'm working on an SSRS report and i'm trying to conditionally format a particular field on the report, but I have to have more than on IIF statement in the expression. I'm fairly still new to writing these expressions and have not been able to get it right yet.

On the properties box for this field on the background color property I have this expression.


I need to add another condtional check which is the Crystal Report Syntax below:

IF {poitem.promise_date} < CURRENTDATE then color (255,204,255) ELSE
IF ISNULL({poitem.promise_date}) THEN COLOR(0,255,0) ELSE NOCOLOR

So far I keep getting errors. Lookin for some help.

SSRSRegular ExpressionsVB Script

Avatar of undefined
Last Comment

8/22/2022 - Mon