Dynamic Sorting in BIRT

birtuser89

Hey can someone plz tell me how i could do dynamic sorting on a column of a table. The report is to be deployed on the web. The drill through technique also does not work well on the web as it generated a URL which relative to the birt viewer. Best possible solution I would like to have which will not require to go to the database again on click to sort.

Thank you in advance

CBR

Hi,

you mean client side sorting? This would be very hard to implement because you do not have much control over the generated HTML. All client side sorting is done with javascript and needs to attach some click listener to an html element (eg the table header). In addition it needs to reconstruct the table to sort it, which would be the hardest part because you could have conditional formatting and things like that (in addition the html of the whole report is auto generated and therefore might not be that easy to change).
The best option (that needs less work) would be to use the hyperlink thing that regenerates the whole report with some different sorting condition.