Search results for query: *

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

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

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

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

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

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

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

Disregard my last I found a solution in the forums after a bit of digging. Thanks again lbass you helped me once again indirectly.

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

thank you very much for the quick response! I'll play with this.

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

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

thank you very much i will play with this

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

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

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

please excuse my bad form but im thinking something similar to this might work as a flag for filtering, as a select expert formula. {Job_Operation.Sequence} + 1 <> Next({Job_Operation.Status}) is "O" this way it will only pull records that have a status of either started "S" or complete "C"...

Thank you for the quick response chelseatech. I dont know if it makes a difference but in the output i have above i already have some select expert filters in place. all the numbers exsist in the sequence field however i am filtering for only "O" or open jobs so i can see if an opereation has...

this is what im seeing on my report Work_Center Sequence Status 15327 INSPECTIO 11 Active O BRAKES 10 Active O DEBURR 9 Active O...

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