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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tkaplanusmc

  1. tkaplanusmc

    my "OR" statement doesnt appear to be pulling records

    i nailed it with a nested formula thanks any way for the help guys! if ({Job_Operation.Status} = "S" or {Job_Operation.Status} = "O") then if ( Previous({Job_Operation.Status}) = "C" and {Job_Operation.Sequence} -1 = previous({Job_Operation.Sequence})) then 1
  2. tkaplanusmc

    my "OR" statement doesnt appear to be pulling records

    still no dice its only spotting jobs that are status "O" not "S". i tried your formula above as well as this slightly modified one and neither one worked. if ( Previous({Job_Operation.Status}) = "C" and {Job_Operation.Status} = "O" ) or ( Previous({Job_Operation.Status}) = "C" and...
  3. 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...
  4. tkaplanusmc

    summarizing and filtering by Previous(field) statements

    the formulas only seem to work when the report is layed out like this: Work_Center sequence Status sequence late 11111 (sum) 0 (sum)2.00 TIG WELD 0 O 0.00...
  5. tkaplanusmc

    summarizing and filtering by Previous(field) statements

    i need it to look something like this, but with the sequence order i described above. select expert formulas currently being used include. record selection: if {Job.Open_Operations} <> 0 and {Job_Operation.Work_Center} <> "" and {Job_Operation.Status} = "O" and {Job.Status} = "Active" then...
  6. tkaplanusmc

    summarizing and filtering by Previous(field) statements

    Thanks lbass these formulas indeed work but i'm still racking my brain here on how im supposed to get this to work. i have two big problems. problem one is that in order to get these formulas to work i need to get everything in sequential order grouped by job number, whereas what i need is for...
  7. 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...
  8. tkaplanusmc

    elimeting duplicate jobs

    Disregard my last I found a solution in the forums after a bit of digging. Thanks again lbass you helped me once again indirectly.
  9. 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...
  10. tkaplanusmc

    selecting jobs that exceed a specific date

    thank you very much for the quick response! I'll play with this.
  11. 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...
  12. tkaplanusmc

    linking my formula field to stored logic

    It Works!! thank you so much. your a life saver!
  13. tkaplanusmc

    linking my formula field to stored logic

    thank you very much i will play with this
  14. 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 <>...
  15. tkaplanusmc

    Selecting ONLY Duplicate records Based on formula field

    Hi Cindy thank you for the fast response. I am accessing the database via ODBC. I did see a table in the database entitled "Reports" that looks like it may have held some data linking exsisting reports to the database somehow but I don't know for certain. I'm not very skilled in the database...
See more

Part and Inventory Search

Back
Top