Datasource Expression problem

Posted on November 9, 2006 at 8:46pm
I have a report that uses a connection to go right to the database but it has a subreport that uses a datasource. I tried the following for the datasource expression but it is failing. Why can I not do this?
new com.dotmarketing.util.SLASubreportDatasource($F{teamId}.longValue())

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :
Source text : new com.dotmarketing.util.SLASubreportDatasource($F{teamId}.longValue())
net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:183)
net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:539)
net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:507)
JasperReports® Library
LORDs_diakonos's picture
LORDs_diakonos
106
Joined: Nov 3 2006 - 2:17am
Last seen: 16 years 11 months ago

6 Answers:

Posted on November 10, 2006 at 5:40am
Can you post the full exception stacktrace, so that the exception that caused the evaluation error is visible?

Regards,
Lucian
lucianc's picture
lucianc
87397
Joined: Jul 17 2006 - 1:10am
Last seen: 1 day 3 min ago
Posted on November 10, 2006 at 11:08am
I will in a couple hours when i get to the office but is it possible to do what I am trying to do? I would think so. Basically it is not filling my variable in the datasource expression.
LORDs_diakonos's picture
LORDs_diakonos
106
Joined: Nov 3 2006 - 2:17am
Last seen: 16 years 11 months ago
Posted on November 10, 2006 at 12:46pm
javax.servlet.ServletException: Error evaluating expression :
Source text : new com.dotmarketing.util.SLASubreportDatasource($F{teamId}.longValue())
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.dotmarketing.filters.LoginFilter.doFilter(LoginFilter.java:38)
com.dotmarketing.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:22)
com.dotmarketing.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:22)

root cause

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :
Source text : new com.dotmarketing.util.SLASubreportDatasource($F{teamId}.longValue())
net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:183)
net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:539)
net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:507)
net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:805)
net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:348)
net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:277)
net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399)
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1289)
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:631)
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:228)
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758)
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666)
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
com.dotmarketing.struts.actions.admin.ProjectInventoryReportAction._generateReport(ProjectInventoryReportAction.java:92)
com.dotmarketing.struts.actions.admin.ProjectInventoryReportAction.search(ProjectInventoryReportAction.java:57)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.dotmarketing.filters.LoginFilter.doFilter(LoginFilter.java:38)
com.dotmarketing.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:22)
com.dotmarketing.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:22)
LORDs_diakonos's picture
LORDs_diakonos
106
Joined: Nov 3 2006 - 2:17am
Last seen: 16 years 11 months ago
Posted on November 10, 2006 at 12:51pm
JRExpressionEvalException should nest a further exception, is this the entire stack trace?
Post edited by: lucianc, at: 2006/11/10 12:58
lucianc's picture
lucianc
87397
Joined: Jul 17 2006 - 1:10am
Last seen: 1 day 3 min ago
Posted on November 10, 2006 at 1:00pm
Well that is all i am getting right now but something is going on with tomcat and logging lol I am working on that. :-)
LORDs_diakonos's picture
LORDs_diakonos
106
Joined: Nov 3 2006 - 2:17am
Last seen: 16 years 11 months ago
Posted on November 10, 2006 at 1:44pm
Well i got logging working properly and low and behold I found my problem. lol a number format exception in my datasource. sorry Jasper Reports is such a great solution. :-) Thanx
LORDs_diakonos's picture
LORDs_diakonos
106
Joined: Nov 3 2006 - 2:17am
Last seen: 16 years 11 months ago
Feedback