We're been using these feature in our internal reports for about a year now, and have found a number of interesting results.
- Set the sort order in the report, as this will put less load on the DB. Depending on the amount of data returned in the query, will govern which order is quicker for you. So test in your reports to find out. Must of our reports do not return too large a result, so we try and set the sort order in the report as part of our standards. (Most of the time
But give the user the ability to order by any column, and let them know which is the default sort column! Again, users have found this a great help on their reports.
Also be careful on report exports to excel, as excel will not keep the table header row visible when scrolling down even if this is enabled on the web page!
Hope these help.