ap2203
5th October 2009, 23:46
I have a problem when i put text in report, I dcl a field string 240 char and put in the a field txt,but I line after line
i put text in excel file but not linr after line
Have any idea how i solve a problem
It is urgent
Need help
best regards
mark_h
6th October 2009, 14:55
Sorry, but I am not understanding. You have a report with text in it - does the text print ok to dislay devices or printers? Next it looks like you download the report into excel - at this point I do not understand what the problem is. The only problem I have with reports with text is converting them in excel - the text does not line up with the field columns. So usually I just delete the text or move it to its own column.
ap2203
6th October 2009, 19:35
I ll try to explain, I have a text operatio which has more line
When i print on report all is OK, but I want download report in excel file
in that moment i have a problem
for one operation on detail I have 4-5 line text
i put text in field which I declared like other but i have next situation
Project Item Pos Tano Oper.tim Text nu NO of line Text
420026 6004102 10 9040 5 1 1445441 1ab
420026 6004102 10 9040 5 1 1445441 2 b
Od Why in this position and again in the next line
420026 6004102 10 9040 5 1 1445441 3 Od
First line is ok
Second OK it must be only b , but next line is the begining of the tfird line but not on correct position
How can i conver correctly in excel file
Is it clearly
Wait help
Best regards
__________________
mark_h
6th October 2009, 20:21
Sorry - the only things I can thing of is to always to a shiftl$ on the report field. I am not sure if that is what you are asking about. I have never really worried about bringing text into excel without me doing a bunch of manual formatting in excel. Maybe others will have better suggestions.
ap2203
7th October 2009, 07:35
Please any example which you work, may be I make a mistake in syntax
Urgently
Thanks
ap2203
7th October 2009, 09:55
I solve my problem
I found in string pos of LF =line feed(chr$(10),
CR = carriage return(chr$(13),
Then I have first and last pos for one line in text and then i put it in col in excel
I dont know may I connect CR+LF which chr$(???)
but it works ok
Thanks again
Best regards