Not display repetitive data

Hi and thank you for reading,

I would like to realize the following functionality with BIRT. I have some customer data which is repetitive in my database and I would like to eliminate the repetitive lines.
To give an example, my current output looks like this:

Customer1_Name, Contact_Detail1
Customer1_Name, Contact_Detail2
Customer1_Name, Contact_Detail1
Customer1_Name, Contact_Detail3
Customer1_Name, Contact_Detail2
Customer1_Name, Contact_Detail1
Customer1_Name, Contact_Detail2
Customer1_Name, Contact_Detail3
Customer2_Name, Contact_Detail1
Customer2_Name, Contact_Detail2
Customer2_Name, Contact_Detail1
Customer2_Name, Contact_Detail3
Customer2_Name, Contact_Detail2
Customer2_Name, Contact_Detail1
Customer2_Name, Contact_Detail2
Customer2_Name, Contact_Detail3
...

Now I have a group on the customer name, so it looks like this:

Customer1_Name
Contact_Detail1
Contact_Detail2
Contact_Detail1
Contact_Detail3
Contact_Detail2
Contact_Detail1
Contact_Detail2
Contact_Detail3

Customer2_Name
Contact_Detail1
Contact_Detail2
Contact_Detail1
Contact_Detail3
Contact_Detail1
Contact_Detail2
Contact_Detail3

But as you see, there contact details are repetitive and I would like to reduce this to something like this:

Customer1_Name
Contact_Detail1
Contact_Detail2
Contact_Detail3

Customer2_Name
Contact_Detail1
Contact_Detail2
Contact_Detail3

I am aware of the possibility to do this on the database side, but would like to find a solution in Birt.

Thank you for any hints and advices (and all example reports are highly appreciated

Evgeny

Find more posts tagged with

Comments

mwilliams

Hi Evgeny,

Here are a couple possible solutions for you. You could sort the customer group by detail and use the "suppress duplicates" option.

-OR-

You could add another group to your table on the detail field and use the group header for that group to display the customerDetails.

Let me know if you have any questions.

evgeny

hi mwilliams.

thank you for your support.
The first option doesn't work for me. Yeah, and the second option is quite obvious, should have thought of it.

About the second option:
Is there a way to show two different groups in one line, so in my example like this:
Customer1_Name_Group, Contact_Group_Detail1
..................................Contact_Group_Detail2
..................................Contact_Group_Detail3

This would avoid a new line after the first group and improve the visibility of my report.

Thank you for your help

Evgeny

mwilliams

Evgeny,

You might be able to bring the data element from the "customer" group down into the detail group and try using the "suppress duplicates" option on that column. I haven't tried this though, so it may not work on group headers. Let me know.

Otherwise, you could do the same as above, only use a "visibility" expression to get rid of the repeated "customer" headers.

evgeny

hello mwillians,

thank you for your reply.

The "suppress duplicates" option doesn't seem to work in my report. I have set the option to "true" in the advanced menu, but it still brings duplicates in the detail row.

To precise my problem again. The customer row is not repeated, since I have put the customer into a group row, the same is true for my contact row, which is also a group in my report. However, to make it look better I would like to put the customer and the contact in the same row. Is it therefore possible to put two groups in one line?

Thank you for further advice

Evgeny

mwilliams

Evgeny,

What version of BIRT are you using again?

evgeny

Hi,

I'm using version="3.2.20".

Cheers

Evgeny

mwilliams

Evgeny,

In the attached report, you can see how I used the two group value in the inner group and used the visibility feature to hide the repeat values. Hope this helps. Let me know if you have questions.

evgeny

ok, thanks!

evgeny

hi mwilliams,

I still have a problem with this topic. now I have three groups: country, city, customer number.
I want country and city be displayed in the same line and the customer number should be grouped. I attached an example, I want that it shows france, and then just once the city of Paris and than the customernames under each other, but the first one in the same line as Paris. How can I do this?

Thank you for your support

Evgeny

mwilliams

Evgeny,

You'd just do the same for city as is done for country. See the attached report design.