0
and ( a.payinslip_no = b.payinslip_no ) and a.membgroup_code = c.membgroup_code and a.sliptype_code in ('PX','CLX','CLC') and c.membgroup_control = cc.membgroup_code
and (a.slip_status = 1 )
and ( a.moneytype_code = mt.moneytype_code ) and x.prename_code = y.prename_code and b.shrlontype_code <> 'FN'
and ( a.sliptype_code = st.sliptype_code ) and x.member_no = a.member_no
and ( a.slip_date >= $P{adtm_start} ) and a.slip_date <= $P{adtm_end} and trim(x.membgroup_code) >= $P{as_startgroup} and trim(x.membgroup_code) <= $P{as_endgroup}
group by a.coop_id, c.membgroup_desc, a.payinslip_no ,b.loancontract_no, a.document_no , a.memcoop_id, a.member_no , a.membgroup_code , c.membgroup_control,cc.membgroup_desc,
mt.moneytype_desc, a.moneytype_code,a.sharestk_value , st.sliptype_desc , a.entry_id, y.prename_desc , x.memb_name , x.memb_surname]]>
0]]>
<band height="47" splitType="Stretch">
<staticText>
<reportElement uuid="7f878485-167c-4a59-80a5-1ae1dd46c2dd" x="68" y="2" width="422" height="20"/>
<textElement textAlignment="Center">
<font fontName="Angsana New" size="14"/>
</textElement>
<text><![CDATA[รายงานชำระพิเศษและหักกลบเงินกู้]]></text>
</staticText>
<staticText>
<reportElement uuid="db10bcc1-1fd7-459f-9d3b-ff1b6a87f386" x="0" y="22" width="68" height="20"/>
<textElement>
<font fontName="Angsana New" size="14"/>
</textElement>
<text><![CDATA[ตั้งแต่วันที่]]></text>
</staticText>
<textField>
<reportElement uuid="ae5d555f-b8b0-4229-8bce-bbd735371975" x="68" y="22" width="100" height="20"/>
<textElement>
<font fontName="Angsana New" size="14"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy",new Locale("th","TH")).format( $P{adtm_start})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="bca08dcc-6822-46a6-a645-70477ade48b6" x="175" y="22" width="68" height="20"/>
<textElement>
<font fontName="Angsana New" size="14"/>
</textElement>
<text><![CDATA[ถึงวันที่]]></text>
</staticText>
<textField>
<reportElement uuid="9ad5d382-e614-4b10-8bbd-960caa7a74c2" x="251" y="23" width="100" height="20"/>
<textElement>
<font fontName="Angsana New" size="14"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy",new Locale("th","TH")).format( $P{adtm_end})]]></textFieldExpression>
</textField>
</band>
0?$F{CONTNO2}:'']]>
0?$F{CONTNO2}:'']]>
0?$F{CONTNO2}:'']]>