rajil

I am using API call to get JSON object from server. Noticed that subDataSource calls API 2nd time to get details. How can I use existing data set instead of calling API twice?

Recently we started using PPTX Exporter. We are using JasperReports 6.5.1 and everything works well on Tomcat8 running on JDK8. When we used WAS8, WAS8.5 and WAS9, the report exeported in PPTX without any error. But when I try to open that file with Microsoft Powerpoint it shows following error: Clicking on Repair button repairs the file and opens it but all pages are blank. When I open this file with Open Office Impress it works well. What could be the issue with WAS? I have attached sample exported file also for review.

Hi; Any solution found for this issue? After setting jvm parameter, -Dsun.java2d.debugfonts=true, found the fonts creating problem in report execution. Suggested at: https://docs.oracle.com/javase/8/docs/technotes/guides/troubleshoot/java2d002.html below is my stack trace: INFO: open TTF: D:Tomcat60temp+~JF518879230854443156.tmp 18 Dec, 2017 6:46:40 PM sun.font.TrueTypeFont readBlock SEVERE: While reading D:Tomcat60temp+~JF518879230854443156.tmp java.awt.FontFormatException: java.lang.NullPointerException at sun.font.TrueTypeFont.open(TrueTypeFont.java:277) at sun.font.TrueTypeFont.readBlock(TrueTypeFont.java:305) at sun.font.FileFont.getGlyphOutlineBounds(Native Method) at sun.font.FileFontStrike.getGlyphOutlineBounds(FileFontStrike.java:883) at sun.font.StandardGlyphVector$GlyphStrike.getGlyphOutlineBounds(StandardGlyphVector.java:1773) at sun.font.StandardGlyphVector.getGlyphOutlineBounds(StandardGlyphVector.java:1156) at sun.font.StandardGlyphVector.getGlyphVisualBounds(StandardGlyphVector.java:568) at sun.font.StandardGlyphVector.getGlyphInfo(StandardGlyphVector.java:846) at sun.font.ExtendedTextSourceLabel.createCharinfo(ExtendedTextSourceLabel.java:566) at sun.font.ExtendedTextSourceLabel.getCharinfo(ExtendedTextSourceLabel.java:492) at sun.font.ExtendedTextSourceLabel.getLineBreakIndex(ExtendedTextSourceLabel.java:438) at java.awt.font.TextMeasurer.calcLineBreak(TextMeasurer.java:308) at java.awt.font.TextMeasurer.getLineBreakIndex(TextMeasurer.java:544) at java.awt.font.LineBreakMeasurer.nextOffset(LineBreakMeasurer.java:340) at net.sf.jasperreports.engine.fill.SimpleTextLineWrapper.measureExactLineBreakIndex(SimpleTextLineWrapper.java:565) at net.sf.jasperreports.engine.fill.SimpleTextLineWrapper.measureExactLine(SimpleTextLineWrapper.java:539) at net.sf.jasperreports.engine.fill.SimpleTextLineWrapper.nextLine(SimpleTextLineWrapper.java:521) at net.sf.jasperreports.engine.fill.TextMeasurer.renderNextLine(TextMeasurer.java:826) at net.sf.jasperreports.engine.fill.TextMeasurer.renderParagraph(TextMeasurer.java:629) at net.sf.jasperreports.engine.fill.TextMeasurer.measure(TextMeasurer.java:570) at net.sf.jasperreports.engine.fill.JRFillTextElement.chopTextElement(JRFillTextElement.java:671) at net.sf.jasperreports.engine.fill.JRFillTextField.prepare(JRFillTextField.java:763) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:536) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:411) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2024) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:580) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:90) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:286) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:759) at com.applied.fincrm.utils.JasperReportBean.getJasperPrintObject(JasperReportBean.java:3154) at com.applied.fincrm.utils.JasperReportBean.generateReportWithoutScheduler(JasperReportBean.java:2191) at com.applied.fincrm.utils.JasperReportBean.generateReport(JasperReportBean.java:415) at com.applied.fincrm.reports.ReportOpenLotsAction.perform(ReportOpenLotsAction.java:618) at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786) at com.applied.fincrm.utils.CustActionServlet.processActionPerform(CustActionServlet.java:77) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.securityfilter.filter.SecurityFilter.doFilter(SecurityFilter.java:188) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.applied.fincrm.utils.MDCUserServletFilter.doFilter(MDCUserServletFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:444) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:399) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) at java.lang.Thread.run(Thread.java:662) 18 Dec, 2017 6:46:40 PM sun.font.FontManager deRegisterBadFont SEVERE: Deregister bad font: ** TrueType Font: Family=Tahoma Name=Tahoma style=0 fileName=D:Tomcat60temp+~JF518879230854443156.tmp 18 Dec, 2017 6:46:40 PM sun.font.TrueTypeFont open INFO: open TTF: D:Tomcat60temp+~JF518879230854443156.tmp

