jasper-reports - w3toppers.com

JasperReports NoClassDefFoundError exception on net.sf.jasperreports.engine.util.JRStyledTextParser

Finally, I’ve got it working. I detected the root Exception, which was thrown before NoClassDefFoundError:net/sf/jasperreports/engine/util/JRStyledTextParser : java.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironment The Sun AWT classes on Unix and Linux have a dependence on the X Window System. When you use these classes, they expect to load X client libraries and be able to talk to an X display … Read more

JasperReport – wrap text to show long text in textfield

I found the answer myself : I did some extra research about the properties of textField and rectangle components. And found that I need to set the following properties. For rectangle : <rectangle> <reportElement stretchType=”RelativeToBandHeight” … /> </rectangle> For textField : <textField isStretchWithOverflow=”true”> … </textField> Output as expected : The <detail> …</detail> section after correction … Read more

How to export to multiple sheets in excel from jasper report

In jasper report there are different ways to achieve new sheet both in jrxml and in java code. The default behavior is to create a new sheet for every page. I will illustrated the 3 most common ways with relative problem in using them. Ignore pagination and break element Method set isIgnorePagination=”true” on the jasperReport … Read more

How to merge cells in same column, apply rowspan?

You can fairly easy achieve text vertically aligned at top by using isPrintRepeatedValues=”false”, setting borders correctly (only top, using empty cell with only left, adding line to columnFooter). To achieve “text vertically aligned at center” use a subreport for the other columns and set stretchType=”RelativeToBandHeight” on your rowspan column. Note you need in this case … Read more

java.io.StreamCorruptedException: invalid stream header: EFBFBDEF

Finally after 3 day of headache I solved my trouble. I’m using maven like tool of project managment and I’m working on a modular project with this structure |– parent |– model –pom.xml |– services –pom.xml |– web-app –pom.xml The porblem was that the file that I try to load like Input stream was in … Read more

Why do I get compilation error “org/codehaus/groovy/control/CompilationFailedException”?

You will have to set the language value in your template to Java. There are two ways you can do this: If you are using iReport, select the root object in your Report Inspector (the one with the same name as your report). Then in the Properties window, select Java from the Languages drop-down. If … Read more

passing SQL “IN” parameter list in jasperreport

Jasper Report has a special variable $X for that: select * from customer where $X{IN,customer_role,roles} should work. See here and here.

JasperReports: How to call the report in jsp page

Compile the report in iReport Place the compiled report on the classpath load it with JasperReport jasperReport = (JasperReport) JRLoader.loadObject(inputStream); Fill it with data. dataSource is the DataSource instance you have – for example a BeanCollectionDataSource JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, params, dataSource); Export it JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream); exporter.exportReport(); The outputStream above … Read more

How to show JRBeanCollectionDataSource data with help of Table component?

1.Send your datasource from the server as a parameter, and fill the report with a different one (can be empty). JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(dataList); Map parameters = new HashMap(); parameters.put(“INFO”, “Hello”); parameters.put(“DS1”, beanColDataSource); JasperReport report = (JasperReport) JRLoader.loadObject(“src/test/ireport/ShowPerson.jasper”); JasperPrint jasperPrint = JasperFillManager.fillReport(report, parameters, new JREmptyDataSource()); 2.Decalre a new parameter in the report of type … Read more

How to insert images from database?

Open the XML view of .jrxml file. Then find code similar to this <field name=”image” class=”java.lang.Object”/> /* “image” must be replaced by your actual field name */ and change it to <field name=”image” class=”java.io.InputStream”/>