Removing Duplicate Table display in BIRT

Hi Guys, 
 
can anyone help me in this regard. 
 
I am getting a Table duplicated based on the rows present in another table (which is located in 2nd row of the same table.) 
 
For Example: 
I have Table and Sub-table in the 2nd row of the same table: 
 
Courses 
Course ID Course NAME 
A123 ABC 
 
Seats 
Seat ID Seat Name 
1 A 
2 B 
 
According to this, Courses is a table which has two rows: 
1st Row with Course ID/Course Name details 
2nd Row has another table Seat with Seat ID/Seat Name. 
 
Now the problem is, the complete Course table duplicates as many times as the number of rows present in the Seats table. 
I mean, if Seats table has 1 row then the Courses table is displayed only Once. 
if Seats table has 2 rows then the Courses table is displayed twice. (which means the Courses table repeats with same data twice). 
if Seats table has 3 rows then the Courses table is displayed thrice. (which means the Courses table repeats with same data thrice). 
 
But i want the Course table should be displayed Only once irrespective of the number of rows present in Seats table (which is another table in the 2nd row of Courses table). 
 
I referred <a class='bbc_url' href='http://birtworld.blogspot.com/2010/10/birt-duplicate-rows.html'>BIRT</a> and tried implementing but NO SUCCESS. 
 
I verified with the dataset query. There is NO duplicate records fetched in the query. But in the Hiding Duplicate Row BIRT, the table Courses is duplicated. 
 
Can any one help me, how to hide the Courses Table if it is duplicated. 
 
Thanks, 
Anand.

Find more posts tagged with

Comments

mwilliams

Take a look at this blog post:

http://www.birt-exchange.org/org/forum/index.php/blog/14/entry-241-last-week-in-the-forums-data-repeats-when-you-use-grouping-truncated-rows-in-pdf-and--more/

The first post covered in it is similar to yours. When you group, if you put your embedded table in the detail row, it will repeat for the number of rows in the outer group. You should move the embedded table to the group footer.

AnandK

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76148" data-time="1303392330" data-date="21 April 2011 - 06:25 AM">
Take a look at this blog post: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/blog/14/entry-241-last-week-in-the-forums-data-repeats-when-you-use-grouping-truncated-rows-in-pdf-and--more/'>http://www.birt-exchange.org/org/forum/index.php/blog/14/entry-241-last-week-in-the-forums-data-repeats-when-you-use-grouping-truncated-rows-in-pdf-and--more/</a> 
 
The first post covered in it is similar to yours. When you group, if you put your embedded table in the detail row, it will repeat for the number of rows in the outer group. You should move the embedded table to the group footer. </blockquote>
 
 
 
 
Thanks Williams for your immediate reply. 
Ya, of-course the embedded table which is inside outer table's row will be repeated, that doesn't matter for me. 
But, in my case, the outer table is repeating based on the number of rows present in the embedded table. 
I don't want outer table to be repeated based on the rows of embedded table. 
I want outer table MUST be displayed only once irrespective of the number of rows present in the embedded table.

mwilliams

The only way the outer table would "repeat" would be if it had multiple lines with the same values. If this is the case, you need to group the outer table on this repeated value and not use the detail row.

Hans_vd

Hi Anand,

Are you joining the courses data and the seats data together somewhere? In a joined dataset or in an SQL query?
It seems like a cartesion product is executed.

Regards
Hans

keerthink

Hello,
 
I am facing a similar issue.. I have a chart embedded inside a table and I am using the same data set for the outer table as well as the chart. I need the chart to iterate as many times as there is data in my XML datasource(which is working just fine now), but the table should only display once. For e.g the name of the customer, date etc should show once only.
 
How do I stop the table from repeating values?
I tried using a grid instead of a table, but when i attempt to merge cells in a grid, I get an Error and then the program hangs on me. 
 
I am using Birt Report Designer 4.2.2.
 
Thank you

JFreeman

I'm not sure I am fully understanding what you are wanting.
Can you provide additional details?
 
If possible, could you also provide a sample report that demonstrates your issue?

keerthink

Thanks for your reply.
 
I tried something, I am not sure if it is the right way.
 
Using a grid seemed to be the right solution for this, as the Grid is not dynamic like a Table and wont iterate over every row...but my issue was when using a grid, i couldn't merge cells, it was throwing an error and everything would freeze. Do you know if this is a bug?
 
So i used separate grid for the rows that i wanted single column and multiple columns. 
 
This seems to work. Although not the best way I would have preferred.
 
Thanks

JFreeman

I know there was a bug in 4.4.1 that was a regression against 4.4.0 that got resolved in 4.4.2 that was about issue merging cells in a grid.
 
This may have existed in 4.2.2 but I've not seen anything about it in that particular version.