on 2006 Oct 11 10:20 PM
<p>I am trying to push a resulset to a subreport. The report is created using ODBC (RDO) datasource.</p><p> </p><p>I have tried the following: </p><p>(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.</p><p>(b) Appiled (a) and pushed the resultset for the main report and the subreport, however I receive the following error </p><p>- com.crystaldecisions.reports.queryengine.bm: Unable to evaluate the range info criteria for this query.<br />- Failed to read next recurring database record: database row set error.<br />com.crystaldecisions.reports.reportdefinition.datainterface.c: Unable to evaluate the range info criteria for this query.<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.l.a(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.l(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.k(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.bk(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.bm(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.else(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.o.a(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.Y(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.i.a(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)<br /> at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)<br /> at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)<br /> at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.report.web.event.ac.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.ac.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.b2.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)<br /> at com.crystaldecisions.report.web.event.av.a(Unknown Source)<br /> at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)<br /> at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)<br /> at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)<br /> at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)<br /> at org.apache.jsp.CrystalReportViewer_jsp._jspService(CrystalReportViewer_jsp.java:79)<br /> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)<br /> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br /> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)<br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)<br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<br /> at java.lang.Thread.run(Unknown Source)<br />Caused by: com.crystaldecisions.reports.queryengine.bm: Unable to evaluate the range info criteria for this query.<br /> at com.crystaldecisions.reports.queryengine.b0.else(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.ao.c(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.b0.d(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.b0.ds(Unknown Source)<br /> ... 58 more<br />- Failed to regenerate saved records: cleaning up errors.<br />- End reading from database<br />- Close rowset<br />- Failed to do first pass: failed to regenerate saved records.<br />com.crystaldecisions.reports.dataengine.a4: Unable to evaluate the range info criteria for this query.<br /> at com.crystaldecisions.reports.dataengine.k.l(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.k(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.bk(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.bm(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.k.else(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.o.a(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.Y(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.dataengine.a8.a(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.i.a(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)<br /> at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)<br /> at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)<br /> at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.report.web.event.ac.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.ac.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.b2.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)<br /> at com.crystaldecisions.report.web.event.av.a(Unknown Source)<br /> at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)<br /> at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)<br /> at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)<br /> at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)<br /> at
org.apache.jsp.CrystalReportViewer_jsp._jspService(CrystalReportViewer_jsp.java:79)<br /> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)<br /> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br /> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)<br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)<br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<br /> at java.lang.Thread.run(Unknown Source)<br />Caused by: com.crystaldecisions.reports.reportdefinition.datainterface.c: Unable to evaluate the range info criteria for this query.<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.l.a(Unknown Source)<br /> ... 57 more<br />Caused by: com.crystaldecisions.reports.queryengine.bm: Unable to evaluate the range info criteria for this query.<br /> at com.crystaldecisions.reports.queryengine.b0.else(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.ao.c(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.b0.d(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.b0.ds(Unknown Source)<br /> ... 58 more<br />- Failed to do first pass, clean up error.<br />- com.crystaldecisions.reports.dataengine.a4: Unable to evaluate the range info criteria for this query.<br />- JRCAgent2 detected an exception: Unable to evaluate the range info criteria for this query. <br /></p><p>Thanks in advance...</p><p> </p><p> </p>
<p>I'm getting the same error, but in a different case.</p><p> The error occurs with the following selection formula:</p><p>not ({VW_cm_COMPSTATUS._status} in ["closed", "pending"])</p><p>The following is going fine: {VW_cm_COMPSTATUS._status} in ["closed", "pending"] </p><p> so it must be: not () <br /></p><p> </p><p>Any idea why this is going wrong and how to fix this? </p><p>Thanks in advance... <br /></p><p> </p><p> </p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
13 | |
10 | |
9 | |
9 | |
8 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.