2006 JR Open Discussion

By: jerrymouse - zkf5902 one problem in chapter 7 (about jasperreports 2006-03-23 20:32 hi, everybody Page 206: Next you need to compile the report. You can do so by using the class com.opensymphony.webwork.views.jasperreports.CompileReport. but i have a error when compiling, the error log is: JasperReports Compiling: D:/workspace/HelloWebwork/resources/users.xml java.io.FileNotFoundException: D:workspaceHelloWebworkusers.class (系统找ä¸åˆ°æŒ‡å®šçš„文件。) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.<init>(FileInputStream.java:106) at net.sf.jasperreports.engine.util.JRLoader.loadBytes(JRLoader.java:315) at net.sf.jasperreports.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:159) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:171) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:130) at com.opensymphony.webwork.views.jasperreports.CompileReport.main(CompileReport.java:28) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:86) and my definition file is users.xml: <?xml version="1.0"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="users"> ... Could you help me? thanks. I use the IDE(eclipse RCP), and run the command with the ide's application model. the command detail is: java -classpath "....." com.opensymphony.webwork.views.jasperreports.CompileReport D:/workspace/HelloWebwork/resources/users.xml and i'm sure the command is right. but what 's the problem? the line in the users.xml: <jasperReport name="users">...</jasperReport> and the line in the error logs: java.io.FileNotFoundException: D:workspaceHelloWebworkusers.class what's the relation between the name attribute and the error? So sorry for my poor english:)

By: Rizwan - rizmerc Accessing lists within collection bean 2006-03-23 12:03 Hi, I am trying to create a report of orders which I am passing to jasper as a collection using the JRBeanCollectionDataSource data source. In the detail section, when I list each order, I would like to access a list called "packages" for that particular order and display the details of each of the packages for that order. So an order can have one or more packages. My question is how do i access the "packages" list inside the order object? My report needs to look something like:- Order# 955 Consignee: XYZ Package 1 weight : 12 lbs Package 2 weight : 15 lbs Package 3 weight : 2 lbs Order# 956 Consignee: ABC company Package 1 weight : 1 lbs Package 2 weight : 9 lbs Package 3 weight : 4 lbs

By: Painter - torlh About page number 2006-03-16 23:54 Hello, My name is Curt Huang. I have a question here. In JasperReport 0.6.0, we can have batch export using parameter JRExporterParameter.JASPER_PRINT_LIST. After we export three reports which contains page number to one file, the file still keeps the original page numbers of each report. I suggest this exported file may generate the page numbers again for all pages. Thus all pages in the exported file has continus page numbers. Thank you! Curt By: jasperkan - jasperkannan RE: About page number 2006-03-17 09:48 Its not clear wht you mean here ? do u mean that if a report has subreports , then page number of the subreport should be continous ? I think the subreport page number is independent of the main report ,so it starts again from 1 . To solve this, We are passing PAGE_NUMBER as a parameter to the subreport and using it to set page numbers . By: Painter - torlh RE: About page number 2006-03-22 19:02 Hi, Let me clarify my question here. For example, in the demo sample,"batchexport",we have three jrxml files(Report1,Report2 and Report3) which has their independent page number. After we use the JASPER_PRINT_LIST parameter to combine the three reports and export to one file like PDF. The page numbers in the exported file has original numbers from the three report files which are not a series. I think sometime we may need to change page numbers in the exported file such that we can have continous page numbers in the exported report file.

