Hi, I am pretty new to crystal report and I having difficulities getting started. Please see the table listed below.
I have a table contains all the historical data and I need to create a report which will show when the "type" column was modified each time between the most recent "date" and the previous date (4/05/07 and 4/13/07). For example, Type was changed from "NAN" to "NSN" between 4/05/07 and 4/13/07. I am thinking I can use subquery to produce this report but I am not sure how to start this. Does anybody know what are the best way to do this in crystal?? I am connecting to a oracle database and using crystal report version 10.

Any help will be greatly appreciated.

thanks

acct# inv# type date

ZX512 a255 CNN 11/16/2006
ZX512 a255 NSN 1/4/2007
ZX512 a255 NAN 4/5/2007
ZX512 a255 NSN 4/13/2007