• 
  新计算引擎首次查询速度很慢，是因为跨库查询的原因吗

  SELECT t.business_code,t.form_title,t.company_name,t.depart_name,t.current_user_name, t.enable_finished,   DATE_SUB(ar.created_time, INTERVAL ar.audit_duration hour) as startTime,ar.created_time as endTime,ar.audit_duration as auditDuration, aa.handleUserNamesFROM (select business_code,form_title,company_name,depart_name,current_user_name, enable_finished,item_type,form_id,tenant_id from temp_instance where tenant_id='001' and item_type = '1') t,(select form_id,enable_approve,tenant_id,created_time,audit_duration from prod_ibp_fee_workflow.approval_record where tenant_id = '001')ar,prod_ibp_fee_workflow.approval_status aps , (select form_id,group_concat(DISTINCT handle_organ_name Order BY created_time Separator ',') as handleUserNames  from prod_ibp_fee_workflow.approval_record group by form_id) aawhere t.item_type = '1' and t.form_id = ar.form_id and ar.enable_approve = aps.state and aps.is_visiable = 1  and aa.form_id = t.form_id and aps.tenant_id = '001'普通报表，只设置了新计算引擎

  290个浏览 2个回答 2022年10月18日发布
• 
  json数据竖向扩展

  有两条json数据放在A1，如何在使用其中的某一个字段(A2)时竖向扩展

  160个浏览 1个回答 2023年03月07日发布
• 
  有一种比较复杂的表单数据解析对应情况：填充横向扩展表头的数据是从两个数据集获取的多条json

  306个浏览 1个回答 FineReport 2022年05月27日发布
• 
  这种扩展得出的数据，能隐藏列支对象这一行为空的数据吗

  ----------------------------------------------------------

  278个浏览 3个回答 2022年09月13日发布
• 
  报表设计中如何获取前台传来的某个url参数数据，用来控制报表显示

  报表设计中如何获取前台传来的某个url参数数据，用来控制报表显示

  292个浏览 1个回答 2022年09月07日发布
