Change Cell Color in RDLC report based on condition using IIF statement in ASP.Net

on Aug 07, 2020 07:37 AM

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",


Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Aug 08, 2020 03:06 AM
on Aug 08, 2020 03:07 AM

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")