Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svanloon
Starting Member
2 Posts |
 Posted - 2005-08-03 : 09:25:56
|
| Hello,I want the background color of a colum in my table to change when it has the following values:< 95 = red> 95 and <100 = orange100 = GreenI have tied the IIF statement but this doesn't work. Can anybody help me?Regards,Sander van Loon |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-08-03 : 09:57:45
|
iif should worktry this.=iif(Fields!TheColumn.Value = 100, "GREEN", iif(Fields!TheColumn.Value < 95, "RED", "ORANGE"))Duane.  |
 |
|
|
svanloon
Starting Member
2 Posts |
Posted - 2005-08-11 : 09:43:17
|
| Duane,Thank you for your response. Indeed it worked.Thanks,Sander van LoonLogicaCMG |
|
|
|
|
|
|
Backgroundcolor