Null Values (1 Viewer)

[loco]

i am having a problem "not" printing null values. for a basic example :
lets say i have a small database that contains company, contact name, address, address 2, city, state, zip. some records do not contain a contact name, or an address 2 line. i am trying to devise a report that will simply print each record but supress the fields that do not have data :

johnson company
john smith
2121 anywhere st
ste 600
maryville, sc 22222


johnson company
2121 anywhere st
maryville, sc 22222

i need the second example to look like it is above, instead of what it looks like below :

johnson company

2121 anywhere st

maryville, sc 22222

notice the blank lines that are left when the contact and address 2 have no data.

anyone know a way around this within the report design ?? suggestions ?

thanks
loco

 

[Travis]

Try setting the fields CanShrink Properties to True.

 

[loco]

that did the trick my friend !
thanks !