2006 JR Open Discussion

By: B Siegel - bernardsiegel I think I am missing something basic... 2006-01-04 14:20 I am new at this so I am probably missing something really basic but I would appreciate any pointers you may have. I searched around and managed to confuse myself even more... Thank you, Bernard Trying to get JasperReports to work (Eclipse, JDK 1.4.2) and I get this error when I attempt to compile the demo/samples/jasper using the compile target in the build.xml: [jrc] Jan 4, 2006 3:58:26 PM org.apache.commons.digester.Digester getParser [jrc] SEVERE: Digester.getParser: [jrc] org.xml.sax.SAXNotRecognizedException: Feature: http://apache.org/xml/features/validation/dynamic [jrc] at org.apache.crimson.parser.XMLReaderImpl.setFeature(Unknown Source) .... [jrc] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:136) BUILD FAILED: C:workspaceTest Jasper Reportsjasperreports-1.1.1demosamplesjasperbuild.xml:30: java.lang.NullPointerException By: Ian - yann123 RE: I think I am missing something basic... 2006-01-06 01:46 Oupssss, the link : http://ensode.net/jasperreports_intro.html By: B Siegel - bernardsiegel RE: I think I am missing something basic... 2006-01-06 06:36 Ok, I read the link (had seen it before). But it says nothing about the unknown Feature: [jrc] Jan 4, 2006 3:58:26 PM org.apache.commons.digester.Digester getParser [jrc] SEVERE: Digester.getParser: [jrc] org.xml.sax.SAXNotRecognizedException: Feature: http://apache.org/xml/features/validation/dynamic It has been suggested to me this is a version problem; the parser I am using does not have that feature. But I am using the xerces parser that came in the zip file. ??? Thank you, Bernard By: Teodor Danciu - teodord RE: I think I am missing something basic... 2006-01-12 08:21 Hi, Current versions of JR work with Jakarta Digester 1.7. For some reason, this version of Digester does not like the Xerces version that comes with Eclipse. So to solve this, when you run the Ant tasks from within Eclipse, make sure you add the Xerces files supplied with the JR project to the classpath. They should be among the first JARs in the classpath. After that, the Ant tasks should work. If you launch Ant from command line, you should not have the mentioned problem. I hope this helps. Teodor By: Ian - yann123 RE: I think I am missing something basic... 2006-01-06 01:45 This link could help you ;). In my case, I have this error on executing this program : java.io.IOException: CreateProcess: javac -classpath V:workspaceJasperReportsIntrobin;V:workspaceJasperReportsIntrolibcommons-beanutils-1.7.0.jar;V:workspaceJasperReportsIntrolibcommons-collections-3.1.jar;V:workspaceJasperReportsIntrolibcommons-digester-1.7.jar;V:workspaceJasperReportsIntrolibcommons-logging.jar;V:workspaceJasperReportsIntrolibjasperreports-1.1.1.jar;V:workspaceJasperReportsIntrolibitext-1.3.jar;V:workspaceJasperReportsIntrolibjcommon-1.0.0.jar;V:workspaceJasperReportsIntrolibjfreechart-1.0.0.jar;V:workspaceJasperReportsIntrolibpoi-2.5.1-final-20040804.jar V:workspaceJasperReportsIntroSimple_Report_1136540177909_556366.java error=2 at java.lang.Win32Process.create(Native Method) at java.lang.Win32Process.<init>(Win32Process.java:66) at java.lang.Runtime.execInternal(Native Method) at java.lang.Runtime.exec(Runtime.java:566) at java.lang.Runtime.exec(Runtime.java:491) at java.lang.Runtime.exec(Runtime.java:457) at net.sf.jasperreports.engine.design.JRJavacCompiler.compileClasses(JRJavacCompiler.java:62) at net.sf.jasperreports.engine.design.JRAbstractClassCompiler.compileUnits(JRAbstractClassCompiler.java:67) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:190) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:131) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:211) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:144) at jasperReportsIntro.main(jasperReportsIntro.java:26) NESTED BY : java.io.IOException: CreateProcess: javac -classpath V:workspaceJasperReportsIntrobin;V:workspaceJasperReportsIntrolibcommons-beanutils-1.7.0.jar;V:workspaceJasperReportsIntrolibcommons-collections-3.1.jar;V:workspaceJasperReportsIntrolibcommons-digester-1.7.jar;V:workspaceJasperReportsIntrolibcommons-logging.jar;V:workspaceJasperReportsIntrolibjasperreports-1.1.1.jar;V:workspaceJasperReportsIntrolibitext-1.3.jar;V:workspaceJasperReportsIntrolibjcommon-1.0.0.jar;V:workspaceJasperReportsIntrolibjfreechart-1.0.0.jar;V:workspaceJasperReportsIntrolibpoi-2.5.1-final-20040804.jar V:workspaceJasperReportsIntroSimple_Report_1136540177909_556366.java error=2 at java.lang.Win32Process.create(Native Method) at java.lang.Win32Process.<init>(Win32Process.java:66) at java.lang.Runtime.execInternal(Native Method) at java.lang.Runtime.exec(Runtime.java:566) at java.lang.Runtime.exec(Runtime.java:491) at java.lang.Runtime.exec(Runtime.java:457) at net.sf.jasperreports.engine.design.JRJavacCompiler.compileClasses(JRJavacCompiler.java:62) at net.sf.jasperreports.engine.design.JRAbstractClassCompiler.compileUnits(JRAbstractClassCompiler.java:67) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:190) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:131) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:211) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:144) at jasperReportsIntro.main(jasperReportsIntro.java:26) NESTED BY : net.sf.jasperreports.engine.JRException: Error compiling report java source files : V:workspaceJasperReportsIntroSimple_Report_1136540177909_556366.java at net.sf.jasperreports.engine.design.JRJavacCompiler.compileClasses(JRJavacCompiler.java:93) at net.sf.jasperreports.engine.design.JRAbstractClassCompiler.compileUnits(JRAbstractClassCompiler.java:67) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:190) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:131) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:211) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:144) at jasperReportsIntro.main(jasperReportsIntro.java:26) Caused by: java.io.IOException: CreateProcess: javac -classpath V:workspaceJasperReportsIntrobin;V:workspaceJasperReportsIntrolibcommons-beanutils-1.7.0.jar;V:workspaceJasperReportsIntrolibcommons-collections-3.1.jar;V:workspaceJasperReportsIntrolibcommons-digester-1.7.jar;V:workspaceJasperReportsIntrolibcommons-logging.jar;V:workspaceJasperReportsIntrolibjasperreports-1.1.1.jar;V:workspaceJasperReportsIntrolibitext-1.3.jar;V:workspaceJasperReportsIntrolibjcommon-1.0.0.jar;V:workspaceJasperReportsIntrolibjfreechart-1.0.0.jar;V:workspaceJasperReportsIntrolibpoi-2.5.1-final-20040804.jar V:workspaceJasperReportsIntroSimple_Report_1136540177909_556366.java error=2 at java.lang.Win32Process.create(Native Method) at java.lang.Win32Process.<init>(Win32Process.java:66) at java.lang.Runtime.execInternal(Native Method) at java.lang.Runtime.exec(Runtime.java:566) at java.lang.Runtime.exec(Runtime.java:491) at java.lang.Runtime.exec(Runtime.java:457) at net.sf.jasperreports.engine.design.JRJavacCompiler.compileClasses(JRJavacCompiler.java:62) ... 6 more If someone could help me, The code is correct, it works on the pC of my colleague... By: jasperkan - jasperkannan RE: I think I am missing something basic... 2006-01-13 10:25 this error is due to jasper being unable to locate the java compiler which it uses to compile ur report . make sure u have the jdt-compiler.jar(this jar is n jasperreports lib) in the classpath . By: Puppy - praba_wits Im new to jasper report 2006-01-06 01:26 hello im new to jasper report. i downloaded all the necessery sources. but i dont know how to start with.i understand that i have to create a xml file that will have the structure of the report. after that i hvae to compile. then the compiles file i can use as a report. this is wat i understood. My application in JSP & SERVLET using Tomcat5 webserver. Please guide me where i have to keep the downloaded jasper files ? how to write xml? how to save & where to keep? how to compile the xml? i saw that u are using java to compile. but i have doubt that i have to write a java program to compile? by using javac compiler? and then how i call the report from JSP&SERVLET. i know that this is very very silly questions.... since im new i feel that im in the ocean. im in urgent.. please help me puppy By: Pavitra - pavitra_saxena HOW TO START MY OWN THREAD ? 2006-04-17 08:53 Can any one tell me the steps how can I start my own topic ? Btw Sorry for putting my question in a reply to another topic ( for urgency ) following is my problem : --------------- Hello, I want to use jasper to print the data of my screen (JSP deployed over a web server), with the expectation of opening a pdf document as a popup which could be printed. My Servlet opened an empty popup which led me to write a PSVM program to check it faster. Now this PSVM program also is generating an empty PDF document instead of a document filled with data. Can any one help me out there? Only difference with the sample (working) program is I do not want to use a database rather using a HashMap (parameters) to provide the actual values. For this purpose , following were the steps followed. 1) modified ‘C:jasperreports-1.2.1demosamplesjasper FirstJasper.jrxml’ in order to remove ‘<queryString><![CDATA[sELECT * FROM Orders WHERE OrderID <= $P{MaxOrderID} ORDER BY ShipCountry]]></queryString>’ This was done with the intention of removing database dependency. 2) Run ant clean, 3) Run ant 4) Run ant compile: generated ‘FirstJasper.jasper’ 5) copied this FirstJasper.jasper to C:/ 6) Compiled JasperTest.java and run the same. FirstJasper.pdf is generated but the same is empty. Why? Any guess? Same PSVM is mentioned below. HashMap paramerets = new HashMap(); paramerets.put("ReportTitle","My Title"); paramerets.put("MaxOrderID",new Integer(1)); ..... poulated all parameters . byte[] bytes = JasperExportManager.exportReportToPdf(JasperFillManager.fillReport(new FileInputStream("c:\FirstJasper.jasper"),paramerets)); FileOutputStream fout = new FileOutputStream("c:\FirstJasper.pdf"); fout.write(bytes); fout.close(); Any type of quick help would be very helpful. Thanks and Regards Pavitra

