报表问题xpath：dataset('rMain_SNAME_FPROJECTNAME')//SNAME

15030479317

开始报表显示没有问题,但是我一修改列宽、行高啥的就报这个错。版本3.6
控制台信息：
2017-09-01 11:42:38 结束-中间文件生成缓存文件: /UI2/PM/PM/process/case_caseStatis/mainActivity.w
[ERROR] 2017-09-01 11:42:40,802 com.justep.report.controller.ReportController - 报表执行失败
选择节点失败，xpath：dataset('rMain_SNAME_FPROJECTNAME')//SNAME
com.justep.report.exception.ReportServerException: 选择节点失败，xpath：dataset('rMain_SNAME_FPROJECTNAME')//SNAME
        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: java.lang.RuntimeException: 选择节点失败，xpath：dataset('rMain_SNAME_FPROJECTNAME')//SNAME
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.CompiledTable.selectXPathNodes(Unknown Source)
        at com.justep.report.Repeat.compile(Unknown Source)
        at com.justep.report.TableRows.compile(Unknown Source)
        at com.justep.report.Table.transform(Unknown Source)
        at com.justep.report.Content.transform(Unknown Source)
        at com.justep.report.ContentSet.transform(Unknown Source)
        at com.justep.report.Report.a(Unknown Source)
        at com.justep.report.ReportDocument.transform(Unknown Source)
        at com.justep.report.ReportTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more
Caused by: java.lang.NullPointerException
        at net.sf.saxon.dom4j.NodeWrapper.makeWrapper(NodeWrapper.java:99)
        at net.sf.saxon.dom4j.NodeWrapper.makeWrapper(NodeWrapper.java:62)
        at net.sf.saxon.dom4j.DocumentWrapper.wrap(DocumentWrapper.java:55)
        at com.justep.report.TransformContext.a(Unknown Source)
        ... 33 more

jishuang

excel文件发一下看看

15030479317

jishuang 发表于 2017-9-1 13:34
excel文件发一下看看

文件

jishuang

只能有一个select，其他的直接写report的xid.字段名

15030479317

jishuang 发表于 2017-9-1 14:41
只能有一个select，其他的直接写report的xid.字段名

调整了还是报错

15030479317

jishuang 发表于 2017-9-1 14:41
只能有一个select，其他的直接写report的xid.字段名

这个是最新的，改了左边合并列

jishuang

1.把第一行的合并和批注先取消
2.count中写的不正确
3.分组显示序号可以参考http://bbs.wex5.com/forum.php?mod=viewthread&tid=48236

15030479317

jishuang 发表于 2017-9-1 15:15
1.把第一行的合并和批注先取消
2.count中写的不正确
3.分组显示序号可以参考http://bbs.wex5.com/forum.php ...

还是这个错：
[size=13.3333px]报表执行错误：选择节点失败，xpath：dataset('rMain_SNAME_FPROJECTNAME')//SNAME

15030479317

jishuang 发表于 2017-9-1 15:15
1.把第一行的合并和批注先取消
2.count中写的不正确
3.分组显示序号可以参考http://bbs.wex5.com/forum.php ...

能不能帮忙远程看一下

jishuang

确认SNAME和FPROJECTNAME字段有数据吗？