tapanghia

Hi, I read/found , many other people facing similar issues with xlsx export (images not being displayed in the export.) but was unable to find a solution. It would be of great help, if anyone could confirm, this is known bug in iReport 3.7 and may be fixed in any of the future releases or if there is any way to resolve this in the 3.7 release. Thanks

When I create a report with an image, and then I export it to Excel 2007 (XLSX) the images are not displayed. There's only a blank space where the images are supposed to be. But if you export it using Excel 2003 or another format like Docx, PDF, XLS, HTML, There's no problem. I tried looking for an answer, found the same question asked a lot of times, but no relevant answer. Can anyone please suggest a solution to this problem. Thanks Code:void getXLSXExport(JasperPrint jasperPrint, HttpServletRequest request, HttpServletResponse response, String reportName) throws JRException, IOException{ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); String downloadFileName = reportName + ".xlsx"; response.setHeader("content-disposition", "attachment; name=\"" + downloadFileName + "\"; filename=\"" + downloadFileName + "\""); ByteArrayOutputStream byteStream = new ByteArrayOutputStream(); JRXlsxExporter xlsxExporter = new JRXlsxExporter(); xlsxExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); xlsxExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); xlsxExporter.setParameter( JRXlsExporterParameter.JASPER_PRINT, jasperPrint); xlsxExporter.setParameter( JRXlsExporterParameter.OUTPUT_STREAM, byteStream); xlsxExporter.exportReport(); response.setContentLength(byteStream.toByteArray().length); response.getOutputStream().write(byteStream.toByteArray()); }

Hi , I am trying to add a hyperlink in a report. And i want a javascript function to be invoked, once this link is clicked on the report. I am actually able to invoke this javascript function, but if i also want to pass some report fields as parameters to this function, how can i do this?? I tried Link Parameters tab, to link a variable to 1 of the fields in the report, but when i am passing this variable to the javascript function, i actually not able to acces this variable in the function. Please let me know, if I am missing on anything or if this can be implemented some other way? Thanks