Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    Did that LB. It still returns null records for sub ids greater than zero and the sort doesn't work.
  2. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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...
  3. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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.
  4. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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...
  5. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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...
  6. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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?
  7. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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...
  8. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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...
  9. cr7user

    Sorting Work To List by Start Date and Works Order Want Date

    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...
  10. cr7user

    Replace Character in a String

    Thanks Ian. That worked like a treat. + sign did the trick.
  11. cr7user

    Replace Character in a String

    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...
  12. cr7user

    Replace Character in a String

    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
  13. cr7user

    Replace Character in a String

    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...

Part and Inventory Search

Back
Top