Dynamic Formatting

[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 perform sorting. 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. Has anyone been able to figure out how this can be done?

 

[morriskc]

Have you considered allowing the user to select the sort order & field as a prompt before they run the report?

 

[Naith]

I would agree with morriskc's approach.

The alternative would be to place on demand subreports behind the column names, which sorted by that column in the opposite way to the main report. However, you would not be able to toggle the sort once within any of the subreports.

Naith