report view cell color on time PM AMI am getting error code what is wrong with my code iifFieldstimeValue 34PM3434RED34 iifFieldstimeValue 34AM3434blue34iifFieldstimeValue 343434RED34 iifFieldstimeValue 343434blue34FieldstimeValue

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

kankon

SOLVED CLOSED ACTIVE ANSWERED
User: kankon
Posted: on Aug 07, 2020 07:37 AM
Forum: Crystal Reports with ASP.Net
Answer: 1
Views: 2389
Sample Code: Download

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

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Aug 08, 2020 03:06 AM
Modified: on Aug 08, 2020 03:07 AM
Report

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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

Company

Explore

Follow us

Contact Us