[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

suppressing empty address lines in reporting services (2003)

I'm trying to suppress empty lines in reporting services.

the code =trim(Fields!cla_address_line_2.Value)
0
shwelopo
Asked:
shwelopo
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Define 'suppress'.
0
 
shwelopoAuthor Commented:
I'd like the next line that's not empty ro move up.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Hmm...  rather than deal with this in the .rdl, any chance you can verify that whatever SQL in your main data set is returning empty rows, and deal with it there?
0
 
planoczCommented:
Jim is right, but you can hide the row if the it is empty.

=IIF(trim(Fields!cla_address_line_2.Value)= "", True, False)
Place this in the hide Windows properpties of that textbox in the report.
this will work only if address2 is only a single line.

If not then you will need to use this in the address1 textbox....

=IIF(trim(Fields!cla_address_line_2.Value) = "", trim(Fields!cla_address_line_1.Value) , trim(Fields!cla_address_line_1.Value) & vbCRLF & trim(Fields!cla_address_line_2.Value))
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now