Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Parameter Sorting
rmendonsa
I have to create a report which will have a Maximo request page with a lookup of the report column names. When a user selects a column name from the lookup the report should generate, sorted by that column....is there anyway I can do that type of parameter sorting in BIRT 2.3.2? If so, please provide some direction and examples. Thanks.
Find more posts tagged with
Comments
rootseur
You can have Birt do the sorting. See <a class='bbc_url' href='
http://wiki.eclipse.org/Example_-_Sort_Table_based_on_parameter_(BIRT)'>wiki.eclipse</a>.<br
/>
Or you can build dynamic sorting in your SQL statement as so:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT * FROM MyTable
ORDER BY
CASE WHEN ? = 1 THEN EmployeeID END,
CASE WHEN ? = 2 THEN LastName END
</pre>
<br />
and link to a report parameter.<br />
<br />
Good luck<br />
Steven Van de Weyer
rmendonsa
I will definitely give that a try. Thank you very much.
