0
and ybm.coop_id = mug.coop_id(+)
and ybm.membgroup_code = mug.membgroup_code(+)
and ybm.coop_id = $P{as_coopid}
and trim(ybm.div_year) = trim($P{as_year})
and ybm.membgroup_code between $P{as_stargroup} and $P{as_endgroup}
group by muc.membgroup_code,muc.membgroup_desc,mug.membgroup_code , mug.membgroup_desc,mb.deptaccount_no ,rt.divpercent_rate , rt.avgpercent_rate,mb.member_no,mp.prename_desc,mb.memb_name,mb.memb_surname,ym.loancontract_no,ym.bank_accid
order by muc.membgroup_code,mug.membgroup_code,mb.member_no]]>
<band height="100" splitType="Stretch">
<staticText>
<reportElement uuid="58ac12ca-f91a-4356-a760-603d6e0c285a" x="0" y="80" width="22" height="20"/>
<textElement/>
<text><![CDATA[ลำดับ]]></text>
</staticText>
<staticText>
<reportElement uuid="0d965918-4710-4773-880d-8accaa018e24" x="20" y="80" width="55" height="20"/>
<textElement/>
<text><![CDATA[เลขที่สมาชิก]]></text>
</staticText>
<staticText>
<reportElement uuid="8b847d27-5a72-4b58-ac0f-51bfb9589fdf" x="75" y="80" width="221" height="20"/>
<textElement/>
<text><![CDATA[ชื่อ สกุล]]></text>
</staticText>
<staticText>
<reportElement uuid="7e96fff4-4724-41e6-b66c-eaaa4dcef462" x="376" y="59" width="356" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[รายการชำระ]]></text>
</staticText>
<staticText>
<reportElement uuid="72526808-2167-4a09-aab9-603a4107a61c" x="376" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[หุ้น]]></text>
</staticText>
<staticText>
<reportElement uuid="ba1bdb93-c64c-46d3-8fc5-b94c67c48844" x="296" y="80" width="80" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[เงินรอจ่ายคืน]]></text>
</staticText>
<staticText>
<reportElement uuid="3c8926a9-3a15-4890-8ea9-f91c74a75919" x="0" y="19" width="452" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[รายงานปันผลเฉลียคืน รอจ่ายคืน ปี พ.ศ. ]]></text>
</staticText>
<staticText>
<reportElement uuid="56818c12-75c6-42d2-992b-90c9fc49a94b" x="0" y="-1" width="783" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[สหกรณ์ออมทรัพย์ครูสุรินทร์ จำกัด]]></text>
</staticText>
<staticText>
<reportElement uuid="674beab9-334e-4765-9d9b-9d532377e4d5" x="409" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[สป]]></text>
</staticText>
<staticText>
<reportElement uuid="cb5e712d-b9b4-4a78-809d-39d1be429b63" x="442" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="7e6486d6-c3bd-41e8-b18e-b144df7dbe93" x="475" y="80" width="63" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[สม./สห./สฒ.]]></text>
</staticText>
<staticText>
<reportElement uuid="36d3bf04-e338-4173-9617-76b47a99ff22" x="538" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="902acb6b-af6d-4e8f-afb0-741e6ff05956" x="571" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[สข.]]></text>
</staticText>
<staticText>
<reportElement uuid="649d4085-1ad8-4f9c-94df-d746e1a2c103" x="604" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="de001aa0-dfb8-454b-b393-43d0f1aa7c26" x="637" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[สว]]></text>
</staticText>
<staticText>
<reportElement uuid="4c34300e-9149-487c-bdab-a4e131b19e82" x="670" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="80a57cf4-e58b-4f1d-9c19-1198197f22e7" x="703" y="80" width="48" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[พพ./พป.]]></text>
</staticText>
<staticText>
<reportElement uuid="42352850-3efc-4287-a788-12e4fa1753cc" x="751" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="74316ef9-023d-49d2-b045-22b167a55e46" x="784" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ฉม.]]></text>
</staticText>
<staticText>
<reportElement uuid="085e51df-a0b2-432b-a585-a73d94a672c2" x="817" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="72950326-6fcf-4cc6-8e87-c0c88954b38b" x="883" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ดบ.]]></text>
</staticText>
<staticText>
<reportElement uuid="bfcef9dc-3af4-477d-8a1a-fae3eebf7b5d" x="850" y="80" width="33" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ฉค.]]></text>
</staticText>
<staticText>
<reportElement uuid="2468a58f-bfc9-4638-98be-39b9f5026a67" x="916" y="80" width="52" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ออมทรัพย์]]></text>
</staticText>
<staticText>
<reportElement uuid="6556174e-c8b0-40a9-b14c-3766871f0459" x="968" y="80" width="46" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[รวม]]></text>
</staticText>
<staticText>
<reportElement uuid="24d7e082-f3f0-4d12-a0a1-9ef69a3eb219" x="1014" y="80" width="48" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[รอจ่ายคืน]]></text>
</staticText>
<staticText>
<reportElement uuid="8a9057a1-0740-4ce9-9027-0b8e446f626b" x="1079" y="80" width="61" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[เลขที่บัญชี]]></text>
</staticText>
<textField>
<reportElement uuid="bc3da460-5fdb-49d7-9e3d-d42f3fc9aa0c" x="75" y="39" width="595" height="20"/>
<textElement textAlignment="Justified"/>
<textFieldExpression><![CDATA["ตั้งแต่หน่วย " + $P{as_stargroup} + " ถึงหน่วย " + $P{as_endgroup}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="69642633-ea37-40b5-9d63-35e39033e0be" x="452" y="19" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{as_year}]]></textFieldExpression>
</textField>
</band>