General information
Category:
Coding, syntax & commands
Thats a difficult One. (Pls read it completely to understand my problem. )
I have made a project for a export company's stores/warehouse, they have codified each and every order, and import the goods related with each order....
the chain is like that:-
main order -> Multiple Invoices of imported goods
Each & every Invoice -> multiple Containers
Each & every container -> multiple goods
I have following files :-
main.dbf - The main Database file
Fields - Code, Description
Invoice.dbf - Invoice File
Fields - code, InvNo, ContCod
Container.dbf - Container File
Fields - ContCode, ContType, Itemcod
Items.dbf - Items file
Fields - ContCod, ItemCode, Description, QtyRcvd
The relation is like that
Main -> Invoice -> container -> items
I want to generate a cross tabulate report from these four files :-
On page Header :-
Main order No. Main Order Description
on group header :-
all the Invoices received related with that order, say I have received 3 invoices, so
inv1 inv2 inv3
in details band
Unique items from items file -> in front of it, total qty received for that particular item, below that particular invoice....
Presently, I have made a very long routine to get to this output, but it is very lengthy, complicated, difficult to modify/debug...
Can somebody please suggest me a way to do this thing, through sql(s)...
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