viccui的提问 - 我的帆软

本帖最后由 viccui 于 2016-7-4 21:17 编辑我做的报表，表头比较复杂，前面还有两个隐藏行，导出的数据无法还原导回，愁死人了。哪位大神有解决办法？建议帆软提供更灵活的数据导入方式：如指定标题栏行，或去掉标题区，从某行开始只导入需要数据。同时可选是否把隐藏列计算在内，保证导入导出数据的一致性。另外大神有没有利用js代码或插件导入的方法，辛苦做的报表，没导入功能没法用啊！{:4_102:} 39231

3181个浏览 7个回答 FineReport 2016年07月04日发布

条件提交校验怎么实现

本帖最后由 viccui 于 2016-7-4 21:31 编辑有三个扩展单元格，如A10，B10，C10，均可为空，其中A100时，B10、A10不能为空或0，这在提交时怎么判断？

1334个浏览 4个回答 FineReport 2016年06月15日发布

提交校验无法捕获错误信息--- fr_verifyinfo，怎么解决？

我在网页框内做了一个表，使用自定义提交按钮，校验时fr_verifyinfo.success出错，提示fr_verifyinfo undefined。日志错误信息是：警告:expecting RPAREN, found 'null'。语句如下： _g('${sessionID}').verifyReport(); if(fr_verifyinfo.success) { alert("校验成功！"); _g('${sessionID}').writeReport(); //执行提交入库操作 } 说明：去掉判断的话校验、保存都能正常执行。

2012个浏览 6个回答 FineReport 2016年06月27日发布

执行第二遍时java.io.StreamCorruptedException: invalid stream header错误

本帖最后由 viccui 于 2016-6-23 21:43 编辑报表执行第二遍时，会抛出错误，再刷新两次可能就好了，一会又出现，有时只抛出错误码。查了一下度娘，似乎是客户端、服务端线程和流之类的问题，但我没有自定义能力，只是系统调用哪里的问题呢？怎么解决？严重:报表计算中 , __LOCALE__ : zh_CN, __STREAMCLOSED__ : , CMD : parameters_d, FR_USERNAME : sytlj, HIDEBLANK : true, HIDERADIO : 0, HIDEVALUE : 0, LABEL1 : 单位：, OP : fr_dialog, REPORTLET : report/report_sh.cpt, REPORTNAME : report/report_sh.cpt, SESSIONID : 27841, TOTALRADIO : 1, YEAR : 2016}] : java.io.StreamCorruptedException: invalid stream header: 6C652E50 at com.fr.cache.list.MappedByteBufferList.get(Unknown Source) at com.fr.cache.list.MappedByteBufferTable.getValueAt(Unknown Source) at com.fr.data.impl.DiskCacheDBDataModel.getValueAt(Unknown Source) at com.fr.data.index.AbstractIndexDataModel.getValueAt(Unknown Source) at com.fr.report.cell.cellattr.core.group.FunctionGrouper.current_value(Unknown Source) at com.fr.report.cell.cellattr.core.group.FunctionGrouper.dealGroupMode(Unknown Source) at com.fr.report.cell.cellattr.core.group.FunctionGrouper.group(Unknown Source) at com.fr.report.cell.cellattr.core.group.DSColumn.dealwith_condition_group_sort_select_result(Unknown Source) at com.fr.report.core.A.H.dealWithBEDSColumn(Unknown Source) at com.fr.report.core.A.k.cc_ce_array(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.resolveColumnRowRange(Unknown Source) at com.fr.report.core.A.u.getVariable(Unknown Source) at com.fr.script.Calculator$NameSpaceChain.getVariable(Unknown Source) at com.fr.script.Calculator.resolveVariableInCE(Unknown Source) at com.fr.stable.script.ColumnRowRange.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.script.Calculator.evalValue(Unknown Source) at com.fr.script.AbstractFunction.evalExpression(Unknown Source) at com.fr.parser.FunctionCall.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.function.IF.evalExpression(Unknown Source) at com.fr.parser.FunctionCall.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.stable.script.Expression.eval(Unknown Source) at com.fr.script.Calculator.evalString(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.script.Calculator.evalValue(Unknown Source) at com.fr.report.core.A.H.dealWithBENormal(Unknown Source) at com.fr.report.core.A.k.cc_ce_array(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.C(Unknown Source) at com.fr.report.core.A.H.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SequenceExecutor.execute(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor._execute(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor.execute(Unknown Source) at com.fr.stable.AbstractActor.executeWorkBook(Unknown Source) at com.fr.stable.AbstractActor.executeWorkBook(Unknown Source) at com.fr.main.impl.WorkBook.execute(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.stable.AbstractActor.getResultBookFromCacheIfNeed(Unknown Source) at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.calResultWorkBook(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getReport2Show(Unknown Source) at com.fr.web.core.A.cD.A(Unknown Source) at com.fr.web.core.A.nA.actionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.A.fC.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 javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 只抛出错误码的情况如下。注：以上情况刷新一次两次就能正常显示。是内部错误吗？求解决方法！严重:报表计算中 , __LOCALE__ : zh_CN, __STREAMCLOSED__ : , CMD : parameters_d, FR_USERNAME : sytlj, HIDEBLANK : true, HIDERADIO : 0, HIDEVALUE : 0, LABEL1 : 单位：, OP : fr_dialog, REPORTLET :report/report_sh.cpt, REPORTNAME : report/report_sh.cpt, SESSIONID : 8494, TOTALRADIO : 1, YEAR : 2016}] : 79225 at java.nio.DirectByteBuffer.get(Unknown Source) at com.fr.cache.list.MappedByteBufferList.readWhenHasCache(Unknown Source) at com.fr.cache.list.MappedByteBufferList.get(Unknown Source) at com.fr.cache.list.MappedByteBufferTable.getValueAt(Unknown Source) at com.fr.data.impl.DiskCacheDBDataModel.getValueAt(Unknown Source) at com.fr.data.index.AbstractIndexDataModel.getValueAt(Unknown Source) at com.fr.report.cell.cellattr.core.group.FunctionGrouper.current_value(Unknown Source) at com.fr.report.cell.cellattr.core.group.FunctionGrouper.dealGroupMode(Unknown Source) at com.fr.report.cell.cellattr.core.group.FunctionGrouper.group(Unknown Source) at com.fr.report.cell.cellattr.core.group.DSColumn.dealwith_condition_group_sort_select_result(Unknown Source) at com.fr.report.core.A.H.dealWithBEDSColumn(Unknown Source) at com.fr.report.core.A.k.cc_ce_array(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.resolveColumnRowRange(Unknown Source) at com.fr.report.core.A.u.getVariable(Unknown Source) at com.fr.script.Calculator$NameSpaceChain.getVariable(Unknown Source) at com.fr.script.Calculator.resolveVariableInCE(Unknown Source) at com.fr.stable.script.ColumnRowRange.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.script.Calculator.evalValue(Unknown Source) at com.fr.script.AbstractFunction.evalExpression(Unknown Source) at com.fr.parser.FunctionCall.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.function.IF.evalExpression(Unknown Source) at com.fr.parser.FunctionCall.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.stable.script.Expression.eval(Unknown Source) at com.fr.script.Calculator.evalString(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.script.Calculator.evalValue(Unknown Source) at com.fr.report.core.A.H.dealWithBENormal(Unknown Source) at com.fr.report.core.A.k.cc_ce_array(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.C(Unknown Source) at com.fr.report.core.A.H.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SequenceExecutor.execute(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor._execute(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor.execute(Unknown Source) at com.fr.stable.AbstractActor.executeWorkBook(Unknown Source) at com.fr.stable.AbstractActor.executeWorkBook(Unknown Source) at com.fr.main.impl.WorkBook.execute(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.stable.AbstractActor.getResultBookFromCacheIfNeed(Unknown Source) at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.calResultWorkBook(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getReport2Show(Unknown Source) at com.fr.web.core.A.cD.A(Unknown Source) at com.fr.web.core.A.nA.actionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.A.fC.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 javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2052个浏览 6个回答 FineReport 2016年06月23日发布

填报分页问题

本帖最后由 viccui 于 2016-6-20 19:11 编辑我的电脑，填报分页怎么不是示例的效果呢？首先，工具栏并不是填报工具栏，其次是横向也分页了，右侧列没在一页显示出来。 38640

1617个浏览 2个回答 FineReport 2016年06月20日发布

Excel导入时纵列串位（含隐藏列）

本帖最后由 viccui 于 2016-6-14 19:25 编辑我设计了一个报表，前两列为隐藏列（父格用），导出excel（不导隐藏列），再使用导出表导回时，整体数据前移了2列，包括标题行都导入了，这是为什么？我看帮助，excel导入可以识别标题，同时还可以识别控件，并且可以只导入控件位置数据，我这个是为什么呢？我也按帮助设置按标题导入而不按位置导入，怎么没起作用？如图： 38229---------------------------------------------------- 38230

1099个浏览 4个回答 FineReport 2016年06月14日发布

在同一个页面下表格联动怎么实现？

页面内设计了两个或者多个报表，每个报表间有相同的字段，我想实现表格间依次按照上一表格选中行对应条件过滤，也就是联动，怎么实现呢？举个例子：如表1显示公司信息，表2显示销售人员信息，表3显示销售产品信息。那么表1选中一行，那么表二自动刷新显示该公司的销售人员，表2选择一个销售人员所在行，则表3显示该人销售的产品。希望这些选中、刷新都自动完成（联动），怎么实现呢？模板参数和过滤似乎只对初始化时好用，随动却做不到。另外只想在报表中完成，因为还想做一些表格操作。求大神指导！！！

2859个浏览 7个回答 FineReport 2016年06月12日发布

提问

调整图片尺寸与位置

viccui（uid：68186）