• 
  数组内嵌套了两个内层数组，如何实现内层数组的扩展

  [[{"id": "c90b31f9-6ef6-4c13-b9fa-d3a9b2ed3611", "seq": 0, "code": "applyAmount", "title": "申请金额(元)", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "4", "displayType": "input", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": ""}, {"id": "22bbea26-838b-49a2-942c-67608a3fda43", "seq": 1, "code": "approvalAmount", "title": "审批金额(元)", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "4", "displayType": "input", "enableFirst": true, "enableDisable": false, "enableVisible": true, "calculateFormula": ""}, {"id": "c4c75f03-93d4-4937-87d0-ba891b40998d", "seq": 2, "code": "paymentWay", "title": "支付方式", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "1", "displayType": "select", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "", "dictionaryValues": "", "writeOffCalMethod": "2", "functionDescription": "require(选择支付方式)"}, {"id": "3a00857e-4b66-4320-931e-0b51fc17ae00", "seq": 3, "code": "feeIllustrate", "title": "备注", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "4", "displayType": "input", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "", "writeOffCalMethod": "2"}], [{"id": "29318c8c-414d-4e2c-bc65-0bda6bf86839", "seq": 0, "code": "applyProduct", "title": "申请产品", "width": "150", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "4", "displayType": "select", "enableFirst": false, "enableDisable": false, "enableVisible": true, "queryDefaultParam": "{\"material\": \"促销品\",\"productName\": \"\",\"productBrand\": \"\",\"tastingWine\": \"\"}", "writeOffCalMethod": "2"}, {"id": "183290d0-0556-4eb4-b40b-4005f76ce2be", "seq": 1, "code": "specs", "title": "规格", "width": "140", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "4", "displayType": "input", "enableFirst": true, "enableDisable": true, "enableVisible": true, "writeOffCalMethod": "2"}, {"id": "e5f4951f-452d-48bc-96d6-cd647b958f64", "seq": 2, "code": "num", "title": "数量", "width": "90", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "4", "displayType": "input", "enableFirst": false, "enableDisable": false, "enableVisible": true, "writeOffCalMethod": "1", "functionDescription": "validatePositiveInteger()"}, {"id": "c5fdbf74-eed7-4943-bd8f-a61395cd2f1c", "seq": 3, "code": "unitMoney", "unit": "oneRMB", "title": "单价/人均(元)", "width": "110", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "4", "displayType": "input", "enableFirst": false, "enableDisable": false, "enableVisible": true, "writeOffCalMethod": "2", "functionDescription": "validateDecimal()"}, {"id": "f45cbc0f-5da7-46e6-a300-c85e3aec63a1", "seq": 4, "code": "applyAmount", "unit": "oneRMB", "title": "申请金额(元)", "width": "110", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "5", "displayType": "input", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "num*unitMoney", "writeOffCalMethod": "1"}, {"id": "99212015-994b-46e6-a64b-bdbc93261d7b", "seq": 5, "code": "approvalAmount", "unit": "oneRMB", "title": "审批金额(元)", "width": "110", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "5", "displayType": "input", "enableFirst": true, "enableDisable": false, "enableVisible": true, "calculateFormula": "applyAmount", "writeOffCalMethod": "1"}, {"id": "0b531798-fe4a-4d38-8992-417b72daa3de", "seq": 6, "code": "feeIllustrate", "title": "备注", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "4", "displayType": "eject-window", "enableFirst": false, "enableDisable": true, "enableVisible": true, "writeOffCalMethod": "2"}, {"id": "b8969c91-b849-43c6-8e4f-ade9f872f068", "seq": 7, "code": "enableThisProduct", "title": "是否本品", "width": "100", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "1", "displayType": "checkbox", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "", "writeOffCalMethod": "2"}, {"id": "63ac0dd5-5a5c-4a1e-8492-168f8ba6707a", "seq": 8, "code": "paymentWay", "title": "支付方式", "width": "100", "versionId": "0542dc8b-3a7b-46a8-8f5d-46778aa1d9bc", "dataSource": "1", "displayType": "select", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "", "dictionaryValues": "", "writeOffCalMethod": "2", "functionDescription": "require('选择支付方式')"}]]-----------------------------------将左边的大数组内的两个小数组分别拆分出来，[{"id": "c90b31f9-6ef6-4c13-b9fa-d3a9b2ed3611", "seq": 0, "code": "applyAmount", "title": "申请金额(元)", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "4", "displayType": "input", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": ""}, {"id": "22bbea26-838b-49a2-942c-67608a3fda43", "seq": 1, "code": "approvalAmount", "title": "审批金额(元)", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "4", "displayType": "input", "enableFirst": true, "enableDisable": false, "enableVisible": true, "calculateFormula": ""}, {"id": "c4c75f03-93d4-4937-87d0-ba891b40998d", "seq": 2, "code": "paymentWay", "title": "支付方式", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "1", "displayType": "select", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "", "dictionaryValues": "", "writeOffCalMethod": "2", "functionDescription": "require(选择支付方式)"}, {"id": "3a00857e-4b66-4320-931e-0b51fc17ae00", "seq": 3, "code": "feeIllustrate", "title": "备注", "width": "100", "versionId": "783c0c6e-0ddd-446b-b748-204ca6e92eaf", "dataSource": "4", "displayType": "input", "enableFirst": false, "enableDisable": true, "enableVisible": true, "calculateFormula": "", "writeOffCalMethod": "2"}]以上是我用SPLIT(REPLACE(RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-2),"], ]\\[")拆分出来的其中一个内嵌数组数据-------------------------------------------------

  267个浏览 1个回答 2022年08月25日发布
• 
  如果将单元格的值作为数组索引获取数组内的数据，如以下公式中的A28的值是0或者1之类的数字

  JSONPathFinder(B16,"$.disburseSubFeePurposeList.extension")

  549个浏览 1个回答 FineReport 2022年07月30日发布
• 
  ssoToken解析失败

  系统管理>集成后台单点登录，解密测试测试当前ssoToken结果能正常解析，但是打开报表会提示解析失败

  1359个浏览 1个回答 FineReport 2022年07月29日发布
• 
  jsonPathFinder取出json数据之后，格式变成了等于号，这是什么原因，能再转回对象格式吗

  原数据如下："extension":{"feeIllustrate":"备注21","distributionCategory":"C","unitMoney":"2","num":"2","customerNum":"2","feePurposeCode":"fee_sub00000013","faceNum":"2","approvalAmount":"16.00","applyAmount":"16.00"}公式如下：JSONPathFinder(B16,"$.disburseSubFeePurposeList.extension")

  524个浏览 0个回答 FineReport 2022年07月30日发布
• 
  请问如果不从数据库获取数据的话，可以直接从前台传json数据到帆软渲染吗

  因为前台打印之前数据可能会变化，数据库内保存的值不是最新的，所以如果不从数据库获取数据的话，可以直接从前台传json数据到帆软渲染吗

  301个浏览 1个回答 FineReport 2022年07月27日发布

15

3

15

10