Hi,

I have a very simple crystal report where by I am showing a field from a database.

This field has multiple bullet points in it. If I were to query the field it would look like below.

• View everything we do from a customers perspective• Be the easiest company to do business with

However, this is not what the client requires.

They would like to appear as such:

• View everything we do from a customers perspective
• Be the easiest company to do business with

How can I do this in crystal or would i have to separate in SQL

Thanks for your help

If I am assuming that the first line is a continuous string.  I would use the replace function.  I do not know what the bullet symbol ascii code so I will use a dummy for the example formula.

replace({somestring}, chr(0), chr(0)+chr(13))

that should put a carriage return into the string.