0 and recpay_status = '1' and ptf2.slip_no = ptf.slip_no) as vat_amt from stposttofin ptf where ptf.recpay_status ='1' and ptf.operate_date between $P{as_date} and $P{as_date} ), cmcoopmaster group by cmcoopmaster.coop_name]]>