Expressions color problem

[Anis]

Hi,

I use expressions in "Fill color", it works very well in the SQL report builder, but in ReportViewer, it uses only one color on all lines (see screenshot).

Expression:  =IIF((Fields!myField1.Value) is nothing & (Fields!myField2.Value) >0, "Yellow", IIF((Fields!myField2.Value) > (Fields!myField1.Value),"Yellow", IIF((Fields!myField2.Value) < (Fields!myField1.Value), "#ff7f00","White")))

Regards,

Anis

Attachment: screenshot_79094fbc.rar

[Mahendran Shanmugam]

Hi Anis, 

  

We have checked the mentioned problem with your shared expression in French culture and its working properly at our end as shown in below shared screenshot. For your reference, we have prepared a RDL file using the shared expression and please confirm whether the RDL file is working properly at your end it can be downloaded from below location, 

RDL:  http://www.syncfusion.com/downloads/support/directtrac/general/ze/SampleReport1941262909 

  

 

If the issue still persist, then revert the shared RDL with issue reproducible procedure to Validate the mentioned problem at our end 

  

Thanks and Regards, 

Mahendran S. 

[Anis]

Thank you for your reply, it was a problem in the expression I think (the and condition). When I changed the expression it works.

Expression : =Switch(((Fields!myField1.Value) is nothing  and (Fields!myField2.Value) > 0), "Red",

  ((Fields!myField2.Value) > (Fields!myField1.Value)), "Yellow",

 (Fields!myField2.Value) < (Fields!myField1.Value), "#ff7f00", 

 (Fields!myField2.Value) = (Fields!myField1.Value),"White")

Regards,

Anis

[Mahendran Shanmugam]