报表横向的合计

tianhong

1.报表横向的合计sum()函数为什么使用不了，一使用就报错图片（tu2）。

2.为什么我给报表添加隐藏列（h-visible:false;）批注后,后台就报错
java.lang.RuntimeException: 计算表达式失败，xpath：false;
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.CompiledTable.calculateXPathValue(Unknown Source)
        at com.justep.report.CompiledCell.getCellValueByRef(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledSheet.compile(Unknown Source)
        at com.justep.report.CompiledTable.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)
        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: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: javax.xml.xpath.XPathExpressionException
        at net.sf.saxon.xpath.XPathEvaluator.compile(XPathEvaluator.java:383)
        at com.justep.report.TransformContext.a(Unknown Source)
        ... 37 more
Caused by: net.sf.saxon.trans.XPathException: XPath syntax error at char 5 in {false;}:
    Unexpected token ";" beyond end of expression
        at net.sf.saxon.expr.ExpressionParser.grumble(ExpressionParser.java:149)
        at net.sf.saxon.expr.ExpressionParser.grumble(ExpressionParser.java:125)
        at net.sf.saxon.expr.ExpressionParser.parse(ExpressionParser.java:233)
        at net.sf.saxon.expr.ExpressionTool.make(ExpressionTool.java:73)
        at net.sf.saxon.xpath.XPathEvaluator.createExpressionInternal(XPathEvaluator.java:202)
        at net.sf.saxon.xpath.XPathEvaluator.compile(XPathEvaluator.java:381)
        ... 38 more

jishuang

1.sum这个单元格怎么设置的？加批注了吗？
2.h-visible:false;改为h-visible:false后面不用；如果有多个直接回车就可以

tianhong

=sum(E3:S3)  没有加批注，用的是excel中的合计相加函数

jishuang

sum(E3+S3)

tianhong

我试了=sum(E3+S3)不行，报错如图tu2

jishuang

把excel文件发一下

tianhong

这就是那个excel

jishuang

=SUM(FW+HTBA)

tianhong

上述方法，试用后，还是没起作用

jishuang

System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());加到java代码中，把返回的table输出发一下看看