Export To Excel

Hi,

I am using BIRT API to generate reports and Export in (PDF,EXCEL,HTML). My clients requirement is when the report is exported to Excel, it is able to apply filters and also be able to use the options provided my Microsoft EXCEL.

Currently what happens is when applying filter it doesn't apply filters to the coulmns mentioned, instead it apply filters to the heading or the blank space.

Is there some way i can control the Filter Options or are there any plugins other than "org.uguess.birt.report.engine.emitter.xls_2.3.1.200902021103.jar" and "org.uguess.birt.report.engine.common_1.0.3.200902021102.jar".

I have placed both this plugins but it couldn't perform the task above mentioned. I want to apply filters to the columns of the reports.

Thanks In Advance.

Find more posts tagged with

Comments

mwilliams

So, when you output the Excel, your filters you've set up in your design do not work?

Birt Dev

No. What I am saying is that. After exporting to Excel I want to use the MS-Excel features. One of which is DATA FILTERS. And when I apply those filters they filter to null columns as the generated report is displaying headings and data in more than one column.

mwilliams

The Tribix and standard BIRT XLS emitters are the only two that I know of that are openly available. As you've said, I'm pretty sure they don't use the column filtering feature of MS-Excel. To do this, you'd have to write your own XLS emitter, most likely. I think that Actuate's BIRT Spreadsheet product is able to do this, but it's obviously a different program than BIRT. It has a free designer and API download, here:

http://www.actuate.com/products/spreadsheets/

You could try it out and see if it does what you're wanting. I'm not too familiar with it, so I'm not completely sure.

Birt Dev

Thanks William. I did download the Spreadsheet designer tool but its much different from BIRT DESIGN TOOL. Will have to write own emitter.