Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
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?
Expert: duncanb7 replied at 2024-06-07 10:14:36
Place this code in your Color box on the properties window of your Customer Name
textbox or cell.
=IIf(Fields!ID0_30.Value > 0,
IIf(Fields!ID31_60.Value > 0,
IIf(Fields!ID61_90.Value > 0,
IIf(Fields!ID91_120.Value > 0,
IIf(Fields!Over120.Value > 0,
IIf(Fields!CustomerTotal.Value > Fields!Limit.Value,
"Red","Black"),"Black"),"Black"),"Black"),"Black"), "Black")
Accepted Solution
Expert: planocz replied at 2024-06-07 09:51:40
500 points EXCELLENT
Place this code in your Color box on the properties window of your Customer Name
textbox or cell.
=IIf(Fields!ID0_30.Value > 0,
IIf(Fields!ID31_60.Value > 0,
IIf(Fields!ID61_90.Value > 0,
IIf(Fields!ID91_120.Value > 0,
IIf(Fields!Over120.Value > 0,
IIf(Fields!CustomerTotal.Value > Fields!Limit.Value,
"Red","Black"),"Black"),"Black"),"Black"),"Black"), "Black")