By: Yemelianov - yemelianov Getting ClassCastException when using count() 2006-03-20 13:09 Hello, I am new to SourceForge. I need some help. The situation is simple, but I really do not understand why am I getting java.lang.ClassCastException: java.lang.Integer when trying to create a report. I use the latest version of JasperReports and Hibernate 3. I map my class to a table in my database as follows: <!------------------------------------------!> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.dao.hibernate.mapping.HibernateEntity" table="DMSEntity"> <composite-id class="com.dao.hibernate.mapping.EntityKey" name="key"> <key-property name="dmsCatalogId" column="dmsCatalogId" type="int"/> <key-property name="dmsEntityId" column="dmsEntityId" type="int"/> </composite-id> <many-to-one name="entityType" column="dmsEntityTypeId" class="com.dao.hibernate.mapping.HibernateEntityType"/> <many-to-one name="catalog" column="dmsCatalogId" class="com.dao.hibernate.mapping.HibernateCatalog" insert="false" update="false"/> <property name="profiles" column="Profiles"/> <property name="reference" column="Reference"/> <property name="name"/> <property name="creator"/> <property name="owner"/> <property name="lastModifiedBy"/> <property name="created"/> <property name="archiveTime"/> <property name="status"/> <property name="description"/> <property name="reviseComment"/> <property name="mimeType"/> <property name="versionNumber"/> <property name="revisionType"/> <property name="fileName"/> <property name="fileSize"/> ................. <!------------------------------------------!> My report definition defines <queryString language="hql"><![CDATA[select count(distinct he.entityType) as totalDocs from HibernateEntity he where he.owner=$P{owner} and he.created>'01-jan-2006' group by he.owner]]></queryString> <field name="totalDocs" class="java.lang.String"/> ......... <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="260" y="4" width="100" height="18" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new String($F{totalDocs})]]></textFieldExpression> </textField> ............ when i execute JasperPrint jp = JasperFillManager.fillReport(report,parameters); logger.debug(CLASS_NAME,"Report begins"); JasperExportManager.exportReportToPdfFile(jp,application.getRealPath("/")+"/jsp/jasperreports/demo1.pdf"); I am getting the error: java.lang.ClassCastException: java.lang.Integer at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource$IndexFieldReader.getFieldValue(JRHibernateAbstractDataSource.java:276) at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.getFieldValue(JRHibernateAbstractDataSource.java:236) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:727) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:932) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:730) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) I gues there is something wrong with my query, but I cant figure it out? Can you give me some advices? Or may be I may use some variable to have the same result as my original HQL query does. Once again, the query is defined as select count(distinct he.entityType) as totalDocs from HibernateEntity he where he.owner=$P{owner} and he.created>'01-jan-2006' group by he.owner Sincerely. By: Lucian Chirita - lucianc RE: Getting ClassCastException when using cou 2006-03-21 08:50 Hello The problem you faced was due to a bug in the code. A fix has been commited on CVS (look for JRHibernateAbstractDataSource.java rev 1.3). As a workaround (if you don't want to patch the JR code and rebuild it), you can change your query to select another dummy expression (which you can otherwise ignore): select count(distinct he.entityType) as totalDocs, 0 as dummy from HibernateEntity he ... Thanks, Lucian By: Lucian Chirita - lucianc RE: Getting ClassCastException when using cou 2006-03-21 09:12 Note that you will also need to change the type of the totalDocs field to something compatible with java.lang.Integer, as the query returns an integer value for count(...) Regards, Lucian By: Yemelianov - yemelianov RE:issue with agregate count() for hibernat3 2006-03-21 11:55 Thank's a lot for the fix. The proplem is solved. I actually recompiled JR with newest JRHibernateAbstractDataSource.java. Regars.

By: Afhrad - afhrad patch for subscript / superscript styles 2006-03-21 06:50 to whom it may concern.... I've made a patch based on the current JR version 1.2.0 to extend the <style> syntax for the recognition of super- and subscript attributes. So far everything is working, due to a trick. From what I learned through the internet, TextAttribute.SUPERSCRIPT will not be rendered nicely on java 1.5.x and is NOT rendered on prior versions (correct me if I'm wrong). We are developing with 1.4.x, so the java 5 stuff could not be verified by me. For the time being, I changed the textsize and added a transformation to shift the corresponding characters up and down. This is totally sufficient for us and I would ask Teodor to review the code and possibly integrate it in a forthcoming release if this is of value for you.

