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

cellInst.getStyle().setDisplay("none") does not work in IE

akrueger

I have a crosstab and am trying to hide some cells (or basically a whole row) based on some data that I get in the cube. 
 
I followed Jason Weathersby's Blog at <a class='bbc_url' href='http://birtworld.blogspot.com/2010/02/birt-crosstab-scripting.html'>http://birtworld.blogspot.com/2010/02/birt-crosstab-scripting.html</a> and all of it works fine, except in IE. Unfortunately I am forced to use it

Below is my script in the onCreateCell function: 
<pre class='_prettyXprint _lang-auto _linenums:0'>function onCreateCell( cellInst, reportContext )
{
if (reportContext.evaluate("dimension['Categories']['CATEGORY_ID']") == 0) {
cellInst.getStyle().setDisplay("none");
}
}</pre>
 
This works in the embedded web viewer in eclipse and in chrome when deployed on an application server. Just not in IE. 
 
In my original code I had added some logging to see if it would actually go into the if statement and it does. Just the setDisplay does not seem to work. 
 
I also tried setting to "DISPLAY_NONE" because I saw that in another post, but it didn't work either. 
 
Environment: 
BIRT 4.2.1 
Eclipse Juno 
Chrome 24 
IE 8.0.7601 
 
Does anybody have any ideas? 
 
Thanks so much 
- Anita

Find more posts tagged with

Comments

CBR

Not really sure why it doesn'T work in IE but the Display property is evaluated by the browser, so the element is in the HTML and it is the browser hiding it. So it totally depends on how the browser interprets the Display none
I would recommend to use a filter on the crosstab. The filter prevents that the row is generated.

akrueger

<blockquote class='ipsBlockquote' data-author="'cbrell'" data-cid="114578" data-time="1361961724" data-date="27 February 2013 - 03:42 AM">
Not really sure why it doesn'T work in IE but the Display property is evaluated by the browser, so the element is in the HTML and it is the browser hiding it. So it totally depends on how the browser interprets the Display none 
I would recommend to use a filter on the crosstab. The filter prevents that the row is generated. </blockquote>
 
Yes, I was trying to use a filter, but the problem is, it filters one the data cube and not only on what is displayed in the crosstab. I have another measure in the header of the crosstab that needs the filtered data, so if I use a filter, those numbers become 0.

CBR

The filter is on the crosstab only, so your totals can also include the filtered rows (if your issue is related to totals)

Are you able to provide a sample of what you want to achieve? I m sure i could create a sample for you then.

akrueger

<blockquote class='ipsBlockquote' data-author="'cbrell'" data-cid="114599" data-time="1361978964" data-date="27 February 2013 - 08:29 AM">
The filter is on the crosstab only, so your totals can also include the filtered rows (if your issue is related to totals) 
 
Are you able to provide a sample of what you want to achieve? I m sure i could create a sample for you then. </blockquote>
 
I feel so stupid, because I tried the filter before. Of course when unchecking "recalculate totals", my numbers re-appear. Thing is, I have 3 measures in the datacube and the 3rd one is not part of the crosstab. I use it in the header to show something else. 
 
Thanks so much cbrell.

CBR

Hi Anita,

no problem.
I m not quite sure if your problem is solved now or if you have issues with the 3rd measure now.
Just let me know if there is anything left.

akrueger

<blockquote class='ipsBlockquote' data-author="'cbrell'" data-cid="114616" data-time="1361985518" data-date="27 February 2013 - 10:18 AM">
Hi Anita, 
 
no problem. 
I m not quite sure if your problem is solved now or if you have issues with the 3rd measure now. 
Just let me know if there is anything left. </blockquote>
 
Sorry, should have been more clear. Yes, the problem is solved. 
I am still wondering why setting those cell's display to none didn't work in IE though... 
 
Thanks 
- Anita