I am trying to report on departments using the description of the department rather than the department code. For example, using this table:

Code - job# - Department - Date
1 - 1000 - Prepress - 7/1/04
2 - 1000 - Proof - 7/2/04
3 - 1001 - Prepress - 7/2/04
4 - 1001 - Proof - 7/3/04
5 - 1001 - Press - 7/3/04
6 - 1000 - Prepress 7/3/04
7 - 1000 - Proof - 7/3/04
8 - 1000 - Press - 7/4/04
9 - 1000 - Shipped - 7/5/04

I want a summary line showing the current department and the maximum date in each department.

Job# - Current Dept - Prepress - Proof - Press - Shipped
1000 - Shipped - 7/3/04 - 7/3/04 - 7/4/04 - 7/5/04
1001 - Press - 7/2/04 - 7/3/04 - 7/3/04

This was easily accomplished by sorting by job number then the code (descending) and suppressing all but the first line. But then I need a report that groups by departments. How can I make a summary field of the Current Department names?

I was able to achieve this by summarizing the Current Department in the stored procedure that queries the SQL data, but that procedure takes much too long to execute. I would like to summarize the data in Crystal Reports.

Any Suggestions?

landon