Do you using Crystal Report Prof 10?
In order to sort by resolution date you can sort the record by sort the attribute creation date from im_incident_resolution
We aren't using Crystal for the reports. We might start, but right now I'm using the built in report designer.
Do you know how to do it inside that?
You can generate a report to sort by incident resolution dates.
You need to create a new report based on:
Module: Incident Management
Business Object: Resolution
This will create a report based on Incident Management \ Resolution table.
In the list you will see "Creation Date" and "Last Update," either of these dates will work when sorting, but is all depends on which one you want to sort by most likely "Creation Date."
You can get all your related Incident details from the "one to one" relationship of "Incident" which is contained on the Resolution Business Object.
You can build the report out with the data that is relevant for your report.