By: man - msr Pls Help me to calculate % (urgent) 2006-04-16 19:32 Hi, i am new to Jasper can anyone pls tell me how to calculate % my report should be ---------------------- desc rate % ---------------------- apple 100 50 banana 100 50 PLSSSSSSSSSSSSSSSSSSSSSSSSSSSSS Regards Rao

By: Rian - rian123 Ant & Eclipse : SEVERE: Digester.getParser: 2006-03-10 08:25 Hi Probably a silly question: I can compile my Jasper reports using the following ant file, but when I try to do it from Eclipse I get the errors as displayed below. I am using Eclipse 3.1.1 and in this instance JasperReports 1.0.0. From what I can see it looks as if Eclipse is picking up the wrong SAX parser. Any ideas will be appreciated. Regards, Rian * Ant section : <property name="web.dir" value="war"/> <property name="report.dir" value="${web.dir}/WEB-INF/report"/> <property name="build.dir" value="${web.dir}/WEB-INF/classes"/> <property name="lib.dir" value="C:/j2sdk1.4.2_08/jasperreports-1.0.0/" /> <path id="classpath"> <pathelement location="./"/> <fileset dir="${lib.dir}"> <include name="**/*.jar"/> </fileset> </path> <target name="compile" description="Compiles the XML report design and produces the .jasper file."> <taskdef name="jrc" classname="net.sf.jasperreports.ant.JRAntCompileTask"> <classpath refid="classpath"/> </taskdef> <jrc destdir="${build.dir}"> <src> <fileset dir="${report.dir}"> <include name="**/*.jrxml"/> </fileset> </src> <classpath refid="classpath"/> </jrc> </target> * Errors : [jrc] Compiling 2 report design files. [jrc] 10-Mar-2006 17:30:38 org.apache.commons.digester.Digester getParser [jrc] SEVERE: Digester.getParser: [jrc] org.xml.sax.SAXNotRecognizedException: Feature: http://apache.org/xml/features/validation/dynamic [jrc] at org.apache.crimson.parser.XMLReaderImpl.setFeature(XMLReaderImpl.java:219) [jrc] at org.apache.crimson.jaxp.SAXParserImpl.setFeatures(SAXParserImpl.java:150) [jrc] at org.apache.crimson.jaxp.SAXParserImpl.<init>(SAXParserImpl.java:133) [jrc] at org.apache.crimson.jaxp.SAXParserFactoryImpl.newSAXParserImpl(SAXParserFactoryImpl.java:113) [jrc] at org.apache.crimson.jaxp.SAXParserFactoryImpl.setFeature(SAXParserFactoryImpl.java:141) [jrc] at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185) [jrc] at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138) [jrc] at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71) [jrc] at org.apache.commons.digester.Digester.getParser(Digester.java:692) [jrc] at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899) [jrc] at org.apache.commons.digester.Digester.parse(Digester.java:1666) [jrc] at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) [jrc] at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:209) [jrc] at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:163) [jrc] at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:147) [jrc] at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) [jrc] at net.sf.jasperreports.ant.JRAntCompileTask.compile(JRAntCompileTask.java:398) [jrc] at net.sf.jasperreports.ant.JRAntCompileTask.execute(JRAntCompileTask.java:252) [jrc] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) [jrc] at org.apache.tools.ant.Task.perform(Task.java:364) [jrc] at org.apache.tools.ant.Target.execute(Target.java:341) [jrc] at org.apache.tools.ant.Target.performTasks(Target.java:369) [jrc] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216) [jrc] at org.apache.tools.ant.Project.executeTarget(Project.java:1185) [jrc] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40) [jrc] at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32) [jrc] at org.apache.tools.ant.Project.executeTargets(Project.java:1068) [jrc] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423) [jrc] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137) By: Rian - rian123 Ant & Eclipse : SEVERE: Digester.getParser: 2006-03-10 08:27 Sorry, I mean to post that in Help. Rian By: Teodor Danciu - teodord Ant & Eclipse : SEVERE: Digester.getParser: 2006-03-10 08:34 Hi, This seems to be a Digester bug. We'll try to look into it deeper and see how to avoid it if possible. http://issues.apache.org/bugzilla/show_bug.cgi?id=38894 Thank you, Teodor By: roskha - roskha Ant & Eclipse : SEVERE: Digester.getParser: 2006-04-14 08:05 You have to overide crimson parser on the rt.jar, which does not support certain features. To do that, go to Ant Perspective in Eclipse, right click on your ant build file select Run As and choose second Ant Build. Select Classpath tab, click on User Entries and click Add Jars. I added xml-apis.jar and xercesImpl.jar

