Help is needed... Dunno how to solve this..

[limhamid]

Ok i need help.
The situation is this : First part of my module is data entry to progress database. In that entry i allow user to use the "ENTER" function to allow user to go to the next line.

Problem :
Now i want do a report using that data but everytime i export it to .txt file whenever it sees the "ENTER" symbol in database it goes to the next line so i have a report that looks like this :-

---NO---- -Comment---- -Type-
00000001 Fussy customer CBS
00000002 Customer have outstanding acc.
ACC no is 231 CBS

So as u can see the comment goes to the next line... i want a straight line

i want something like this:-

---NO---- -Comment---- -Type-
00000001 Fussy customer CBS
00000002 Customer have outstanding acc.ACC no is 231 CBS

 

[tamhas]

I presume that you are using an editor widget for the text entry?

I would simply use replace() on the string after the entry before storing the string in the database to remove the carriage return and/or new line characters. This will work in your report and word wrap will get you a reasonable display in Progress.