Hi all

I need to display text from Purchase Line to the report Purchase Order Related to Invoices (tfacp143011000).

i have follow from sales report like this bellow, but not display the text.


i have add the text field tdpur401.txta in the Input Field


detail.1:
before.layout:

select tccom100.nama:namebp
from tccom100
where tccom100.bpid ={:tfacp240.otbp}
selectdo
endselect

| Display text
after.layout:
field.tdpur401.txta:


please anyone can help me.

Not sure I get what you are showing. Is tdpur401.txta retrieved in the session code and then passed to the report? If so then you just add it to the reports input field, and then go add it to the layout you want it on. No report script needed.

Now if the tdpur401.txta is not part of the source session - then you can go into the report and add a query to retrieve it. Add the query in the before layout of the section where you want the text to print. Do not add tdpur401.txta to the reports input fields - not needed. So Just add the table in the declarations and do the query in the report script. Then just add the report field tdpur401.txta into the layout.