Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/UseRecordEnterReportHelper.java =================================================================== diff -u -r38302 -r38755 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/UseRecordEnterReportHelper.java (.../UseRecordEnterReportHelper.java) (revision 38302) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/UseRecordEnterReportHelper.java (.../UseRecordEnterReportHelper.java) (revision 38755) @@ -143,7 +143,7 @@ String insidequeryExpensiveGoodsAmount = ""; if (queryExpensiveGoods) { outsideQueryExpensiveGoodsAmount = " ,sum(expensiveGoodsAmount) expensiveGoodsAmount "; - insidequeryExpensiveGoodsAmount = " (select count(0) from ExpensiveGoodsInstance egi where egi.userecordId=u.id) expensiveGoodsAmount,"; + insidequeryExpensiveGoodsAmount = " ,(select count(0) from ExpensiveGoodsInstance egi where egi.userecordId=u.id) expensiveGoodsAmount "; } String sql = String.format("select u1.operator,u1.depart,sum(useRecordAmount) amount,sum(tousseAmount) tousseAmount,sum(disposableGoodsAmount) disposableGoodsAmount " + " %s from ( select u.operator,u.depart,u.enteringDate,1 useRecordAmount,u.hospitalNum,"