Help on creating a report

[analytics2006]

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

 

[synapsevampire]

Group by acct and inv in ascending, and then by the date by descending, suppresss the details section and place the type field in the date group header, and alongside place this formula:

next({table.date})
next({table.type})

You don't show what you want as output, do so in the future.

-k

 

[analytics2006]

I have tried and it kind worked but the output is like the following. I only want to do the comparison between the 4/13 (most recent) and 4/05 (2nd most recent) and hope to output like the "final output i have described below". Is this possible?? Can you please help me??

thanks so much.

************current output:
zx512
a255
4/10/2007
nan 4/5/2007

1/9/2007
nsn 1/4/2007

**************desired final output

zx512
a255
current type date prev_type prev_date
nsn 4/13/2007 nan 4/5/2007