General information
Category:
Reports & Report designer
>
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only