0 then 1 else 0 end )as age
FROM
MBMEMBMASTER ,
MBUCFMEMBGROUP ,
MBUCFPRENAME ,
SHSHAREMASTER ,
mbucftambol,
MBUCFDISTRICT ,
MBUCFPROVINCE,
CMCOOPMASTER
WHERE
( mbucftambol.tambol_code (+) = mbmembmaster.tambol_code) and
( MBUCFDISTRICT.DISTRICT_CODE (+) = MBMEMBMASTER.AMPHUR_CODE) and
( MBUCFDISTRICT.PROVINCE_CODE (+) = MBMEMBMASTER.PROVINCE_CODE) and
( MBMEMBMASTER.PROVINCE_CODE = MBUCFPROVINCE.PROVINCE_CODE (+)) and
( MBUCFMEMBGROUP.MEMBGROUP_CODE = MBMEMBMASTER.MEMBGROUP_CODE ) and
( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and
( SHSHAREMASTER.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and
(MBMEMBMASTER.MEMBER_TYPE >0) and
( MBMEMBMASTER.COOP_ID = $P{coop_id} ) AND
( MBMEMBMASTER.MEMBER_DATE between $P{adtm_sdate} and $P{adtm_edate})
ORDER BY MBUCFMEMBGROUP.MEMBGROUP_CODE,"MBMEMBMASTER"."MEMBER_NO"]]>
<band height="33" splitType="Stretch">
<textField>
<reportElement uuid="91554bf0-3060-45ba-a6d2-b0dea353b755" x="30" y="13" width="493" height="20"/>
<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>