• 
  填报校验

  426574265942658 需求如上图所示，哪位大神有做好的模板，相似的也行，跪求一份！！！

  818个浏览 4个回答 FineReport 2016年08月21日发布
• 
  h5插件支持填报预览方式吗？

  http://bbs.fanruan.com/thread-93825-1-1.html 我做好了移动端页面，放在手机浏览器上用h5插件预览后，为什么插件没有生效呢？而且定位功能也使用不了，但是在数据分析app中就是正常的。后期是想和钉钉做集成，不知道怎么解决？ 72336 编辑于 2017-7-28 12:14

  458个浏览 4个回答 FineReport 2017年07月28日发布
• 
  获取当前地理位置为什么显示的不是中文地址？

  官方的demo在本地打开的模板，点击获取地理位置为什么是串代码？而官方的demo能获取到中文名，小白一脸懵逼，求大神指点。谢谢！ 7204972050 var jingdu = 116.322987; var weidu = 39.983424; FR.location(function(status, message){ if(status=="success") { var aa = message.split(','); weidu = aa; jingdu = aa; setTimeout(function() { FR.ajax({ url: "/app/getaddress.jsp?jingdu=" + jingdu + "&weidu=" + weidu, success: function(msg){ FR.Msg.alert("当前地址", msg); contentPane.setCellValue(3,7,msg); } }); }, 500); } });

  766个浏览 6个回答 FineReport 2017年07月25日发布
• 
  条件属性失效

  我做了一个demo，1、将excel导入后，测试列的条件属性为什么没有生效？ 2、测试列为什么就只有一行，而不是向下扩展的呢？ 7227672278 编辑于 2017-7-28 00:06

  504个浏览 15个回答 FineReport 2017年07月27日发布
• 
  7.0升级到8.0打开同一张报表慢很多

  两台服务器，做了weblogic集群，报表是从7.0升级到8.0的，问题是在7.0上打开同一张报表只要1秒，升到8.0打开模板要5秒多，而且主机和子机打开的速度还差2秒多。求解决方案！！！

  401个浏览 3个回答 FineReport 2017年07月18日发布
• 
  怎么用参数控制sql语句

  求大神看看哪里写错了？${if(len(sf)==0 || sf='中国',"select StatsMt, '全国', c.cpbusndivnm, operqtyyoy '业务量同比', operqtymom '业务量环比', rvnamtyoy '业务收入同比', rvnamtmom '业务收入环比', MonOperQty/100000000 as '业务量', MonOperRvnAmt/100000000 as '收入' from TB_FCT_SUM_DET_Mon a join (select distinct cpbusndivcd, cpbusndivnm from dash.tb_cde_cpbusntyp) c on c.cpbusndivcd = a.PostBusnTypCd where 1=1 and CpOrgCd = '00000000' and PostBusnTypCd !='999999'", if(sf in (tb_prt_cporg_all.provsignnm), "select StatsMt, b.provsignnm, cpbusndivnm, operqtyyoy '业务量同比', operqtymom '业务量环比', rvnamtyoy '业务收入同比', rvnamtmom '业务收入环比', MonOperQty/100000000 as '业务量', MonOperRvnAmt/100000000 as '收入' from TB_FCT_SUM_DET_Mon a join (select max(StatsMt) as maxStatsMt from TB_FCT_SUM_DET_Mon) a1 on a1.maxStatsMt = a.StatsMt join (select distinct provcporgcd, provsignnm from tb_prt_cporg_all) b on b.provcporgcd=a.CpOrgCd join (select distinct cpbusndivcd, cpbusndivnm from dash.tb_cde_cpbusntyp) c on c.cpbusndivcd = a.PostBusnTypCd where b.provsignnm='${sf}'", "select StatsMt, b.ctysignnm, cpbusndivnm, operqtyyoy '业务量同比', operqtymom '业务量环比', rvnamtyoy '业务收入同比', rvnamtmom '业务收入环比', MonOperQty/100000000 as '业务量', MonOperRvnAmt/100000000 as '收入' from TB_FCT_SUM_DET_Mon a join (select max(StatsMt) as maxStatsMt from TB_FCT_SUM_DET_Mon) a1 on a1.maxStatsMt = a.StatsMt join tb_prt_cporg_all b on b.ctycporgcd=a.CpOrgCd join (select distinct cpbusndivcd, cpbusndivnm from dash.tb_cde_cpbusntyp) c on c.cpbusndivcd = a.PostBusnTypCd where b.ctysignnm='${sf}'" ))}

  482个浏览 2个回答 FineReport 2017年06月16日发布
