Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/WorkQualityCollectionDataIndex.java =================================================================== diff -u -r25294 -r25313 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/WorkQualityCollectionDataIndex.java (.../WorkQualityCollectionDataIndex.java) (revision 25294) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/WorkQualityCollectionDataIndex.java (.../WorkQualityCollectionDataIndex.java) (revision 25313) @@ -1260,7 +1260,8 @@ null); - reportParams.monthlyStr = dateQueryAdapter.dateConverAdapter3("ti.sterileEndTime","mm"); + reportParams.monthlyStr = dateQueryAdapter.dateConverAdapter3(dateQueryAdapter.stringFieldToDate("ti.sterileEndTime"),"mm"); + reportParams.extraJoinCondition = " inner join SterilizationRecord sr on sr.id = ti.sterilizationRecord_id " + "inner join Sterilizer s on s.id = sr.sterilizer_id ";