Export Data - Excel

Im using more than one dataset for a table content in my report. When i click on export data, many items are listed under Available resultset drop down.
For example, i've a table of four rows and four columns. I'm using 4 queries(dataset) to generate the table content . In the export data option, i see 16 items in the available resultset.

Im not able to export the complete table content to the excel.
Is there any solution to this? (I want to use only export data option)

Find more posts tagged with

Comments

scaracas

This question sounds like "Can i do Excel like multiple sheets with CSV , WITHOUT Excel "?

The answer is yes but...some effort needed. :-)

What you can do rapidly is a joint dataset containing data from your 5 datasets for example. Or modify your SQL to adapt data.

Or you can code your own button performing exactly your need , except you need to know some BIRT API and Java.

Finally , as BIRT code is open , you can reuse the CSV emitter to customise it to your needs.

Sheela

Thank you so much scaracas!

I joined them into a single query.

I have one more problem with data export. In the report, the decimal values are rounded to two decimal places. But when the data is exported to CSV, the number is not formatted to two decimal places.
Is there a way to solve this?

Virgil Dodson

Could you try doing the rounding in the data set by creating a new computed column that is rounded? Otherwise, the rounding on the table is just for display formatting.