Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r13527 -r13536 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 13527) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 13536) @@ -4206,7 +4206,7 @@ + MaterialDefinition.TYPE_EXPENSIVEMATERIALGOODS + "') "; lostMaterialFilterSql += " and m.goodsType = '"+MaterialDefinition.TYPE_EXPENSIVEMATERIALGOODS+"' "; damageFilterSql += " and m.goodsType = '"+MaterialDefinition.TYPE_EXPENSIVEMATERIALGOODS+"' "; - expensiveDisposablegoodsSql = " and d.expensiveDisposablegoodsId is null "; + expensiveDisposablegoodsSql = " and 1=2 "; } }else{ returnGoodsFilterSql += " and ri.expensiveDisposablegoodsId is not null";