Data in Detail band (only) not showing up in Xls

[citress]

Hi, I am trying to export a Jasper report to XLS format however the data in the Detail band is not showing up - everything else such as the pie chart, grouping header and footer all contain correct data. I have exported the same report (same template, same fill data) in PDF with no issues. Can someone please take a look and let me know what I may be missing?

I am using Excel 2007 on Windows 7 to open and view the report. It would open the report in compatibility mode (since it is .xls format, not .xlsx) - could this be an issue?

Below is the code I use for the export to XLS. I have attached the generated XLS as well as my report template.

Thanks!

Code:

JRXlsExporter exporter = new JRXlsExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

[citress]

I just realized that the same problem exists in iReport when I preview the template in XLS and XLSX formats. Help??

[bbb_pedro]

Hello,
did anybody found solution for this problem ?

Kind regards.

 

[alestar]

Same issue here. Did someone figure out how to export to Excel using the detail band and passing information through the data source?