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-08 : 13:57:58
|
| I have a table that contains address info. If there is no info for address2 i would like the row to dissapear like it would in access if you set it to shrink. i have set the properties to grow and to shrink, i have put the following expression in initial visability (=iif(Fields!Address2.Value is nothing, true, false) and nothing works. I tried (=iif(Fields!Address2.Value is null, true, false) and got an error. When i look at the data returned by the query i do see that this field is Null... Any ideas? Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-08 : 14:05:52
|
| Here's the expression to use:= IIF(Len(Fields!Address2.Value) < 1, True, False)Tara |
 |
|
|
barb184
Starting Member
10 Posts |
Posted - 2005-03-08 : 14:14:44
|
| Thanks - tried it. Did not get any errors but my blank row is still there... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-08 : 14:50:34
|
| So I think you need to use the Visibility attribute then. Highlight the field in VS, then on the right side you'll have the properties window. Change the Hidden expression to what I have posted.Tara |
|
|
|
barb184
Starting Member
10 Posts |
Posted - 2005-03-08 : 14:57:25
|
That did it!!!! Thank you!!!! |
|
|
|
|
|
|
making rows visible or not visible