请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
JL98(uid:452208)
职业资格认证:FCA-FineReport | FCA-简道云 | FCP-FineBI | FCP-报表交付工程师 | FCA-FineBI | FCA-业务分析理论
  • 页面公式cs.rar页面查看效果想要达到效果,EXCEL截图EXCEL公式截图应该是SUM(A3:B3) 这个没有算到对应的位置,只是加了B3这一个单元格,前面的值并没有加到横向扩展,A3要累加B3算出来的值之后再用相同的公式计算
  • 公式能否将SQL函数查出的B010,B011这样的数据显示成B010','B011呢?不一定只有这两个,可能是多个不固定的,SPLIT函数可以分开,但是再怎么拼接呢?数据库是MYSQL,或者在SQL里实现也可以,SQL试过GROUP_CONCAT,不太行公式举例:SQL("FRDemo","SELECT 'B010' AS ID union all SELECT 'B011' AS ID",1)现在效果想要实现
  • 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
  • 其他配置相同,定时调度-调度周期-公式判断是否不同版本有字数限制,这样写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版本截图,失败版本直接下载软件,之后从低版本跨版本升级的成功版本截图,直接下载的软件
  • 填报预览想实现动态扩展行,选择一个月份,12月就扩展12行,显示1-12为序号,1月就不扩展,显示1,相当于序号,RANGE(1,月份,1)公式不好用,会在1个单元格里显示数组,不进行扩展,有没有大神知道js怎么写填报动态扩展行.rar
  • 1、frm报表里,可以设置先执行报表块里的动态参数,再执行外面点击事件js脚本吗(现在第一次点击为null,第二次显示参数值)。2、JavaScript脚本可以绑定使用数据集的数据列吗。(我要实现不同的参数参数传递,网页框跳转不同的链接),公式里写SQL绑定(sql("FRDemo",sql+参数 ,1))也试验过,还是遇到第一个先后顺序的问题。项目盾构机.zip
  • 我想引用javascript文件,传入用户名和密码,如何接收return返回后的加密密码呢,或者有其他实现方法吗?
  • 有没有大佬知道这个错误需要怎么解决
  • 点击红框出现列表,点击列表实现跳转,已经参考了动态参数实现多级下拉折叠菜单,设置之后点击,位置会改变扩展,而且会出现滚动条,是否有其他的设置方法,或者解决点击折叠菜单后位置发生改变的问题?项目投资融资.zip
  • 实现功能:通过自定义钻取地图,第一级设置区域地图为省份,点击省份下钻至项目经纬度页面,点击项目点跳转至项目页面。遇到问题:设置超级链接后,点击省份会触发超链接和下钻,是否能通过js脚本判断点击的区域名是否带省和自治区字段控制超链接生效。如果能实现,哪位大佬提供一下写法!!!下面为模板及地图文件dss(1)(1).zip地图.frm

36

871

36

10

个人成就
内容被浏览15,603
加入社区3年331天
返回顶部