I am creataing a report with a Local Mode report and ReportViewer. Part of the report has an address:
[FName] [LName]
[Address1]
[Address2]
[City] [State] [ZIP]
[Phone]
So the data might come out on the report:
John Doe
123 Fake Street
Suite 32
Somewhere USA 00101
(800) 555-1212
Which is great, except if address2 is blank (as in most cases it is) it comes out:
John Doe
123 Fake Street
Somewhere USA 00101
(800) 555-1212
How can I make it Hide the [Address2] Field if it is blank, so that extrat line space is taken out?
Thanks
UPDATE** - As soon as i posted this site i realized when you use the expression for this, it should be =Field(Value) = "". I had =Field(Value) <> "". I was backwards. Sorry for the uncecessary post.
In the visibility property of textbox give the expression as
IIF(Len(Fields.Address2.value)>0,True,False)
Thanks
Subbu
No comments:
Post a Comment