任何条件都不输入，直接查询能查看所有的明细内容，一旦输入搜索条件就报错sql:select cnrq,sjh,ht,dw,sjlx,skfs,htcckpje,sqr,dhdwmc2 from sj_mx
${if(len(dw) ==0,"","and dw in ('" + dw + "')")}
${if(len(bh) ==0,"","and ht in ('" + bh + "')")}
${if(len(ckrqfrom)==0,""," and cnrq >='"+ckrqfrom+"'")}
${if(len(ckrqto)==0,""," and cnrq <='"+ckrqto+"'")}
order by cnrq DESC
报错如下：java.lang.RuntimeException: 错误代码:1301 数据集配置错误Query:ORA-00933: SQL 命令未正确结束 at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.r.A(Unknown Source) at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.I.E(Unknown Source) at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.I.B(Unknown Source) at com.fr.report.worksheet.WorkSheet._execute(Unknown Source) at com.fr.report.worksheet.WorkSheet.execute(Unknown Source) at com.fr.report.core.A.C.C.E(Unknown Source) at com.fr.report.core.A.C.C.C(Unknown Source) at com.fr.main.impl.WorkBook.execute(Unknown Source) at com.fr.log.LogUtils$1.exe(Unknown Source) at com.fr.log.LogUtils.executeAndLogAndRecord(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source) at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source) at com.fr.web.core.ShowWorkBookPolicy$Policy4Page.show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.showDirect(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.createPageSetChain(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getReportPage(Unknown Source) at com.fr.web.core.A.yA$_A.A(Unknown Source) at com.fr.web.core.A.yA$_A.A(Unknown Source) at com.fr.web.core.A.yA.process(Unknown Source) at com.fr.web.core.ReportDispatcher.dealInOp(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source) at com.fr.web.BaseServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误Query:ORA-00933: SQL 命令未正确结束 at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source) at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source) ... 45 moreCaused by: java.sql.SQLException: ORA-00933: SQL 命令未正确结束 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:800) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273) at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) ... 47 more
