Crystal Syntax Newline Command

[Odysseus2118]

Hello,

I was wondering if anyone knew of a newline command in crystal syntax. For example, if I wanted to create a formula which puts together an address: I would want to get the street address, then add a new line (so the next line would be below the street address), then the city, then a newline, then the state/zip.
Is there anyway to do this? Thank you for any help ahead of time.

 

[mbarron]

Try this:
{line 1} + chr(13)+{line 2}+chr(13)+{line 3}


Make sure you format the field to "Can Grow"
Mike

 

[Odysseus2118]

Thank you, it seemed to work fine. Out of curiousity, what does the chr(13) command stand for?

Now that this has worked I have another question. What, if anything, can be done if the value in the database is NULL? For example, say no address is specified, but a town/city is. Is there anyway to display the town name without creating a blank line where the address would usually go? Thanks again.

 

[dgillz]

If IsNull({Field2}) then
{Field1}+chr(13)+{Field3} else
<< your full formula >> Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[mbarron]

CHR(13) is ASCII for &quot;carriage return&quot; Mike

 

[Odysseus2118]

Thank you ... this has helped me out a great deal.