乾学院 5002 号会员
6 回帖  •  53 浏览  • 
待解决      ...

表达式在我的电脑是可以正常预览的，但是换了一台电脑就不行了，控制台报错是这个，有没有大佬帮忙解决一下的

 
报错(1)

[2025-05-28 20:49:18] : [INFO] - 开始运算报表，首先取数……
[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - feeClrIds=SELECT DISTINCT fee_clr_id
FROM medins_pre_clr_sum_d
WHERE clr_ym = ?
AND VALI_FLAG = ‘1’
and insutype in (‘310’,‘340’)
[2025-05-28 20:49:18] : [DEBUG] - arg0: 202504
[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - docnos=SELECT DISTINCT docno
FROM trt_dfr_doc_d
WHERE DFR_SOUC = ‘2012’
AND souc_sn in (?)
AND VALI_FLAG = ‘1’
AND FIN_ACCTSET IN (‘310’, ‘311’, ‘312’, ‘320’, ‘340’)
[2025-05-28 20:49:18] : [DEBUG] - arg0: 149900S000000000000039003
[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - dfrId=SELECT docno,dfr_id
FROM trt_dfr_doc_d
WHERE DFR_SOUC = ‘2012’
AND docno in (?)
AND VALI_FLAG = ‘1’
AND FIN_ACCTSET IN (‘310’, ‘311’, ‘312’, ‘320’, ‘340’)
group by docno,dfr_id
[2025-05-28 20:49:18] : [DEBUG] - arg0: 149900S000000000000053001
[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - getPlaceCode=SELECT PARA_TYPE, PARA_LABL, PARA_CODE FROM data_para_ext_d WHERE PARA_TYPE IN (‘DFR_SOUC’, ‘CLR_TYPE_LV2’)

[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - optInfo=SELECT
OPTINS_NO,
OPT_TIME,
OPTER_NAME,
DFR_SOUC
FROM
trt_dfr_doc_d
WHERE
DOCNO in (?)
AND VALI_FLAG = ‘1’
LIMIT 1
[2025-05-28 20:49:18] : [DEBUG] - arg0: 149900S000000000000053001
[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - trtDfrDoc=SELECT
docno,
sum(DFR_SUMAMT) as dfr_sumamt
FROM
trt_dfr_doc_d
WHERE
DFR_SOUC = ‘2012’
AND DOCNO in (?)
AND FIN_ACCTSET IN (‘310’, ‘311’, ‘312’, ‘320’, ‘340’)
AND VALI_FLAG = ‘1’
group by docno
[2025-05-28 20:49:18] : [DEBUG] - arg0: 149900S000000000000053001
[2025-05-28 20:49:18] : [DEBUG] - 下面开始打出 sql
[2025-05-28 20:49:18] : [DEBUG] - trtDfrDocDetl=SELECT
dfr_id,
DFR_OBJ_CODE,
DFR_OBJ_NAME,
CASHYM,
CLR_TYPE_LV2,
SUM(CASE WHEN FUND_MNY = ‘310009’
AND POOLAREA_FUND_PAY_TYPE NOT IN (‘999801’, ‘999802’, ‘999803’, ‘999804’, ‘99999756’, ‘31020402’)
THEN DFR_SUMAMT ELSE 0 END) accsum,

SUM(CASE WHEN FUND_MNY = ‘310008’
AND POOLAREA_FUND_PAY_TYPE IN (‘310101’, ‘999712’, ‘310102’)
AND CLR_TYPE_LV2 != ‘999983’
THEN DFR_SUMAMT ELSE 0 END) insusum,

SUM(CASE WHEN FUND_MNY = ‘310008’
AND POOLAREA_FUND_PAY_TYPE IN (‘310101’, ‘999712’)
AND MED_TYPE IN (‘530102’, ‘52’, ‘520101’, ‘530202’)
AND CLR_TYPE_LV2 != ‘999983’
THEN DFR_SUMAMT ELSE 0 END) AS sySum,

SUM(CASE WHEN (FUND_MNY = ‘310008’
AND POOLAREA_FUND_PAY_TYPE IN (‘310101’, ‘999712’)
AND CLR_TYPE_LV2 = ‘999983’)
OR POOLAREA_FUND_PAY_TYPE = ‘31020402’
THEN DFR_SUMAMT ELSE 0 END) yddfsum,

SUM(CASE WHEN FUND_MNY = ‘310008’
AND POOLAREA_FUND_PAY_TYPE IN (‘320101’, ‘999723’)
THEN DFR_SUMAMT ELSE 0 END) AS gbSum,

SUM(CASE WHEN (FUND_MNY = ‘310008’ AND POOLAREA_FUND_PAY_TYPE = ‘340101’)
OR (FUND_MNY = ‘310009’ AND POOLAREA_FUND_PAY_TYPE = ‘99999756’)
THEN DFR_SUMAMT ELSE 0 END) AS lxSum,

SUM(CASE WHEN POOLAREA_FUND_PAY_TYPE NOT IN (‘999801’, ‘999802’, ‘999803’, ‘999804’)
THEN DFR_SUMAMT ELSE 0 END) AS yfSum,

SUM(CASE WHEN POOLAREA_FUND_PAY_TYPE = ‘999801’
AND (MEMO NOT IN (‘PRIC’) OR MEMO IS NULL)
THEN DFR_SUMAMT ELSE 0 END) AS shSum,

SUM(CASE WHEN POOLAREA_FUND_PAY_TYPE = ‘999801’
AND MEMO = ‘PRIC’
THEN DFR_SUMAMT ELSE 0 END) AS shbjSum,

SUM(CASE WHEN POOLAREA_FUND_PAY_TYPE = ‘999803’
THEN DFR_SUMAMT ELSE 0 END) AS zkSum,

SUM(CASE WHEN POOLAREA_FUND_PAY_TYPE = ‘999804’
THEN DFR_SUMAMT ELSE 0 END) AS qtSum,

SUM(CASE WHEN POOLAREA_FUND_PAY_TYPE = ‘999802’
THEN DFR_SUMAMT ELSE 0 END) AS bzSum,

SUM(DFR_SUMAMT) sfsum

FROM trt_dfr_doc_detl_d
WHERE DFR_ID IN (?,?,?)
AND FIN_INSUTYPE IN (‘310’, ‘311’, ‘312’, ‘320’, ‘340’)
GROUP BY
dfr_id,
DFR_OBJ_CODE,
DFR_OBJ_NAME,
CASHYM,
CLR_TYPE_LV2
ORDER BY DFR_OBJ_CODE;
[2025-05-28 20:49:18] : [DEBUG] - args:0:149900S000000000000208001,149900S000000000000208002,149900S000000000000208003,
[2025-05-28 20:49:18] : [INFO] - 取数结束, 开始运算
单元格 J5 中有错误: 表达式： trtDfrDocDetl.select(accsum,false,dfr_id == D5) 中表达式：accsum 中不能识别的表达式：accsum
at com.runqian.report4.model.expression.UnknownSymbol.$1(Unknown Source:84)
at com.runqian.report4.model.expression.UnknownSymbol.calculate(Unknown Source:57)
at com.runqian.report4.model.expression.Expression.calculate(Unknown Source:578)
at com.runqian.report4.model.expression.function.dsfunction.DSSelect.calculate(Unknown Source:69)
at com.runqian.report4.model.expression.Expression.calculate(Unknown Source:578)
at com.runqian.report4.model.engine.ExtExtendCell.calculate(Unknown Source:407)
at com.runqian.report4.model.engine.ExtCellSet.$1(Unknown Source:2200)
at com.runqian.report4.model.engine.ExtCellSet._$1(Unknown Source:2419)
at com.runqian.report4.model.engine.ExtCellSet.calculate(Unknown Source:2357)
at com.runqian.report4.usermodel.Engine.calc(Unknown Source:133)
at com.runqian.report4.ide.GVIde.execute(Unknown Source:671)
at com.runqian.report4.ide.IIIlIIllIllIIIlI.run(Unknown Source:759)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

报错(1)