Export to PDF, Excel and Deployment

Exporting

// PDF bytes for download / email
byte[] pdf = JasperExportManager.exportReportToPdf(print);
// Excel with one sheet per page removed
net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter exporter =
    new net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter();
exporter.setExporterInput(new SimpleExporterInput(print));
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput("report.xlsx"));
SimpleXlsxReportConfiguration cfg = new SimpleXlsxReportConfiguration();
cfg.setOnePagePerSheet(false);
exporter.setConfiguration(cfg);
exporter.exportReport();

Deployment Tips

• Ship compiled .jasper files (or compile .jrxml once at startup), never per request.
• Externalize the template path and logo path as parameters for white-labelling.
• Set a query timeout and row cap on ad-hoc reports so one user cannot lock the database.