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)
shwelopoAsked:
Who is Participating?
 
planoczConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.