All,
Perhaps this topic has already been covered in this forum, but I thought I'd throw the question out there. I'm creating a report with sortable columns that can be sorted by clicking on the column header. When I click the header, the sort works correctly, but it has to hit the database and run the report all over again.
Does anyone know of a way to sort just the data that is present on the report without having to query the database again? A 'dynamic' sort would be much more user friendly and would speed up the report.
Thank you!
Hi
I'm not sure if this will work or not but you could try using the local cache. You can find this in the properties for the query. In theory this will cache the resut set in memory so that when you resort the report it won't have to hit the database.
You will still need to run the report again but it should come back faster than hitting the database.
Have you checked the following
http://www-304.ibm.com/support/docview.wss?uid=swg21343332
It uses javascript to achieve the sorting.
The only negative is that it sorts only the data dispayed on the current page and not the data of the whole report