Hey everyone,
I'm trying to make an image appear differently depending on the values of certain data. The statement that I am using is:
= IIF(DATEDIFF("dd",Fields!LastBackupDate.Value,Now)>15,"redball",IIF(DATEDIFF("dd",Fields!LastBackupDate.Value,Now)<8,"greenball","yellowball"))
And the error that I get is:
[rsRuntimeErrorInExpression] The Value expression for the image ‘image4’ contains an error: Argument 'Interval' is not a valid value.
Preview complete -- 0 errors, 1 warnings
When I preview the report I just get the typical white box with a red x where the image should be. I don't understand.
Thanks in advance,
Keith
Nevermind, argument needs to be "d". Thanks anyway!
-Keith
No comments:
Post a Comment