I am trying to extract all the purchase history for each item but somehow only the last purchase record of each of the items are extracted on the report. Below is the statement I have written in the report script. Pls advice what's wrong with the program.


detail.1:
before.layout:
select tdpur041.*
from tdpur041
where tdpur041._index2 = {" ", :tibom010.sitm}
and tdpur041.orno >= 100000
and tdpur041.orno < 200000
order by tdpur041._index2
selectdo
orno = tdpur041.orno
suno = tdpur041.suno
pric = tdpur041.pric
endselect

I am trying to extract all the purchase history for each item but somehow only the last purchase record of each of the items are extracted on the report. Below is the statement I have written in the report script. Pls advice what's wrong with the program.


detail.1:
before.layout:
select tdpur041.*
from tdpur041
where tdpur041._index2 = {" ", :tibom010.sitm}
and tdpur041.orno >= 100000
and tdpur041.orno < 200000
order by tdpur041._index2
selectdo
orno = tdpur041.orno
suno = tdpur041.suno
pric = tdpur041.pric
endselect

Hello,

purchase line history is tdpur051 ????? !!!!!

In tdpur041 index._2 is project, article .........
Better select inrange {" ", :item}
and {"ZZZZZZ", :item}
....
....
....
....


Regards

If you want to show Itemwise, Supplier-Order-Price. Like master-details.

Hope layout.again() helps.

Regards,

-Suhas

I see u (both) wrote " " instead of "" in where expression

Is it a mistake or are u really sure this is ever the best way?