Jump to content
Changes to the Jaspersoft community edition download ×

dave_8

Members
  • Posts

    3
  • Joined

  • Last visited

dave_8's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. in fact I had Jaspersoft studio taking a SQL date and using it as a string - caught out by data typing ! thank you again
  2. Hi, I'm trying to get a formatted date into a Jaspersoft Studio Report expression. Some of my data has nulls and some has date completed. I can identify which elements are null and which have dates with an expression like IF(EQUALS($F{adate},null),"N/A",$F{adate}) but if I try and format the date: IF(EQUALS($F{adate},null),"N/A",DATEFORMAT($F{adate},"dd-MMM-YYYY")) I get an error when filling the report (see below) Any ideas how to work around this - I'm driving myself mad ! Thanks in advance I hope ! Dave net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : IF(EQUALS($F{support expires},null),"N/A",DATEFORMAT($F{support expires},"dd-MMM-YYYY"))at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:482)at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:457)at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:347)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : IF(EQUALS($F{support expires},null),"N/A",DATEFORMAT($F{support expires},"dd-MMM-YYYY"))at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:244)at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591)at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:559)at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1016)at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:504)at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:488)at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259)at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2057)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:778)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:288)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932)at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120)at java.lang.Thread.run(Thread.java:695)Caused by: groovy.lang.MissingMethodException: No signature of method: net.sf.jasperreports.functions.standard.DateTimeFunctions.DATEFORMAT() is applicable for argument types: (java.lang.String, java.lang.String) values: [2013-11-07, dd-MMM-YYYY]Possible solutions: DATEFORMAT(java.util.Date, java.lang.String)at net.sf.jasperreports.compilers.GroovyEvaluator.functionCall(GroovyEvaluator.java:120)at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:272)at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:52)at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:49)at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:57)at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:145)at Renewals28Nov_1385649853078_751931.methodMissing(calculator_Renewals28Nov_1385649853078_751931:22)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:597)at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)at groovy.lang.MetaClassImpl.invokeMissingMethod(MetaClassImpl.java:832)at groovy.lang.MetaClassImpl.invokePropertyOrMissing(MetaClassImpl.java:1123)at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1076)at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1110)at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:904)at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:49)at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:133)at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:145)at Renewals28Nov_1385649853078_751931.evaluate(calculator_Renewals28Nov_1385649853078_751931:356)at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:231)... 14 more
×
×
  • Create New...