• 
  能否设置如果报表没有查到内容则不发送邮件？

  FR10，现在做的定时调度每天发送一次，即使报表没有数据也会发送，能否设置如果没有查询到数据则不发送？

  488个浏览 1个回答 FineReport 2020年08月27日发布
• 
  设置邮箱后测试失败

  FR10.0设置邮箱后测试发送失败报错如下：javax.mail.AuthenticationFailedException: 550 User has no permission at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:965) at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:876) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:780) at javax.mail.Service.connect(Service.java:388) at javax.mail.Service.connect(Service.java:246) at com.fr.base.EmailManager.connect(Unknown Source) at com.fr.base.EmailManager.sendEmail(Unknown Source) at com.fr.base.EmailManager.send(Unknown Source) at com.fr.base.EmailManager.sendWithRecord(Unknown Source) at com.fr.base.EmailManager.send(Unknown Source) at com.fr.base.EmailManager.send(Unknown Source) at com.fr.base.EmailManager.send(Unknown Source) at com.fr.base.EmailManager.send(Unknown Source) at com.fr.base.EmailManager.sendTestMail(Unknown Source) at com.fr.decision.webservice.v10.config.ConfigService.testEmailConnection(Unknown Source) 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.decision.config.ConfigInterceptor.intercept(Unknown Source) at com.fr.decision.webservice.v10.config.ConfigService$$EnhancerByCGLIB$$fb9e39a3.testEmailConnection(<generated>) at com.fr.web.controller.decision.api.config.EmailResource.testEmail(Unknown Source) at com.fr.web.controller.decision.api.config.EmailResource$$FastClassBySpringCGLIB$$6124e2a1.invoke(<generated>) at com.fr.third.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:201) at com.fr.third.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:710) at com.fr.third.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at com.fr.third.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) at com.fr.decision.webservice.aspect.DecisionLogAspect.doControllerAround(Unknown Source) 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:621) at com.fr.third.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) at com.fr.third.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:69) 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:646) at com.fr.web.controller.decision.api.config.EmailResource$$EnhancerBySpringCGLIB$$d1e08be8.testEmail(<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:221) at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137) at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747) at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676) 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:938) at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870) at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.fr.decision.base.DecisionServletInitializer$6.doFilterInternal(Unknown Source) 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.DecisionServletInitializer$4.doFilter(Unknown Source) 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:88) 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:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)

  457个浏览 2个回答 FineReport 2020年08月27日发布
• 
  填报限制

  FR10，在填报的时候比如只允许填123这三个数字或只允许填报北京上海这两个地方如何设置，完善一下问题，是只允许比如0，1，2，3，4，999这5个数字

  480个浏览 4个回答 FineReport 2020年07月02日发布
• 
  调用存储过程时能否使用内置参数传参

  求JS写法，下面的写法是否正确FR10，数据库Oracle，建立了存储过程reate or replace procedure AAA (V_CGY IN VARCHAR2)  isbegin                  UPDATE TB_SYS_USERROLE SET DELETEFLAG=0 WHERE USERID =V_CGY;               commit;end;在填报页面设置处写了一个填报后事件，想根据登陆的用户编码来更新字段值var sql ="SQL(\" BBB\",\"call AAA('"+$fine_username+"')\",1,1)";return FR.remoteEvaluate(sql);

  915个浏览 1个回答 FineReport 2020年06月11日发布
• 
  求调用ORACLE存储过程传参模板

  存储过程如下create or replace procedure CS001(V_SL IN number default 10)asbegininsert into BSELECT HH,SL+V_SL,SYSDATE FROM A;commit;end ;在数据库中用EXEC  CS001;执行可以插入数据想实现在点击查询时将参数传入存储过程插入数据

  1196个浏览 3个回答 FineReport 2020年04月28日发布
• 
  如何导出FR中所有人员的模板权限

  想在FR中做一个报表查出所有人的模板权限

  590个浏览 2个回答 FineReport 2020年03月30日发布
• 
  Oracle连续天数

  样表如下：NAME   RQA001    2020-01-01A001    2020-01-02    A001    2020-01-05A001    2020-01-06B001    2020-01-01B001    2020-01-02B001    2020-01-03B001    2020-01-05想实现效果：NAME    开始日期              结束日期          连续天数    A001      2020-01-01        2020-01-02          2A001      2020-01-05        2020-01-06          2B001      2020-01-01        2020-01-03          3B001      2020-01-05        2020-01-05          1

  553个浏览 4个回答 SQL 2020年03月20日发布
• 
  Oracle 统计连续天数

  求Oracle 统计连续天数查询语句样表如下：NAME   RQA001    2020-01-01A001    2020-01-02    A001    2020-01-05A001    2020-01-06A001    2020-01-07B001    2020-01-01B001    2020-01-02B001    2020-01-03B001    2020-01-04B001    2020-01-06想实现查询结果为：NAME    连续天数A001       2A001       3B001       4B001       1

  1217个浏览 5个回答 SQL 2020年03月18日发布
• 
  在不修改FineDB 中 fine_conf_entity 表的值的情况下做导入

  FR10.0在使用EXCEL导入的功能时需要修改FineDB 中 fine_conf_entity 表的值，并重启服务器，但由于权限等问题无法重启服务器，有没有其他方法做EXCEL导入，如能否实现将EXCEL表内容复制粘贴后导入？？

  1078个浏览 1个回答 FineReport 2020年03月05日发布
• 
  根据帮助文档导入EXCEL根据标题匹配无法导入商品及类别

  根据在线帮助导入EXCEL根据标题匹配https://help.finereport.com/doc-view-1089.html下载帮助中的EXCEL模板导入发现无法导入产品及类别ID

  699个浏览 1个回答 FineReport 2020年03月05日发布

93

33

93

10