Dear Baan Experts,

Please help me to create a script to make the supplier code a column title same crosstab with item, qty and price as rows and qty * price as value. This will read from table tdpur106.
Your script suggestions will be very much appreciated.

Thanks,
JOJO

In baan reporting u can have maximum 500 charactrers in a line . So Baan reporting for this may not be suitables . If u are comfortable with excel pivot table , write / print data in csv format , open in xl and create pivot table of imported data (through a macro u can automate this ) and u will get the data in the format u wish .

There could be other alternatives like reporting services / BIRT , which also u can try but excel method seems to be the easiest.

Dear Hitesh Shah,

If ever I will use BIRT, could you share with me some sample scripts that will make the supplier code as the column header? I would really thank you for the help that you will extend to me about this report.

JOJO

Hi JOJO,
if using BIRT you can create your crosstab layout in Birt Designer. All you have to do is defining the correct query to get required Data.
Afterwards you can define your dimensions and measures very easily.

You can find good tutorials on building crosstabs in BIRT here (http://www.birt-exchange.org/devshare/designing-birt-reports/202-birt-cross-tab-example-basic-/#description) and here (http://www.birt-exchange.org/devshare/designing-birt-reports/216-building-a-dynamic-crosstab-birt-2-2-1-tutorial-series/#description).


Hope this helps,
Andreas

Dear Andreas,

Thank you very much for the links you gave, I will try to study and learn this and make my crosstab report in BIRT. I think this will helps me really.
Again thanks and more power.

JOJO