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!

Register Log in
  • Congratulations derfloh 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. tkaplanusmc

    my "OR" statement doesnt appear to be pulling records

    Hello CR 11 here, i'm trying to implement this formula but only the "and" statement appears to be working and i need to scan jobs in the database to find both "O" (open) or "S" (Started)operations. I'm embarrased that im getting hung up on something so miniscule but i need help. heres my formula...
  2. tkaplanusmc

    summarizing and filtering by Previous(field) statements

    using CR 11. I am trying to create a report that shows the correct order of jobs by sequence and current workcenter thats next up on the sequence list. I am using this formula to calculate the workcenter next up on the worklist: if Previous({Job_Operation.Status}) = "C" and...
  3. tkaplanusmc

    elimeting duplicate jobs

    my report is showing duplicate jobs due to the fact that some of the promised dates are different. All I want is the earliest date for a current job not the extras. I've tried to supress duplication but the feilds are still showing up. any suggestions on a select expert formula that may help me...
  4. tkaplanusmc

    selecting jobs that exceed a specific date

    I am trying to select jobs exceeding specific preassigned dates for a Lead Time report. in the examples below im trying to show jobs in the planning workcenter that exceed 27 days, and then for purchasing im trying to reflect 24 days late from promised date. thank you in advance for the help...
  5. tkaplanusmc

    linking my formula field to stored logic

    I have been struggling on this for quite sometime now. i'm worried i may lose my position if i can't crack this. I need to filter for duplicate "Skipped Operations" which i have reflected here in my formula field @Operation: Crystal XI if {Job_Operation.Sequence} + 1 <>...
  6. tkaplanusmc

    Selecting ONLY Duplicate records Based on formula field

    I have a formula field named @Next with the following formula: if {Job_Operation.Sequence} + 1 <> Next({Job_Operation.Sequence}) then "Skipped Operation" it shows up in my report like this: Page -1 of 1 Work_Cente equence Status Statu Next 11111 TIG WELD 0Active O...
  7. tkaplanusmc

    select expert formula assistance

    I am fairly new to developing crystal reports and I'm not very savvy when it comes to writing formulas for my reports. for my ODBC report I need to write a formula that filters for a skipped operation in a number sequence. I'm thinking i need some kind of for loop while incorporating some sort...

Part and Inventory Search

Back
Top