Index: ssts-web/src/main/webapp/jasperRtp/materialMissTotalView.jrxml =================================================================== diff -u -r17512 -r17524 --- ssts-web/src/main/webapp/jasperRtp/materialMissTotalView.jrxml (.../materialMissTotalView.jrxml) (revision 17512) +++ ssts-web/src/main/webapp/jasperRtp/materialMissTotalView.jrxml (.../materialMissTotalView.jrxml) (revision 17524) @@ -35,7 +35,7 @@ case when r.materialcost is null then 0.00 else r.materialcost end price FROM MaterialErrorDamageDetail r -WHERE 1= 1 +WHERE 1= 1 and r.materialName != '器械包标识牌' $P!{querySql} GROUP BY r.materialname,