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 |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2012-11-14 : 09:15:45
|
| HiI'm trying to add an expression for null values and want to return "No Assignee" if null else assignee field:Can someone help please?=IIF(Fields!Assignee_Details____Assignee_Name.Value Is Nothing, "", "No Assignee" Else Fields!Assignee_Details____Assignee_Name.Value |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-14 : 09:18:38
|
You don't use an else clause in IIF. The second argument is the value returned if the first argument evaluates to true, and the third argument is returned if the first argument evaluates to false=IIF( Fields!Assignee_Details____Assignee_Name.Value Is Nothing, "No Assignee", Fields!Assignee_Details____Assignee_Name.Value) |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2012-11-14 : 09:44:01
|
| Thank you :) |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-14 : 10:00:02
|
| Glad to help .) |
|
|
|
|
|
|
If IsNull