Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/WorkQualityCollectionDataIndex.java =================================================================== diff -u -r33091 -r33141 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/WorkQualityCollectionDataIndex.java (.../WorkQualityCollectionDataIndex.java) (revision 33091) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/WorkQualityCollectionDataIndex.java (.../WorkQualityCollectionDataIndex.java) (revision 33141) @@ -938,8 +938,7 @@ reportParams.isDisableIDCardSqlWithAliasOfTousseDefinitionIsTd = ""; reportParams.taskGroupSqlWithAliasOfTousseDefinitionIsTd = ""; reportParams.tousseGroupSqlWithAliasOfTousseDefinitionIsTd = ""; - reportParams.sqlLengthFunctionName = sqlLengthFunctionName; - reportParams.extraJoinCondition = " inner join SterilizationRecord sr on sr.id = ti.sterilizationRecord_id "; + reportParams.sqlLengthFunctionName = sqlLengthFunctionName; reportParams.extraGroupBy = " group by td.toussetype "; reportParams.extraSelectColumns = " ,td.tousseType tousseType "; String sql = dataIndex.getWorkAmountByPackageSQL("灭菌数量", reportParams);