By: kaushal desai - kaushal_ndesai subreport not dispalyed..plz help... 2006-03-21 04:31 hi.. i m not able to get subreport displayed with master report .... can any one help me out... Thanks in advance.... i have the following code written in Action class::: ArrayList detaillist; JasperReport subreport=null; if(detaillist.size() > 0) { JRDataSource datasource1 = new JRBeanCollectionDataSource(detaillist); JasperPrint jasperPrint; String temp = request.getRealPath("pages"+ "/reports//SubReport.jasper"; subreport = (JasperReport)JRLoader.loadObject(temp); jasperPrint=JasperFillManager.fillReport( subreport,parameters1,datasource1); StringBuffer pdfPath1 = new StringBuffer(request.getRealPath("pages/reports/jasperReportsPDFs")); String pdfFile1 = "subreport.pdf"; pdfPath1.append("/" + pdfFile1); JasperExportManager.exportReportToPdfFile(jasperPrint,pdfPath1.toString()); } // for master report.... // passing subreport as a parameter to master report parameters.put("subreport", subreport); jasperReportViewer.getPDFReport(request,response,datasource,parameters,reportFile,pdfPath.toString()); AND public void getPDFReport(HttpServletRequest request, HttpServletResponse response,JRDataSource dataSource, HashMap parameters, String reportXMLPath, String pdfFileName) { try { JasperReport jasperReport = JasperCompileManager.compileReport(reportXMLPath); JasperPrint jasperPrint = new JasperPrint(); jasperPrint = JasperFillManager.fillReport(jasperReport,parameters, dataSource); JasperExportManager.exportReportToPdfFile(jasperPrint,pdfFileName); } catch (JRException jre) { jre.printStackTrace(); }

By: chenwj - cwscwj I really need help,filling date to subreport 2006-03-11 22:48 as i was executing filling date to subreport in my java programe, there is a err like that'net.sf.jasperreports.engine.JRRuntimeException: Error preparing statement for executing the report query : select * from proTable where unitKind ='aa ', seems it couldnt pass the parameter value to the subreport, pls help me, this question already trouble me many days By: chenwj - cwscwj RE: I really need help,filling date to subreport 2006-03-13 19:15 hello, all ,pls give me some suguestions on how to slove this question, i have tired to many ways but doesnt work at all, many thanksssss firstly By: nsorochan - nsorochan RE: I really need help,filling date to subrep 2006-03-13 21:56 need more information please. Can you post the code? The query? the jrxml? Is the parameter listed as a data in the report? By: Slobodan Kasterovic - kaster RE: I really need help,filling date to subrep 2006-03-14 00:18 I can just join nsorochan! This is really unsufficient illustrated problem! We need at least jrxml! By: chenwj - cwscwj RE: I really need help,filling date to subreport 2006-03-14 18:06 yes, buddy, i will sent my jrxml file and my code for you to test, and could you give me your email address or sth to contract with , if possible , could you use someone instant messaging service , e.g Msn, throught add in friends list then have a commuincation online, it will be more helpful to me ..thank you very much~!!! By: chenwj - cwscwj RE: I really need help,filling date to subreport 2006-03-14 18:15 // to compile the subreport jrxml file , and get a subrepot jasper file String jasperSubFileName= JasperCompileManager.compileReportToFile("F:\ireport\iReport-1.1.0\subTestReport.jrxml"); JasperReport comSub = (JasperReport)JRLoader.loadObject(jasperSubFileName); // to push comSub object to the master report that is name of 'testReport', parameters.put("testReport", comSub); ////to compie master report .jrxml file into .jasper formate String jasperFileName= JasperCompileManager.compileReportToFile("F:\ireport\iReport-1.1.0\testReport.jrxml"); /////////////////////fill date String jrprintFileName= JasperFillManager.fillReportToFile(jasperFileName, parameters,getConnection()); my code is similar to the way done in the sample demo, and my sql query is select totalNum,unitNum,bioChemi,anti,chemi,midMed,midCre,others, unitKind,zongshu,buhege from proTable where unitKind =$P!{unitKind}, if you needs more information, pls tell me : cwscwj@hotmail.com thank you very much again~!! By: chenwj - cwscwj RE: I really need help,filling date to subreport 2006-03-14 18:59 btw, i dont understand why there is a code like this "parameters.put("ProductsSubreport", subreport);" in the jasperreport demo, and it's unsuccessful for me to compile this words, coz the 'ProductsSubreports' is a subreport name but not a master name, the comiplier displays this err like 'net.sf.jasperreports.engine.JRException: Incompatible net.sf.jasperreports.engine.JasperReport value assigned to parameter subTestReport in the testReport dataset.', could you tell me which one is right to use bewteen master report name or subreport one , as i use master report name as my first parameters in the put() method, the compiler displays my front error in the thread " By: chenwj - cwscwj RE: I really need help,filling date to subreport 2006-03-18 22:53 Hello all,, pls give a look at my issue.., many thanks... im trying to many ways in order to slove the question but fails again... By: chenwj - cwscwj RE: I really need help,filling date to subreport 2006-03-20 23:35 thanks all that care my issues and give helps to me ,,i already slove this question, a bit hard to explain it clear in a words, if you have similar quesion you could email to me : cwscwj@hotmail.com and there r two advice on my issue: 1.take care of using the method of 'setAutoCommit()' 2. take care of the property of the imagine expression class in your subReport attribute , eithor to use String or Jasperreort

By: mccools - jc_mccauley JDT Compiler needed moving 0.6.8 to 1.x.x 2006-03-20 07:13 Greetings, Apparently, after moving form JR 0.6.8 to 1.02 or 1.1.1, I need the JDT Compler...What changes made this necessary? How, using JasperAssistant can I configure Eclipse to use the JDT Compiler as opposed to the standard JRE 1.4 compiler? TIA

By: slowfinger - slowfinger reference xml data 2006-03-18 15:34 Hi all, My report data are xml data so I used JRXmlData. The data structure is as follows: <Problemwurzel> <StandardberichtProblemVO> <Problem> <Problemnummer></Problemnummer> </Problem> <Bearbeitungsschritte> <StandardberichtBSMassnahmeVO> <VorgBearbTs> 2006-03-14 15:09:50.171686 </VorgBearbTs> <Bearbeitungsart> </Bearbeitungsart> </StandardberichtBSMassnahmeVO> <StandardberichtBSAnalyseVO> <Bemerkung> <Text> some text</Text> </Bemerkung> <BearbeitungTs> 2006-03-14 15:09:50.171686 </BearbeitungTs> <Bearbeitungsart> </Bearbeitungsart> </StandardberichtBSAnalyseVO> </Bearbeitungsschritte> </StandardberichtProblemVO> </Problemwurzel> The root XML Path is: /Problemwurzel/StandardberichtProblemVO I want to reference some of "StandardberichtProblemVO" elements and than all "StandardberichtBSMassnahmeVO" elements per "StandardberichtBSAnalyseVO" which is referenced by the relation of StandardberichtBSMassnahmeVO/VorgBearbTs->StandardberichtBSAnalyseVO/BearbeitungTs How I can do that. I tried a lot but nothing works. So I tried: Masterreport with : /Problemwurzel/StandardberichtProblemVO and subreport data source expression: dataSource("/Problemwurzel/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSMassnahmeVO") and in that subreport with dataSource("/Problemwurzel/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSAnalyseVO[bearbeitungTs=" + $FmassnahmeVorgBearbTs + &quot]") to output the analyse bemerkung. Who can help I really frustrated to realize this. Thanks in forward Rico

By: Dave Cherkassky - dcherk Thread-safe connections? 2006-03-17 15:06 We are trying to run a subreport within a report. However we are getting an exception thrown from the subreport code because it is trying to use the same java.sql.Connection as was passed into the report. Apparently the subreport is running on a different thread. Our implementation of java.sql.Connection detects that it is being used by 2 threads at the same time and throws an IllegalStateException. Questions: - do we have to have threadsafe Connection objects to run subreports? - what if the Connection is closed by the calling thread before the subreport is finished? Does the calling thread wait for all subreport threads? - does each subreport have it's own thread and do they run in parallel? - I assume that if Jasper Reports is using multiple threads it is doing thread pooling? How do we configure the pool?

By: jms - xblackfire how to use jasper reports with barcode4j? 2006-03-17 07:14 i'm a newbie with jasper reports, the report i need requiered the generation of codebar39 from mysql db, i need to know if is posible use barcode4j to genereate the code bar image in the report via scriptlet or if somebody can provide some example of jasper reports with codebar generation, or some reference and many thanks for the people who answer my question.

By: Duncan - dc72 Returning Multiple values from one parameter 2006-03-17 05:38 Hey, Is it possible to retrun multiple values from one parameter? The parameter result will be returned from a sql query. When selecting the parameter a description will be displayed and when selected and submitted need to pass two values to the main source query. The values will be for example a REC_ID and MODEL_ID. ThanX, DC

By: Stefano - szaccaria JRCsvDataSource COLUMN problem 2006-03-17 05:01 Hi Teodor, I found a bit bug in the JRCsvDataSource: at the line 113 is write: columnIndex = Integer.getInteger(fieldName.substring(7)); but I thought that it write as: columnIndex = Integer.parseInt(fieldName.substring(7)); otherwise it lauch a exception. I hope this help to you Ciao Stefano

By: Bruce Martin - bruce_a_martin Datasource for Fixed field width (Cobol) 2006-03-17 04:08 If anyone is interested, I have added a Jasper Datasource for Fixed Width Data files (i.e. Cobol) to the RecordEditor project http://record-editor.sourceforge.net/. It can handle both Text and binary files. For details see http://record-editor.sourceforge.net/re2Jasper.htm. Note this is still very much an example program and needs more testing

By: Stefano - szaccaria PDF quality resolution 2006-03-17 01:55 Is possible to change the resolution of pdf as do pdfcreator ? Like jpg compression, text compression etc? I use " asperExportManager.exportReportToPdfFile(jasperPrint, pdfPathFile)" method, exists some other method that change the compression level? Ad example .setDPI( int dpi ) or setCompression( in compression ) ? Thanks in advance Stefano By: Teodor Danciu - teodord RE: PDF quality resolution 2006-03-17 02:26 Hi, A new PDF exporter parameter called IS_COMPRESSED was added this week. Check the CVS version and see if it is what you need. PDF files do get smaller, but not a lot smaller. Thank you, Teodor By: Stefano - szaccaria RE: PDF quality resolution 2006-03-17 02:47 Thanks to you Teodor, have you got some idea to integrate other methods to export pdf? Like resolution, compression etc. In next release of jasperReports ? Thanks Stefano

By: Painter - torlh About page number 2006-03-16 22:46 Hello, My name is Curt Huang. I have a question here. In JasperReport 0.6.0, we can have batch export using parameter JRExporterParameter.JASPER_PRINT_LIST. After we export three reports which contains page number to one file, the file still keeps the original page numbers of each report. I suggest this exported file may generate the page numbers again for all pages. Thus all pages in the exported file has continus page numbers. Thank you! Curt

By: cvconover - cvconover Hyperlink Target 2006-03-16 13:24 I want to create a report that generates html files with links. These html files will be in frameset, so I want the links to target specific frames, but it appears that the target attribute for hyperlinkReferenceExpression and others only allows "Self" and "Blank" as values. Is there a way to specify a custom named frame target? I guess I could resort to generating the html markup directly, but would rather avoid that.

By: jeffrey willis - jeffrey_willis Problem with JRLoader 2006-03-16 06:24 --Is anyone experiencing the problem that I am? --I have a report. --It generate once, but if I try generating it twice I get the following error stack trace: 06/03/16 08:18:15 java.lang.ClassNotFoundException: net.sf.jasperreports.engine.base.JRBaseSubreport 06/03/16 08:18:15 at java.lang.ClassLoader.findClass(ClassLoader.java:341) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClass(ClassLoader.java:289) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClass(ClassLoader.java:235) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) 06/03/16 08:18:15 at java.lang.Class.forName0(Native Method) 06/03/16 08:18:15 at java.lang.Class.forName(Class.java:219) 06/03/16 08:18:15 at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:558) 06/03/16 08:18:15 at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1513) 06/03/16 08:18:15 at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1435) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1626) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324) 06/03/16 08:18:15 at java.util.ArrayList.readObject(ArrayList.java:547) 06/03/16 08:18:15 at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) 06/03/16 08:18:15 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2 5) 06/03/16 08:18:15 at java.lang.reflect.Method.invoke(Method.java:324) 06/03/16 08:18:15 at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:838) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1746) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324) 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:85) 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:62) 06/03/16 08:18:15 at mil.af.aces.eod.reports.servlets.JasperReportServlet.doGet(JasperReportServlet.java :78) 06/03/16 08:18:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 06/03/16 08:18:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 06/03/16 08:18:15 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.j ava:824) 06/03/16 08:18:15 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDis patcher.java:330) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java: 830) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126) 06/03/16 08:18:15 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourceP ooledExecutor.java:186) 06/03/16 08:18:15 at java.lang.Thread.run(Thread.java:534) 06/03/16 08:18:15 NESTED BY : 06/03/16 08:18:15 java.lang.ClassNotFoundException: net.sf.jasperreports.engine.base.JRBaseSubreport 06/03/16 08:18:15 at java.lang.ClassLoader.findClass(ClassLoader.java:341) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClass(ClassLoader.java:289) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClass(ClassLoader.java:235) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) 06/03/16 08:18:15 at java.lang.Class.forName0(Native Method) 06/03/16 08:18:15 at java.lang.Class.forName(Class.java:219) 06/03/16 08:18:15 at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:558) 06/03/16 08:18:15 at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1513) 06/03/16 08:18:15 at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1435) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1626) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324) 06/03/16 08:18:15 at java.util.ArrayList.readObject(ArrayList.java:547) 06/03/16 08:18:15 at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) 06/03/16 08:18:15 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2 5) 06/03/16 08:18:15 at java.lang.reflect.Method.invoke(Method.java:324) 06/03/16 08:18:15 at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:838) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1746) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324) 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:85) 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:62) 06/03/16 08:18:15 at mil.af.aces.eod.reports.servlets.JasperReportServlet.doGet(JasperReportServlet.java :78) 06/03/16 08:18:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 06/03/16 08:18:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 06/03/16 08:18:15 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.j ava:824) 06/03/16 08:18:15 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDis patcher.java:330) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java: 830) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126) 06/03/16 08:18:15 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourceP ooledExecutor.java:186) 06/03/16 08:18:15 at java.lang.Thread.run(Thread.java:534) 06/03/16 08:18:15 NESTED BY : 06/03/16 08:18:15 net.sf.jasperreports.engine.JRException: Class not found when loading object from file : C: projectsaces-eowebreportsBaseSummaryReport.jasper 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:93) 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:62) 06/03/16 08:18:15 at mil.af.aces.eod.reports.servlets.JasperReportServlet.doGet(JasperReportServlet.java :78) 06/03/16 08:18:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 06/03/16 08:18:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 06/03/16 08:18:15 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.j ava:824) 06/03/16 08:18:15 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDis patcher.java:330) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java: 830) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285) 06/03/16 08:18:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126) 06/03/16 08:18:15 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourceP ooledExecutor.java:186) 06/03/16 08:18:15 at java.lang.Thread.run(Thread.java:534) 06/03/16 08:18:15 Caused by: java.lang.ClassNotFoundException: net.sf.jasperreports.engine.base.JRBaseSubrepor t 06/03/16 08:18:15 at java.lang.ClassLoader.findClass(ClassLoader.java:341) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClass(ClassLoader.java:289) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClass(ClassLoader.java:235) 06/03/16 08:18:15 at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) 06/03/16 08:18:15 at java.lang.Class.forName0(Native Method) 06/03/16 08:18:15 at java.lang.Class.forName(Class.java:219) 06/03/16 08:18:15 at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:558) 06/03/16 08:18:15 at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1513) 06/03/16 08:18:15 at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1435) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1626) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324) 06/03/16 08:18:15 at java.util.ArrayList.readObject(ArrayList.java:547) 06/03/16 08:18:15 at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) 06/03/16 08:18:15 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2 5) 06/03/16 08:18:15 at java.lang.reflect.Method.invoke(Method.java:324) 06/03/16 08:18:15 at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:838) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1746) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845) 06/03/16 08:18:15 at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769) 06/03/16 08:18:15 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274) 06/03/16 08:18:15 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324) 06/03/16 08:18:15 at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:85) 06/03/16 08:18:15 ... 11 more --The error is being thrown by the JRLoader class. --To be more specific Object loadObject(File file) method. By: Teodor Danciu - teodord RE: Problem with JRLoader 2006-03-16 07:12 Hi, It might be related to the Orion server. Some class loader problems in Orion came up in the past. Could you deploy the same application on a different server? I hope this helps. Teodor By: jeffrey willis - jeffrey_willis RE: Problem with JRLoader 2006-03-16 11:09 Teodor, Thanks for you response, thus right now I have the report in an application deployed on an OC4J webserver.

