Eclipse Community Forums: BIRT » Hiding duplicate records in a group

Home » Archived » BIRT » Hiding duplicate records in a group

Hiding duplicate records in a group [message #235383]

Wed, 18 April 2007 15:55

Eclipse User

Originally posted by: jmday.us.ibm.com

Is there anyway to hide records (via the API) that are duplicates? We have
a situation where when we group a set of data (usually with a calculated
column)

Project Name, Total Builds, %Passed, %Failed

Where we see a row for each build. We really only want to see one row per.

If we apply the columns to the grouping row (instead of the detail row) we
end up with the problem where if the user decides to add Build ID to the
list, they will only get the first row in each group.

(Our web app allows the user a "wizard" type interface to our data)

Jeannette

Re: Hiding duplicate records in a group-- ANYONE?? [message #235547 is a reply to message #235383]

Thu, 19 April 2007 11:14

Eclipse User

Originally posted by: jmday.us.ibm.com

{ Crickets }

Re: Hiding duplicate records in a group-- ANYONE?? [message #235578 is a reply to message #235547]

Thu, 19 April 2007 12:12

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Jeannette,

Maybe I do not understand, but why can't you use the suppress duplicate
on the columns?

Jason

Jeannette Day wrote:
> { Crickets }
>

Re: Hiding duplicate records in a group-- ANYONE?? [message #235733 is a reply to message #235578]

Thu, 19 April 2007 18:24

Eclipse User

Originally posted by: jmday.us.ibm.com

Jason,

Thanks for the reply. I'm not sure we knew about the suppress duplicate
method? is that on the column? or row?

Thanks!!
Jeannette

Re: Hiding duplicate records in a group-- ANYONE?? [message #235879 is a reply to message #235733]

Fri, 20 April 2007 11:12

Eclipse User

Originally posted by: jasonweathersby.alltel.net

It is on the column in the general tab.
If you do all columns it should hide the row.

Jason

Jeannette Day wrote:
> Jason,
>
> Thanks for the reply. I'm not sure we knew about the suppress duplicate
> method? is that on the column? or row?
>
> Thanks!!
> Jeannette
>

Re: Hiding duplicate records in a group-- ANYONE?? [message #235885 is a reply to message #235733]

Fri, 20 April 2007 11:12

Eclipse User

Originally posted by: jmday.us.ibm.com

Ok, so adding the suppressDuplicates method to the table detail row did
NOT work. Any ideas? What other info do you need from me?

Jeannette

Re: Hiding duplicate records in a group-- HELP! [message #235959 is a reply to message #235733]

Fri, 20 April 2007 13:24

Eclipse User

Originally posted by: jmday.us.ibm.com

Ok, not sure what happened to the last two messages (one each from Jason
and myself).

I set the suppressDuplicate property (via the api) on each column in the
table. Unfortunately, this still includes a row and the cells for each
"suppressed" duplicate. The HTML for these dups is just empty table cells.
How do I get rid of those? It's not acceptable to still see a row for
every duplicate row as sometime there are 100 or more of these empty rows.

Help!

Re: Hiding duplicate records in a group-- HELP! [message #235985 is a reply to message #235959]

Fri, 20 April 2007 14:45

Eclipse User

Originally posted by: jasonweathersby.alltel.net

I filed a bug on this yesterday. In BIRT 2.1.2 this functions correctly.
I filed the bug for 2.2 M6.

Jason

Jeannette Day wrote:
> Ok, not sure what happened to the last two messages (one each from Jason
> and myself).
>
> I set the suppressDuplicate property (via the api) on each column in the
> table. Unfortunately, this still includes a row and the cells for each
> "suppressed" duplicate. The HTML for these dups is just empty table
> cells. How do I get rid of those? It's not acceptable to still see a row
> for every duplicate row as sometime there are 100 or more of these empty
> rows.
>
> Help!
>

Re: Hiding duplicate records in a group-- HELP! [message #1268414 is a reply to message #235985]

Mon, 10 March 2014 09:23

Eclipse User

I ran into this problem in which I have a table with grouping. The suppress duplicate=true worked when all columns are set. My problem came in when I need to add a label "$" or currency symbol on the aggregated amount. In short, it does not recognize the grouping of the table. I tried formatting the aggregate amt but did not work so it was not an option, there was no "format number" in the property either. I even converted it to string so I can write it this way "$" + row[aggAmt].toString() but none worked. The only thing that I was able to get rid of the duplicate is adding an aggregated field with type string and function CONCATENATE WITH EXPRESSION "$". in that way I can apply the group by. I know this was a such an effort just to add a $ sign, but can someone suggest an easier way that I haven't tried?

Previous Topic:	Populating Arraylist from Dataset
Next Topic:	BIRT - Web App Help Needed

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 14 18:09:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter