Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find CHR(13) in a string
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00888936
Message ID:
00889243
Views:
21
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform