回答:可以试试标记导入
回答:参考:定时发送填报任务-https://help.fanruan.com/finereport/doc-view-3889.html
回答:https://bbs.fanruan.com/wenda/question/117783.html
回答:下拉树默认值设置-https://help.fanruan.com/finereport/doc-view-1011.html
回答:OR(LEFT(RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1),FIND("R",RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1))-1)>10,REPLACE(RIGHT(a1,INARRAY(" ",REVERSEARRAY(SPLIT(A1,"")))-1),'R','') = 0)用or()上面公式没改,下面那个加个replace。可以试试
回答:CSS修改控件样式-https://help.fanruan.com/finereport/doc-view-1367.html 写js或者引用css文件模板Web属性-https://help.fanruan.com/finereport/doc-view-1228.html
回答:WorkBook1.7z上传内置模板看下呢-----------------------------if (this.value != "") { var sql = 'select max(产品编码) cpbm from product where 产品类型="' + this.value + '"'; var bm=FR.remoteEvaluate('=sql("mysql","SELECT max(产品编码) cpbm from product where 产品类型=\''+this.value+'\'",1,1)');var new_bm = FR.remoteEvaluate('CONCATENATE(format(right("' + bm + '", 6) + 1, "#000000"))'); _g().setCellValue('B2', new_bm); }---------------------------------------if (this.value != "") { var sql = 'select max(产品编码) cpbm from product where 产品类型="' + this.value + '"'; var bm=FR.remoteEvaluate('=sql("micro_crm","SELECT max(产品编码) cpbm from product where 产品类型=\''+this.value+'\'",1,1)');var new_bm = FR.remoteEvaluate('CONCATENATE(left("' + bm + '", 2), format(right("' + bm + '", 6) + 1, "#000000"))'); if(bm.length==0){//判断该产品类型下是否有产品编码,如果没有,给默认值_g().setCellValue('B2', 'PJ000001');}else{_g().setCellValue('B2', new_bm);} }
回答:定义数据连接-https://help.fanruan.com/finereport/doc-view-234.html 参考文档,有不同数据库的连接方法
回答:sql中过滤或者将0转为空,结合
回答:这样?button0控件的点击事件:this.options.form.getWidgetByName("button0").css("background-color","red");this.options.form.getWidgetByName("button1").css("background-color","");button1控件的点击事件:this.options.form.getWidgetByName("button0").css("background-color","");this.options.form.getWidgetByName("button1").css("background-color","red");
3342
3342
30
10