Table rows overwritten by first row

Dear all,

I have created a BIRT report that uses a table to display data. The problem I have is that the first row from the dataset is overwriting the rest of the records. The report is getting the correct number of records from the database except its only displaying the first record as many times as the number of records pulled from the database.

Kindly assist.

Find more posts tagged with

Comments

thuston

I don't know how that could happen. Please post your design.

CyberDVD

<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="70259" data-time="1289570757" data-date="12 November 2010 - 07:05 AM">
I don't know how that could happen. Please post your design. </blockquote>
 
Thanks for your reply thuston, 
Please find attached the design. This is just one of the reports that have this problem. 
 
regards

mwilliams

If you preview the results in the dataSet editor, do you get the correct results? Or does this show the repeated first line as well?

CyberDVD

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70266" data-time="1289576382" data-date="12 November 2010 - 08:39 AM">
If you preview the results in the dataSet editor, do you get the correct results? Or does this show the repeated first line as well? </blockquote>
 
Hi mwilliams, 
 
The results are ok when i preview from the dataset editor. Its only the presentation in the report that is not correct. When i aggregate values of a certain column, the i am getting correct sum which is different from summing up the values the report is showing. 
 
Regards

mwilliams

Is this only in a certain output? Or in all outputs? If you create a simple report like this with the sample database, do you get the same issue? Or is this only with your dataSource?

CyberDVD

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70269" data-time="1289577291" data-date="12 November 2010 - 08:54 AM">
Is this only in a certain output? Or in all outputs? If you create a simple report like this with the sample database, do you get the same issue? Or is this only with your dataSource? </blockquote>
 
I am not sure if its the datasource that is faulty because when i preview the output of the dataset from the dataset editor the output is fine. I have actually tried to create simple reports like the one I attached earlier and am still having the same problem.

mwilliams

Did you try the sample database as suggested in my last post? Does it do the same? Let me know.

CyberDVD

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70273" data-time="1289578895" data-date="12 November 2010 - 09:21 AM">
Did you try the sample database as suggested in my last post? Does it do the same? Let me know. </blockquote>
Dear all, 
 
Thanks for the help with this issue. I later discovered the problem. I was binding the table data columns to the actual resultset in the table's binding instead of using the container's dataset. 
 
Thanks very much for the help.

mwilliams

Ah. Glad you found it! Let us know whenever you have questions!

sultanib

<blockquote class='ipsBlockquote' data-author="'CyberDVD'" data-cid="70515" data-time="1290153896" data-date="19 November 2010 - 01:04 AM">
Dear all, 
 
Thanks for the help with this issue. I later discovered the problem. I was binding the table data columns to the actual resultset in the table's binding instead of using the container's dataset. 
 
Thanks very much for the help. </blockquote>
 
I had the same problem today and fortunately found this tip here. Thank you very much for sharing.