数据集预览一切正常,但是在报表预览报错:错误代码:11300001 数据集 [money_d1] 配置错误ORA-01722: 无效数字 具体sql如下: select * from ( select t2.branch_id,t2.branch_name,to_char(t0.OP_TIME,'yyyymmdd')op_time, t1.fee_name,t0.pay_money from (select fee_code,fee_name from FINEREPORT.V_BOSS_OP_FEE_CATALOG where regexp_like (fee_name,'装机工料费|配套建设费|三网建设费') )t1 inner join sidss.t2_ia_loginopr_pay t0 on t0.OP_TIME between to_date('${DATEBEGIN}','yyyymmdd') and to_date('${DATEEND}'+1,'yyyymmdd') and trim(t0.PAY_TYPE)=T1.FEE_CODE inner join SIBOSS.E1_BS_ORG4BRANCH t2 on t0.GROUP_ID=t2.ORG_ID ) pivot(sum(pay_money) for fee_name in ('装机工料费' as 装机工料费,'配套建设费' as 配套建设费,'三网建设费' as 三网建设费))
|