federico.cattozzi Posted March 18, 2010 Share Posted March 18, 2010 I use a combo box Input Control to permit to choice a sort option on my JasperServer and I use code like this in the report query:SELECT name, surnameFROM userORDER BY $P!{ORDER_BY} $P!{ASC_DESC}So, Oracle Database has internal optimizations if you enter the same query several times.If I want to change after the first run only the order of the rows, query is submitted equal to before aside for ORDER BY clause.There is a <sortField> tag which permits to change the order after query submit, but this tag can contain only static field name.Is is possible to have a <sortParameter> or something else in the next releases of JasperReports? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now