Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Next Function

Status
Not open for further replies.

angel106

Technical User
Aug 1, 2005
39
US
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})
 
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.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top