Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/DepartmentMonthDetailHelper.java =================================================================== diff -u -r40698 -r40715 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/DepartmentMonthDetailHelper.java (.../DepartmentMonthDetailHelper.java) (revision 40698) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/DepartmentMonthDetailHelper.java (.../DepartmentMonthDetailHelper.java) (revision 40715) @@ -344,7 +344,7 @@ } } } - if(queryTousseGroupName){ + if(queryTousseGroupName || queryWeightScore || queryTechnicalDifficulty){ if(StringUtils.isBlank(addTousseDefinitionAtWhere)){ addTousseDefinitionAtWhere += " left join TousseDefinition td on td.id = ii.tousseDefinitionId " + "left join TousseDefinition tdc on tdc.id=td.ancestorID ";