'LRC' then "LNCONTSTATEMENT"."PRINCIPAL_PAYMENT" else 0.00 end ) as prin_pay,
"LNCONTMASTER"."LOANTYPE_CODE" , "LNLOANTYPE"."LOANTYPE_DESC" , sum( "LNCONTSTATEMENT"."INTEREST_PAYMENT" ) as int_pay,
sum( "LNCONTSTATEMENT"."INTARR_PAYMENT" ) as intarr_pay, sum( "LNCONTSTATEMENT"."FINE_PAYMENT" ) as fine_pay,
sum( "LNCONTSTATEMENT"."FINEARR_PAYMENT" ) as finearr_pay, sum( "LNCONTSTATEMENT"."INT_COMPENSATE" ) as int_receive,
sum( case when "LNCONTSTATEMENT"."LOANITEMTYPE_CODE" <> 'LRC' and "LNCONTSTATEMENT"."BFPRINCIPAL_ARREAR" > 0 then "LNCONTSTATEMENT"."PRINCIPAL_PAYMENT" else 0.00 end ) as prin_payarr,
"LNCONTSTATEMENT"."SLIP_DATE" FROM "LNCONTMASTER" , "LNCONTSTATEMENT" , "LNLOANTYPE"
WHERE ( "LNCONTMASTER"."LOANCONTRACT_NO" = "LNCONTSTATEMENT"."LOANCONTRACT_NO" (+)) and
( "LNLOANTYPE"."LOANTYPE_CODE" = "LNCONTMASTER"."LOANTYPE_CODE" ) and ( ( "LNCONTSTATEMENT"."SLIP_DATE" between $P{adtm_startdate} and $P{adtm_enddate} ) And
( "LNCONTMASTER"."LOANTYPE_CODE" between $P{as_startlntype} and $P{as_endlntype} ) and ( "LNCONTSTATEMENT"."ITEM_STATUS" = 1 ) ) GROUP BY "LNCONTSTATEMENT"."SLIP_DATE" ,
"LNCONTMASTER"."LOANTYPE_CODE" , "LNLOANTYPE"."LOANTYPE_DESC"]]>
<band height="60" splitType="Stretch">
<textField>
<reportElement uuid="7df374b5-d07a-41c4-9cf8-dc3e7e663e3c" x="74" y="35" width="417" height="20"/>
<textElement textAlignment="Center">
<font fontName="Angsana New" size="16" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["ระหว่างวันที่"+" "+new SimpleDateFormat("dd/MM/yyyy",new Locale("th","TH")).format($P{adtm_startdate})+" ถึงวันที่ "+new SimpleDateFormat("dd/MM/yyyy",new Locale("th","TH")).format($P{adtm_enddate})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="28c20566-0e9e-4e2a-bbd9-ab4c375f4201" x="165" y="5" width="238" height="30"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Angsana New" size="18" isBold="true"/>
</textElement>
<text><![CDATA[รายงานสรุปการรายรับ-รายจ่ายเงินกู้ รายวัน]]></text>
</staticText>
</band>