• 
  相对层次公式问题，FR11实现

  页面公式cs.rar页面查看效果想要达到效果，EXCEL截图EXCEL公式截图应该是SUM(A3:B3) 这个没有算到对应的位置，只是加了B3这一个单元格，前面的值并没有加到横向扩展，A3要累加B3算出来的值之后再用相同的公式计算

  290个浏览 3个回答 2023年05月25日发布
• 
  FR10.0公式应用

  公式能否将SQL函数查出的B010,B011这样的数据显示成B010','B011呢？不一定只有这两个，可能是多个不固定的，SPLIT函数可以分开，但是再怎么拼接呢？数据库是MYSQL，或者在SQL里实现也可以，SQL试过GROUP_CONCAT，不太行公式举例：SQL("FRDemo","SELECT 'B010' AS ID union all SELECT 'B011' AS ID",1)现在效果想要实现

  243个浏览 3个回答 2023年04月24日发布
• 
  FineBI导入用户失败，数据库HIVE

  com.fr.third.org.hibernate.exception.ConstraintViolationException: could not execute batch at com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112) at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:236) at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:617) at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:462) at com.fr.third.org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at com.fr.third.org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:50) at com.fr.third.org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1263) at com.fr.third.org.hibernate.internal.SessionImpl.list(SessionImpl.java:1331) at com.fr.third.org.hibernate.internal.QueryImpl.list(QueryImpl.java:87) at com.fr.third.org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966) at com.fr.stable.db.session.DAOSessionStore$1.count(DAOSessionStore.java) at com.fr.stable.db.tenant.dao.BaseCombinedIdDao.count(BaseCombinedIdDao.java) at com.fr.decision.authority.controller.UserControllerImpl.getUserCount(UserControllerImpl.java:1394) at com.fr.decision.sync.work.impl.UserSyncWork.currentCount(UserSyncWork.java:275) at com.fr.decision.sync.work.impl.UserSyncWork.over(UserSyncWork.java:231) at com.fr.decision.sync.TableDataSyncAction.over(TableDataSyncAction.java:166) at com.fr.decision.sync.TableDataSyncAction.execute(TableDataSyncAction.java:69) at com.fr.decision.authority.controller.personnel.PersonnelActionManager.execute(PersonnelActionManager.java:75) at com.fr.decision.authority.controller.personnel.PersonnelActionManager.doWork(PersonnelActionManager.java:50) at com.fr.decision.authority.AuthorityContext.doPersonnelWork(AuthorityContext.java:421) at com.fr.decision.service.authority.impl.DefaultDecisionUserServiceProvider.importUsers(DefaultDecisionUserServiceProvider.java:534) at com.fr.web.controller.decision.api.user.UserResource.importUser(UserResource.java:92) at com.fr.web.controller.decision.api.user.UserResource$$FastClassBySpringCGLIB$$992c3099.invoke(<generated>) at com.fr.third.net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:205) at com.fr.third.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:737) at com.fr.third.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at com.fr.third.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:84) at com.fr.decision.webservice.aspect.DecisionLogAspect.doControllerAround(DecisionLogAspect.java:42) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.fr.third.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at com.fr.third.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at com.fr.third.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at com.fr.third.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168) at com.fr.third.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at com.fr.third.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at com.fr.third.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:672) at com.fr.web.controller.decision.api.user.UserResource$$EnhancerBySpringCGLIB$$8946e9c2.importUser(<generated>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854) at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765) at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:682) at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:765) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.webservice.BackupActivator$1.doFilter(BackupActivator.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.webservice.filter.TenantFilter.doFilter(TenantFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.base.DecisionServletInitializer$6.doFilterInternal(DecisionServletInitializer.java:242) at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.base.VirtualFilterChain.doFilter(VirtualFilterChain.java:34) at com.fr.decision.base.DecisionServletInitializer$4.doFilter(DecisionServletInitializer.java:174) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.webservice.filter.SecurityRefererFilter.doFilter(SecurityRefererFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.webservice.filter.CookieCheckFilter.doFilterInternal(CookieCheckFilter.java:37) at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1693) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:750)Caused by: java.sql.BatchUpdateException: Duplicate entry 'WangWei-default' for key 'UK548m71akign8vsov5smlm4uwx' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1154) at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1835) at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1319) at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:954) at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 105 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'WangWei-default' for key 'UK548m71akign8vsov5smlm4uwx' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2136) at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1813) ... 109 more

  208个浏览 1个回答 2023年02月07日发布
