select expert formula assistance

[tkaplanusmc]

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 of "count" to help me pin point when a number is skipped. the table and field I need to filter from and display from is Job_Operation.Sequence

Any help would be greatly appreciated. I dont have a human soal to turn to for assistance with Crystal reports 11

 

[tkaplanusmc]

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


DEBURR 7 Active O


STAGE 21 Active O


INSPECTIO 20 Active O


ASSEMBLY 19 Active O


HARDWARE 18 Active O


HARDWARE 17 Active O


INSPECTIO 14 Active O

 

[chelseatech]

You first need to sort the data by that numeric field and then use a formula of
if {table.sequence} + 1 <> Next({Table.Sequence})
then "Missing record"


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[tkaplanusmc]

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 been skipped based on the number sequence being out of sync. I did try entering this into the select expert formula field

if {Job_Operation.Sequence} + 1 <> Next({Job_Operation.Sequence}) then "Missing record"

and it gave me an error message "this formula cannot be used because it must be evaluated later

 

[tkaplanusmc]

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" following "O" Open, as the sequence counts along. the only issue with this though is that its gonna pull the next operation that was started and the end user needs to see which operation was skipped (i.e- the "O" before the "S" or "C")

any help with my formula notation or suggestions would be greatly appreciated. thank you in advance