Work order finish date and work order desired want date are the same - Apologies for my inconsistency.
A works order consists of multiple operations to manufacture a part. For example, a works order with a desired want date of 28/06/2010 can have 3 operations to make a part.
Operation 1 can...
I am using 4 tables Operation, Work Order, Part and Shop Resource.
The main fields are work order base id, work order sub id , operation resource id, operation start date, operation finish date and work order finish date.
I have tried TopN/Group Sort and it doesn't seem to sort it.
I have a group on WO, but I have 5 other groups before that in the sorting order. Can I do group sort based on maximum of work order finish date in Crystal 7. Can't find that option in my report writer.
I tried your formula maximum({WORK_ORDER.DESIRED_WANT_DATE},({WORK_ORDER.BASE_ID})) and...
If you look at my sample, there are three different work orders and hence three different finish dates. My problem starts when I want to display the finish date of the main assy on the detail section of sub ids greater than 1.
For example, lets say works order W12345 is for a computer assy...
Sub ids greater than zero are sub-assemblies indented under the main assembly (Which always has zero as sub id and a finish date).
Lines with sub ids greater than zero do not have a WO finish date. I want to use the main assembly's finish date on those lines.
Is it possible to do this?
LB,
This is what I am expecting to see in the report.
WO Sub ID Start Date WO Finish Date
W2000 0 15/06/2010 20/07/2010
W2001 1 15/06/2010
W2002 2 16/06/2010
The report is displaying the above info (although there finish date records in the works order table for lines 2 & 3).
If they...
Hi LB,
Thanks for your response. I have attached the report this time.
The tables in the report are Work_order, Operation and Shop_Resource linked by equal joins and work_order and Part tables linked by left outer join.
Each works order will have its sub id as zero and has a finish date. A...
Hi,
I have created a shop floor work to list using crystal 7. I have sorted the operation table by scheduled start date.
When multiple operations are scheduled to start on the same day, I would like to use a secondary sort by works order finish date.
Crystal displays the works order finish...
Ian,
I am a learner. This is the formula I am using and it still comes up with boolean is required here error.
if left ({LABOR_TICKET.DESCRIPTION}, 1) = "A" then ("TUBROD 14.05 ROOT WIRE FCAW") and mid ({LABOR_TICKET.DESCRIPTION},2,50)
else if left ({LABOR_TICKET.DESCRIPTION}, 1) = "B" then...
Hi Ian,
Tried your suggestion, but it comes up with a boolean is required here error before "WB6105S(FCAW".
Also length of mid is not a constant and it could be anything between 5 to 25 characters. How do I define the string length? Kindly help.
TIA
Hi,
I would like to replace the letters A and B in the fields below with the actual welding wire types:
if {LABOR_TICKET.DESCRIPTION} = "A/PN9705" then output should be "WB6105S(FCAW)/PN9705"
else if {LABOR_TICKET.DESCRIPTION} = "B/PN9405" then output should be "WB6316L(FCAW)/PN9405"
We use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.