Hello!
Please help me with my problem. I am intending to filter the output of my report using report script. I wanted to show all items in the tdinv120 table by its tiitm900.ccloca which is the field name for location(warehouse). I have been able to show the item by location but an item was shown for how many the item was in the tdinv120 table.

Please help. I am kind of new with report script manipulation. Thanks!
Posted was the script i've made.

before.tiitm900.ccloca.1:
before.layout:

select tiitm900.item, tiitm900.ccloca, tdinv120.*
from tiitm900, tdinv120
where tiitm900.ccloca BETWEEN 1 and 9999
and tdinv120.item refers to tiitm900
order by tiitm900._index1
| as set with 1 rows
selectdo
endselect





select tdinv911.*
from tdinv911
where tdinv911._index1 = {:tiitm900.ccloca}
selectdo
endselect

select tiitm001.*
from tiitm001
where tiitm001._index1 = {:tdinv120.item}
selectdo
endselect