报表设置如下:
给签名处的单元格添加批注:display-type:image
在sql语句中已这种方式返回: '/UI/system/images/dzqm/'||FSHR||'.jpg' as FSHR
报表显示效果(无问题):
报表打印预览效果(有问题):
而且控制台还会报错误一下错误(tomcat的配置文件没动过【<Connector port="8080" URIEncoding="utf-8" maxHttpHeaderSize="8192"。。。。。】):
2017-4-25 14:21:54 org.apache.catalina.connector.CoyoteAdapter convertURI
严重: Invalid URI character encoding; trying ascii
在点击导出时报如下错误:
2017-4-25 14:28:33 org.apache.catalina.connector.CoyoteAdapter convertURI
严重: Invalid URI character encoding; trying ascii
[ERROR] 2017-04-25 14:28:33,837 com.justep.report.controller.OutputController - 报表输出失败
生成xls文件失败
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:595)
Caused by: java.lang.RuntimeException: 生成xls文件失败
at com.justep.report.convertor.ExcelConvertor.generateByte(Unknown Source)
... 26 more
Caused by: java.lang.RuntimeException: Excel转换为二进制格式失败
at com.justep.report.convertor.ExcelConvertor.a(Unknown Source)
... 27 more
Caused by: java.lang.RuntimeException: 根据URL读取流失败,URL:http://localhost:8080/x5/UI/system/images/dzqm/边银.jpg
at com.justep.report.convertor.ExcelConvertor.getUrlFileContent(Unknown Source)
at com.justep.report.convertor.ExcelConvertor.a(Unknown Source)
at com.justep.report.convertor.ExcelConvertor.a(Unknown Source)
... 28 more
Caused by: java.io.FileNotFoundException: http://localhost:8080/x5/UI/system/images/dzqm/边银.jpg
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1194)
... 31 more