报表问题：如何在 select 中加过滤条件呀？

sunch

报表问题：
在Excel报表中，ds的显示分几个部分，每个部分通过字段 datatype 来区分 (值分别为： M1,M2,M3, ... )。
于是，我通过 设置  reportdata.select(reportdata.id,'datatype = 'M1'') 的方式来显示数据

可是，出现错误：

Error at /xsl:stylesheet/xsl:template[1]/xsl:element[1]/xsl:element[1]/xsl:element[1]/xsl:for-each[1]/xsl:if[1]
  XPST0003: XPath syntax error at char 11 on line -1 in {datatype = }:
    Unexpected token "<eof>" in path expression
[ERROR] 2015-08-20 12:45:48,526 com.justep.report.controller.ReportController - 报表执行失败
转换数据失败
com.justep.report.exception.ReportServerException: 转换数据失败
        at com.justep.report.controller.ReportController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        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:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.data.ReportDataTransformException: 转换数据失败
        at com.justep.report.data.ReportDataTransformer.a(Unknown Source)
        at com.justep.report.data.ReportDataTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more
Caused by: javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
        at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
        at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
        ... 25 more
Error at /xsl:stylesheet/xsl:template[1]/xsl:element[1]/xsl:element[1]/xsl:element[1]/xsl:for-each[1]/xsl:if[1]
  XPST0003: XPath syntax error at char 11 on line -1 in {datatype = }:
    Unexpected token "<eof>" in path expression
[ERROR] 2015-08-20 12:45:53,364 com.justep.report.controller.ReportController - 报表执行失败
转换数据失败
com.justep.report.exception.ReportServerException: 转换数据失败
        at com.justep.report.controller.ReportController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        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:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.data.ReportDataTransformException: 转换数据失败
        at com.justep.report.data.ReportDataTransformer.a(Unknown Source)
        at com.justep.report.data.ReportDataTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more
Caused by: javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
        at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
        at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
        ... 25 more

jishuang

reportdata.select(reportdata.id,'reportdata.datatype="M1"')
看一下

sunch

jishuang 发表于 2015-8-20 17:19
reportdata.select(reportdata.id,'reportdata.datatype="M1"')
看一下

试了一下，还是不对呀

jishuang

把,'reportdata.datatype="M1"'去掉就可以吗？

sunch

jishuang 发表于 2015-8-24 11:52
把,'reportdata.datatype="M1"'去掉就可以吗？

去掉达不到我的目的呀，我是要显示满足这个条件的数据呀，请大神帮忙处理，谢！！

jishuang

sunch 发表于 2015-8-25 08:25
去掉达不到我的目的呀，我是要显示满足这个条件的数据呀，请大神帮忙处理，谢！！ ...

我知道，我现在就是问去掉这个如果可以的话，有可能就是缺陷，就需要去sql中设置where条件

sunch

jishuang 发表于 2015-8-25 11:53
我知道，我现在就是问去掉这个如果可以的话，有可能就是缺陷，就需要去sql中设置where条件 ...

去掉肯定可以呀，不然报表都产生不了

jishuang

那报表中的设置可能是缺陷，先到sql中设置where条件吧


你好楼主，这个问题需要我在本地环境进行问题重现，所以会花费较长时间，请你耐心等待，我完成后会第一时间反馈结果，谢谢！

tiger0425

请问这个问题解决了吗