Hi All,

I'm creating a PO report which requires to extract the additional text tdpur401.txta .

my issue here, when I execute the query and export to excel, the text information not print complete like other field.

Do you know how to merge or compress or any terms to use to ensure the text printed out complete and in 1 column .

Thank you for your precious time.

Thank you

Are you trying to print all the text in one column in excel?

TEXT_CONTENT macro can be used to get value in ln.(used in fp7)
e.g

string text_data(999)
select TEXT_CONTENT(tccom100.text):text.data
from tccom100

Here all data linked text to get assigned to text.data.
cons:we have to give fixed size variable.

or you can use text.to.buf to concat text from text field.
____________

Hi Mark_h ,

I'm trying to print it at 1 row .
Current report, it print in lines .. so when 1 Purchase order has 2 order lines , the report print more lines for column text . As attached file.

I want it be more efficient when it could print at 1 line.

Thank you

Hi Rahul ,

can you show me how ?
I tried your suggestion but I failed.
I guess im not doing it correctly .

Thank you

I already shown in my example.you have just pass text no field table as argument TEXT_CONTENT Macro.post your code so i can check what you're missing.

hi Rahul_ingale ,

this is the portion that I need
* ------------------------------------------------------------------ *
declaration:

table ttdpur401

string text_data(999)

select TEXT_CONTENT(tdpur401.txta):text.data

tdpur401.txta=text.data

thank you