Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tip for cross tabulate reports
Message
De
15/05/1997 11:05:17
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordanie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00032393
Message ID:
00032426
Vues:
39
>
>Personally, I have devised a customized cross-tab approach for complex situations. I create two tables. THead and TBody. I have a common link between then called VSet (Vertical Set). I use SET RELATION to link the two tables via VSET. I then setup a report form with the VSet group and make sure that page break is on for VSet changes.
>
>Here's what I do. I get a distinct list of dates from the primary data set and load them into THead. Next, I assign a Vset number to each record in THead, sequential 1 through x. Now, I read the primary data set and create TBody and back fill the VSet field from THead. It seems to work for me and allows me to handle strange data problems that I encounter that require data massaging. .

The method, which you are using can be applicable in my report, iwant a output like this:-

order, desc, jan, feb, mar, apr, ....

from these 2 files :-
order which is having order no. and description

delivery which is having order no., delivery date and qty.

the records in delivery will be shown in jan, feb.. columns, Pls advs, is it possible and if it is, which of the 2 methods is easy and fast.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform