Crystal Reports - Custom formula to find the next date

[BigdaddyPrecision]

Good morning,

So I am writing a report to display information from Jobboss for my team to know what order to do their work. I have two operations on a job in which the first one is programming and the second one is machining. Each of these process lines have a schedule date. What I am trying to code is that if the work center = programming then display the next work center start date. The reason I am doing that is so that the programmer understand when the part is supposed to start on the machine. This way they can have it done before it is due to start on a machine.

My experience and background with Crystal and code writing is limited so asking for some help.

I tried this and it doesn't work:
if {Job_Operation.WC_Vendor} = "progrm/fix"
then
next({Job_Operation.Sched_Start})

Thank you in advance for the help.

 

[kray4660]

In what way does it not work? First off, the report needs to be sorted so that the records are in chronological order. I am also assuming that there is a job id of some sort. So it also needs to be sorted/grouped by the job id.