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>