how to sort column?.

[shivac]

 Hi

     I have a one query

     How can I use the column sorting in jasperserver 3.1?  is it possible, if so how can achieve it. any help

 

Thanks in advacne 

Shivac

[anandharaj]

Do you mean sort the column after it has been generated? This is not supported in JS Community, perhaps Pro version have this

[shivac]

  Hi Anandharaj

                        Thanks for ur quick replay. Ya after generating the report, if i want to click the column header then the clicked column should be sort. 

 

Thanks in advance

Shivac

[anandharaj]

I think its not available in JS Community

[mdahlman]

Shivac,

 

anandharaj is right that this functionality is not built-in to JasperServer. You might be interested in the HTMLTemplate Exporter for JasperReports. It includes "sorting, hide/showing sections (also called folding), and displaying pop-ups" and it's for sale in the JasperShop.

 

Regards,
Matt

[leeyuiwah]

Hi,

 

Here is the url for the add-on product "Template Exporter"

 

http://www.jaspersoft.com/jaspersoft-template-exporter-jasperreports

 

I want to know how well the quality this product has. I noticed on the said page that this product is not supported by JasperSoft and is sold AS IS. That makes me nervous. I would appreciate if someone can reply and say they are using it and are happy about it despite the fact it is not supported.

 

Thanks!

[brooneyx1]

I am currently implementing this as follows:

1) Create a Parameter "SortBy" of type int and default it to the column 1. In my case this is a video name.

2) Add this parameter to your query: "Order by $P{SortBy}"

3) Create an input with name/value pair that corresponds to coulmun names: "Title/1", "Views/2", etc...

4) Create column header that are text and use hyperlink to create drill down report that just switches the $P{SoryBy} parameter.

So far this works for me, but I am using an input list till I can finish the drill down part.