report hide null values

[ashley1]

Hello Everyone

On a report i print the address from sql query
the format is

address line1
address line2
address line3
address line4
address line5
Country
Postcode

as address sometimes dont have all lines, sum fields contain no values so on report it puts a blank line, is there a way i can not put the field if it has no value???

thanks

 

[ashley1]

its ok i did by reading another thread i didnt see before
all u do is set the height property to 0 and can grow to yes
then pop them in one text field

cool