Lucianc; Thanks for the solution. I faced same issue and trying to fix using this solution. But i found that this post is very old. Is there any support for stretch crosstab column width to fill the entire page in newer version? I upgraded jasper library to 6.3, let me know if latest version supports this.

Thans for the reply Hozawa. I am using JasperReports 6.2.2 library. I still am unable to open xml to designer view. it loads only xml source file instead of opening in designer. I tried all compatibility settings but not successful. If i change extension to JRXML from XML then it's opening. But i can't do that because, mentioned earlier, it's not feasible to change file extension in a project. Isn't there any parameter to load XML in designer instead of JRXML?

Hello; I was using old version of jasper till now and was using iReport 3 till now. I have lots of reports designed and saved as "xml" extension. I have upgraded jasper reports library version to 6.2.2 now. I also have downloaded Jaspersoft Studio 6.2.2 but the problem is the earlier saved reports with XML extension isn't opening in report designre. I can rename the file and open it in report designer. But due to some reason and dependency i don't want to change extesion of report source files to JRXML from XML. Is there any way to continue using XML extension for report design instead of JRXML?

My Question is related to this post: http://community.jaspersoft.com/wiki/embedded-example-how-embed-jasper-reports-your-bootstrap-web-site-using-visualizejs Author has written to use JasperReports Server5.5 and Visualize.js plugin to run this example. I have downloaded Jasper Server 5.5 pro trial and installed reports provided by him. but didn't find this visualize.js file to run Bootstrap example. Can anybody say where to find it and how to enable it to use this example?

Hi Prosvet / Lucian; Can you please let me know what changes you made? I am having the same issue. I was using jasperreports0.5 earlier and upgraded to jasperreports3.0 I'm using ireport3.0 and i can open xml file in irport and can compile reports after modifing from irport. I want to make some general changes in report xml files. so i written java program to make these changes using Jasper API and saving back to same file. When i save these file after changes, it removes DOCTYPE tag and adding xmlns tags. This is creating problem in compilation. Stacktrace is shown below: [java] jasper compile for: ReportTransactionStatement_India.xml [java] net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException: Attribute "xmlns" is not declared for element "jasperReport" [java] at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243) [java] at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) [java] at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) [java] at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:168) [java] at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:152) [java] at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:89) [java] at com.applied.fincrm.utils.JasperCompiler.main(JasperCompiler.java:155) [java] Caused by: org.xml.sax.SAXParseException: Attribute "xmlns" is not declared for element "jasperReport". [java] at org.apache.crimson.parser.Parser2.error(Parser2.java:3160) [java] at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1411) [java] at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) [java] at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) [java] at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) [java] at org.apache.commons.digester.Digester.parse(Digester.java:1647) [java] at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239) [java] ... 6 more Instant help required on this.. Please let me know if you know anything..

Hi Have you found solution to this issue? I have similar problem to this. Having more than 400 reports of same design and i'm using compiled reports. Want to change part of report header section that includes Report Header Part + Column Headers. I want to change Report Header Section such that it comes from a template report. So that when i change 1 template it reflects in all reports. One solution is to add sub-report but I can not open and edit all these reports to add sub-report. Another solution is to introduce styled template, but i have to change the position and alignment of the fields being displayed in report header. So this also is not a good approach.Is there any other way exist to achieve this?? This is really very urgent. can anybody reply on this?

I have more than 400 reports in my project. By changing each report individually to add sub-report and remove header fields and passing them to sub-report is very time consuming. Is there any other way to achieve this?

