Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r32170 -r32173 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 32170) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 32173) @@ -15232,7 +15232,7 @@ tempOrderBySql = "order by temp.id desc,temp.orderNumber,temp.qmdOrderNumber asc"; requestParameters.put("dataType", "监测范围为材料和器械包的质量监测数据"); if(isShowTousseMaerialSumAmount){ - materialAmountSql = ",(select sum(count) from MaterialInstance join TousseDefinition on ancestorID=tousse_id where ancestorID=qmd.tousseDefinitionId) materialAmount "; + materialAmountSql = ",(select sum(count) from MaterialInstance join TousseDefinition td on td.id=tousse_id where td.id=qmd.tousseDefinitionId) materialAmount "; } materialAndTousse = true; }