ksql查询报表数据，数据能出来，控制台还是报错。

bjzhouyi

... 25 more
Caused by: com.justep.model.exception.ModelException: 找不到变量：ftbrq对应的值！
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
... 30 more
[ERROR] 2013-10-22 21:42:12,493 com.justep.report.controller.DataController - 报表数据获取失败
执行ksql:select A_YX_JZJKYXRZ5_ZB.fTBRQ as fTBRQ,A_YX_JZJKYXRZ5_ZBXX.* from A_YX_JZJKYXRZ5_ZB A_YX_JZJKYXRZ5_ZB  join A_YX_JZJKYXRZ5
_ZBXX A_YX_JZJKYXRZ5_ZBXX on A_YX_JZJKYXRZ5_ZB  =  A_YX_JZJKYXRZ5_ZBXX.fZBID where DateToString( A_YX_JZJKYXRZ5_ZB.fTBRQ ) =:ftbrq
and  A_YX_JZJKYXRZ5_ZBXX.fJZ =:fjz时出错！
com.justep.report.exception.ReportServerException: 报表数据获取失败
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.report.exception.ReportServerException: 执行ksql:select A_YX_JZJKYXRZ5_ZB.fTBRQ as fTBRQ,A_YX_JZJKYXRZ5_ZBXX.*
from A_YX_JZJKYXRZ5_ZB A_YX_JZJKYXRZ5_ZB  join A_YX_JZJKYXRZ5_ZBXX A_YX_JZJKYXRZ5_ZBXX on A_YX_JZJKYXRZ5_ZB  =  A_YX_JZJKYXRZ5_ZB
XX.fZBID where DateToString( A_YX_JZJKYXRZ5_ZB.fTBRQ ) =:ftbrq and  A_YX_JZJKYXRZ5_ZBXX.fJZ =:fjz时出错！
at com.justep.report.controller.DataController.a(Unknown Source)
at com.justep.report.controller.DataController.a(Unknown Source)
... 20 more
Caused by: java.lang.Exception
... 22 more

fpj

你是自定义action吗？然后用reportdata，
ACTION所需要的参数 ftbrq 给它传值了吗？
报表参数查询的可以参考demo/report/process/property/parameterFilterReport.w

bjzhouyi

结贴把，我报表自动加载了。。。。