Hide Textbox If Null - SQL Server Forums

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.

All Forums

Development Tools

Reporting Services Development

Hide Textbox If Null

Author

Topic

cjpsx
Starting Member

34 Posts

Posted - 2006-05-08 : 16:03:43

I need to hide a textbox if an address value is null. In Access, I got around this by concatenating address values into one textbox and then inserting a carriage return. How can this be done in SSRS?

Thanks,
cj

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-08 : 16:16:05

Highlight the text box, go to the Visibility..Hidden attribute in the properties. Type this in for the expression of Hidden:

=IIf(Len(Fields!Address.Value) < 1, True, False)

Tara Kizer
aka tduggan

cjpsx
Starting Member

34 Posts

Posted - 2006-05-08 : 17:24:04

That still leaves me with an empty address line, for example:

Line 1: Name
Line 2: Address1
Line 3:
Lin3 4: [City, State, Zip]

I need to move [City, State, Zip] up one line if the textbox above is null.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-08 : 17:26:03

I don't see how that's possible. Could you provide screen shots of what you changed in Visual Studio?

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources