在数据库中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.YEARwhere 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