Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r13136 -r13137 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 13136) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 13137) @@ -4148,8 +4148,8 @@ + "'"; returnGoodsFilterSql += " and ri.toussename = '" + goodsNameSearch + "'"; - materialNameFilterSql = " ii.materialName = '" - + goodsNameSearch + "'"; + materialNameFilterSql = " and ii.materialName = '" + + goodsNameSearch + "' "; lostMaterialFilterSql += " and r.materialName = '" + goodsNameSearch + "'"; damageFilterSql += " and i.materialName = '" @@ -4161,7 +4161,7 @@ returnGoodsFilterSql += " and ri.toussename like '%" + goodsNameSearch + "%'"; materialNameFilterSql = " and ii.materialName like '%" - + goodsNameSearch + "%'"; + + goodsNameSearch + "%' "; lostMaterialFilterSql += " and r.materialName like '%" + goodsNameSearch + "%'"; damageFilterSql += " and r.materialName like '%"