hi all

I am a beginner of baan tools development.I have met some trouble about a report session.

This report I want to list statistic of per day item input& output,and I want report can be desigend like following:
Transaction Date:
Item Input output downgrade
A1000 100 100 50
......
I want select data from table tdlra013.

But in the table, each record is based on transaction date, transaction type,order type and item.

I have write a sql statement that:

select tdlra013.trdt,tdlra013.item,tdlra013.kost,tdlra013.koor,tdlra013.quan
from tdlra013
where tdlra013.trdt between :e.item.f and :e.item.t
and tdlra013.item between :e.trdt.f and e.trdt.t
order by tdlra013.trdt,tdlra013.item,tdlra013.kost,tdlra013.koor

While the result will be like that:

01-04-2006 A1000 ProductionOrder Receipt 1000
02-04-2006 A1000 productionOrder Receipt 2000
.
.
.
01-04-2006 A1000 ProductionOrder Issue 500
02-04-2006 A1000 ProductionOrder Issue 200
.
.
.


In select do block, what can i do to reach my goal.
I do not know whether&how I can using loop statement in select do block also.

Does there any better suggestion?

Thank you for your help.

You are not very clear about what you need but i understood i telling you.
You can short you data by item, transactiontype, date
from program script of session the sorted data would be sent report.

syntax for select

select * from
table_name <condition>
orderby
selectdo
.....
....
selectempty
----
----
endselect

It looks to me like you want to change your sort to item, koor, kost, transdate.