0 then 1 else 0 end )as age
FROM
"MBMEMBMASTER" ,
"MBUCFMEMBGROUP" ,
"MBUCFPRENAME" ,
"MBUCFRESIGNCAUSE" ,
"SHSHAREMASTER" ,
"SHSHARETYPE",CMCOOPMASTER
WHERE
( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and
( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and
( "MBUCFRESIGNCAUSE"."RESIGNCAUSE_CODE"(+) = "MBMEMBMASTER"."RESIGNCAUSE_CODE" ) and
( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) and
( "MBMEMBMASTER"."MEMBER_NO" = "SHSHAREMASTER"."MEMBER_NO" ) and
( "MBMEMBMASTER"."COOP_ID" = "CMCOOPMASTER"."COOP_ID" ) and
( ( MBMEMBMASTER.COOP_ID = $P{coop_id}) and
( MBMEMBMASTER.RESIGN_DATE between $P{adtm_sdate} and $P{adtm_edate} ) and
( MBMEMBMASTER.RESIGN_STATUS = 1 ) )
order by "MBMEMBMASTER"."MEMBGROUP_CODE","MBMEMBMASTER"."MEMBER_NO"]]>
<band height="42" splitType="Stretch">
<textField>
<reportElement uuid="57812429-c000-4575-988b-0850a4c7adfa" x="1" y="0" width="553" height="42"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Angsana New" size="16" 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>