Next Function

[angel106]

I'm trying to use the next function is CR9 to show the next step.

next({sequenceid})

I have a a group based on my sequence id then i have work orders in my detail section i created a formula (@next step) that has the equation next({sequenceid})in it. I place the (@nextstep) equation in my detail section when i run my report i get every sequence id returned which is to be expected since i never filter on anything however every the last work order in the sequence returns the next sequence id not it isn;t unique for every work order nubmer


how do i make an equation like this
next({sequenceid},{work order})

 

[Madawc]

I'm not sure what you're after. You could do a test like
{sequenceid} <> next({sequenceid})
and
{work order} <> next({work order})

You can also get the maximum for groups.

Madawc Williams (East Anglia, UK)