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.