0 ) OR
("SHSHAREMASTER"."SHAREBEGIN_AMT" = 0 AND
( MBMEMBMASTER.COOP_ID = $P{coop_id} ) and
to_char("MBMEMBMASTER"."MEMBER_DATE",'yyyymmdd') between to_char( $P{adtm_sdate},'yyyymmdd') and to_char($P{adtm_edate} ,'yyyymmdd')) AND
"MBUCFMEMBGROUP"."MEMBGROUP_CODE" between $P{membgroup_start} and $P{membgroup_end}
group by "MBMEMBMASTER"."MEMBGROUP_CODE",
"MBUCFMEMBGROUP"."MEMBGROUP_DESC",
"MBMEMBMASTER"."SEX",
"MBMEMBMASTER"."MEMBER_DATE",
"MBMEMBMASTER"."RESIGN_STATUS",
"MBMEMBMASTER"."MEMBER_NO",
"MBMEMBMASTER"."MEMB_NAME",
"CMCOOPMASTER"."COOP_NAME"
order by "MBMEMBMASTER"."MEMBGROUP_CODE"]]>
= $P{adtm_sdate} ? 1 : 0): 0): 0)]]>
= $P{adtm_sdate} ? 1 : 0): 0): 0)]]>
= $P{adtm_sdate} ? 1 : 0): 0): 0)]]>
= $P{adtm_sdate} ? 1 : 0): 0): 0)]]>
= $P{adtm_sdate} ? 1 : 0): 0)]]>
<band height="46" splitType="Stretch">
<textField>
<reportElement uuid="d4b1d318-53fc-4e89-8beb-1bad9ea06016" x="11" y="0" width="522" height="26"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Angsana New" size="16" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["รายงานแสดงจำนวนสมาชิกคงเหลือทั้งหมด (ใบปะหน้า)"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="541d06f8-b99a-4d44-a055-1e0cdff89483" x="11" y="26" width="522" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Angsana New" size="14" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["ตั้งแต่วันที่ "+new SimpleDateFormat("dd/MM/yyyy",new Locale("th","TH")).format($P{adtm_sdate})+" ถึงวันที่ "+new SimpleDateFormat("dd/MM/yyyy",new Locale("th","TH")).format($P{adtm_edate})]]></textFieldExpression>
</textField>
</band>