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 |
|
tking1
Starting Member
22 Posts |
 Posted - 2011-01-28 : 16:03:16
|
| I need to format bold font based on whether field has any of 4 possible values. Can anyone provide the statement?I have tried this, but not working what am i doing wrong?=Iif(Fields!ProjType.Value="Value1",Iif(Fields!ProjType.Value="Value2", Iif(Fields!ProjType.Value="Value3", Iif(Fields!ProjType.Value="Value4", "Bold","Normal"))))Thanks! |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-02-22 : 12:18:07
|
| =Iif(Fields!ProjType.Value<>"Value1",Iif(Fields!ProjType.Value<>"Value2", Iif(Fields!ProjType.Value<>"Value3", Iif(Fields!ProjType.Value<>"Value4", "Normal","Bold"))))What your code was saying was "If the field = Value1 AND Value2 AND Value3 AND Value4 then make it bold. Well it can't equal all those values so it was never going to be bold. Try this alteratin and see what happens.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
 |
|
|
|
|
|
Conditional Formatting Help!!