Fields with no values

[EscapeUK]

I want to display an address. However some of the fields are blank which makes the output look very messy.

At the moment the report is structured like this

{Name}
{Address1}
{Address2}
{Address3}
{Town}
{County}
{Post code}

However there is not always any values in address 2 and address 3 with makes the report look a mess, any advice.

 

[Guest_imported]

Make fields very small (heigth) and choose for "Can grow"
or put them in different sections (On desired section click on right mousebutton and choose "Insert section below&quot
Put Address 2 in that new section and format the section so that it suppresses depending on a formula, which checks to see if the field is empty or not.

best regards,
Guy.van.dyck@vaderlandsche.be

 

[kenhamady]

Or, you can create 7 subsections, and place EACH field in it's own subsection. Then format each section to "suppress blank section" in the section expert. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dcm]

EscapeUK: There is a v. v. simple way to overcome this! USe a text object to contain your fields. Text objects are set by default to suppress empty fields with the result that Address 3 would print directly under Address 1. You may wish to include a formula field to force correct line feed within the text object [formula = CHR(13)] to prevent the postcode from wrapping up onto the County line if you resize the Text object David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner