CiviCRM Community Forums (archive)

In a custom CiviReport, is it possible to allow the user to sort the report by clicking the column heading? Just like the current behavior in searches?

On a related note, why are all the column headings click-able in the built-in reports even though nothing happens when they are clicked? This behavior is confusing to new users, who when their cursor changes when they mouse over the column headings think that they should be able to click to sort.

In the report criteria section, "Donor Report (Detail)" for example, you should see a "Order by Columns" section, which allows user sort by one/multiple columns, provided report code has 'order_bys' specified.

Making report sort by clicking column heading doesn't work currently, and doesn't have any code written to address it. Agree that the behaviour should be fixed to remove the confusion.

Given that order_bys does work now if we could just pickup order-bys from url, it won't be too hard to make column header click to make report sortable. Of course this won't be ajax behaviour to begin with.

Using datatables / jquery would require more effort to make report sortable under the grid making sure that whole report result is sorted and not just the current-view.

Patches for any of above is most welcome.