[CChesler]

I am working in Crystal XI creating a very basic family directory. I have two formatting issues that I can't figure out.
One - I have a cell of just the Family Last Name. In those cases where the last name is hyphenated - like "Brantley-Jones" - I want to put a line break or hard return in at the point of the hyphen. I've tried an IF - Then - Replace - but I'm missing something.

Two - I have a section that can contain four lines -
Address
City, St, Zip
HomePhone
Email

In those cases where I have permission to publish the Home Phone - but not the address - I want to suppress the address lines so I don't have a blank space.

Thanks

[DrewAllen]

Quote:

Originally Posted by CChesler

I am working in Crystal XI creating a very basic family directory. I have two formatting issues that I can't figure out.
One - I have a cell of just the Family Last Name. In those cases where the last name is hyphenated - like "Brantley-Jones" - I want to put a line break or hard return in at the point of the hyphen. I've tried an IF - Then - Replace - but I'm missing something.

You don't need to use the IF THEN part of the construction. Replace will return the original string if there are no instances of the search substring. A hard return is a cr/lf. You have to construct it using the function CHRW(). So you'll have something like Replace( {field}, "-", "-" & Chrw(13) & Chrw(10) ).

Quote:

Two - I have a section that can contain four lines -
Address
City, St, Zip
HomePhone
Email

In those cases where I have permission to publish the Home Phone - but not the address - I want to suppress the address lines so I don't have a blank space.

Right-click on the section name on the far left side and select the "Section Expert". Then next to "Suppress" click the formula button to create a formula based on your permission field(s).

Drew

[DrewAllen]

I forgot to mention, that you'll need to put the address and the phone number in different sections for this to work. You can add another section by right-clicking and selecting "Add Section Below".

Drew