text box formating

[brianjay]

I'm collecting data from a SQL database. the form has checkboxes and when I print the data, they're seperated by a pipe (ex. text1|text2|text3). How can I remove the pipes and add a carrage return so that the data looks like:
text1
text2
text3

Thank you,

 

[Madawc]

Use a formula field. Try replace for "pipes2, and if possible replace them by CHR(13), the line-skip.

It helps to give your Crystal version, since newer versions have extra solutions, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia)

 

[brianjay]

I have records on a "MySQL" data server. I'm usin CR10. The "Time" cells on the DB are set for hh:mm. Regardless of what I enter in the DB, the report will only show the time as 12:00AM. Is there a switch I'm missing?

 

[Madawc]

You should post your new inquiry as a new thread. I can't advise since our data doesn't include times.

Madawc Williams (East Anglia)