If field exists, add extra space for field in report 2

[Zugdud]

Howdy folks, Im working on a report which has three address fields, the second and third are not always populated. Right now the report just prints with the first address per line

So heres an example

Company Name Phone Address1
Company Name Phone Address1
Company Name Phone Address1


Due to space constraints I can not fit the additional address 2 and address 3 in the same row so I would like to add them below each record ONLY IF they are not null, so for example lets say some of the above records had more then one address, this is how I would like them to print out:


Company Name Phone Address1
Address2
Address3
Company Name Phone Address1
Address2
Company Name Phone Address1
Company Name Phone Address1
Address2
Company Name Phone Address1
Address2
Address3

Hope that makes sense, basically I guess I need to figure out if its possible to dynamically adjust the height of the output record...or mabey have a hidden section that is unhiden if the address fields are not null?

Any thoughts?

Thanks!!!

 

[lbass]

Put each address in a separate detail section (detail_a,_b,_c) and then format each section to "Suppress blank section".

-LB

 

[synapsevampire]

Right click your details section and select insert section below 2 times.

Place the first set of data in details A, 2nd in details B, etc.

Now you can right click each section and select format->Section->suppress when blank, or whatever the equivalent is in your version of Crystal.

-k

 

[Zugdud]

Thanks guys, that worked great!!!