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

kankon
 
on Aug 07, 2020 07:37 AM
Sample_178356.zip
1289 Views

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

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