Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r34367 -r34368 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34367) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34368) @@ -27493,7 +27493,7 @@ params.extraSelectColumns = " ,case when proxydisinfection_id is not null then (select depart from invoicePlan where id=ti.proxydisinfection_id ) else ti.depart end depart "; params.extraGroupBy = " group by ti.proxydisinfection_id,ti.depart "; //灭菌记录 - String sql2 = String.format(" union all select tl.depart,sum(tl.amount) amount from (" + sql += String.format(" union all select tl.depart,sum(tl.amount) amount from (" +dataIndex.getWorkAmountByPackageSQL("灭菌数量", params) + ") tl group by tl.depart "); params.extraSelectColumns = "";