Datasource Expression problem

[LORDs_diakonos]

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)

[lucianc]

Can you post the full exception stacktrace, so that the exception that caused the evaluation error is visible?

 

Regards,

Lucian

[LORDs_diakonos]

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]

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)

[lucianc]

JRExpressionEvalException should nest a further exception, is this the entire stack trace?

Post edited by: lucianc, at: 2006/11/10 12:58

[LORDs_diakonos]

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]

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