By: Lutz Mueller - lutz_mueller using CallableStatement when needed 2006-03-16 04:14 Hello, We are using Jasperreports since version 0.4. it is a great product and serves our reporting needs quite well. However , recently we switched our main product to use DB2 as a database backend. i had to call a stored proc inside a report. This did not work because the JRJdbcQueryExecuter always uses connection.prepareStatement(String), and the db2 jdbc driver insists on stored procedures being called by a CallableStatement. So i patched the JRJdbcQueryExceuter to use connection.prepareCall(String) when appropriate (i just use contains("call") on the query string, to determine if its an procedure call). Now my questions are: is there a way to force jasper to use a callableStatement without patching the sourcecode? and, if not, could this patch please be applied to the jasperreports source-tree, so i do not have to "customize" every new version for my needs? lutz mueller

By: Tri YM - littlejarni Is it possible to save Jasperprint object 2006-03-10 05:44 Hi all, Is it possible if we can save the jasperprint object to file and saved to database? So if we execute a report with the same parameter, we don't need querying anymore. We just only call the old jasperprint and show the data. Pls help me.. Thx a lot.. Tri YM By: Daren O - rckrll106 RE: Is it possible to save Jasperprint object 2006-03-10 06:52 You can definately store a jasperprint object. However, you might have noticed some posts here on the issues of serial UID. Anyways, if you upgrade a version of jasper the old reports will throw an error when you read them out. The only way currently to get around this is to save(export) the jasper print object as xml. The store that into the DB. Look into the JRXmlExporter and JRPrintXmlLoader. Hope this helps. By: Code_Slave - code_slave RE: Is it possible to save Jasperprint object 2006-03-15 18:20 yes that is what i do, well actually i store the source & the compiled report on the server. if the compiled report matches the current jasper library version, then it uses the compiled version, if it does not match I use the source report then re-compile. you will still need to query the data