By: Flip-Flop - rojinegra Jasper Reports/Linux Internship in Houston TX 2006-04-13 12:23 Linux Journal (http://www.linuxjournal.com) is hiring in the Houston area for a short term software engineering internship! We're currently implementing a new system to manage our subscription base and could use a hand. Length of employment would vary with your expertise in various subjects, but the following are a must: - At least Junior level (completed 2nd year in university) studying software engineering or related field. - Strong proficiency in SQL. Experience with PostgreSQL is a plus. - Familiarity with Java or ability to be familiar before you start. - Strong self motivation. You'll be reporting to work each day at an office (in Houston), but your boss will be working with you from abroad. Therefore, you must be resourceful and largely be able solve your own problems with minimal guidance. - Fluent in English. Your boss will be bilingual (English/Spanish) but your customer is not. - Strong attention to detail. Lots of money will hinge on the things you do. You must be willing to double and triple check your work before submitting it, as we will largely trust you to do your job. - Sense of humor. We love our jobs, and we think you should love yours too. Optional Skills: - Familiarity with Jasper Reports and iReport is a HUGE plus. - Proficiency in Ruby. - Web site design in Ruby, PHP, or another open source language. - Familiarity and ability to "whip things up" in Photoshop/Gimp in a pinch. This is a paid position. Term of employment is negotiable, largely depending on which skills of the above you have and how well you fit with the rest of the team, but would be a minimum of 1 - 3 months. Hours are also fairly flexible. I'd be happy to discuss specifics and address any needs or concerns you may have before you apply. To apply, please send a resume, description of why you should be our intern, and/or other things you think we might find helpful to Kevin Brown at blargity@gmail.com. Thanks! :-)

By: Teodor Danciu - teodord [ANN] JasperServer 0.9.0 released 2006-04-07 08:17 JasperServer 0.9.0 released JasperServer is specifically designed to provide a Web application around JasperReports, the most popular open source reporting solution. Continuing the philosophy of JasperReports, JasperServer provides a managed, stand alone Web reporting environment, as well as being able to be embedded in existing Java Web applications, and services to a variety of technologies through Web services, including the LAMP stack. By focusing on a clean business API and using an advanced inversion of control architecture, JasperServer can be easily integrated and customized for your needs. This first public release of JasperServer provides the ability to define and maintain JasperReports in a Web application and Web services environment. An extensible metadata repository defines all needed resources to run JasperReports in a secure environment. Report parameters can be defined so that the user can be prompted for required inputs as reports are run. JasperIntelligence is an open source business intelligence platform from JasperSoft built by the team behind JasperReports, providing common services like security and metadata management, and the capability to easily add additional functionality. JasperServer is the first service using the JasperIntelligence platform. JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net Sincerely, JasperSoft Team By: M. Overdijk - marceloverdijk RE: [ANN] JasperServer 0.9.0 released 2006-04-10 13:30 Wow, sounds good. Is this something similar as openreports? Is there any roadmap information available when a final 1.0 will be releases? Cheers, Marcel By: Sherman Wood - sgwood RE: [ANN] JasperServer 0.9.0 released 2006-04-11 14:06 This 0.9.0 release aims to give the community a look at the application. We are wrapping up a few more features and doing a broad test, aiming to release a 1.0 by the end of April. Sherman JasperSoft By: Sherman Wood - sgwood RE: [ANN] JasperServer 0.9.0 released 2006-04-11 15:06 We have broader goals than OpenReports. JasperIntelligence is a platform that will be extended to cover OLAP and other business intelligence technologies. See http://jasperintel.sourceforge.net/ Sherman JasperSoft By: M. Overdijk - marceloverdijk RE: [ANN] JasperServer 0.9.0 released 2006-04-12 12:50 OK I will give it a try. On the roadmap I see EJB support, is this also available in 1.0? By: Sherman Wood - sgwood RE: [ANN] JasperServer 0.9.0 released 2006-04-13 07:56 We have not planned for that at the moment. Put in a feature request in the JasperIntelligence Tracker https://sourceforge.net/tracker/?group_id=162962&atid=825864. Sherman JasperSoft

By: Jason Hodge - jnthodge Spawning new threads in JR API... 2006-03-27 11:05 I've noticed in the net.sf.jasperreports.engine.fill.JRFillSubreport class that on line 523, that JasperReports does this: fillThread = new Thread(this); fillThread.start(); First, it isn't strictly necessary since in my profilers, I see that the work done by these threads are serialized for some reason anyway, perhaps by further synchronization. Secondly, if you're going to use a separate thread to generate sub-reports, then couldn't you at least configure a thread pool mechanism? Will this result in deadlock if there aren't enough threads? Thirdly, it is forbidden for EJB's and even Servlets to spawn their own worker threads. This is also enforced by some app servers, at least I've been told. Fourthly, if you were to make a pluggable thread pool or a built in one, I'd prefer that you use the EDU.oswego package by Doug Lea. He engineered the Java 5 concurrent utils for Sun and is a well-recognized expert. Fifthly, when you spawn 13 threads (my report with charts/subreports), on a linux box, each thread is grabbing 64Mb of memory for a grand total of 832 Megs of RAM to run this small report only once, only for the threads to never be reused and die immediately after doing an infintecimal amount of work. By: Dave Cherkassky - dcherk RE: Spawning new threads in JR API... 2006-03-30 04:42 Yes, this is a huge problem. Sadly, the good people at JasperReports have not yet acknowledged it or scheduled a fix. There's even an official bug: https://sourceforge.net/tracker/index.php?func=detail&aid=1457827&group_id=36382&atid=416703 but there hasn't been any movement... The resonse so far to other similar questions has been "Well, that's the way it is." :( Thank you for raising this point. I hope that if enough developpers voice their concerns, a change might come down some time in the futures. I imagine it would not be an easy implementation to change, but I think it has to be done... Dave Cherkassky. By: Dan Desch - danieldesch RE: Spawning new threads in JR API... 2006-03-30 06:32 Dave, I agree 100%. This is a big problem for EJB developers. The most natural place to do the work of assembling a Jasper report object would be in a session bean, thereby putting the code close to the data and allowing all local references. This approach is made practically impossible by this threading issue. Some have argued that the multi-threading restrictions applies only if you actually invoke an EJB from within a subreport--that is to say, they argue that it is okay to spawn a sub-thread within an EJB so long as that thread does not itself invoke other EJBs. This has two problems. First, and foremost, I want to invoke an EJB within my sub report's data source; the alternative of pre-loading my data is too hideous to consider. Second, even though this work-around may avoid an actual blow up, it still violates the EJB spec restriction against sub-threads. I have a viscerally negative reaction to work-arounds that violate specs but "work anyway". I am under the impression that the threading in Jasper is used not for any parallel processing purpose but solely as a data communication/data encapsulation technique. It seems to me that sub-reports would have to be generated synchronously in almost every case anyway, so I don't think there can be any concern about performance degradation if Jasper gives up the multi-threading. So, add my name to the list of agitators. I gather that removing threading from Jasper is a difficult task, but I think it is important to do. By: Dick Zetterberg - dickz RE: Spawning new threads in JR API... 2006-04-03 01:25 I do not think that using a thread-pool would be a good idea for this. That would break applications that today manage to work (in spite of the threading) by using InheritableThreadLocal variables. Any thread-pooling would break those applications. However, I agree with you and the other posters that it would be good if the threading was removed altogether. Cheers, Dick Zetterberg dick@transitor.se > Secondly, if you're going to use a separate thread to generate sub-reports, then couldn't you at least configure a thread pool mechanism? Will this result in deadlock if there aren't enough threads? By: Dick Zetterberg - dickz RE: Spawning new threads in JR API... 2006-04-04 00:22 I do not think that using a thread-pool would be a good idea for this. That would break applications that today manage to work (in spite of the threading) by using InheritableThreadLocal variables. Any thread-pooling would break those applications. However, I agree with you and the other posters that it would be good if the threading was removed altogether. Cheers, Dick Zetterberg > Secondly, if you're going to use a separate thread to generate sub-reports, then couldn't you at least configure a thread pool mechanism? Will this result in deadlock if there aren't enough threads? By: Teodor Danciu - teodord RE: Spawning new threads in JR API... 2006-04-11 05:32 Hi, 4 years after the introduction of subreport functionality in JasperReports, it seems that the multi-threading issue could be tackled using this new concept called "Java Continuations". In this article here written by Bruce Tate, we can see that JasperReports is actually using threads for "Simulated Continuations" in Java. http://www-128.ibm.com/developerworks/java/library/j-cb03216/index.html?ca=drs- We are currently looking into third-party libraries that offer "continuations" functionality to Java applications, such as RIFE and Jakarta Commons JavaFlow. Thank you, Teodor By: Lucian Chirita - lucianc RE: Spawning new threads in JR API... 2006-04-13 02:21 Hi We've isolated the thread-related code out of the subreport fill code into a subreport runner implementation. In addition, a new subreport runner implementation based on Javaflow continuations is provided. To use this latter implemetation (which doesn't require extra threads), add net.sf.jasperreports.subreport.runner.factory=net.sf.jasperreports.engine.fill.JRContinuationSubreportRunnerFactory in your jasperreports.properties (if you don't have one, create it and place it on the application classpath). Testing on different JVMs, J2EE envs and reports would be very useful in detecting Javaflow misusages/limitations/bugs that we're not aware of. Get the sources from CVS and build JR using Ant to make sure Javaflow has the chance to do its bytecode instrumentation. Note that the current code is not final; performance is a concern that might be addressed in the future. Regards, Lucian

By: slowfinger - slowfinger simultaneous move of text label and textfield 2006-03-28 21:35 Hi, I have following case: The detail contains a lot of text elements and subreports. The text label and field elements are aligned horizontal. All of the text fields contents could be bigger as the expected width thats why I adjust the text fields property isStretchWithOverflow=true. I've adjust all text fields property positionType="Float". And now it could happen, that the correspondend text label stay upper to it's content. What can I do that both the label and it's text field move downwards if the previous text field was stretched ? Any suggestions. Thanks in forward. Rico By: Teodor Danciu - teodord RE: simultaneous move of text label and textf 2006-04-10 07:57 Hi, Use an invisible line to separate the label and text pairs. The line should also have postitionType="Float", but will push both the text and the label at the same time. Otherwise, put the label/text pairs into their own separate bands using dummy groups. I hope this helps. Teodor By: C-Box - c-box RE: simultaneous move of text label and textf 2006-04-10 08:10 Could not also a frame element help in this case!?!?!? hth C-Box By: Teodor Danciu - teodord RE: simultaneous move of text label and textf 2006-04-10 08:16 Yes, frames should work. Good catch! Thanks, Teodor By: slowfinger - slowfinger RE: simultaneous move of text label and textf 2006-04-10 23:04 Thanks, suggestion with line didn't work for me but with frame works well. Rico By: C-Box - c-box RE: simultaneous move of text label and textf 2006-04-11 00:33 The trick with the invisible line must work also (as I did so in almost all of my reports before the frame-element came into JasperReport) ... you must set it to float and it must above BOTH elements (label and field) to cause the moving (also set both elements to "float") but the frame is much better (cleaner) for new version of reports. C-Box

By: Giulio Toffoli - gt78 [ANN] iReport 1.2.1 released! 2006-04-07 11:16 The iReport Team is pleased to announce the new iReport release: 1.2.1. iReport Release 1.2.1 April 7, 2006 The following changes have been made to software since release 1.2.0 * Full support for JasperReports 1.2.1 * New handling of conditional style * New dockable interface * New subreport wizard * New styles library * New translation status plugin * New date and percentage tools * New load/save query buttons * Serveral bug fixes and improvements See details on iReport 1.2.1 What's new? page! (http://ireport.sourceforge.net/index.php?p_module=page&pageid=32) iReport home page: http://ireport.sf.net Download it now: http://sourceforge.net/project/showfiles.php?group_id=64348

By: jasperkan - jasperkannan Last PageFooter in Subreport Issue 2006-04-07 06:36 Subreport last page footer moves up in the pa ge if the details band has less number of records to fill the entire page .Since i am putting the page number in the last page footer , the Page X of Y is coming to the middle of the page . Its surprisng since in the main page , the last page footer stays in the bottom of the page . why its not behvin the same in subreport ? I have added Subreport to the SUMMARY Field of tehy main report .is this the culprit ?

By: bulkao - bulkao Dynamic valorization of attributes ? 2006-04-06 08:01 Hi, I would like to valorize an tag attribute (e.g: the height attribute on a <reportElement>) at runtime, that is at "fill" time. So i tried something like this (in jrxml file): [...] <parameter name="hBand" isForPrompting="true" class="java.lang.Integer"/> [...] <reportElement mode="Transparent" x="0" y="10" width="515" height="<![CDATA[integer.parseInt(hBand)]]>" ... /> It fails ! Any workaround ? Thanks in advance. By: bulkao - bulkao RE: Dynamic valorization of attributes ? 2006-04-07 01:32 Maybe the solution stands in giving a "key" to the <reportElement>, and adressing the key in a scriptlet ?... But how to do this ? Thanks for any help...

By: M. Overdijk - marceloverdijk JasperReports works on GlassFish 2006-04-06 22:31 I've just successfully deployed the JasperReports demo webapp on the latest GlassFish build (b42). See these links: http://blogs.sun.com/roller/page/theaquarium http://blogs.sun.com/roller/page/theaquarium?entry=jasperreports_on_glassfish http://wiki.java.net/bin/view/Projects/GlassFishExtras http://www.jroller.com/page/marceloverdijk/Weblog/jasperreports_works_on_glassfish Regards, Marcel

By: velatro - velatro I don't want to display subreport when empty? 2006-04-03 07:42 Hi all, I have a subreport like that; (Appaerance of my subreport in main report.) ----------------------------------------- Training(*) ----------------------------------------- Description(*) |Date(*) |Place(*) ----------------------------------------- ...... (*) Static fields. Now, if my subreport does not contain any records, I don't want to display this static variables. (Subreport) How can I do this? Thank's all.. By: jasperkan - jasperkannan RE: I don't want to display subreport when empty? 2006-04-06 14:04 use PrintWhenExpression n the Subreport when u add the subreport to the main report.So ur subreport wont be printed if the condition is false

By: bulkao - bulkao Displaying a chart in more than 1 page 2006-04-06 05:29 Hi everyone, Got a jasper reports with an embedded Chart Scriptlet. This scriptlet may be very "tall" (about 1500 or 2000). I didn't found a tag which let the Chart being displayed on many pages of the report. Is it possible ? Any idea concerning this ? Thanks. Best regards. By: bulkao - bulkao RE: Displaying a chart in more than 1 page 2006-04-06 05:57 (response to myself) There's no "page" entity. In order to display "tall" charts, you have to paly with height attributes on <reportElement> tag, then cascading height attributes on <band> and <jasperReport> tags....

By: Thiago Almeida - thiago_almeida Subreport page break 2006-03-23 10:09 Hello, i have this situation. I have 3 JasperReport files that are passed by parameter to my master report. I need to put them into the master as subreports. I've created 3 different groups and have put each file in a separate group. My question is: How can i break the page after each subreport presentation ? I've tried all kinds of things but it seems not work. Any sugestions, Thank you, Thiago By: Daren O - rckrll106 RE: Subreport page break 2006-03-29 07:14 If you put your subreports in seperate groups and "start on a new page" that should work. You might have to play around with the "min height to start a new page" By: C-Box - c-box RE: Subreport page break 2006-04-05 01:49 The thing is, that if you are using dummygroups the "StartNewPage" feature of the group is not working, because the group-expressions never change for the current record. Even if you are using different group-expressions like "1" , "2" and "3" you won't get the expected page-break. So a page-break element like I already suggested some times would be REALLY REALLY great.... then the using of dummy groups just for getting pagebreaks would be history!!!! Please (Teodor) write your opinion towards this. greetings from Germany C-Box

By: David Sachdev - dsachdev Drill Downs 2006-03-29 19:51 I know this is an old topic, and I have gone through the forums looking for the topic, but I am wondering if anyone has simulated drill downs in JasperReports sucessfully using a hyperlink on a report element to launch a second report using the parameter that was cliked on. I am using hibernate and JSF with jasper. By: Doug Berkland - berkland RE: Drill Downs 2006-03-30 08:33 I created a report:// protocol that runs reports in our custom reporting framework. The protocol takes a report key that points to a configuration set that includes the jasper location. The query portion of the URL is used to pass parameters to the subreport. e.g. "report://CUSTOMER_LIST?state=AK" would load the jasper file defined in the CUSTOMER_LIST report configuration, and store "AK" in the parameter map with a key of "state". The datatype from the report field is examined to allow non-String datatypes to be parsed and passed. The protocol is registered using the "java.protocol.handler.pkgs" system property. We use that protocol when creating drilldown reports. When we save the reports, we modify the URL in JRPrint object to point to the location the subreport was saved to. This lets the same viewer be used for live reports and saved reports. By: Doug Berkland - berkland RE: Drill Downs 2006-03-30 08:43 Our implementation is in a rich-client with a Swing-based report viewer application. For a JSF application the implementation would be slightly different. You would want to use http protocol, maybe point it to a servlet that maybe gets passed the report key and all of the selection criteria for the drilldown. By: David Sachdev - dsachdev RE: Drill Downs 2006-04-04 12:33 Thanks! Hopefully I will have a my working drill downs before too long. Finishing up the "destination" report now, and them implementing drill downs in a similar fashion.

By: Shireesh Anjal - anjalshireesh Ignoring records based on condition 2006-03-30 00:02 Hi, We have a requirement wherein the report engine should be able to ignore certain records based on certain criteria. (This criteria can be set as an expression that returns a Boolean value - true or false). If the value of the given expression is true, then that particular record (row from the data source) should be ignored and next row should be fetched and evaluated. e.g. Ignore all rows where value of the field partTranType is "C". (This is just a simple example, there can be more complex conditions). The expression can contain variables, fields, parameters and constant values. Please let me know how this can be achieved with JasperReports. Thanks and regards, Shireesh Anjal By: jasperkan - jasperkannan RE: Ignoring records based on condition 2006-03-31 14:30 use the flag value ie partTanType='C' set the PrintWhenExpression expression to true for the entire field. so if the field value doesnt match entire row gets skipped. By: jasperkan - jasperkannan RE: Ignoring records based on condition 2006-03-31 14:30 use the flag value ie partTanType='C' set the PrintWhenExpression expression to true for the entire fields . so if the field value doesnt match entire row gets skipped. By: Shireesh Anjal - anjalshireesh RE: Ignoring records based on condition 2006-04-03 10:38 Hi, Setting printWhenExpression will ensure that the record will not be printed on the report. However detail evaluation will still happen for these records, and hence the evaluation of all variables will also happen. My requirement is that whenever the predefined condition is true, the current row should be ignored and none of the variables should be evaluated for this row. The next row should be fetched immediately and the detail evaluation should happen on this row (if the condition is not true for this row). Let me give a small example to explain this. Let us say the data coming from the data source is as follows: ================ emp_no salary 1001 20000 1002 30000 1003 40000 1004 50000 1005 10000 1006 23000 ================ In the report, we need to print all employees whose salary is greater than 25000, and also the sum of salaries of such employess. i.e. the report should look like: ======================================== Employees having salary more than 25000: emp_no salary ================ 1002 30000 1003 40000 1004 50000 ================ Total 120000 ======================================== For calculating the total of salaries, we need to define a variable (sum_sal) of type sum and expression as $F{salary} If we use printWhenExpression in the detail band to print only those rows where salary is more than 25000, the number of records will be correct, however the variable sum_sal will still contain the total of all the records, which will be 170000. I know that we can still manage by putting a ternary operator in the variable expression - something like: $F{salary} > 25000 ? $F{salary} : new BigDecimal(0) However this will become really tedious and user unfriendly if there are too many variables in a report. Hence we need a mechanism wherein the user can specify a condition, which being true, those records coming from data source will be ignored - not just while printing the detail band, but also for variable evaluation. It is true that such situations can be best handled by not sending such data from the data source, however it may not always be possible. e.g. Our data source is a custom data source that provides the data from a flat file. And since it (the custom data source) can not access variables/parameters from the report, there is no way it can filter data based on a user specified condition. Probably we need some tag in the JRXML file where user can specify a condition for ignoring records. When this condition evaluates true, the present record should be discarded and the next one should be fetched before any variable evaluation happens. Or at least some API function that I can invoke from my scriptlet (inside beforeDetailEval) so as to move to the next record without evaluating any variables. Thanks and regards, Shireesh Anjal

By: Yaroslav Novytskyy - ynovytskyy Dynamic SQL Query 2006-03-31 01:16 Hello, is it possible to build SQL query depending on the Boolean parameter, passed to the report? example: I have a parameter Boolean LAST_EVENT_ONLY and depending on it would like to build query: SELECT name, time FROM events WHERE 1] $P{LAST_EVENT_ONLY} == false time >= $P{start} AND time <= $P{end} 2] $P{LAST_EVENT_ONLY} == true time = ( SELECT MAX(time) FROM events WHERE time >= $P{start} AND time <= $P{end} ) is this possible on the report side? or is it a must in this case to form a WHERE part in java code, pass it as a parameter and then include as $P!{WHERE_PARAM}. If yes can I include params in in such a string? By: nsorochan - nsorochan RE: Dynamic SQL Query 2006-03-31 06:57 If this is oracle you can use a case statment in the query. I believe postgres has similar capabilities. Not sure about other databases. By: cyclistca - cyclistca RE: Dynamic SQL Query 2006-03-31 09:15 I've done it two ways 1. Built the code in my java application and passed the where clause as a parameter 2. Make a main report with a header and dummy sql. I then built the SQL in s scriptlet and passed it to a subreport for execution.

