Export to Excel displays only first and last rows

Hi

I have a report which comprises a list. The header part of the list contains a group (GH1). I have a grid with some values under this group header. Detail Part does not contain any grid/table.
If i view the report in viewer, all the data are displayed properly (the grid is supposed to display five rows). But when i click Export Data , the excel sheet displays only the First and Last row data of the grid.

My version of BIRT is 2.2. (Is this a bug in 2.2 version and will be resolved in 2.3 ?? )

Can anyone help me out of this?? This is an urgent issue to be fixed.

Thanks in Advance.

Find more posts tagged with

Comments

mwilliams

Hi IN_BIRTY,<br />
<br />
Can you recreate this issue with the sample database and post the design in here so I can run it and see the issue? I'll be able to run it in 2.2.2 and 2.3.x to see if I see your issue.<br />
<br />
Also, you can always search bugs at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a> to see if your issue has been reported.

IN_BIRTY

Hi

Thanks for the reply. Pls find the attachment of my rpt design file.

Thanks.

mwilliams

IN_BIRTY,

Can you make a report design that you get this problem with that is made from the sample database? This way I can run it. Thanks.

IN_BIRTY

Hi michael

The rpt file which i ve attached in my previous reply will do the needful. It replicates the issue.

Thanks.

mwilliams

IN_BIRTY,

I don't have access to your data, so the report has errors when I run it. See the attached screenshots for what I see when I run it and when I export to excel in 2.2.2.

IN_BIRTY

Hi michael

I ve attached the modified report which contains the query in the dataset. This query when executed in my database returns three rows which are displayed properly in report viewer page. But when i cllick export data, the excel which opens contains only first and last rows.

(i have issue with 'Export Data' and not 'Export report'.)

Thanks.

mwilliams

IN_BIRTY,

It won't let me access your data still. I updated my driver for sqlserver 2005, but now it tells me that login failed for user FREYA. You'll have to make a similar report with the Classic Models Sample Database for me to run it. It can be as simple of an example as it takes to recreate the issue for me to see and try on newer versions of BIRT. Thanks.

IN_BIRTY

Michael

Sorry for the late reply..

Regarding this issue we just want to provide some more information about how we use the database for storing the details of a claim. Our database mainly contains the CLAIM details of a patient.

1. Every claim has one or more claimlines. So we store the details, both in claim & claimline level in the DB.
2. We have 2 separate tables for claim & claimline in DB.

Various scenarios leading to the same issue:

1. If there are 5 claims with one claimline per claim in the DB & when we click the 'Export Data' button, only 2 or 3 claims are exported into the excel. The rest of the claims are getting missed in the exported excel. So ALL THE CLAIMS ARE NOT EXPORTED TO EXCEL

2.If a claim has 5 claimlines in the DB & when we click the 'Export Data' button, only 2(most of the time the first & last) claimlines of that claim is exported into the excel. The rest of the claimlines of the associated claim are getting missed in the exported excel. So ALL THE CLAIM LINES ARE NOT EXPORTED TO EXCEL.

3.If there is more than 1 value, say 3(a,b,c different values) for a Column(COL1) of a claimline table in the DB & when we click the 'Export Data' button, only 1 value of the Column(COL1), a (or) b (or) c are exported into the excel. The rest of the values of that Column(COL1) are getting missed in the exported excel. So all the values of that Column(COL1) associated for the claimline are not exported .

We hope the above mentioned all 3 scenarios are much similar & may be due to a common reason.
When we generate the report & verify through the birt report viewer we find all the claims, all the claimlines of a claim & all the values of a column of a claimline are fetched from DB properly without any issue. All 3 scenarios works fine if verified in the report viewer.

Moreover , the excel generated by clicking the 'Export Data' button have inconsistent data.( every time we generate, the 2 claims out of the 5 claims present in the excel are not the same).This data is inconsistent for all 3 scenarios.

In the previous discussion of this thread I was asked to attach the sample DB. But I cannot create the sample DB & hence could not attach it. From the explanation given above I hope u could understand the issue.

Also i guess you will be able to view my report layout from the attachment which i ve given in my previous post. That exactly shows my report structure..usually we dont use the "DETAIL" part of the list in the report. We display the values and do the computations only in the "GROUP HEADER" part of the list...

We are currently using BIRT 2.2 version. I want to know whether this is a known issue in this particular version of BIRT or could it be resolved in the higher version of the BIRT. If it is a known issue, could you pls give some post & threads supporting this as a known issue?? And if it could be resolved in higher version, which version of BIRT will help us from this issue?

This is a very critical issue & we are hardly in the quest of finding solution to this issue soon.

This would be of GREAT HELP if anyone could provide us a solution for this issue as soon as possible.

Thanks in advance.

mwilliams

IN_BIRTY,

Sorry, I may not have been clear on the sample database thing. I didn't ask you to attach a sample database, I asked for you to create a report with the Classic Models sample database that comes with BIRT that shows this issue when you run it so that I can see it. To create a report with the Classic Models database, all you need to do is create a new report, right click on Data Sources in the Data Explorer, choose "New Data Soure", and choose the classic models datasource option. Then you can run a query against that database, that I have access to.

IN_BIRTY

Hi michael

Thanks a lot for your patience... Finally i ve created my report with the classic model sample DB .. Please have a look at this... When generated using report viewer all the info are getting displayed properly (without anything being skipped).. If we export the same using 'EXPORT DATA' only the first and last row are getting exported...

This is usual report structure and we dont design the grid and table items in 'Detail' section... We use only 'Group Header' to manipulate and display the required data.

Is this a known issue for this kind of design?? or in this version of BIRT (2.2) ?

Hope this helps.. Expecting your help to resolve this..

Thanks.

mwilliams

IN_BIRTY,

If you click "export data", choose the "Element_xxxx" item from the result set dropdown, and then click ok, you should get all the data.

IN_BIRTY

Michael,

Our requirement is to export only few columns from the available list and not all the columns binded to the list. ie, We ve only few columns to be displayed under the particular resultset. If we use the element_xxxx to export the data, even the aggregated data items present in the inner list are getting listed under resultsets and will get exported. To restrict these values from being listed under the resultset in Export data, we cannot remove those bindings from this list, as they are being used in the body of the report for other purposes.
In order to remove this issue, we have created an outer list and binded it with values only we require to export. So, only the required columns will be listed under the resultset pertaining to this list. This list name has been modified to "SAVINGS" such that it makes sense and we have removed all the other result sets which starts with "Element_ " from the infrastructure itself, as part of our requirement. Tat means, while generating report from our application, the resultsets which starts with 'Element_' will not be present. Hence we can export only the first resultset which contains a proper name as "SAVINGS".
If we export that resultset, we are not able to get all the data present in the report. And we are in need of a solution for this kind of design.

Hope this is clear.

Thanks.