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; } } }

To hide column in a table based on the name of the column

Happy_20

Hey

Please see the attached Report.
I am using BIRT 2.6 version.
In that the first table has column name as "unused". This text comes from external property file.
I want to hide the column if the column name is "unused". I tried to work with event handler, but there is no Event adapter for column. In case of visibility expression, i can have access to data and row but not to label.

Can you please guide me how to do it.

Thanks in advance.

Find more posts tagged with

Comments

Happy_20

<blockquote class='ipsBlockquote' data-author="'Happy_20'" data-cid="81491" data-time="1313090007" data-date="11 August 2011 - 12:13 PM">
Hey 
 
Please see the attached Report. 
I am using BIRT 2.6 version. 
In that the first table has column name as "unused". This text comes from external property file. 
I want to hide the column if the column name is "unused". I tried to work with event handler, but there is no Event adapter for column. In case of visibility expression, i can have access to data and row but not to label. 
 
Can you please guide me how to do it. 
 
Also it would be great if there is column event adapter enhancement in BIRT. 
 
Thanks in advance. </blockquote>

mcremer

Hi Happy_20, 
 
First of please don't quote your self to keep a topic in the top. Its not really nice <a class='bbc_url' href='http://www.albion.com/netiquette/'>NET etiquette</a>. 
 
But back to your question. 
 
What I understand is that you want to set visabilety rules based on a COLUMN value (correct right?). 
 
But bc Im not sure could you be a bit more detailed (because just a pdf doesn't tell me a lot just the layout).

Happy_20

<blockquote class='ipsBlockquote' data-author="'mcremer'" data-cid="81538" data-time="1313409124" data-date="15 August 2011 - 04:52 AM">
Hi Happy_20, 
 
First of please don't quote your self to keep a topic in the top. Its not really nice <a class='bbc_url' href='http://www.albion.com/netiquette/'>NET etiquette</a>. 
 
But back to your question. 
 
What I understand is that you want to set visabilety rules based on a COLUMN value (correct right?). 
 
But bc Im not sure could you be a bit more detailed (because just a pdf doesn't tell me a lot just the layout). </blockquote>
 
Hey mcremer, 
 
Thanks for taking time to read my post. Just to clarify, I didn't quote purposely. If you see, I added extra line in my second post "Also it would be great if there is column event adapter enhancement in BIRT.". I was trying to edit the 1st post and add this line but unfortunately it came up as second post. 
 
Coming to my question, based on the name of the column I want to hide/unhide column in the table. 
 
Thanks

mcremer

<blockquote class='ipsBlockquote' data-author="'Happy_20'" data-cid="81550" data-time="1313420343" data-date="15 August 2011 - 07:59 AM">
Hey mcremer, 
 
Thanks for taking time to read my post. Just to clarify, I didn't quote purposely. If you see, I added extra line in my second post "Also it would be great if there is column event adapter enhancement in BIRT.". I was trying to edit the 1st post and add this line but unfortunately it came up as second post. 
 
Coming to my question, based on the name of the column I want to hide/unhide column in the table. 
 
Thanks </blockquote>
 
Hi Happy_20, 
 
I take it is per table (thats why how this script is going to work). 
 
On the create part of the column that will contain some script. I did this before ill post it later today. (Sorta bussy atm).

Happy_20

mcremer

<blockquote class='ipsBlockquote' data-author="'mcremer'" data-cid="81573" data-time="1313486917" data-date="16 August 2011 - 02:28 AM">
Hi Happy_20, 
 
I take it is per table (thats why how this script is going to work). 
 
On the create part of the column that will contain some script. I did this before ill post it later today. (Sorta bussy atm). </blockquote>
 
As promised here are the scripts: 
 
on the create of a data object you want to set the visabilety on you write: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
var rowLast = BirtStr.trim(''+reportContext.getGlobalVariable("PRODUCT_rlp"));
var rowLastp = this.getRowData().getColumnValue("PRODUCT");

reportContext.setGlobalVariable("PRODUCT_rl", rowLast);
reportContext.setGlobalVariable("PRODUCT_rlp", rowLastp);
</pre>
 
Then on the Visebilety of the whole column you set the folowing code: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if( row["PRODUCT"] == reportContext.getGlobalVariable("PRODUCT_rlp") ){
true;
}else{
false;
}
</pre>
 
Hope this helps.