By: slowfinger - slowfinger returning current row count of subreport 2006-03-28 21:59 Hi, I have following situation ... My report output shows a 1 to n relationship for that case it has an subreport which contains another subreport. Now the first subreport should display a line number of the current dataset which was printed by the child subreport. How I can do that ? Any suggestions ? Thanks in forward. Rico By: Daren O - rckrll106 RE: returning current row count of subreport 2006-03-29 07:10 There is a way in jasper reports to return variables from a subreport and store them into a variable in the main report. It is in the jasper reports guide, section 12.3 I have to admit it hasn't worked well for me. I found it easier to create a HashMap in the main report, pass it to the subreport as a subreport parameter. The subreport can store values in the map which you can use in your main. I use this if I want to return totals but you could return the row count as well. Hope this helps.

By: Subhashini Sekar - ss161213 unable to load .jasper subreport in unix 2006-03-29 06:45 We are using jasper for generate reports. we have created jrxml via iReport. We have written a servlet which will create the report on the fly. My application is working fine when i run it in Windows environment. we are using oracle app server. But the same thing is not workin with Unix. it says unable to load <xxxx.jasper> in the following method call. JasperFillManager.fillReport(report, parameters,conn); one more query is the xml created by iReport is in UTF-8 format how can i convert that into UTF-16 format By: Daren O - rckrll106 RE: unable to load .jasper subreport in unix 2006-03-29 07:05 First, I'm assuming you've compiled the jrxml and the jasper is in a directory on your unix machine. I'm also assuming your passing the file name to the fillReport call? If so, my initial thought is to check your file path. I use a system property set to the jasper report directory. On our unix machines we change the system property to point to the correct location. Hope this helps.

