I need to create a report.In that no of columns are not fixed.It depends on the item range given by user.So how can I design a report for this kind??
It is some thing like this
Item1 Item2 Item3 Item4 ......
opening stock
sales
consumption
transfer
closing stock


thanks in advance.
juvenile

Well you could always use in the report one big string array. Then build the text field in the script. In the cases we did this the headings were fixed, but you could also create them if so needed. All you have to do is work out spacing. This is just one way it could be done.

Mark

This Variable column report (http://www.baanboard.com/baanboard/showthread.php?t=9395&highlight=spool+variable+columns) thread may help u .

Further we do have a tool whereby the report can come directly in excel directly from any baan report / baan table. Do let me know if u need more information.

You have to use spool() functions to make a dynamic multi-column report.

You can also exceed the limitation of column width of reports using spool.*.

Refer to - Nb max of characters on line in the report (http://www.baanboard.com/baanboard/showthread.php?t=9408&highlight=spool.line)