FineReport11填报提交以后出来这样的提示该怎么解决?

楼主
我是社区第660597位番薯,欢迎点我头像关注我哦~

com.fr.write.WriteSubmitException: 子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后,或子查询用作表达式时,这种情况是不允许的。

异常位置

sheet:sheet1

填报属性:内置SQL1

at com.fr.write.DBCommitWrapper.commit(DBCommitWrapper.java:120)

at com.fr.write.DBCommitWrapper.commit2db(DBCommitWrapper.java:43)

at com.fr.report.write.BuiltInSQLSubmiter.execute(BuiltInSQLSubmiter.java:106)

at com.fr.report.write.ReportWriteAttr.submit(ReportWriteAttr.java:231)

at com.fr.report.write.SubmitHelper.submit$original$sZQTaUJV(SubmitHelper.java:79)

at com.fr.report.write.SubmitHelper.submit$original$sZQTaUJV$accessor$ygU9VGMp(SubmitHelper.java)

at com.fr.report.write.SubmitHelper$auxiliary$YniysFZa.call(Unknown Source)

at com.fr.report.core.ExceptionLocateInterceptor.intercept(ExceptionLocateInterceptor.java:27)

at com.fr.report.write.SubmitHelper.submit(SubmitHelper.java)

at com.fr.report.write.SubmitHelper.submit(SubmitHelper.java:126)

at com.fr.web.core.bochavy.FbtfrGjrdamLwiimpXasipp.actionCMD$original$Lw52iAaB(Unknown Source)

at com.fr.web.core.bochavy.FbtfrGjrdamLwiimpXasipp.actionCMD$original$Lw52iAaB$accessor$5A6BOyfF(Unknown Source)

at com.fr.web.core.bochavy.FbtfrGjrdamLwiimpXasipp$auxiliary$pjauyqQe.call(Unknown Source)

at com.fr.intelli.metrics.MonitorInterceptor.intercept(MonitorInterceptor.java)

at com.fr.web.core.bochavy.FbtfrGjrdamLwiimpXasipp.actionCMD(Unknown Source)

at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(WebActionsDispatcher.java)

at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(WebActionsDispatcher.java)

at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(WebActionsDispatcher.java)

at com.fr.web.core.bochavy.FbtfrGtjocxa.process(Unknown Source)

at com.fr.web.core.ReportDispatcher.dealWithOp(ReportDispatcher.java)

at com.fr.web.core.ReportDispatcher.dealWeblet(ReportDispatcher.java)

at com.fr.web.core.ReportDispatcher.dealWithRequest(ReportDispatcher.java)

at com.fr.web.controller.BaseRequestService.handleRequest(BaseRequestService.java:40)

 

分享扩散:

沙发
发表于 前天 15:44
应该是SQL写的有问题,子查询查出的数值多余1个,正常子查询应该是查出一个值
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

返回顶部 返回列表