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();