Empty Address Lines

Hot Topic

Running SQL server 2000 & 2005 side by side
Encryption and database restore
Concatenating 2 text boxes
Deliver to SharePoint
How to create and combine 4 reports, one being a total off fields from the other 3 ?
Date Time Format Options When Writing to a Flat File
Uninstall Microsoft SQL 2005 CTP
Service Broker from behind the NAT
SQL 2005 Enterprise June CTP Installation Error
Should you save results of intermediate data flow steps to temporary tables or raw files?

SQL Server

how to do it without using cursor?
SQL 2005 scripting stored procedures
Using SSMS to Manage SSIS
RowGuid
WWW Service overload when trying to print a rs2005 report
SQL Server Setup failed to retrieve the SSL Certificate Name
Session MDX scripts and assignments
2000 Client Connectivity .msi?
Can't run param server reports using ReportViewer control.
SQL Server Express EULA

Empty Address Lines

What is an easy way to squeeze the lines of an address when anyone one of the address lines might be empty

Example:
Customer Name
AddressLine1
AddressLine2
AddressLine3
City, ST, ZIP

Answer this question

Empty Address Lines

  • AnnyJacky

    I have not tried this but you can try using a formula for the LINE HEIGHT property of the the address lines - Under Properties/Format

    =iif(Fields!AddressLine2.Value= "","0pt","9pt")

    This hopeful will set it's line height to 0 if its empty OR 9pts if not.
  • Empty Address Lines
Answer this question