By: Teodor Danciu - teodord [ANN] Report of the Month Contest 2006-01-27 06:44 Submit Your Best Report. Win an iPod Nano. Do you have a excellent report you would like to share? Done something really cool with JR? We invite you submit your best reports, screenshots of applications that were developed with JasperReports, or PDF's of runtime reports. We are looking for JR reports that showcase all of the JasperReports' functionality. Each month a panel of judges will select the best report, and the winner for that month will receive a free iPod Nano. The winning reports will also be posted on our website. All monthly winners will be eligible to win the JasperSoft Report of the Year and a Bose Speaker System. Learn more about and enter the contest here: http://www.jaspersoft.com/best_report.html Good luck! Teodor By: jasperkan - jasperkannan RE: [ANN] Report of the Month Contest 2006-03-07 12:05 Hi teodar , this is a good idea ? would like to clarify , for selecteing the Report of the month wht is the main criteria u look at ? Is it based on the Jasper features used or the look and feel of the UI ? By: Teodor Danciu - teodord RE: [ANN] Report of the Month Contest 2006-03-08 00:05 Hello, I don't think there is a main criteria. At least not in my case (there are several judges that participate). You could have a very complex report that uses many JasperReports features, but the overall document might not look very good. Or we might get beautiful reports that are just simple plain listings. So I would say it is a combination of several criteria including complexity, use of JasperReports features and overall look and feel. Thank you, Teodor By: Barry Klawans - bklawans RE: [ANN] Report of the Month Contest 2006-03-08 08:51 Hi, As one of the judges, my criteria is a report that makes me say "wow" :-) Of course, what causes that will differ from month to month. The first winner (has it been posted yet?) was a complex report but that doesn't mean all entries need to be complex - a simple but concise display of information can win too. For those curious, the judges are sent the output files submitted to the contest without any indication of who submitted them, where they came from, etc. -Barry By: Code_Slave - code_slave RE: [ANN] Report of the Month Contest 2006-03-15 17:51 Can one of you guys post something , to sort of "set" the level. so we can see what is currently being done.

By: David Sachdev - dsachdev Detecting/Displaying Empty Jasper Report 2006-03-15 05:59 Hello - I am using Hibernate as a datasource, and when the SQL query returns no rows I get back a blank Jasper Report (no headers, no nothing). Is there a way I can get Jasper to either 1) still print the headers or 2) Print out a message saying that the user's query returned no rows? In addition, my reports have an HTML link (via a variable I set) back to the Reports Selection page, but this link does not show when the report is blank. I would have expected Jasper to still print all of the other report elements, but just not have any rows of data. Thanks for your help David

By: slowfinger - slowfinger nesting subreport and xml data source 2006-03-14 07:15 Hi all, I want to output data like that: data -subdata -subsubdata the xml data source is as follows: <Problemwurzel> <StandardberichtProblemVO> <Problem> <Problemdatum></Problemdatum> <ProblemKurztext></ProblemKurztext> </Problem> <Bearbeitungsschritte> <StandardberichtBSAnalyseVO> <BearbeitungTs> 2005-03-09 15:28:51.907652 </BearbeitungTs> </StandardberichtBSAnalyseVO> <StandardberichtBSMassnahmeVO> <VorgBearbTs> 2005-03-09 15:28:51.907652 </VorgBearbTs> <BearbeitungTs> 2005-03-10 13:29:15.222385 </BearbeitungTs> </StandardberichtBSMassnahmeVO> <StandardberichtBSMassnahmeVO> <VorgBearbTs> 2005-03-09 15:28:51.907652 </VorgBearbTs> <BearbeitungTs> 2005-03-09 15:34:16.722383 </BearbeitungTs> </StandardberichtBSMassnahmeVO> <StandardberichtBSMassnahmeImEinsatzVO> <VorgBearbTs> 2005-03-09 15:34:16.722383 </VorgBearbTs> </StandardberichtBSMassnahmeImEinsatzVO> </Bearbeitungsschritte> </StandardberichtProblemVO> </Problemwurzel> Where element StandardberichtBSMassnahmeVO/VorgBearbTs reference StandardberichtBSAnalyseVO/BearbeitungTs so each StandardberichtBSAnalyseVO can 0 or more StandardberichtBSMassnahmeVO elements. To output all StandardberichtBSMassnahmeVO elements is no problem with datasource expression: ((net.sf.jasperreports.engine.data.JRXmlDataSource) $P{REPORT_DATA_SOURCE}).dataSource("/Problemwurzel/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSAnalyseVO") in the subreport. But how can I output the element StandardberichtBSAnalyseVO. Do I have to do that inside this subreport or is it better to do that in a separate subreport. I have no idea to solve that. Who can help Rico

By: vinod - vinodkelbaikar Jasper report not able to Display Euro sign 2006-03-07 22:07 Hi I am hardcoding the € [EURO] sign in my report. The generated HTML report shows Encoding as UTF-8. Hence on the resulting page this EURO sign is displayed as '?' as it is not supported by UTF-8. Can anyone let me know how can I change the encoding to ISO-8859? I tried changing the encoding of XML ISO-8859 to but its not working. By: Slobodan Kasterovic - kaster RE: Jasper report not able to Display Euro si 2006-03-14 00:24 How you trying change the encoding ? Try with: String x = "€"; String y = new String(x.getBytes(), "iso-8859"); Hope this helps.

By: amodg - amodg Displaying data columnwise in Excel... 2006-03-13 04:33 Hi, I want to display sometihng like this... Bugs in Reopen State 1 Bugs in Processing State 2 Bugs in Open State 10 Bugs in Request to Close State 11 Bugs in Closed State 12 in my report. To acieve this, I have placed the elements one over the other and have used the text field expressions like.... <![CDATA[(String.valueOf($F{STATUS}).equals("Open"))?$F{STATUSCOUNT}:""]]> <![CDATA[(String.valueOf($F{STATUS}).equals("Processing"))?$F{STATUSCOUNT}:""]]> This logic is working fine when I view the report in PDF but, when I view the report in Excel,it looks like... Bugs in Reopen State 1 Bugs in Processing State Bugs in Open State Bugs in Request to Close State Bugs in Closed State (with no values except the 1st one...) Any idea about this? or May I have to change my logic? Waiting for any reply... Thanks in advance... -Amod