New to this forum.  I'm usally pretty good with crystal, but this one has me stumped. 

 

I need to write a report from a database that tracks movement of a person from one place (in a prison) to another.  Prisoners move all the time, so there are a lot of records.  The subpoena asks for prisoners that were moved from "cell block A", to "cell block C" in a given date range.   But, they only want to show those who went direct from one to the other, not those that stopped at intermediate places between the two. 

 

For Example:

 

Inmate #1

     CELL BLOCK C   12-01-2005

     CELL BLOCK B   11-01-2005

     CELL BLOCK A   10-01-2005

 

Inmate #2

     CELL BLOCK C  12-01-2005

     CELL BLOCK A   11-01-2005

     CELL BLOCK B   10-01-2005

 

So, in this case I would only want to show Inmate #2, since he went direct from A to C, not stopping anywhere else in between. 

 

Does anyone have an idea on how to pull something like this off?   

 

 

Thaks in Advance!