• 
  换行问题

  1.设计器2.预览效果3.期待效果

  33个浏览 3个回答 2025年11月10日发布
• 
  自定义导出插件

  本地和服务器都装了，没启用，FR连接的远程服务器

  22个浏览 2个回答 2025年11月07日发布
• 
  快速替换

  数据集过滤，可以快速替换多个吗

  40个浏览 4个回答 2025年11月06日发布
• 
  数据表关联问题，特定字段值需要做关联重新取值

  u2至x4字段没值，可能是什么原因：SELECT     r.b AS b1,    r.c AS c1,    r.d AS d1,    r.e AS e1,    r.f AS f1,    r.g AS g1,    r.h AS h1,    r.i AS i1,    r.j AS j1,    r.k AS k1,    r.l AS l1,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.lfy_actual_ytd_display ELSE a.lfy_actual_ytd_display END        ELSE NULL     END AS u2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_budget_ytd_display ELSE a.cfy_budget_ytd_display END        ELSE NULL     END AS v2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f1_ytd_display ELSE a.cfy_f1_ytd_display END        ELSE NULL     END AS w2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f2_ytd_display ELSE a.cfy_f2_ytd_display END        ELSE NULL     END AS x2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.nfy_budget_ytd_display ELSE a.nfy_budget_ytd_display END        ELSE NULL     END AS z2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_mtd_display ELSE a.ly_actual_mtd_display END        ELSE NULL     END AS o3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_mtd_display ELSE a.cy_budget_mtd_display END        ELSE NULL     END AS p3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_mtd_display ELSE a.cy_actual_mtd_display END        ELSE NULL     END AS q3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_ytd_display ELSE a.ly_actual_ytd_display END        ELSE NULL     END AS o4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_ytd_display ELSE a.cy_budget_ytd_display END        ELSE NULL     END AS p4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_ytd_display ELSE a.cy_actual_ytd_display END        ELSE NULL     END AS q4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_lfyact_fullyear_display ELSE a.cal_contvar_cfyf1_lfyact_fullyear_display END        ELSE NULL     END AS ai2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_cfybud_fullyear_display ELSE a.cal_contvar_cfyf1_cfybud_fullyear_display END        ELSE NULL     END AS aj2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_lfyact_fullyear_display ELSE a.cal_contvar_cfyf2_lfyact_fullyear_display END        ELSE NULL     END AS ak2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfybud_fullyear_display ELSE a.cal_contvar_cfyf2_cfybud_fullyear_display END        ELSE NULL     END AS al2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfyf1_fullyear_display ELSE a.cal_contvar_cfyf2_cfyf1_fullyear_display END        ELSE NULL     END AS am2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_nfybud_cfyf2_fullyear_display ELSE a.cal_contvar_nfybud_cfyf2_fullyear_display END        ELSE NULL     END AS aq2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfybud_lfybud_fullyear_display ELSE a.cal_contvar_cfybud_lfybud_fullyear_display END        ELSE NULL     END AS ar2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_mtd_display ELSE a.cal_contvar_cyact_lyact_mtd_display END        ELSE NULL     END AS w3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_mtd_display ELSE a.cal_contvar_cyact_cybud_mtd_display END        ELSE NULL     END AS x3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_ytd_display ELSE a.cal_contvar_cyact_lyact_ytd_display END        ELSE NULL     END AS w4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_ytd_display ELSE a.cal_contvar_cyact_cybud_ytd_display END        ELSE NULL     END AS x4FROM raw_finerpt_config_vprpt_displaysetting r LEFT JOIN apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis a     ON a.vmr_code_entity = r.c     AND a.vmr_code_kfi = 'Vec_15'    AND a.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'    AND a.vmr_type_data = '${vmr_type_data}'    AND a.config_accesscode LIKE '%${config_accesscode}%'    AND a.type_displaycurr = '${type_displaycurr}'    AND a.cmentity_type_buzunit = '${cmentity_type_buzunit}'LEFT JOIN (    SELECT        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str,        SUM(t1.lfy_actual_ytd_display) AS lfy_actual_ytd_display,        SUM(t1.cfy_budget_ytd_display) AS cfy_budget_ytd_display,        SUM(t1.cfy_f1_ytd_display) AS cfy_f1_ytd_display,        SUM(t1.cfy_f2_ytd_display) AS cfy_f2_ytd_display,        SUM(t1.nfy_budget_ytd_display) AS nfy_budget_ytd_display,        SUM(t1.ly_actual_mtd_display) AS ly_actual_mtd_display,        SUM(t1.cy_budget_mtd_display) AS cy_budget_mtd_display,        SUM(t1.cy_actual_mtd_display) AS cy_actual_mtd_display,        SUM(t1.ly_actual_ytd_display) AS ly_actual_ytd_display,        SUM(t1.cy_budget_ytd_display) AS cy_budget_ytd_display,        SUM(t1.cy_actual_ytd_display) AS cy_actual_ytd_display,        SUM(t1.cal_contvar_cfyf1_lfyact_fullyear_display) AS cal_contvar_cfyf1_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf1_cfybud_fullyear_display) AS cal_contvar_cfyf1_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_lfyact_fullyear_display) AS cal_contvar_cfyf2_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfybud_fullyear_display) AS cal_contvar_cfyf2_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfyf1_fullyear_display) AS cal_contvar_cfyf2_cfyf1_fullyear_display,        SUM(t1.cal_contvar_nfybud_cfyf2_fullyear_display) AS cal_contvar_nfybud_cfyf2_fullyear_display,        SUM(t1.cal_contvar_cfybud_lfybud_fullyear_display) AS cal_contvar_cfybud_lfybud_fullyear_display,        SUM(t1.cal_contvar_cyact_lyact_mtd_display) AS cal_contvar_cyact_lyact_mtd_display,        SUM(t1.cal_contvar_cyact_cybud_mtd_display) AS cal_contvar_cyact_cybud_mtd_display,        SUM(t1.cal_contvar_cyact_lyact_ytd_display) AS cal_contvar_cyact_lyact_ytd_display,        SUM(t1.cal_contvar_cyact_cybud_ytd_display) AS cal_contvar_cyact_cybud_ytd_display    FROM apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis AS t1    WHERE (t1.vmr_code_kfi = 'Vec_11' AND t1.cmentity_type_buz <> 'Holding')        OR (t1.vmr_code_kfi = 'Vec_14' AND t1.cmentity_type_buz = 'Holding')    GROUP BY        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str) b ON b.cmentity_type_buzunit = '${cmentity_type_buzunit}'    AND b.vmr_type_data = '${vmr_type_data}'    AND b.type_displaycurr = '${type_displaycurr}'    AND b.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'WHERE r.k = 'Ctrl EBITDA'    AND r.j::text != '0'     AND r.year = LEFT('${ymonth}', 4)    AND (        (r.j::text != '2')         OR         (r.j::text = '2' AND r.b LIKE '%${config_accesscode}%')    )ORDER BY l1

  5个浏览 1个回答 2025年09月24日发布
