Recently I wanted to create a cross tabulate report from 2 files, one was order and one was delivery.

Output should come for each order monthwise than means, 12 months on top of report and below that delivery dates and quantities of that particular order.

the problem with genxtab is, it only allows 3 fields to select , so I have used another trick :-

select iif(month(date)=1, date, { / / }) as jan, iif(month(date)=2, date, { / / }) as feb, ... and so on for the 12 months.

This trick can be helpful for creating report similar to this one and the output of select can be transfered to a cursor, from where it can be further modified/formatted.