crazybugs

Is this an existing issue in jasperreports-3.7.6 jar ? Post Edited by crazybugs at 01/24/2011 10:38

I am using Jasper reports jasperreports-3.7.6 jar, and POI 3.5; When I try to export the report to Xls format, I get the below mentioned exception [sunJDK14ConditionalEventPump] Exception occurred during event dispatching: java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/CellRangeAddress;)I at net.sf.jasperreports.engine.export.JRXlsExporter.createMergeRegion(JRXlsExporter.java:628) at net.sf.jasperreports.engine.export.JRXlsExporter.initCreateCell(JRXlsExporter.java:578) at net.sf.jasperreports.engine.export.JRXlsExporter.createTextCell(JRXlsExporter.java:561) at net.sf.jasperreports.engine.export.JRXlsExporter.exportText(JRXlsExporter.java:407) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:586) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:459) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:203) at net.sf.jasperreports.view.save.JRSingleSheetXlsSaveContributor.save(JRSingleSheetXlsSaveContributor.java:108) at net.sf.jasperreports.view.JRViewer.btnSaveActionPerformed(JRViewer.java:1132) at net.sf.jasperreports.view.JRViewer$3.actionPerformed(JRViewer.java:672) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) Does this jasper reports version support POI 3.5 jar??

Is there a way to change the alignment of image in Image field for each row data in a report... Some thing like, 1st row data has image aligned to "Center". 2nd row data has image aligned to "left" ...

I have a report where the number of fields changes as per some criteria. Is it possible to alter the size of the report accordingly???

I am able to generate a barcode in Graphics2D format. How will I be able to place it in jasper reports??

We need to display 2D barcodes with label in jasper reports. Is there any free jar available which generates 2D barcodes to be displayed in Jasper reports. Post Edited by crazybugs at 09/01/2010 14:28

Did anyone face any such issue? Post Edited by crazybugs at 12/14/2009 12:24

I have a report where date is displayed in one of the fields. I have set the date format to "dd/MM/yyyy" in the report jrxml file. On generating the report it appears in "dd/MM/yyyy" format in Jasper viewer. On saving it to csv it gets saved in the same format. Then I changed the date format property of excel to "yyyy/MM/dd" through Regional and language settings option in the control panel. On generating the report in csv format, the report again appears in "dd/MM/yyyy". It seems to use only the format mentioned in the report jrxml in both cases. Is this the way how csv export is designed to work.

Has anyone faced similar issue??

I was able to resolve the issue by following steps. I used the following property in the master report. <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.mysubreport" value="columnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.mysubreport" value="xxxxx_subreport"/> I used the following property in my subreport(xxxxx_subreport). <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.columnHeader" value="columnHeader"/>

Thanks for the reply teodor. The problem was with the xml design only.

jasperreports-3.6.1

I tried to keep the first occurence of column header in csv by using the below mentioned parameters but it didnt work out. <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.mysubreport" value="columnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.mysubreport" value="xxxx_subreport"/>

Thanks for the reply lucianc. Using the above mentioned parameters I was able to exclude the column header from the subreport in csv. but how will be able to keep first occurance of the column header in csv. Post Edited by crazybugs at 12/01/2009 16:24 Post Edited by crazybugs at 12/03/2009 08:19

Teodor, In my case the content in xml file is aligned properly. I am able to get the report in HTML and xls formats properly. The issue appears only in docx format. Moreover when I delete some 1 or 2 columns the report comes properly even in docx format. So I am in confusion whether it is the number of columns or some property in text fields that creates this issue.