nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change column order with a parameter

julienemixis

Hello everybody,
 
I would like to change dynamically columns order in my birt report with a parameter.
For example, i will receive a parameter with : "vehicle, reference, platenumber" and columns will be displayed in this order.
Is it possible to change dynamically column order?
What is the best way to do this?
 
Thank you in advance,
 
Julien

Find more posts tagged with

Comments

pricher

HI,
 
Assuming your parameter is named pSort, select the table component, go to the Sorting tab and enter the Expression row[params["pSort"].value].

Matthew L.

This can be a bit tricky, however modifying a previous example that creates <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/?p=132987'>dynamic tables</a> we can arrange the order of the columns based on their input order in a comma separated parameter input.
 
Please look over this modified design and let me know if you have any questions about it.

pricher

ooops, I realize that I totally misread the question.... Matthew's post is the one to keep!!!
 
Sorry for that,
 
P.

julienemixis

Thanks for your answers, i will try it.

julienemixis

Hello Matthew,
 
I tried your code and it works fine but the problem is that I have to make a lot a things in my reports (dynamic group and order, hidding columns with the same order column param, hidding row in xsl output, custom background...) and i have more or less 20 reports to write, with dead line it's not possible to write all of them dynamically..
 
Is there an other way to change order after report generation?
 
Thanks for your Help.
 
Julien

Matthew L.

If you are using the Professional version of BIRT, it includes an Interactive Viewer (IV) which you could hook and arrange the columns after generation. 
However this technique would only work for the IV web viewer and the column order would not be effected for outputs such as PDF, DOC, XLS, etc...
 
Also note that if you are dynamically changing lots of properties (groupings, column order, hidden rows, background colors, etc) some of these options are only changeable during the table's build state (beforeFactory).
 
It really depends on the requirements of the final output.

PaulCooper

Matthew,
 
You could split the comma separate list of fields into an array
 
(Report Initialize event)
<pre class="_prettyXprint">
columnArray = params["columnSortOrder"].split(","); </pre>
and then use in the data fields in tables row[columnArray[0]], row[columnArray[1]], etc.
 
You would need some sort of lookup for column headers too such as:
 
(Report Initialize event)
<pre class="_prettyXprint">
columns = ["vehicle", "reference", "platenumber"];
titles = ["Vehicle", "Reference", "Plate Number"]

function columnTitleLookup(column)
{
 try
 {
 return titles[columns.indexOf(column)];
 }
 catch (e)
 {
 return "";
 }

}</pre>
and then use in the column header data field columnTitleLookup(columnArray[0]), columnTitleLookup(columnArray[1]), etc.
 
Paul