Hi. I'm searching on this topic since last 2-3 days and didn't find any question or answer. I would like to know following: Environment: 1) Using Jasper Reports 3.0 on web application with JDK1.4 + Tomcat4.1 and JDK1.6 + Tomcat6 etc. 2) Having more than 400 reports in this application. I'm using compiled reports. i.e. all the JRXML or XML files are compiled to JASPER 3) All the reports are is designed to have Report Header + Report Detail + Footer etc. Most of the reports have single or multiple sub reports. 4) Report Header section prints various details for the report like. Customer Name, Date of Running the Report, Other criteria selected for the report while running. 5) The report header section prints the data dynamically from the report query or other source. But the location of these TextFields are fiexed. i.e. they are printed in report header centrally, one-after-another in next line. e.g. given below Customer ID and Customer Name Customer Address Customer Group From Date ____ to ToDate ___ Problem: Seraching for a solution to replace Report Header section by another report or programetally such that i can reposition the fields being deplayed in report header. e.g. 1) I wanted to print CustomerName in the Left then Group Name in the center then From Date __ to Date in the right alignment in the same line. 2) Logo position and width to be modified. 3) Fonts and Fonts size to be modified. Is there any way to achieve above layout? Soulution i found and implemented so far: 1) I have written a program to delete all the report heder fields from each report and introduced a sub-report to print all this details. 2) All header section details are passed as a parameter to Header sub-report and this Header Sub-Report is degined saperately for each customer. I achieved dynamic header printing this way. Problem with this solution: 1) I have to run this program everytime i change the report and to convert it to introduce header section. 2) Customer is getting different source then we have in our records as we are giving them converted reports, conversion is made through a java program as i mentioned to remove header items and adding sub report. Is there any other way to achieve this??

I also have issues in some of reports in my application. The report prints extra blank page at the end. Still not found any solution to this issue.

You can use subreport in your main report. Subreport prints text from java class if it's dynamic. Or you can dump your static text in sub report.

Is there any option to set Font Size and Font color in header section? I'm adding header to Excel file using above code. I want to set font size and font color of header text i'm adding.

I want to add watermark image while exporting report to PDF file. I'm using Jasper Report 3.0. Actually, my jrxml file is compiled to jasper file, i.e. i'm using compiled report design and exporting it to PDF file by providing vaious data source and query. Now, I want to add watermark while exporting report to PDF file. I don't want to change JRXML file. Is there any way to do this? Thanks in advance. Rajil Code:JRPdfExporter exporter = new JRPdfExporter();JasperPrint jppdf = new JasperPrint();jppdf = JasperFillManager.fillReport(this.reportFile, reportParams, con);exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, outputFilePath);exporter.setParameter(JRExporterParameter.JASPER_PRINT, jppdf);exporter.exportReport();

Hi.. Can you share how did you do that? I want to add watermark image in every report i generate. I have all the compiled report files. I want to add watermark while exporting to pdf file.I have no idea how to do this. Can I accomplish this using JRExporter Interface?

We are using simple architecture to generate report from our application. We have one java class that process jasper file and query from inputs and generates report. Report heading, column heading, number formatter etc comes from table and stored in map and passed to jasper report. And data being printed in report comes from report query that is passed to report via java class. I want to introduce i18n into these reports. I seen example but it requires change in all the report to take values from properties file as per language selection. But in my case column values comes from database table that is passed as map to JasperReport. I have 2 options to implement i18n in my reports. 1) via example given by JasperTeam to create properties file for language and change every report to support different language. 2) This approach does not use readymade i18n feature given by jasper team. This is to Create other tables for each language that can be processed from java class and required values can be passed to jasper report. But there i found problem is that i am not able to insert values of different languages into my oracle table. I'm using Jasper v3.0 and Jdk 1.4 and oracle 10g / 11g Can expert suggest which approach is better for my application?

Hi; Actually these problems reported at client side and i am not able to re-produce the same on our side. I am able to run the same code successfully at my side but 2 of our clients facing problem. Let me re-produce the problem here and will report bug then-after with proper data and source. Thanks for the reply.

