ReportServer Forum

quintg

Member

Registered: 2016-10-19

Jasper Excel export in xlsx format?

I noticed that Birt reports export to XLSX format while Jasper exports to XLS format.
Is it possible to generate XLSX format from Jasper as well? If not, is it on the roadmap?
The xlsx output from Birt is smaller and cleaner than the xls output (generates many empty columns).
Furthermore the xls output seems to be limited to 65535 records:
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Maximum row number is 65535.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Jasper Excel export in xlsx format?

Hi quintg,

we will look if it is possible to change the jasper export format to XLSX in the next reportserver version.

If you need excel sheets, why aren't you using dynamic lists which you can then export easily? This is easy and works like a charm.
The jasper excel export creates a lot of empty columns as you noted, and I'm not sure if changing the format to XLSX will improve this behavior. It depends on the complexity of the report and how the jasper library handles this. Normally, we would recommend dynamic lists for Excel exports. The results are cleaner.

Best regards,
Eduardo

quintg

Member

Registered: 2016-10-19

Re: Jasper Excel export in xlsx format?

Thanks for the tip Eduardo, I'll try the dynamic list option

quintg

Member

Registered: 2016-10-19

Re: Jasper Excel export in xlsx format?

Hi again, the dynamic list finished quite quick and I do see the output listed in the teamspace but when I try to open or save it shows an empty window. In the log I see this message:

07-Dec-2016 17:03:09.947 SEVERE [pool-DwAsyncService-1-thread-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Packet for query is too large (105075840 > 33554432). You can change this value on the server by setting the max_allowed_packet' variable.

On another post I read the suggestion to increase this parameter in my.cnf file but I cannot find it in the File System.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Jasper Excel export in xlsx format?

Hi,

my.cnf is a mysql config file.

Greets,
Eduardo

quintg

Member

Registered: 2016-10-19

Re: Jasper Excel export in xlsx format?

Hi, found it and it works. Thanks.
Kind regards, Gerard

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Jasper Excel export in xlsx format?

Hello,

we added XLSX support in the jasper excel export functionality to the next reportserver version.
Analogous to BIRT, it uses the configuration here:
/etc/exportfilemd/excelexport.cf

This setting can be <format>xlsx</format> or <format>xls</format> and this is now used both in BIRT and Jasper.
As I said previously, the XLSX output is not cleaner than the XLS output because of the jasper libraries. So we still recommend to use dynamic lists for getting nice clean excel files.

We will investigate if we can also add XLSX support to the Crystal reports too and will keep you informed here.

Best regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Jasper Excel export in xlsx format?

Hello,

since Crystal's XLSX export only supports a "data only" mood, we will leave the XLS Version for this, since formatting is not being lost with the XLS export.
For Jasper, as I said previously, we added the XLSX support in an analogous way as BIRT.

Cheers,
Eduardo

quintg

Member

Registered: 2016-10-19

Re: Jasper Excel export in xlsx format?

Thanks Eduardo.