报表导出的word如何固定表头

malixin

类似这个红色区域需要导出的word每页都显示

jishuang

table-header:true设置为表头

malixin

jishuang 发表于 2021-3-23 19:25
table-header:true设置为表头

请问加到哪个单元格，我一设置的话就会默认到第一列合并的单元格了，但是会报错，报表转换失败。


请问是不是下面那个用了系统的select所以报错了，单纯文字的话不报错。如何解决？

jishuang

那行要固定就在那行的第一个单元格上设置批注

把合并单元格放到后面看看

malixin

jishuang 发表于 2021-3-24 09:03
那行要固定就在那行的第一个单元格上设置批注

把合并单元格放到后面看看 ...

依然报错


Error
  SXCH0003: org.apache.fop.fo.ValidationException: Error(126/-1): column-number or number of
  cells in the row overflows the number of fo:table-column specified for the table.
[ERROR] 2021-03-26 08:24:40,207 com.justep.report.controller.OutputController - 报表输出失败
报表转换文件失败
com.justep.report.exception.ReportServerException: 报表输出失败
        at com.justep.report.controller.OutputController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.CacheController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(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: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: 报表转换文件失败
        ... 26 more
Caused by: java.lang.RuntimeException: 生成PDF文件失败，文件名：E:\BeX5_V3.8\apache-tomcat\temp\com.justep.report.convertor.StreamCache-6051184708586898786.temp
        at com.justep.report.convertor.PDFConvertor.generateByte(Unknown Source)
        ... 26 more
Caused by: java.lang.RuntimeException: FO生成PDF文件失败
        at com.justep.report.convertor.PDFConvertor.a(Unknown Source)
        ... 27 more
Caused by: net.sf.saxon.trans.XPathException: org.apache.fop.fo.ValidationException: Error(126/-1): column-number or number of cells in the row overflows the number of fo:table-column specified for the table.
        at net.sf.saxon.event.ContentHandlerProxy.handleSAXException(ContentHandlerProxy.java:521)
        at net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:375)
        at net.sf.saxon.event.NamespaceReducer.startContent(NamespaceReducer.java:197)
        at net.sf.saxon.event.ReceivingContentHandler.startElement(ReceivingContentHandler.java:367)
        at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
        at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
        at net.sf.saxon.event.Sender.sendSAXSource(Sender.java:404)
        at net.sf.saxon.event.Sender.send(Sender.java:214)
        at net.sf.saxon.IdentityTransformer.transform(IdentityTransformer.java:30)
        ... 28 more
Caused by: org.apache.fop.fo.ValidationException: Error(126/-1): column-number or number of cells in the row overflows the number of fo:table-column specified for the table.
        at org.apache.fop.fo.flow.table.TableCellContainer.addTableCellChild(TableCellContainer.java:50)
        at org.apache.fop.fo.flow.table.TableRow.addChildNode(TableRow.java:94)
        at org.apache.fop.fo.FOTreeBuilder$MainFOHandler.startElement(FOTreeBuilder.java:317)
        at org.apache.fop.fo.FOTreeBuilder.startElement(FOTreeBuilder.java:163)
        at net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:362)

malixin

jishuang 发表于 2021-3-24 09:03
那行要固定就在那行的第一个单元格上设置批注

把合并单元格放到后面看看 ...

如果改成上面这样的

那么报表显示不正常，如下图所示。

jishuang

要设置表头上面的都要设置，不能设置中间一行为表头

malixin

jishuang 发表于 2021-3-26 12:02
要设置表头上面的都要设置，不能设置中间一行为表头

我就是设置上面的都是表头，但是如果上面有引用的mainData的数据就无法和固定表头同时用，会报错。

jishuang

excel发一下