Hi; Is there any solution to the previous error? Is this a bug and reported? I also am getting following ----------------- error:net.sf.jasperreports.engine.JRRuntimeException: The virtualizer is used by more contexts than its in-memory cache size 100 at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer$Cache$LRUScanMap.removeLRU(JRAbstractLRUVirtualizer.java(Compiled Code)) at org.apache.commons.collections.LRUMap.put(Unknown Source) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer$Cache.put(JRAbstractLRUVirtualizer.java(Inlined Compiled Code)) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.registerObject(JRAbstractLRUVirtualizer.java(Compiled Code)) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.<init>(JRVirtualPrintPage.java(Inlined Compiled Code)) at net.sf.jasperreports.engine.fill.JRBaseFiller.newPage(JRBaseFiller.java(Inlined Compiled Code)) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java(Inlined Compiled Code)) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java(Compiled Code)) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java(Compiled Code)) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java(Compiled Code)) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java(Compiled Code)) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java(Inlined Compiled Code)) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java(Compiled Code)) -------------- This problem is found under Windows 2003, WebSphere 6 Network Eddition, JDK 1.4.2 and JasperReports 3.0 Same problem is found under Tomcat4.1 with above all configuration. I didn't find any post related to above error except this and is there any solution to above Exception??

Hi All; I am facing problem while compiling JasperReport. - I have project running under jdk1.4 and jasper-0.5. I am able to compile all report under this environment and running well. - I want to migrate this project to jdk1.5. Now the problem is i am not able to compile my reports in jdk1.5 environment. - I have written some user defined classes like DbUtil, JasperParameters and SimpleNumberFormat to use in jrxml files. Not when i compile my project it compiles all the classes. But when i run "ant jasper" to compile all jrxml files to jasper it gives me error like [java] file name: SummaryContributionAnalysis.xml [java] 1 error [java] jasper compile for: SummaryContributionAnalysis.xml [java] at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) [java] at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) [java] at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:135) [java] at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:94) [java] at com.applied.fincrm.utils.JasperCompiler.main(JasperCompiler.java:155) [java] net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: [java] C:workfincrmNewSummaryContributionAnalysis_1227504311234_289722.java:253: cannot access com.applied.fincrm.utils.Ja ChartFactory [java] bad class file: C:Tomcat5.5webappsfincrmWEB-INFclassescomappliedfincrmutilsJasperChartFactory.class [java] class file has wrong version 49.0, should be 48.0 [java] Please remove or make sure it appears in the correct subdirectory of the classpath. [java] value = (net.sf.jasperreports.engine.JRRenderable)((new net.sf.jasperreports.renderers.JCommonDrawabl derer (com.applied.fincrm.utils.JasperChartFactory.createVerticalBarChart("", "", "Contribution", ((org.jfree.data.category.De tCategoryDataset)variable_ChartContribution.getValue()), true,false,false))));//$JR_EXPR_ID=20$ [java] ^ [java] 1 error The class JasperChartFactory contains method used to create chart and being reffered from jrxml file. All these classes are compiled under jdk1.5. Can anybody say what would be the issue? how can i compile these reports to run under jdk1.5 and tomcat5.5?? - - rajil

I successfully implement static formula in jasper report. formula sum(A1:A10) now I want to do same thing dynamically, data fetch from database it may return 1 row it may return 100 rows.so how can I adjust sum(A1:A{x}) how can I replace at runtime ? Please help me.

check version of iText it must be itext-1.3.1.jar and delete if older version is available in lib folder.

1. Open iReport 3.0 2. Open your JRXML file 3. Insert "Static Text" from tool bar 4. Right Click on Newly added Static Text 5. Select Custom Element Properties 6. Click On new button 7. Property Name : net.sf.jasperreports.export.xls.formula 8. Property Value : write any valide Excel expression i.e. sum(B1:B10) . remember don't put = sign before formula 9. compile and export report in Excel 10. enjoy formula.... - By KP Bird

I have sampe problem. when database return 0 rows PDF show blank page I tryed no output at all ("NoPages") but still PDF show me blank page. I am using jasperReport 3.0

Ok I solve problem. and I don't required to put extra / in jrxml. FlashVars="jrpxml=servlets/xml?" this will work. I forget to add following lines in my web.xml file <servlet> <servlet-name>XmlServlet</servlet-name> <servlet-class>net.sf.jasperreports.j2ee.servlets.XmlServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>XmlServlet</servlet-name> <url-pattern>/servlets/xml</url-pattern> </servlet-mapping> :P