By: slowfinger - slowfinger frame over over more than one band 2006-03-28 21:48 Hi, I have a tabular layout. The labels are placed in the columnHeader, the details contains nothing but I have a lot of dummy groups in order to separate the contents of the subreports which display it's content. But the layout of such tabular layout would really looks better if I could frame the content. But how I can do that in the layout over the dummy groups ? Any ideas ? Thanks in forward. Rico

By: slowfinger - slowfinger nestings subreports and xml data source 2006-03-20 22:57 Hi All, I posted already to the same subject some days ago, but nobody helps so I want to try it again. I want to describe it a bit more detailed ... What I want is to output data which are not in flat hierarchy instead the report contains main data and referenced data which are 1 to n related. I use xml data source. A short example follows: <Problemwurzel> <StandardberichtProblemVO> <Problem> <Problemdatum></Problemdatum> <ProblemKurztext></ProblemKurztext> </Problem> <Bearbeitungsschritte> <StandardberichtBSAnalyseVO> <BearbeitungTs> 2005-03-09 15:28:51.907652 </BearbeitungTs> <Bemerkung> <Text>Analyse Text</Text> </Bemerkung> </StandardberichtBSAnalyseVO> <StandardberichtBSMassnahmeVO> <VorgBearbTs> 2005-03-09 15:28:51.907652 </VorgBearbTs> <SollEinsatz>22.10.2005</SollEinsatz> <DurchfuehrDatum>13.03.2006</DurchfuehrDatum> <Bemerkung> <Text>Massnahme 1</Text> </Bemerkung> </StandardberichtBSMassnahmeVO> <StandardberichtBSMassnahmeVO> <VorgBearbTs> 2005-03-09 15:28:51.907652 </VorgBearbTs> <SollEinsatz>01.03.2006</SollEinsatz> <DurchfuehrDatum>14.03.2006</DurchfuehrDatum> <Bemerkung> <Text>Massnahme 2</Text> </Bemerkung> </StandardberichtBSMassnahmeVO> </Bearbeitungsschritte> </StandardberichtProblemVO> </Problemwurzel> The relation between <StandardberichtBSAnalyseVO> and <StandardberichtBSMassnahmeVO> is 1 to n and is defined by timestamps: /StandardberichtBSMassnahmeVO/VorgBearbTs -> StandardberichtBSAnalyseVO/BearbeitungTs The root path which I use for the main report is as follows: /Problemwurzel/StandardberichtProblemVO The report structure looks as follows: - the main report which reference problem data: Problem/Problemdatum and so forth -- a subreport with dataSourceExpression: ((net.sf.jasperreports.engine.data.JRXmlDataSource) $P{REPORT_DATA_SOURCE}).subDataSource("/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSAnalyseVO") subreportExpression: "analyse.jasper" -- the report "analyse.jasper" contains the analyse text (Bemerkung/Text) and another subreport which should list <StandardberichtBSMassnahmeVO> elements, that I do with dataSourceExpression: dataSource("/Problemwurzel/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSMassnahmeVO[VorgBearbTs=" + $F{analyseBearbeitungTs} + "]") subreportExpression: "massnahme.jasper" That subreport reference the massnahme elements: SollEinsatz, DurchfuehrDatum, Bemerkung/Text My problem is now the massnahme data will not be displayed and I can't say why. So I need your help. How can I do that? Thanks in forward Rico By: slowfinger - slowfinger RE: nestings subreports and xml data source 2006-03-21 09:19 Hi, I really really need help on this subject and it seems that it should work but not on me. c-box wrote that it's working fine and mostly its because of wrong datasource expressions. But it would really help if one of that short answers show a short example. Please help I think it wouldn't help only me. Thanks in forward Rico By: Lucian Chirita - lucianc RE: nestings subreports and xml data source 2006-03-21 09:33 Hi When you do subDataSource("..") in the first report, a document is created having as root node this report's current node (/Problemwurzel/StandardberichtProblemVO) and this document is used by the second report. Therefore, in the second report StandardberichtProblemVO is the root node so when you instantiate the third report you should not use "/Problemwurzel/StandardberichtProblemVO/.." but "/StandardberichtProblemVO/..". HTH, Lucian By: slowfinger - slowfinger RE: nestings subreports and xml data source 2006-03-21 22:58 Hi Lucian, thanks for your answer. I tried your suggestion but it doesn't help. I debugged the code and stepped into jasper sources and what I wonder is that the second call for dataSource() of the nested subreport will never be called. What could be the reason for that. Rico By: Lucian Chirita - lucianc RE: nestings subreports and xml data source 2006-03-22 00:27 I don't have any clue. It worked for me with your xml data after making the change I mentioned in my previous post. Regards, Lucian By: slowfinger - slowfinger RE: nestings subreports and xml data source 2006-03-22 01:51 Thanks, yes it works. What I've done that it works was a really short master which contains only the subreport. That I called from iReport with the data source and it works. You are correct. Now I have to evaluate what the difference is between my original report when I call it from java. Thanks again Rico By: slowfinger - slowfinger RE: nestings subreports and xml data source 2006-03-28 08:54 I found the problem. It's the subreports which I pass as a Map to the parameter map of Jasper. If I use a subreport in an subreport I have to pass the subreports as a subreport parameter and it works like expected. Rico

