BIRT Sorting Feature

Hi,

I have generated a birt report properly. In the report I have 3 columns. One is displaying name, another amount and last is displaying a date. Now client wants a sorting facility by clicking on header column name i.e. user will be able to sort the report by clicking any one of the columns. I have not found anything like this in birt design module. How can I implement that? Please let me known how to do that? It's very urgent.

Regards,
Somnath

Find more posts tagged with

Comments

madhu_2009

Hey... 
The sorting feature is available in Actuate BIRT. There you have an option called "Enable Interactivity" which will give you options to sort,filter etc.. 
 
For futher refernce you can view this URL.. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/wiki/Interactive_Viewer/'>Interactive Viewer - BIRT Wiki - BIRT Exchange</a> 
 
Regards, 
Madhu

bhanley

The easiest way to do it is to use the Interactive Viewer. The functionality is there Out of the Box. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/products/interactive-viewer/'>Products and Services - Interactive Viewer - Overview - BIRT Exchange</a> 
 
Otherwise you can modify the beforeOpen event of the dataSet. That would involve the following steps: 
 
1) Add a hidden parameter to the report to hold the desired sort spec. 
2) Make each column header a hyperlink which re-executes the report design. Make sure and append your hidden parameter and value to the URL built fro each column header. 
3) Add a script to the beforeOpen evnet of the data set to check the global variable and modify the data set's sort at that point. 
 
Good Luck!