Creation of Cross Tab Reports

We want to generate some cross tab reports for sales mis.
We intend to do this using the category codes in item master and
Address book number. Typically a report will look like this.

Sales for the period dd/mm/yy
------------------------------------------------
Product -> xx1 xx2 xx3 xx4

Region

yy1 99 99 99 99

yy2 99 99 99 99

yy3 99 99 99 99


Product is represented by item master category code 01
Regiion is represeneted by Address book category code 11


Can anybody suggest a method for this ?

Sasi,

a third-party reporting tool such as Crystal Reports is your best approach to generate your cross-tab in my opinion. You can even use MS Access to do it.

Regards,

Sounds like you should be using tabular section reports.............