Asked by pcgym
at 2024-06-07 09:05:58
Point:500 Replies:2 POST_ID:828320USER_ID:12109
Topic:
.NET;;MS SQL Reporting
I'm looking to change the text color of one field (The Customer Name) if 1 or more of the following is True.
=IIf(Fields!ID0_30.Value > 0, "Red", "Black")
=IIf(Fields!ID31_60.Value > 0, "Red", "Black")
=IIf(Fields!ID61_90.Value > 0, "Red", "Black")
=IIf(Fields!ID91_120.Value > 0, "Red", "Black")
=IIf(Fields!Over120.Value > 0, "Red", "Black")
=IIf(Fields!CustomerTotal.Value > Fields!Limit.Value, "Red", "Black")
Can anyone help me with the syntax?
=IIf(Fields!ID0_30.Value > 0, "Red", "Black")
=IIf(Fields!ID31_60.Value > 0, "Red", "Black")
=IIf(Fields!ID61_90.Value > 0, "Red", "Black")
=IIf(Fields!ID91_120.Value > 0, "Red", "Black")
=IIf(Fields!Over120.Value > 0, "Red", "Black")
=IIf(Fields!CustomerTotal.Value > Fields!Limit.Value, "Red", "Black")
Can anyone help me with the syntax?