• 
  sql数据关联问题

  字段u2至x4没有值，可能什么原因：SELECT     r.b AS b1,    r.c AS c1,    r.d AS d1,    r.e AS e1,    r.f AS f1,    r.g AS g1,    r.h AS h1,    r.i AS i1,    r.j AS j1,    r.k AS k1,    r.l AS l1,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.lfy_actual_ytd_display ELSE a.lfy_actual_ytd_display END        ELSE NULL     END AS u2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_budget_ytd_display ELSE a.cfy_budget_ytd_display END        ELSE NULL     END AS v2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f1_ytd_display ELSE a.cfy_f1_ytd_display END        ELSE NULL     END AS w2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f2_ytd_display ELSE a.cfy_f2_ytd_display END        ELSE NULL     END AS x2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.nfy_budget_ytd_display ELSE a.nfy_budget_ytd_display END        ELSE NULL     END AS z2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_mtd_display ELSE a.ly_actual_mtd_display END        ELSE NULL     END AS o3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_mtd_display ELSE a.cy_budget_mtd_display END        ELSE NULL     END AS p3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_mtd_display ELSE a.cy_actual_mtd_display END        ELSE NULL     END AS q3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_ytd_display ELSE a.ly_actual_ytd_display END        ELSE NULL     END AS o4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_ytd_display ELSE a.cy_budget_ytd_display END        ELSE NULL     END AS p4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_ytd_display ELSE a.cy_actual_ytd_display END        ELSE NULL     END AS q4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_lfyact_fullyear_display ELSE a.cal_contvar_cfyf1_lfyact_fullyear_display END        ELSE NULL     END AS ai2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_cfybud_fullyear_display ELSE a.cal_contvar_cfyf1_cfybud_fullyear_display END        ELSE NULL     END AS aj2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_lfyact_fullyear_display ELSE a.cal_contvar_cfyf2_lfyact_fullyear_display END        ELSE NULL     END AS ak2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfybud_fullyear_display ELSE a.cal_contvar_cfyf2_cfybud_fullyear_display END        ELSE NULL     END AS al2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfyf1_fullyear_display ELSE a.cal_contvar_cfyf2_cfyf1_fullyear_display END        ELSE NULL     END AS am2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_nfybud_cfyf2_fullyear_display ELSE a.cal_contvar_nfybud_cfyf2_fullyear_display END        ELSE NULL     END AS aq2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfybud_lfybud_fullyear_display ELSE a.cal_contvar_cfybud_lfybud_fullyear_display END        ELSE NULL     END AS ar2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_mtd_display ELSE a.cal_contvar_cyact_lyact_mtd_display END        ELSE NULL     END AS w3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_mtd_display ELSE a.cal_contvar_cyact_cybud_mtd_display END        ELSE NULL     END AS x3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_ytd_display ELSE a.cal_contvar_cyact_lyact_ytd_display END        ELSE NULL     END AS w4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_ytd_display ELSE a.cal_contvar_cyact_cybud_ytd_display END        ELSE NULL     END AS x4FROM raw_finerpt_config_vprpt_displaysetting r LEFT JOIN apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis a     ON a.vmr_code_entity = r.c     AND a.vmr_code_kfi = 'Vec_15'    AND a.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'    AND a.vmr_type_data = '${vmr_type_data}'    AND a.config_accesscode LIKE '%${config_accesscode}%'    AND a.type_displaycurr = '${type_displaycurr}'    AND a.cmentity_type_buzunit = '${cmentity_type_buzunit}'LEFT JOIN (    SELECT        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str,        SUM(t1.lfy_actual_ytd_display) AS lfy_actual_ytd_display,        SUM(t1.cfy_budget_ytd_display) AS cfy_budget_ytd_display,        SUM(t1.cfy_f1_ytd_display) AS cfy_f1_ytd_display,        SUM(t1.cfy_f2_ytd_display) AS cfy_f2_ytd_display,        SUM(t1.nfy_budget_ytd_display) AS nfy_budget_ytd_display,        SUM(t1.ly_actual_mtd_display) AS ly_actual_mtd_display,        SUM(t1.cy_budget_mtd_display) AS cy_budget_mtd_display,        SUM(t1.cy_actual_mtd_display) AS cy_actual_mtd_display,        SUM(t1.ly_actual_ytd_display) AS ly_actual_ytd_display,        SUM(t1.cy_budget_ytd_display) AS cy_budget_ytd_display,        SUM(t1.cy_actual_ytd_display) AS cy_actual_ytd_display,        SUM(t1.cal_contvar_cfyf1_lfyact_fullyear_display) AS cal_contvar_cfyf1_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf1_cfybud_fullyear_display) AS cal_contvar_cfyf1_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_lfyact_fullyear_display) AS cal_contvar_cfyf2_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfybud_fullyear_display) AS cal_contvar_cfyf2_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfyf1_fullyear_display) AS cal_contvar_cfyf2_cfyf1_fullyear_display,        SUM(t1.cal_contvar_nfybud_cfyf2_fullyear_display) AS cal_contvar_nfybud_cfyf2_fullyear_display,        SUM(t1.cal_contvar_cfybud_lfybud_fullyear_display) AS cal_contvar_cfybud_lfybud_fullyear_display,        SUM(t1.cal_contvar_cyact_lyact_mtd_display) AS cal_contvar_cyact_lyact_mtd_display,        SUM(t1.cal_contvar_cyact_cybud_mtd_display) AS cal_contvar_cyact_cybud_mtd_display,        SUM(t1.cal_contvar_cyact_lyact_ytd_display) AS cal_contvar_cyact_lyact_ytd_display,        SUM(t1.cal_contvar_cyact_cybud_ytd_display) AS cal_contvar_cyact_cybud_ytd_display    FROM apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis AS t1    WHERE (t1.vmr_code_kfi = 'Vec_11' AND t1.cmentity_type_buz <> 'Holding')        OR (t1.vmr_code_kfi = 'Vec_14' AND t1.cmentity_type_buz = 'Holding')    GROUP BY        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str) b ON b.cmentity_type_buzunit = '${cmentity_type_buzunit}'    AND b.vmr_type_data = '${vmr_type_data}'    AND b.type_displaycurr = '${type_displaycurr}'    AND b.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'WHERE r.k = 'Ctrl EBITDA'    AND r.j::text != '0'     AND r.year = LEFT('${ymonth}', 4)    AND (        (r.j::text != '2')         OR         (r.j::text = '2' AND r.b LIKE '%${config_accesscode}%')    )ORDER BY l1

  13个浏览 1个回答 2025年09月24日发布
• 
  跨sheet引用

  两个引用值单独在单元格有值，相减时第二个引用值不生效：在上一个单元格放入第二个值时，公式可以正常计算,第一个值为数据集过滤出来的单个值，第二个是sum值

  29个浏览 2个回答 2025年11月06日发布
• 
  边框问题

  怎么设置这一个单元格，得到右边边框效果：

  27个浏览 1个回答 2025年11月04日发布
• 
  隐藏列宽导出后变了，可能啥原因

  设置了固定列宽，导出excel后变成标准列宽了

  36个浏览 4个回答 2025年11月03日发布
• 
  if条件不同数据集问题

  同行后面其他列的数据可以根据if条件更换数据集吗

  40个浏览 2个回答 2025年10月24日发布
• 
  计算问题

  O57=O35 + O49 + O55O35 、O49 、O55的计算都涉及到了条件属性新值，结果都是正确的O35 、O49 、O55内容是包含新值的公式O57的结果错误，公式都正确，可能是什么原因

  42个浏览 3个回答 2025年10月22日发布

85

7

85

10