By: legion - cajinadiaz How display ORDSYS.ORDIMAGE in jasper?? 2006-03-28 07:13 It 's posible display a ORDSYS.ORDIMAGE image from Oracle database in a jasperreport.. ??

By: mclanza - mclanza Graphs with JFreeChart 2006-03-28 05:09 I'm trying to make a PDF report with a table with some data and a graphic using JFreeChart. I've done each of them but I couldn't make them together in a single PDF. Can anyone help me? (Sorry for my English, I'm very bad with it... I hope you understand me...)

By: jack - jackysan55 pdf 2006-03-21 19:46 how to export from .jrxml to .pdf?? help! By: lazzeroni - lazzeroni RE: pdf 2006-03-28 04:43 JasperDesign jasperDesign=JRXmlLoader.load("C:\Documents and Settings\steve\Bureau\demonstation\ireport\scenario2\senario2.jrxml");//redéfinir le fichier source xml //VERIFIER POUR XML //JasperDesign jasperDesign = JRXmlLoader.load("C:\senario.xml"); JasperReport jasperReport=JasperCompileManager.compileReport(jasperDesign); // JasperReport jasperReport=JasperManager.compileReport(jasperDesign); //envoie des données passé en parametre Map parameters=new HashMap(); parameters.put("titre","titre"); //exécution du rapport avec insertion dans la base JasperPrint jasperPrint=JasperFillManager.fillReport(jasperReport,parameters,conn); //format pdf // JasperExportManager.exportReportToPdfFile(jasperPrint,"c:\senario1jasper.pdf"); //format xml //JasperExportManager.exportReportToXmlFile(jasperPrint,"c:\senariojasper.xml",true); // impression du document // JasperPrintManager.printPage(jasperPrint,1,true); // visualisation du rapport JasperViewer.viewReport(jasperPrint);

By: lazzeroni - lazzeroni print with jasperreport 2006-03-28 04:41 how can your print out of multi-vat with jasperreport. is this possible? can you one differentiate the title page, and the last page of the other pages