how to use New line in Crystal Report using Formula Field

Try to get HTML string from the formula and use html tag to format your output, like

"Address: " & ToText(Add1) & " <br> " & ToText(Add2)

drop the formula field on your report and change its 'Text Interpretation' property on 'Paragraph' tab to 'HTML Text'

I've got a variation on the new line question

I have one field and I want to insert a carriage return in the middle of the value based on a the appearance of a certain word.

For example, the text field value might be "Credit line for the object. Company Name." (all in one field)
I want to insert a new paragraph line so it displays as;

Credit line of the object.
Company Name.

Is this possible?
Thanks

Hello Member
I give you very easy way for this:

If you want to add address in crystal report as a Add1, Add2, Add3.
You can take a three Text object as a txtAdd1, txtAdd2, txtAdd3.

you can manage this for your requirement. It's a very easy compare of formula. If you use formula it's so difficult to modify it's such as bold text, underline, alignment etc.

if you fill your address in differences three text object you can work easy ant its easy to mentaine if future uses.


After that desion wise you.
You can try different way and you desided which is easy to use.

:)