Get information from the previous record

[SuperTime]

Crystal 9, Sql database

I have a report that lists the Jobs Performed.


Job 1 TeamA

Job 2 TeamB

Job 3 TeamC

On each Job except for the first one I want to show the Team on the prevoius Job

Eg.

Job 2 TeamB Prev: TeamA
Job 3 TeamC Prev: TeamB

How can I achive this..?

Right Now the report uses the stored Proc. that lists all The jobs and the current Team on the Job

 

[Turkbear]

Hi,
Crystal has a Previous function that will do that for you..
( assuming 'order by Job')

Previous({Team})





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SuperTime]

Waow!!! I never nee about this function...Its cool..


Thanks ***

 

[Turkbear]

Hi,
Even cooler is the Next({Field}) function, it can see into the future!


Enjoy..





To Paraphrase:"The Help you get is proportional to the Help you give.."