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 |
|
barb184
Starting Member
10 Posts |
 Posted - 2005-03-23 : 11:38:45
|
| I don't want to show a row if the supplier3 field contains the value "none". I have the code below in the visibility property for the row - can anyone tell me what I am doing wrong? Thanks!!!!!!= IIF(Len(Fields!Supplier3.Value) = "none", True, False)Barb |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-03-23 : 12:04:55
|
| Why the use of the LEN function? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-23 : 12:19:28
|
| I have a feeling that this is copied code from the NULL data example I showed not too long ago. You don't need Len for this as Andrew is pointing out.Tara |
|
|
|
barb184
Starting Member
10 Posts |
Posted - 2005-03-23 : 12:45:35
|
| yes, that's exactly what i did. So I removed the len and it still does not work... this is what i have:= IIF(Fields!Supplier3.Value) = "none", True, False)Error i get now is argument not specified for false part... Sorry to be such a pain but i am really trying to learn this as i go. Any help would be greatly appreciated!Barb |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-23 : 12:49:47
|
| You are missing a left parenthesis now. You've got one left and two rights. It should be:= IIF(Fields!Supplier3.Value = "none", True, False)Tara |
|
|
|
barb184
Starting Member
10 Posts |
Posted - 2005-03-23 : 13:09:44
|
| Geez - what a dope i am. Thanks TaraBarb |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-23 : 13:11:53
|
| Sometimes the easy ones slip by us as we think the problem is more complex...it happens to me all of the time.Tara |
|
|
|
|
|
|
Hiding rows in table based on specific value