Crystal Reports - Finding Previous Record Values

Hi,

I'm trying to find out the previous value of a record in Crystal 10.

I know I need to use the previous({recordset}) to get it, however if the previous value is = to "something" I need to keep looking at down the recordset until the value does not = "something"

I know it needs to be something along the lines of

If Previous({group}) like "MGS CCT*" then

Else Previous({group})

Just not sure what fits in the middle.

Can anyone advise ?

Many thanks
Steve[ moved ]