report view cell color on time PM - AM
I am getting error code what is wrong with my code
=iif(Fields!time.Value = "PM","RED", iif(Fields!time.Value = "AM","blue",
iif(Fields!time.Value = "م","RED", iif(Fields!time.Value = "ص","blue",
Fields!time.Value))))
Download FREE API for Word, Excel and PDF in ASP.Net:
Download
dharmendr
on Aug 08, 2020 03:06 AM
on Aug 08, 2020 03:07 AM
3
use Like operator with OR condition.
Check with expression like below to set the color.
=IIF((Fields!time.Value LIKE "*AM") OR (Fields!time.Value LIKE "*ص*"),"Blue","Red")