You are not logged in.
Pages: 1
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.
Offline
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
Offline
Thanks for the tip Eduardo, I'll try the dynamic list option
Offline
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.
Offline
Hi,
my.cnf is a mysql config file.
Greets,
Eduardo
Offline
Hi, found it and it works. Thanks.
Kind regards, Gerard
Offline
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
Offline
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
Offline
Thanks Eduardo.
Offline
Pages: 1