Home
Analytics
Sort Table
DrCarter
Hi,
I have a table with some columns. What I want is to sort this table, by clicking on the header. So the table should be sorted by this attribute.
How I can do that in BIRT?
I am using BIRT 2.6.1
Thank you for your help
Find more posts tagged with
Comments
mwilliams
You can set up a drill through to pass the column name through and sort based on this parameter. The "key" for the sort has an expression builder so that you can set this up.
Let me know if you have questions.
DrCarter
Hi, thank you for your answer.
I tried this with a drill-through, but I am nut sure weather i made it correct.
So all I need to do, is to create a drill-through link on the header of the table, link the parameters and build an expression.
But how I can build this expression?
mwilliams
Take a look at this example. Look at the sort expression for the table and at the hyperlinks for each label.
DrCarter
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76885" data-time="1305130073" data-date="11 May 2011 - 09:07 AM"><p>
Take a look at this example. Look at the sort expression for the table and at the hyperlinks for each label.<br /></p></blockquote>
<br />
thank you for the file.<br />
<br />
It looks good. <br />
Is there a way to sort the table by not re-loading the report?<br />
well my reports are big and take a few seconds until they are loading. so when i have to re-load them always I loose a lot of time... :wacko:
mwilliams
You would have to create this functionality yourself in your viewer. Reloading is the way of the open source "re-sort" unless you build the functionality. Actuate has a commercial offering that allows for filtering and sorting after the report has already ran without re-running the report. It's called the Interactive Viewer. You can see the product page at the link below:
http://www.birt-exchange.com/be/products/birt-user-experience/interactive-viewer/features/
You can download a trial version here as well and see if it's something you're interested in.
DrCarter
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76935" data-time="1305211113" data-date="12 May 2011 - 07:38 AM"><p>
You would have to create this functionality yourself in your viewer. Reloading is the way of the open source "re-sort" unless you build the functionality. Actuate has a commercial offering that allows for filtering and sorting after the report has already ran without re-running the report. It's called the Interactive Viewer. You can see the product page at the link below:<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.com/be/products/birt-user-experience/interactive-viewer/features/'>http://www.birt-exchange.com/be/products/birt-user-experience/interactive-viewer/features/</a><br
/>
<br />
You can download a trial version here as well and see if it's something you're interested in.<br /></p></blockquote>
<br />
ok thank you for the link...<br />
<br />
so there is no way for sorting the table without re-load the whole report with the free version of the viewer?
mwilliams
Not out of the box, no, unfortunately not.
