My rows have Ship dates and Ship quantities by Customer and Contract Number (Blanket Order). This is a manufacturing environment where fulfillment of orders is tracked for JIT (Just in time delivery.
A typical row will consist of the following information pulled from five tables in the query, but the query only has a Main table, and the other 4 just contain fields based on the primary keys; Customer and Contract.
Each ROW contains; Customer, Contract, Ship Date, Ship Qty, Customer Order Number, Mfg Part Number, Our Work Order number, and a Sequence Number for the Item.. 010, 020, etc..
The report needs to be formatted to show:
Header:
Customer CutomerNo ContractNo SequenceNo AllPreviouslyShipped ShippedTodayDate ShippingDate+1 ShippingDate+2 ShippingDate+3 ShippingDate+4 ShippingDate+5 ShippingNextWeek TotalStillDueToShip
I need to be able to enter a Parameter Discrete Value Date that looks at all ContractNo SequenceNo shipments prior to the date entered. The Items Shipping Today, then the schedule of items out 4 more days, than the next weeks total shipping schedule and then the total left due to ship after the current data(Schedule).. Today - through - Next Week has been satisfied.
Data to Consider:
ROW:
XYZ CORPORATION, CONTRACT1, SHIPDATE1, SHIP_QTY(5), CUSTOMER_ORDER(12345), MFG_PN(43R23), WO_NUM(123RD23), SEQ_NO(010).
Delivery in report:
Customer Data ... WO Data .. Prev. Shipped Today 10/16/2002 .. 10/20/2002.. LeftToShip
XYZ 200000 2100 10 .. 55 22056
Are there any ways to create cross-tab queries on the fly? etc.
Thanks
A typical row will consist of the following information pulled from five tables in the query, but the query only has a Main table, and the other 4 just contain fields based on the primary keys; Customer and Contract.
Each ROW contains; Customer, Contract, Ship Date, Ship Qty, Customer Order Number, Mfg Part Number, Our Work Order number, and a Sequence Number for the Item.. 010, 020, etc..
The report needs to be formatted to show:
Header:
Customer CutomerNo ContractNo SequenceNo AllPreviouslyShipped ShippedTodayDate ShippingDate+1 ShippingDate+2 ShippingDate+3 ShippingDate+4 ShippingDate+5 ShippingNextWeek TotalStillDueToShip
I need to be able to enter a Parameter Discrete Value Date that looks at all ContractNo SequenceNo shipments prior to the date entered. The Items Shipping Today, then the schedule of items out 4 more days, than the next weeks total shipping schedule and then the total left due to ship after the current data(Schedule).. Today - through - Next Week has been satisfied.
Data to Consider:
ROW:
XYZ CORPORATION, CONTRACT1, SHIPDATE1, SHIP_QTY(5), CUSTOMER_ORDER(12345), MFG_PN(43R23), WO_NUM(123RD23), SEQ_NO(010).
Delivery in report:
Customer Data ... WO Data .. Prev. Shipped Today 10/16/2002 .. 10/20/2002.. LeftToShip
XYZ 200000 2100 10 .. 55 22056
Are there any ways to create cross-tab queries on the fly? etc.
Thanks