Hello ,
I have a problem with a query with a script . The data selected by the script are not displayed in the query report .
Below is the query code
select
tdpur400.orno, | Purchase Order
tccom100.bpid, | Business Partner
tccom100.nama, | Name
tdpur401.pono, | Position
tcibd001.dsca, | Description
tdpur401.pric, | Price
tdpur400.ccur, | Currency
tdpur401.qoor, | Ordered Quantity
tdpur401.cuqp, | Purchase Unit
tdpur401.oamt, | Order Amount
tdpur401.cpay, | Payment Terms
tdpur400.hdst, | Status
tdpur401.ddte, | Actual Receipt Date
tdpur401.qiiv, | Invoiced Quantity
tdpur400.corg, | Origin
tdpur400.odat, | Order Date
tdpur401.amld | Order Line Discount Amount
from
tccom100, | Business Partners
tcibd001, | Items - General
tdpur400, | Purchase Orders
tdpur401 | Purchase Order Lines
where
tdpur400.orno >= tdpur400.orno.f and
tdpur400.orno <= tdpur400.orno.t and
tdpur400.odat >= tdpur400.odat.f and
tdpur400.odat <= tdpur400.odat.t and
tdpur400.orno = tdpur401.orno and
tdpur401.item = tcibd001.item and
tdpur401.otbp = tccom100.bpid
order by
tdpur400.orno

And here is the script code

declaration:

table ttdpur402
table ttdpur200

detail.1:
before.layout:

select tdpur402.rqno, tdpur200.rdep from tdpur402, tdpur200 where tdpur402.orno= :tdpur400.orno and tdpur402.pono= :tdpur401.pono and tdpur200.rqno=tdpur402.rqno

|select tdpur200.rdep from tdpur200 where tdpur200.rqno= tdpur402.rqno

selectdo
selectempty

endselect


I edited the layout and compiled the report .
Is there something that i am missing.
Your help would be much appreciated.
Best regards

Which set of data are you talking about? What is found in the query or what is found in the detail.1 layout. If the detail layout then search on layout.again. Each record found would have to be printed. Plus it might need to be its own layout.

Hi Mark,
Thank you for your time and for your reply.
I am talking about the field in the script , they should be also printed in the report . But the report is only displaying the fields in the query and not in the script.
Can you help to check what i am missing ?
Thanks

Hello ,
I have a problem with a query with a script . The data selected by the script are not displayed in the query report .
Below is the query code
select
tdpur400.orno, | Purchase Order
tccom100.bpid, | Business Partner
tccom100.nama, | Name
tdpur401.pono, | Position
tcibd001.dsca, | Description
tdpur401.pric, | Price
tdpur400.ccur, | Currency
tdpur401.qoor, | Ordered Quantity
tdpur401.cuqp, | Purchase Unit
tdpur401.oamt, | Order Amount
tdpur401.cpay, | Payment Terms
tdpur400.hdst, | Status
tdpur401.ddte, | Actual Receipt Date
tdpur401.qiiv, | Invoiced Quantity
tdpur400.corg, | Origin
tdpur400.odat, | Order Date
tdpur401.amld | Order Line Discount Amount
from
tccom100, | Business Partners
tcibd001, | Items - General
tdpur400, | Purchase Orders
tdpur401 | Purchase Order Lines
where
tdpur400.orno >= tdpur400.orno.f and
tdpur400.orno <= tdpur400.orno.t and
tdpur400.odat >= tdpur400.odat.f and
tdpur400.odat <= tdpur400.odat.t and
tdpur400.orno = tdpur401.orno and
tdpur401.item = tcibd001.item and
tdpur401.otbp = tccom100.bpid
order by
tdpur400.orno

And here is the script code

declaration:

table ttdpur402
table ttdpur200

detail.1:
before.layout:

select tdpur402.rqno, tdpur200.rdep from tdpur402, tdpur200 where tdpur402.orno= :tdpur400.orno and tdpur402.pono= :tdpur401.pono and tdpur200.rqno=tdpur402.rqno

|select tdpur200.rdep from tdpur200 where tdpur200.rqno= tdpur402.rqno

selectdo
selectempty

endselect


I edited the layout and compiled the report .
Is there something that i am missing.
Your help would be much appreciated.
Best regards

Hello,
are you missing this fields ?

tdpur402.rqno
tdpur200.rdep


Are this fields present in report layout detail.1 ?

Regards

Hello ,
I have a problem with a query with a script . The data selected by the script are not displayed in the query report .
Below is the query code
select
tdpur400.orno, | Purchase Order
tccom100.bpid, | Business Partner
tccom100.nama, | Name
tdpur401.pono, | Position
tcibd001.dsca, | Description
tdpur401.pric, | Price
tdpur400.ccur, | Currency
tdpur401.qoor, | Ordered Quantity
tdpur401.cuqp, | Purchase Unit
tdpur401.oamt, | Order Amount
tdpur401.cpay, | Payment Terms
tdpur400.hdst, | Status
tdpur401.ddte, | Actual Receipt Date
tdpur401.qiiv, | Invoiced Quantity
tdpur400.corg, | Origin
tdpur400.odat, | Order Date
tdpur401.amld | Order Line Discount Amount
from
tccom100, | Business Partners
tcibd001, | Items - General
tdpur400, | Purchase Orders
tdpur401 | Purchase Order Lines
where
tdpur400.orno >= tdpur400.orno.f and
tdpur400.orno <= tdpur400.orno.t and
tdpur400.odat >= tdpur400.odat.f and
tdpur400.odat <= tdpur400.odat.t and
tdpur400.orno = tdpur401.orno and
tdpur401.item = tcibd001.item and
tdpur401.otbp = tccom100.bpid
order by
tdpur400.orno

And here is the script code

declaration:

table ttdpur402
table ttdpur200

detail.1:
before.layout:

select tdpur402.rqno, tdpur200.rdep from tdpur402, tdpur200 where tdpur402.orno= :tdpur400.orno and tdpur402.pono= :tdpur401.pono and tdpur200.rqno=tdpur402.rqno

|select tdpur200.rdep from tdpur200 where tdpur200.rqno= tdpur402.rqno

selectdo
selectempty

endselect


I edited the layout and compiled the report .
Is there something that i am missing.
Your help would be much appreciated.
Best regards

Hello,
are you missing this fields ?

tdpur402.rqno
tdpur200.rdep


Are this fields present in report layout detail.1 ?

Regards

Hello bdittmar,
Yes i am missing the two fields
tdpur402.rqno
tdpur200.rdep

Can you explain the process ? Should i create a layout with name detail.1 ?
Best regards

Hello,

i assume, layout detail.1 in report exists !


select tdpur402.rqno, tdpur200.rdep
from tdpur402, tdpur200
where tdpur402.orno= :tdpur400.orno
and tdpur402.pono= :tdpur401.pono --> tdpur402.pono not selected
and tdpur200.rqno=tdpur402.rqno ........

recordset is always empty because of missing tdpur402.pono
no comparision in "and clause" can be done


use : select tdpur402.pono, tdpur402.rqno, tdpur200.rdep

or : select tdpur402.*, tdpur200.* (Use all fields)

-----------------------------------------------------------------------------
I have no LN-Company with purchase requisition, so i can't test on a DEV-System.

Have you tried to analyse the report in debugger ?
While adding tdpur402.rqno and tdpur200.rdep to detail.1 in report layout, answered with YES on question "add as inputfield" ?

Regards

Hello,
After adding the field to the report it was possible to display the information.
Thank you all for your help.
Best regards