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

Difference in suppress duplicates

serial

I have the following problem: 
 
I have my table with few columns/rows, and i have "suppress duplicates" enabled on a column (column1). 
Till here, everything is working fine, but i would like to hide the visibility of another column (column2) in relation with the column1. 
 
Here is a small pic: 
 
<img src='http://i51.tinypic.com/15f5awj.png' alt='Posted Image' class='bbc_img' /> 
 
Column1 has "suppress duplicates" and its working fine. I dont have duplicate values there. 
But now, i would like to hide that "remove" picture, which is a link which contains the value of the column1: 
"<a class='bbc_url' href='http://blabla/"+row'>http://blabla/"+row</a>["column1"] 
 
Is there anyway i could do that? Show the trash-picture only when the column1-value is displayed? 
 
 
My birt version: 3.7.1

Find more posts tagged with

Comments

mwilliams

You should be able to select the element in the column, go to the onCreate script and you could track the value of "column 1" and hide the image in script on your own when there are repeats. Let me know if you need a simple example.

serial

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="84105" data-time="1318537290" data-date="13 October 2011 - 01:21 PM">
You should be able to select the element in the column, go to the onCreate script and you could track the value of "column 1" and hide the image in script on your own when there are repeats. Let me know if you need a simple example. </blockquote>
 
Hey thx for the reply, but i tried for a while without finding a solution. 
So i really could use a simple example. 
 
thx. 
 
EDIT: Hey, i just found an answer of you in a different thread in this forum where you gave a solution for this problem. So problem fixed. thx again.

mwilliams

You're welcome. Sorry for the delay, I was off on friday. Glad you found another post that helped!

Let us know whenever you have questions!

kedd

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="84105" data-time="1318537290" data-date="13 October 2011 - 01:21 PM">
You should be able to select the element in the column, go to the onCreate script and you could track the value of "column 1" and hide the image in script on your own when there are repeats. Let me know if you need a simple example. </blockquote>
 
Hello sir, 
 
I would like to know how to do so.. I hope I can see an example of yours. Thanks in advance.

mwilliams

What is your BIRT version?

kedd

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="116246" data-time="1366847334" data-date="24 April 2013 - 04:48 PM">
What is your BIRT version? </blockquote>
 
Oh sorry. I am using 2.3.2

mwilliams

Take a look at this report. The suppress duplicates checkbox is checked for the customernumber column. For the image, look at the visibility script, in the property editor for the image.

kedd

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="116255" data-time="1366867706" data-date="24 April 2013 - 10:28 PM">
Take a look at this report. The suppress duplicates checkbox is checked for the customernumber column. For the image, look at the visibility script, in the property editor for the image. </blockquote>
 
 
This is what exactly what I am looking for... 
 
Thank you very much mwilliams for your help. May you please explain how did it happened? 
 
When I put it on my report, it didn't work. I was wondering if it is because of the "lastValue" thingy for I am not sure where it came from or what it is all about. 
 
Thanks. 
 
(Please see this post I have made similar to this problem: <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/29247-removing-duplicates-without-using-suppress-duplicates/page__p__116193&#entry116193'>link</a> )

kedd

hmmm I don't know what I am doing wrong.. why is it working fine in your file?

mwilliams

If you put the script I used as the visibility script in your image's visibility script and change the value set in the persistent global variable to the field you're using suppress duplicates on, it should work. In the example attached, the field I suppressed was an integer field, which is why I used the new Number() part. If your field is a string, remove this.

What the script does is it checks the current row's value against a persistent global variable named "lastValue". The first time this variable is accessed, it returns null because it's not set, so the values don't match. From here on out, the script sets the value when they don't match and hides the image if they do. Hopefully this makes sense. If you continue to have trouble, attach your example and I'll modify it for you.

kedd

WOW! this works like magic! Thank you very much mwilliams, I am really happy for this.. thanks for the explanations too

... Thank you, thank you, thank you

mwilliams

You're welcome! Let us know whenever you have questions!