Dynamic Data Sorting

Hello All,
I want to make my table header click-able in such a way that the data in the table gets sorted (ascending) by the column name that has been clicked.

For example, refer to the attached snapshot of a part of my table.
If I click on the Run ID column header, I want all the data in the table to get sorted in ascending order of Run ID. If I click the Log Date column header, I want all the data in the table to get sorted in ascending order of Log Date. And so on.

Is this possible by any chance?
I don't want to send another request every time the table header is clicked i.e. once the data set has fetched all data, I want to sort it as described earlier without requesting the server for the data again.

Thanks a lot in advance.

Find more posts tagged with

Comments

mwilliams

Hi ZEIGER, 
 
You can do user sortable columns with a BIRT drill through. This, however, runs the report again each time, which is not what you want. If you have the know-how, you could build your own viewer that has this functionality built in. There is also a product available through Actuate that does do this. It's called "Interactive Viewer". Here is a link you can check out to see more information on it. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/products/interactive-viewer/'>Products and Services - Interactive Viewer - Overview - BIRT Exchange</a> 
 
Hope this helps.

ZEIGER

Hey thank you so much for the reply!
Well actually, I cannot use any other tool as such because we have already integrated BIRT into our enterprise application.

Is there no other way to do this?

mwilliams

ZEIGER,

Besides modifying the viewer that you're currently using to include this functionality or using the drill-through, which reruns the report like you don't want, I don't believe there is another way. I could be wrong, but as far as I know there isn't.