在数据库中SQL语句查询没问题，但是放到Finereport数据源里修改成输入参数，显示报错是数据集配置错误，哪位大神麻烦帮忙看看，万分感激。 SELECT BEN.year, BEN.month, BEN.QYJL, BEN.DQJL, BEN.SF, BEN.DLS, BEN.CPBM, BEN.CPMC, BEN.CPGG, BEN.DJ, BEN.SL, BEN.CWKPJE, BEN.DJJE, BEN.FHJE,BEN.HLSL, BEN.DGHKJE,BEN.DJHKJE,sum(CWKPJE) ljcwkpje FROM (SELECT YEAR,MONTH,QYJL,DQJL, CWKPJE,SF,DLS,CPBM,CPGG, CPMC,DJ,SL,DJJE,FHJE,HLSL,DGHKJE,DJHKJE FROM VIEW_JIANBAO WHERE YEAR = '${y}' AND month = '${m}' AND SF = '${SF}' AND DQJL = '${DQJL}') BEN RIGHT JOIN
(SELECT YEAR,QYJL,DQJL,sum(CWKPJE) LJCWKPJE FROM VIEW_JIANBAO WHERE YEAR = '${y}' AND month <='${m}' AND DQJL = '${DQJL}'
GROUP BY YEAR,QYJL,DQJL) LJBEN ON LJBEN.year = BEN.YEAR where 1=1 ${if(len(y)=0,"","and year in ("+y+") ")} ${if(len(m)=0,"","and month in ("+m+") ")} ${if(len(BMMC)=0,"","and BMMC in ('"+BMMC+"') ")} ${if(len(CPMC)=0,"","and CPMC in ('"+CPMC+"') ")} ${if(len(CPGG)=0,"","and CPGG in ('"+CPGG+"') ")} ${if(len(qyjl)==0,"","and qyjl in ('"+qyjl+"')")} ${if(len(sf)==0,"","and sf in ('"+sf+"')")} ${if(len(dqjl)==0,"","and dqjl in ('"+dqjl+"')")} order by year,month
|
1min目标场景问卷
立即参与