• 
  部署之后所有页面都显示空白

  Tomcat9 jak1.8 fr5.12（测试了很多版本） 安装部署之后所有自带demo都显示空白，数据集能正常预览。自己制作的模板也是显示空白。服务器明明能访问百度，在决策平台上打开插件商城却报404。Tomcat报错如下 五月 24, 2017 8:31:32 下午 警告: design_test_con error com.fr.web.core.A.zD: design_test_con error at com.fr.web.core.A.nD.A(Unknown Source) at com.fr.web.core.A.U.E(Unknown Source) at com.fr.web.core.A.U.process(Unknown Source) at com.fr.stable.fun.impl.NoSessionIDOPService.process(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source) at com.fr.web.BaseServlet.doGet(Unknown Source) at com.fr.web.BaseServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException at java.io.Reader.(Reader.java:78) at java.io.InputStreamReader.(InputStreamReader.java:97) at com.fr.base.BaseXMLUtils.readXMLFile(Unknown Source) at com.fr.dav.DavXMLUtils.readXMLDatabaseConnection(Unknown Source) at com.fr.web.core.A.NC.actionCMD4User(Unknown Source) ... 33 more 五月 24, 2017 8:31:40 下午 严重: Could not initialize class sun.awt.X11GraphicsEnvironment java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:264) at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:103) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82) at java.awt.image.BufferedImage.createGraphics(BufferedImage.java:1181) at com.fr.base.IconManager.init4Image(Unknown Source) at com.fr.base.IconManager.checkInit(Unknown Source) at com.fr.base.IconManager.getCssInfo(Unknown Source) at com.fr.form.ui.Button.createJSONConfig(Unknown Source) at com.fr.form.ui.ToolBarButton.createJSONConfig(Unknown Source) at com.fr.form.ui.ToolBar.createJSONComponents(Unknown Source) at com.fr.form.ui.ToolBar.createJSONConfig(Unknown Source) at com.fr.report.web.ToolBarManager.toJSONConfig(Unknown Source) at com.fr.web.core.ReportWebUtils.dealWithToolbar(Unknown Source) at com.fr.web.core.ReportWebUtils.dealWithLoading(Unknown Source) at com.fr.web.core.ReportWebUtils.policyMap4Tpl(Unknown Source) at com.fr.web.core.ReportWebUtils.context4PolicyPaneTpl(Unknown Source) at com.fr.web.core.ReportWebUtils.context4PolicyPaneTpl(Unknown Source) at com.fr.web.core.ReportWebUtils.context4PageTpl(Unknown Source) at com.fr.stable.AbstractActor.createContext4Tpl(Unknown Source) at com.fr.web.core.reserve.ReportletDealWith.dealWithHtml(Unknown Source) at com.fr.web.core.reserve.ReportletDealWith.dealWithPageHtml(Unknown Source) at com.fr.web.core.reserve.ReportletDealWith.dealWithReportlet(Unknown Source) at com.fr.web.core.Reportlet.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source) at com.fr.web.BaseServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 65751

  1113个浏览 4个回答 FineReport 2017年05月24日发布
• 
  mysql查询出的数据在柱状图中为什么不是按顺序排列

  我在mysql中查询出的数据，为什么在柱状图中不是按项目储备、年度预算、预算下达、需求提报、招标采购、合同签订、合同履约、物资领用、支出入账顺序排列的。而是乱的。 62626 SELECT * FROM ( SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '年度预算' as type,BEGBUDAMOUNT/10000 as type_value,'' rate,'' rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '项目储备' as type,ALL_INVEST/10000 as type_value,'' rate,'' rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '预算下达' as type,TRAAMOUNT/10000 as type_value,'预算下达率' as rate,RATE_1 as rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '需求提报' as type,APPAMOUNT/10000 as type_value,'需求提报率' as rate,RATE_1 as rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '招标采购' as type,INVAMOUNT/10000 as type_value,'招标采购率' as rate,RATE_1 as rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '合同签订' as type,SIGAMOUNT/10000 as type_value,'合同签订率' as rate,RATE_1 as rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '合同履约' as type,AGGREAMOUNT/10000 as type_value,'合同履约率' as rate,RATE_1 as rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '物资领用' as type,HOLDAMOUNT/10000 as type_value,'物资领用率' as rate,RATE_1 as rate_value FROM date_xm_01 UNION SELECT DEPT_NAME AS '所属网省',SUBSTR(YM,1,4) y,PRONAME AS '项目名称',MANOBJID AS '项目定义', '支出入账' as type,PAST/10000 as type_value,'支出入账率' as rate,RATE_1 as rate_value FROM date_xm_01 ) a WHERE y = '${统计日期}' AND 项目名称 = '${项目名称}'

  683个浏览 5个回答 FineReport 2017年04月18日发布
• 
  对单元格使用过滤条件后取不到正确的数据

  本帖最后由 竹林舞剑 于 2016-9-28 21:47 编辑 457934579245791 如图，对表中的C3和D3单元格使用了布尔型过滤条件，但得不到我想要的表中数据。 需求有三个：根据选择的年份统计出该年下每个月的①订单总数、②已付订单数量、③月销量 帮忙看下我做的表哪里有问题，谢谢！

  654个浏览 8个回答 FineReport 2016年09月27日发布
• 
  自定义组合图中的饼图会动态变换位置

  点击自定义组合图中的折线图的标记点，饼图的位置会动态显示在标记点的周围。 现在的效果是饼图的位置是固定的，需求是动态显示饼图位置，这个应该怎么写？ 60462

  568个浏览 5个回答 FineReport 2017年03月22日发布

39

120

39

10