Pushing Resultset to subreports

37 Views

I am trying to push a resulset to a subreport. The report is created using ODBC (RDO) datasource.

I have tried the following:

(a) I have tried switching the tables on the main report and subreports to use a JDBC driver, however when the report is run the table qualifier and table name are the wrong way round. This causes the query to fail.

(b) Appiled (a) and pushed the resultset for the main report and the subreport, however I receive the following error

- com.crystaldecisions.reports.queryengine.bm: Unable to evaluate the range info criteria for this query.
- Failed to read next recurring database record: database row set error.
com.crystaldecisions.reports.reportdefinition.datainterface.c: Unable to evaluate the range info criteria for this query.
at com.crystaldecisions.reports.reportdefinition.datainterface.l.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.l(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.k(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.bk(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.bm(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.else(Unknown Source)
at com.crystaldecisions.reports.dataengine.o.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.a8.Y(Unknown Source)
at com.crystaldecisions.reports.dataengine.a8. (Unknown Source)
at com.crystaldecisions.reports.dataengine.a8. (Unknown Source)
at com.crystaldecisions.reports.dataengine.a8. (Unknown Source)
at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv. (Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.l. (Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.p. (Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)
at com.businessobjects.reports.sdk.b.i.a(Unknown Source)
at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getPage(Unknown Source)
at com.crystaldecisions.report.web.event.ac.a(Unknown Source)
at com.crystaldecisions.report.web.event.ac.a(Unknown Source)
at com.crystaldecisions.report.web.event.b2.a(Unknown Source)
at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)
at com.crystaldecisions.report.web.event.av.a(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)
at org.apache.jsp.CrystalReportViewer_jsp._jspService(CrystalReportViewer_jsp.java:79)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: com.crystaldecisions.reports.queryengine.bm: Unable to evaluate the range info criteria for this query.
at com.crystaldecisions.reports.queryengine.b0.else(Unknown Source)
at com.crystaldecisions.reports.queryengine.ao.c(Unknown Source)
at com.crystaldecisions.reports.queryengine.b0.d(Unknown Source)
at com.crystaldecisions.reports.queryengine.b0.ds(Unknown Source)
... 58 more
- Failed to regenerate saved records: cleaning up errors.
- End reading from database
- Close rowset
- Failed to do first pass: failed to regenerate saved records.
com.crystaldecisions.reports.dataengine.a4: Unable to evaluate the range info criteria for this query.
at com.crystaldecisions.reports.dataengine.k.l(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.k(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.bk(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.bm(Unknown Source)
at com.crystaldecisions.reports.dataengine.k.else(Unknown Source)
at com.crystaldecisions.reports.dataengine.o.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.a8.Y(Unknown Source)
at com.crystaldecisions.reports.dataengine.a8. (Unknown Source)
at com.crystaldecisions.reports.dataengine.a8. (Unknown Source)
at com.crystaldecisions.reports.dataengine.a8. (Unknown Source)
at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv. (Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.l. (Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.p. (Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)
at com.businessobjects.reports.sdk.b.i.a(Unknown Source)
at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getPage(Unknown Source)
at com.crystaldecisions.report.web.event.ac.a(Unknown Source)
at com.crystaldecisions.report.web.event.ac.a(Unknown Source)
at com.crystaldecisions.report.web.event.b2.a(Unknown Source)
at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)
at com.crystaldecisions.report.web.event.av.a(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)
at

org.apache.jsp.CrystalReportViewer_jsp._jspService(CrystalReportViewer_jsp.java:79)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: com.crystaldecisions.reports.reportdefinition.datainterface.c: Unable to evaluate the range info criteria for this query.
at com.crystaldecisions.reports.reportdefinition.datainterface.l.a(Unknown Source)
... 57 more
Caused by: com.crystaldecisions.reports.queryengine.bm: Unable to evaluate the range info criteria for this query.
at com.crystaldecisions.reports.queryengine.b0.else(Unknown Source)
at com.crystaldecisions.reports.queryengine.ao.c(Unknown Source)
at com.crystaldecisions.reports.queryengine.b0.d(Unknown Source)
at com.crystaldecisions.reports.queryengine.b0.ds(Unknown Source)
... 58 more
- Failed to do first pass, clean up error.
- com.crystaldecisions.reports.dataengine.a4: Unable to evaluate the range info criteria for this query.
- JRCAgent2 detected an exception: Unable to evaluate the range info criteria for this query.

Thanks in advance...