Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r35811 -r35812 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 35811) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 35812) @@ -4937,7 +4937,7 @@ //一次性物品信息出库数量查询-退货 returnSummarySql = "select po.externalCode, case when po.specification is null then po.name else po.name + '['+ po.specification +']' end name, -1*sum(rgi.amount) amount from DisposableGoods po " - +" left join ReturnGoodsItem rgi on po.id=rgi.dexpandColoumnsConfigOfUsingRecordEntryDetailReportsArrisposableGoodsId" + +" left join ReturnGoodsItem rgi on po.id=rgi.disposableGoodsID" +" and rgi.returnGoodsRecord_ID in (select id from ReturnGoodsRecord f where 1=1 " + returnTimeCondition + " and f.handleDepartCode='" + orgUnitCoding + "') where 1=1 " + goodsNameCondition + gradeCondition +" group by po.externalCode, po.name,po.specification order by po.externalCode"; }else if(dbConnection.isOracle()){