dear Baan Experts,
i am creating a new session and report and i would like to have my report display data in horizontal. pls refer to attachment.

report output
WHA WHB
Item A Lot 123 10 20
Item B Lot 234 50 0

Below is my program script.
select whinr140.*,tcibd001.* from whinr140,tcibd001 where (whinr140.cwar=:cwar.a or whinr140.cwar=:cwar.b)
and tcibd001.cpcl inrange {:cpcl.f} and {:cpcl.t}
and whinr140.item refers to tcibd001.item
selectdo
rprt_send()
endselect

Please advise how to trigger my qty on hand to show in horizontal?

Thank you

The first thing that popped into my mind is to track the warehouses in an array - then send the array to the report. Then you can place each element of the array out to the right. Not pretty, but would work.

If the number of warehouses is fixed and limited (20-30), then baan report can do it . But if it's uncertain and dynamic , then i'll recommend u use dynamic arrays , create a csv file and export it XL pivot table to get it . That can be quite intuitive and interactive solution also.

Dear Baan Experts,
Thank you so much for your advise.

Thanks