Interactive sort capability

[nicatt]

I have a business contact who posed the following question. Once the report has drilled down to the last section, which contains the detail, can the records be sorted by clicking the column title? I believe he would like a feature similar to a grid sort option available in Visual Basic, Excel, etc. where the records are sorted by the column you click. I noted that the records could be displayed in any desired order but I did not believe they could be re-sorted by multiple column options without regenerating the report. I suggested the data be exported to Excel and then it could be sorted six ways to Sunday. However I am intriqued by the possibilities. We have Crystal Reports 9 within the Crystal Enterprise environment.
Is this even possible?

Thanks in advance for any ideas.