The best is not to add new fields in your database but add fields in a temp table you only use for the report.
>Hello,
>
>Thanks for the reply.
>
>I was hoping I could use the existing field and just search for CHR(13) in a Formula Field.
>If this is not possible, I will have to add another field to the database.
>
>Thanks,
>
>TFISHER
>
>>Create deferente fields in your data for every format of output.
>>Then in the Crystal Report you use the one you need for the report.
>>
>>Select address,strtran(address,chr(13)) as AddressNoCR from MyDate
>>
>>
>>>Hello,
>>>
>>>I have an address where I would like to be able to display two different ways.
>>>
>>>The first way is as follows:
>>>
>>>222 Address Street
>>>YourCity, YourState 55555
>>>
>>>The second way is as follows:
>>>
>>>222 Address Street, YourCity, YourState 55555
>>>
>>>I am currently placing a CHR(13) in the string.
>>>
>>>Is there a way, using Crystal Reports Developer version 9, to search for the CHR(13) and replace it with a space?
>>>
>>>I have tried the REPLACE command in Crystal, but I can not get it to find the CHR(13) -- at least, I can't get the string to display all on one line.
>>>
>>>Any ideas how to do this?