Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tip for cross tabulate reports
Message
From
15/05/1997 11:05:17
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00032393
Message ID:
00032426
Views:
41
>
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform