t3_chris

Hello! This line: Caused by: java.lang.ClassCastException: org.joda.time.LocalDateTime cannot be cast to org.joda.time.LocalDateTime Looks like if there seems to be a class loading problem. You may want to check if you have joda-time twice in your classpath. Best Regards, Christian

Hello! I have exactly the same problem and try to find a solution since hours. Could you finally solve the issue? Best Regards, Christian

Hello! I would like to use the EJBQL/JPA related features in Jasper Reports within my project and therefore need to configure JasperSoft Studio 6.0.3 to be able to use my JPA 2.0 Persistence Unit. I use Hibernate 4.2 as my JPA 2.0 Persistence Provider. This is where the problem starts... It seems as if there is a bundled version of Hibernate 3 which comes with JasperSoft Studio. When I try to include all the necessary Hibernate4-JAR-files as a UserLibrary in my reports project in JasperSoft Studio I get InvocationTargetExceptions and/or ClassCastExceptions when trying to preview a report. So the next thing I've tried was to include the required JARs at the top-most level "C:Program FilesTIBCOJaspersoft Studio-6.0.3.finalfeaturesjre.win32.win32.x86_64.feature_1.7.0.u71jrelibext" - but with the same result. Did anybody out there manage to intialize a JPA 2.0 Persistence Unit in JasperSoft Studio 6? If so I would be really grateful for any guidelines you can provide. Thank you very much! Best Regards, Christian

Hello! Since iReport was ported to the Netbeans Platform I have severe class loading problems, when I use JPA/EJB-QL based reports. To query for JPA-classes ("SELECT c FROM SomeClass c") I have to load my businesslogic library into iReport using the classpath option. But I've never had success using my businesslogic which unfortunately relies on quite some external JARs (SLF4J, Log4J, JodaTime, ...) since iReport has been ported over to Netbeans RCP. With the legacy version 3.0.0 of iReport, the same businesslogic (with the needed extensive classpath) and JPA/EJB-QL queries run fine. One example problem is described in this tracker item: http://jasperforge.org/projects/ireport/tracker/view.php?id=4527 In note #0008752 Giulio assumes, that my problems are class loading issues, and he is absolutely right with his assumption. My question is: Is there any way to load my classpath items using the standard Java approach instead of the Netbeans approach? I'd greatly appreciate to be able to upgrade from iReport-3.0.0 to the current versions. In appreciation of your help, christian

What I've also noticed, is that iReport doesn't really like large classpaths since after version 3.0.0 and up. So you may check your classpath for unnecessary items.

Hello! I greatly appreciate your iReport 4.x.x releases! I am using them for SQL based reports since it's initial release. However, there is a big Problem when trying to use an EJB-QL Query as the report's data source. If only JDK-types are used as fields to be displayed in the report, everything is fine. As soon as I include a class from my businesslogic into the report design, I get strange errors. The following error is raised, when i add a Postalcode-object to the report design: Creating entity manager Closing entity manager Error filling print... Error evaluating expression : Source text : ""+$F{postalcode} net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : ""+$F{postalcode} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:867) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:421) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:406) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:468) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2037) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:761) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:291) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:133) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:954) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.ClassCastException: com.xyz.gollum.businesslogic.Postalcode cannot be cast to com.xyz.gollum.businesslogic.Postalcode at Rp_445145145Test_1316762737833_725853.evaluate(Rp_445145145Test_1316762737833_725853:274) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190) ... 18 more Most strange for me is the part marked in red. Does anybody of you have any idea, how I can enable iReport 4 to work with EJB-QL Datasources? Thanks a lot in anticipation! Best Regards, Christian Post Edited by t3_chris at 09/23/2011 07:33

Hello! I am in need to preselect some values when using a multi-select query (to provide my users with a default selection of parameters) Is there any way to achieve this? Thanks in advance! christian

Hello! I've got a report which requests a parameter of type Integer. I've created a corresponding InputControl of type Number in JasperServer. My report JRXML uses Integer.valueOf(4000) as default value for this parameter. The input control renders this number as "4.000", if the user clicks on the OK button, the parameter is passed to the report as an integer with the value "4". What is obviously not the desired behaviour. Is there any way to format the number or better to avoid any formatting of the number? Thanks in anticipation of your help! Christian

Hello! Until now, I've used iReport-3.0.0 for my reports. Now I decided to give iReport-4.0.1 a try, but I am experiencing problems with reports which use an EJBQL connection to collect data. The connection and query works fine, also including simple types (String, Double, ...) into the report works perfect. The Problem occurs when I try to print complex types on my report. Then I get very weird ClassCastExceptions. For example, I have a Customer object which has a field named group in this field a CustomerGroup object is stored. This CustomerGroup object has a few simple attributes (name, rowid, ...). Here's the exception which I get, when I try to print a field with the expression "$F{group}.getName()" (returns a string) on my report: Creating entity manager Closing entity manager Error filling print... Error evaluating expression : Source text : $F{group}.getName() net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{group}.getName() at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:383) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:368) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2036) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:760) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:270) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:953) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.ClassCastException: com.vendidata.gollum.businesslogic.Customergroup cannot be cast to com.vendidata.gollum.businesslogic.Customergroup at test_1299228363389_432890.evaluate(test_1299228363389_432890:256) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182) ... 18 more I can't understand the ClassCastException when casting from Customergroup to Customergroup. Do you have any suggestion, what the error may causes? With iReport-3.0.0 the same report works perfectly fine! Thanks in advance for your help! Best Regards, Christian Reiter

Some further information: When a report is designed using a SQL/JDBC datasource, those are also generated. But in this case, they don't mess up things.

The attached file "report1.jrxml" illustrates the issue.

Thanks for your reply! I've already noticed that I can insert any character I want for my currency symbol, but the currency symbol I have to use is stored in a variable which is passed to the report. If i use $V{CURRENCY_SYMBOL} it doesn't work. regards, chris

Hi! I assume that the pattern function in iReport uses the currency symbol from the current default locale. But I am in need to predefine the currency symbol indepently of the current locale. Is there any way to achieve this? Best Regards, christian

Thanks!

Hi! Up to now i've used JasperCompileManager.compileReport(inputStream) to compile my reports. This worked without any problems as long as the jrxml-files i wanted to compile didn't contain any iReport-handled scriptlets. When i try to compile a report-jrxml which contains a reference to a scriptlet, i get the following exception from the compile manager: net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. java.lang.ClassNotFoundException: Will not load classes from default package (Scriptlet_DemoScriptlet) What can i do to compile reports which contain Scriptlets? Is there any way to supply the Scriptlet.java-File to the compile manager? This is how my .jrxml references to the scriptlet: <jasperReport ... scriptletClass="Scriptlet_DemoScriptlet" ... <property name="ireport.scriptlethandling" value="1" /> ... </jasperReport> Thanks for your help in anticipation! Best Regards from Austria, christian