Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r34093 -r34094 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34093) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34094) @@ -14386,7 +14386,7 @@ joinMaterialInstanceSql = ""; } if(DatabaseUtil.isPoIdValid(materialId)){ - materialInstanceSql = " and td.id in(select tousse_id from MaterialInstance where materialDefinition_id="+ materialId +" and tousseDefinition_id=td.id) "; + materialInstanceSql = " and td.id in(select tousse_id from MaterialInstance where materialDefinition_id="+ materialId +") "; }else{ materialInstanceSql = ""; }