• 
  定时调度-调度周期-公式判断

  其他配置相同，定时调度-调度周期-公式判断是否不同版本有字数限制，这样写SQL公式是可以保存的SQL("dm","SELECT T1.ShortName FROM (select * from dm.FIN_Material_Price_Rise) AS T1 INNER JOIN dw.Input_RawMaterial_Standard AS T2 ON 1=1 where t1.Marketdate = '2022-08-24'  ",1,1) <> null加了条件后就保存不了了SQL("dm","SELECT T1.ShortName FROM (select * from dm.FIN_Material_Price_Rise) AS T1 INNER JOIN dw.Input_RawMaterial_Standard AS T2 ON 1=1 where t1.Marketdate = '2022-08-24'and T1.ShortName = '1' or T1.ShortName = '2'  ",1,1) <> null但是用我本地的又可以保存SQL("dm","SELECT T1.ShortName FROM (select * from dm.FIN_Material_Price_Rise) AS T1 INNER JOIN dw.Input_RawMaterial_Standard AS T2 ON 1=1 where t1.Marketdate = '2022-08-24'and T1.ShortName = '1' or T1.ShortName = '2'  ",1,1) <> null版本截图，失败版本直接下载软件，之后从低版本跨版本升级的成功版本截图，直接下载的软件

  281个浏览 2个回答 2022年09月09日发布
• 
  填报想实现动态扩展行，RANGE(1,变量a,1)公式不好用，有没有大神知道js怎么写

  填报预览想实现动态扩展行，选择一个月份，12月就扩展12行，显示1-12为序号，1月就不扩展，显示1，相当于序号，RANGE(1,月份,1)公式不好用，会在1个单元格里显示数组，不进行扩展，有没有大神知道js怎么写填报动态扩展行.rar

  533个浏览 5个回答 FineReport 2022年07月07日发布
• 
  关于超链接的先后顺序，frm报表里，可以设置先执行报表块里的动态参数，再执行外面点击事件js脚本吗

  1、frm报表里，可以设置先执行报表块里的动态参数，再执行外面点击事件js脚本吗（现在第一次点击为null，第二次显示参数值）。2、JavaScript脚本可以绑定使用数据集的数据列吗。（我要实现不同的参数参数传递，网页框跳转不同的链接），公式里写SQL绑定（sql("FRDemo",sql+参数 ,1)）也试验过，还是遇到第一个先后顺序的问题。项目盾构机.zip

  575个浏览 3个回答 FineReport 2021年12月14日发布
• 
  引用javascript文件，传入用户名和密码，如何接收return的值呢？

  我想引用javascript文件，传入用户名和密码，如何接收return返回后的加密密码呢，或者有其他实现方法吗？

  397个浏览 1个回答 FineReport 2021年12月03日发布
• 
  预览报表显示Oops!!!非常抱歉，出错啦。

  有没有大佬知道这个错误需要怎么解决

  328个浏览 1个回答 FineReport 2021年11月19日发布
• 
  实现点击显示主题列表，点击列表实现跳转

  点击红框出现列表，点击列表实现跳转，已经参考了动态参数实现多级下拉折叠菜单，设置之后点击，位置会改变扩展，而且会出现滚动条，是否有其他的设置方法，或者解决点击折叠菜单后位置发生改变的问题？项目投资融资.zip

  295个浏览 2个回答 FineReport 2021年11月15日发布
• 
  钻取地图实现，钻取后超链接跳转页面

  实现功能：通过自定义钻取地图，第一级设置区域地图为省份，点击省份下钻至项目经纬度页面，点击项目点跳转至项目页面。遇到问题：设置超级链接后，点击省份会触发超链接和下钻，是否能通过js脚本判断点击的区域名是否带省和自治区字段控制超链接生效。如果能实现，哪位大佬提供一下写法!!!下面为模板及地图文件dss(1)(1).zip地图.frm

  654个浏览 2个回答 FineReport 2021年11月04日发布

36

874

36

10