Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Tip for cross tabulate reports
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement