Full post title: Selecting records in a sub-report based on the value of a record in the main report.

In my main report, I have the field {Job_Operation.Sequence}; the values in that field are a simple numerical sequence: 1, 2, 3, etc. I want to create a sub-report that returns only the record with the next step in the sequence. Something like this:

{Job_Operation.Sequence} [in the sub-report] = {Job_Operation.Sequence} [in the main report] + 1

The main report and the sub-report are linked.

Any suggestions?

Thanks!

Matteo