Dynamic Sorting

[mmwalker]

We are creating reports in Crystal 9.0 using SQL stored procedures. We would like to allow the end user to click on column headers to sort records. For example if a report contained a column for Customers, the default sort order may be ascending. If the user clicked on the Customer heading it would sort descending and then if they clicked again it would revert back to ascending. We would like to be able to do this for multiple columns in the same report. If the report had columns for Sales, Orders and Total Dollars we would like to sort on any of the columns the end user clicks on. Does anyone know of a way to allow the user to click on a heading in the viewer after the report has been run to sort the records?

 

[synapsevampire]

Crystal doesn't do that.

Your users can export it to another format such as Excel or an Access table.

-k

 

[mmwalker]

We do not want to provide export functionality to the users. I was unable to find a function in Crystal that did the sorting like that, I was hoping to find someone who may have found a way to code around it.