|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bhumie/upload/../report/LaporanPembayaran/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="detil_perBank" language="groovy" pageWidth="1601" pageHeight="850" orientation="Landscape" columnWidth="1587" leftMargin="7" rightMargin="7" topMargin="36" bottomMargin="7" uuid="56c43b37-5528-4378-a442-26f08c499363">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="577"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="4a1d9c5f-641f-4061-bb66-9230af129def">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Pkd_kecamatan" class="java.lang.String"/>
<parameter name="Pkd_kelurahan" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Ptgl_akhir" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select
a.jml_sppt1
,a.jml_pbb1
,b.jml_sppt2
,b.jml_pbb2
,c.jml_sppt3
,c.jml_pbb3
,d.jml_sppt4
,d.jml_pbb4
,e.jml_sppt5
,e.jml_pbb5
,f.jml_sppt6
,f.jml_pbb6
,g.jml_sppt7
,g.jml_pbb7
,b.jml_sppt2 + c.jml_sppt3 + d.jml_sppt4 + e.jml_sppt5 + f.jml_sppt6 + g.jml_sppt7 as jml_sppt
,b.jml_pbb2 + c.jml_pbb3 + d.jml_pbb4 + e.jml_pbb5 + f.jml_pbb6 + g.jml_pbb7 as jml_pbb
,a.jml_sppt1 + g.jml_sppt7 as jml_tunggakan_sppt
,a.jml_pbb1 + g.jml_pbb7 as jml_tunggakan_pbb
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb1,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now())
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
) a inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb2,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 1
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)b on a.id = b.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb3,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 2
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)c on a.id = c.id inner join (
Select coalesce(COUNT(*),0) jml_sppt4, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb4,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 3
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)d on a.id = d.id inner join (
Select coalesce(COUNT(*),0) jml_sppt5, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb5,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 4
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)e on a.id = e.id inner join (
Select coalesce(COUNT(*),0) jml_sppt6, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb6,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 5
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)f on a.id = f.id inner join (
Select coalesce(COUNT(*),0) jml_sppt7, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb7,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') <= date_part('year',now()) - 6
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)g on a.id = g.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<field name="jml_sppt4" class="java.lang.Long"/>
<field name="jml_pbb4" class="java.math.BigDecimal"/>
<field name="jml_sppt5" class="java.lang.Long"/>
<field name="jml_pbb5" class="java.math.BigDecimal"/>
<field name="jml_sppt6" class="java.lang.Long"/>
<field name="jml_pbb6" class="java.math.BigDecimal"/>
<field name="jml_sppt7" class="java.lang.Long"/>
<field name="jml_pbb7" class="java.math.BigDecimal"/>
<field name="jml_sppt" class="java.lang.Long"/>
<field name="jml_pbb" class="java.math.BigDecimal"/>
<field name="jml_tunggakan_sppt" class="java.lang.Long"/>
<field name="jml_tunggakan_pbb" class="java.math.BigDecimal"/>
<variable name="variable1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_tunggakan_pbb}]]></variableExpression>
</variable>
</subDataset>
<subDataset name="dataset2" uuid="5fdaeb70-41f5-4928-9ca2-c1407a41cc2d">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Pkd_kecamatan" class="java.lang.String"/>
<parameter name="Pkd_kelurahan" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<queryString>
<![CDATA[select
a.jml_sppt1
,a.jml_pbb1
,b.jml_sppt2
,b.jml_pbb2
,c.jml_sppt3
,c.jml_pbb3
,d.jml_sppt4
,d.jml_pbb4
,e.jml_sppt5
,e.jml_pbb5
,f.jml_sppt6
,f.jml_pbb6
,g.jml_sppt7
,g.jml_pbb7
,b.jml_sppt2 + c.jml_sppt3 + d.jml_sppt4 + e.jml_sppt5 + f.jml_sppt6 + g.jml_sppt7 as jml_sppt
,b.jml_pbb2 + c.jml_pbb3 + d.jml_pbb4 + e.jml_pbb5 + f.jml_pbb6 + g.jml_pbb7 as jml_pbb
,a.jml_sppt1 + g.jml_sppt7 as jml_tunggakan_sppt
,a.jml_pbb1 + g.jml_pbb7 as jml_tunggakan_pbb
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb1,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now())
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
) a inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb2,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 1
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)b on a.id = b.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb3,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 2
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)c on a.id = c.id inner join (
Select coalesce(COUNT(*),0) jml_sppt4, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb4,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 3
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)d on a.id = d.id inner join (
Select coalesce(COUNT(*),0) jml_sppt5, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb5,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 4
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)e on a.id = e.id inner join (
Select coalesce(COUNT(*),0) jml_sppt6, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb6,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 5
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)f on a.id = f.id inner join (
Select coalesce(COUNT(*),0) jml_sppt7, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb7,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and to_number(thn_pajak_sppt,'9999') <= date_part('year',now()) - 6
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)g on a.id = g.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<field name="jml_sppt4" class="java.lang.Long"/>
<field name="jml_pbb4" class="java.math.BigDecimal"/>
<field name="jml_sppt5" class="java.lang.Long"/>
<field name="jml_pbb5" class="java.math.BigDecimal"/>
<field name="jml_sppt6" class="java.lang.Long"/>
<field name="jml_pbb6" class="java.math.BigDecimal"/>
<field name="jml_sppt7" class="java.lang.Long"/>
<field name="jml_pbb7" class="java.math.BigDecimal"/>
<field name="jml_sppt" class="java.lang.Long"/>
<field name="jml_pbb" class="java.math.BigDecimal"/>
<field name="jml_tunggakan_sppt" class="java.lang.Long"/>
<field name="jml_tunggakan_pbb" class="java.math.BigDecimal"/>
<variable name="sum_sppt1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt1}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb1}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt2" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt2}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb2" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb2}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt3" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt3}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb3" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb3}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt4" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt4}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb4" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb4}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt5" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt5}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb5" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb5}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt6" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt6}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb6" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb6}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt7" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt7}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb7" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb7}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt_tot" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb_tot" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt_tung" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_tunggakan_sppt}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb_tung" class="java.lang.Integer" calculation="Sum">
<variableExpression><![CDATA[$F{jml_tunggakan_pbb}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
</subDataset>
<subDataset name="dataset3" uuid="275a1365-6a5a-44fa-8f54-df05b4690f64">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<queryString>
<![CDATA[select
a.jml_sppt1
,a.jml_pbb1
,b.jml_sppt2
,b.jml_pbb2
,c.jml_sppt3
,c.jml_pbb3
,d.jml_sppt4
,d.jml_pbb4
,e.jml_sppt5
,e.jml_pbb5
,f.jml_sppt6
,f.jml_pbb6
,g.jml_sppt7
,g.jml_pbb7
,b.jml_sppt2 + c.jml_sppt3 + d.jml_sppt4 + e.jml_sppt5 + f.jml_sppt6 + g.jml_sppt7 as jml_sppt
,b.jml_pbb2 + c.jml_pbb3 + d.jml_pbb4 + e.jml_pbb5 + f.jml_pbb6 + g.jml_pbb7 as jml_pbb
,a.jml_sppt1 + g.jml_sppt7 as jml_tunggakan_sppt
,a.jml_pbb1 + g.jml_pbb7 as jml_tunggakan_pbb
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb1,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now())
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
) a inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb2,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 1
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)b on a.id = b.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb3,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 2
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)c on a.id = c.id inner join (
Select coalesce(COUNT(*),0) jml_sppt4, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb4,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 3
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)d on a.id = d.id inner join (
Select coalesce(COUNT(*),0) jml_sppt5, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb5,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 4
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)e on a.id = e.id inner join (
Select coalesce(COUNT(*),0) jml_sppt6, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb6,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 5
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)f on a.id = f.id inner join (
Select coalesce(COUNT(*),0) jml_sppt7, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb7,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and to_number(thn_pajak_sppt,'9999') <= date_part('year',now()) - 6
and tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)g on a.id = g.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<field name="jml_sppt4" class="java.lang.Long"/>
<field name="jml_pbb4" class="java.math.BigDecimal"/>
<field name="jml_sppt5" class="java.lang.Long"/>
<field name="jml_pbb5" class="java.math.BigDecimal"/>
<field name="jml_sppt6" class="java.lang.Long"/>
<field name="jml_pbb6" class="java.math.BigDecimal"/>
<field name="jml_sppt7" class="java.lang.Long"/>
<field name="jml_pbb7" class="java.math.BigDecimal"/>
<field name="jml_sppt" class="java.lang.Long"/>
<field name="jml_pbb" class="java.math.BigDecimal"/>
<field name="jml_tunggakan_sppt" class="java.lang.Long"/>
<field name="jml_tunggakan_pbb" class="java.math.BigDecimal"/>
</subDataset>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<queryString>
<![CDATA[select
h.KD_PROPINSI||'.'||h.KD_DATI2||'.'||h.KD_KECAMATAN||'-'||i.NM_KECAMATAN KODE,
h.KD_PROPINSI, h.KD_DATI2, h.KD_KECAMATAN, h.KD_KELURAHAN, h.KD_KELURAHAN||'-'||h.NM_KELURAHAN as ALIA
from
pbb.REF_KELURAHAN h,pbb.REF_KECAMATAN i
where h.KD_KECAMATAN = i.KD_KECAMATAN AND h.KD_DATI2 = i.KD_DATI2 AND h.KD_PROPINSI = i.KD_PROPINSI
order by h.KD_PROPINSI, h.KD_DATI2, h.KD_KECAMATAN, h.KD_KELURAHAN]]>
</queryString>
<field name="kode" class="java.lang.String"/>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="alia" class="java.lang.String"/>
<group name="nmKelurahan">
<groupExpression><![CDATA[$F{kode}]]></groupExpression>
<groupHeader>
<band height="26">
<textField>
<reportElement uuid="36a969a0-d369-4442-9000-d8ef23f63b3e" x="4" y="5" width="141" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kode}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="4f693655-94ad-486d-a7e9-ea2f1519bc7c" x="3" y="22" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1471" y="-20" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1419" y="-20" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
</band>
</groupHeader>
<groupFooter>
<band height="39">
<staticText>
<reportElement uuid="dc629eb9-f8ed-4f40-94ea-1c6200d7b20a" x="4" y="5" width="154" height="26"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[ J U M L A H :]]></text>
</staticText>
<line>
<reportElement uuid="29deabaa-8f38-405c-b7ae-f4b38308cfd2" x="3" y="3" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="29deabaa-8f38-405c-b7ae-f4b38308cfd2" x="3" y="33" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="29deabaa-8f38-405c-b7ae-f4b38308cfd2" x="3" y="35" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="6175368d-9fe3-428e-af99-199b5e980124" x="172" y="5" width="1403" height="28"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset2" uuid="7156e156-08fa-4ad5-a30c-9916d156d067">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_awal">
<datasetParameterExpression><![CDATA[$P{Ptgl_awal}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_akhir">
<datasetParameterExpression><![CDATA[$P{Ptgl_akhir}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="28" width="1403">
<textField>
<reportElement uuid="c1da0619-a8f6-4433-b0e2-654ce2658631" x="1301" y="0" width="102" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb}+$F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6bd9e6c8-7327-47c7-b6f0-1b24067fe07f" x="1249" y="0" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}+$F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d176e3cc-1861-46c0-bab7-606c5e39ca1a" x="1145" y="1" width="102" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="71c8dace-74d0-412f-b2e5-65832ae81633" x="1093" y="1" width="50" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bee44d27-7f99-4c39-b154-fd66c1a94037" x="989" y="1" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb7}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="05ace334-2f5f-4d1b-96ce-e6aa445001e9" x="937" y="1" width="50" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt7}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2a970d96-e80c-4889-805f-74e49864134b" x="833" y="1" width="102" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb6}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8aed0824-b2d4-4c85-a6bf-f94a072a5595" x="781" y="1" width="50" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt6}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f956c2f1-2ab6-4e0f-b3d4-fb265b91d506" x="677" y="1" width="102" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb5}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4105a006-8302-421a-a9ec-831c293d8751" x="625" y="1" width="50" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt5}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cc2614af-2ab3-4a25-b6fd-848c7332e363" x="521" y="0" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb4}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fb403998-8a7f-40ce-a794-0bcbd6a0a470" x="469" y="1" width="50" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt4}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4f88ffe3-a558-42ce-8081-dc8a278d1513" x="365" y="1" width="102" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d359814c-b025-4340-8133-6c8858c9fdf1" x="313" y="2" width="49" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="27835dae-879c-4790-a233-f43aa9d2e24d" x="209" y="1" width="102" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a5e30e22-abd4-4939-a799-5dbc840a3eb4" x="157" y="1" width="49" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ab9d12e7-ae23-4e78-858c-6e925b1277ad" x="53" y="2" width="102" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d28d252a-c810-42c8-8cf6-222837d32436" x="1" y="1" width="50" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="171" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="223" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="327" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="379" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="483" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="535" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1004" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="796" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="692" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="952" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="848" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="640" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1471" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1263" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1159" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1419" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1315" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1107" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="40" splitType="Stretch">
<staticText>
<reportElement uuid="0ebfee46-f922-40ec-b66a-7a13e5ff5baf" x="4" y="0" width="1577" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[LAPORAN PENERIMAAN PAJAK BUMI DAN BANGUNAN]]></text>
</staticText>
<staticText>
<reportElement uuid="efd3f3b2-c10e-4c2f-83b8-654d892ac3fb" x="660" y="20" width="52" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[PERIODE ]]></text>
</staticText>
<textField>
<reportElement uuid="e0011211-ee67-4868-912f-63f371dfbb42" x="722" y="20" width="75" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA[$P{Ptgl_awal}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="640a215e-f5fb-428c-9a15-f45a9f442342" x="853" y="20" width="79" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA[$P{Ptgl_akhir}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="3a558dd5-ccad-4b9f-a8d3-5fcad68c6e37" x="810" y="20" width="28" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[s/d]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="66" splitType="Stretch">
<staticText>
<reportElement uuid="e2d2d7c8-51c4-4cfe-a4cd-22bf73ecf384" x="4" y="24" width="57" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[WILAYAH]]></text>
</staticText>
<textField>
<reportElement uuid="c6e00bd9-230e-4a74-b935-5dbd17ba7c4c" x="173" y="21" width="154" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["POKOK " + new Integer(new SimpleDateFormat("yyyy").format(new Date()))]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="329" y="23" width="154" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format(new Date()))-1]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="485" y="20" width="154" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format(new Date()))-2]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="641" y="22" width="154" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format(new Date()))-3]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="953" y="23" width="154" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format(new Date()))-5]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="1109" y="22" width="154" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["<= " + (new Integer(new SimpleDateFormat("yyyy").format(new Date())) -6)]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="797" y="22" width="154" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format(new Date()))-4]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="bcb1664d-58bf-466a-b5d2-4bf39f4be1ee" x="1421" y="22" width="154" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML. POKOK + TUNGGAKAN]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="173" y="44" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="7df833f1-d72c-41ba-a0aa-a1e7c8e087bf" x="1265" y="23" width="154" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML. TUNGGAKAN]]></text>
</staticText>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="171" y="24" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="171" y="42" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="327" y="24" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="483" y="23" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="639" y="25" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="795" y="24" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="951" y="24" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1107" y="24" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1263" y="25" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1419" y="24" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="17" width="1577" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="19" width="1577" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="59" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="61" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="172" y="39" width="1409" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="225" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="381" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="329" y="45" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="537" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="485" y="45" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="693" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="641" y="45" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="797" y="45" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="849" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1005" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="953" y="45" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1109" y="45" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1161" y="45" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1265" y="46" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1317" y="46" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1473" y="46" width="102" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="1421" y="46" width="50" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[STTS]]></text>
</staticText>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="327" y="44" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="379" y="45" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="223" y="44" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="535" y="45" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="639" y="45" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="691" y="46" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="483" y="44" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="847" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="795" y="46" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1003" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="951" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1107" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1159" y="48" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1263" y="48" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="1315" y="48" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="678421c0-d3c3-4c4f-a2ea-4eac294a0840" x="1498" y="1" width="34" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="78c9cccc-9e4c-4f91-b113-74d0405fd325" x="1517" y="1" width="25" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[dari]]></text>
</staticText>
<textField evaluationTime="Report">
<reportElement uuid="df69814d-9487-472f-b806-9760e722c2b3" x="1546" y="1" width="36" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="102cac89-1e01-4398-8c32-02c60f65fd38" x="1437" y="1" width="61" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Halaman : ]]></text>
</staticText>
</band>
</pageHeader>
<detail>
<band height="29" splitType="Stretch">
<textField>
<reportElement uuid="de1c5adc-e19f-4119-a248-1fde90583f9f" x="4" y="2" width="154" height="26"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alia}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="f8d0c47a-9beb-4633-afae-8ca898bdd3f3" x="172" y="0" width="1403" height="29"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset1" uuid="bab27885-8fba-4aa4-b5d3-0953f66ff016">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_awal">
<datasetParameterExpression><![CDATA[$P{Ptgl_awal}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_akhir">
<datasetParameterExpression><![CDATA[$P{Ptgl_akhir}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="29" width="1403">
<textField>
<reportElement uuid="ecb66b2e-aea6-45d7-898c-3bd26b260759" x="1" y="1" width="50" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fe0901c8-ca21-4d83-b1ba-85a2131656b2" x="53" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bdfe784f-e938-46e2-a213-c4c1f204b531" x="157" y="2" width="49" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0ffdb3b2-8578-4b92-bf3b-9c1c3cda7a3d" x="209" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3717453c-e236-40fa-aa59-e4b82590daa1" x="313" y="2" width="49" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="418024fb-b568-414a-b35c-97f7f300534e" x="365" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e886b2bf-850c-44c4-8300-c159c1964b47" x="469" y="2" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt4}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b5bb8d7b-8732-479b-afcb-cd3593cf0ec5" x="521" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb4}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="48286d1b-13e0-4ea1-b569-e13608542af9" x="625" y="2" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt5}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2bde0831-4990-4832-9a5b-6868f81e913e" x="677" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb5}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="67dde7f3-9447-45ac-9541-f2b444639641" x="781" y="2" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt6}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f5d06095-1cc6-4f3e-9dd1-a64f6bd6c542" x="833" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb6}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="69981467-d7de-4ef3-9bcf-59b555039533" x="937" y="2" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt7}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3c681dfa-7770-4df5-9afa-698e9e0859cc" x="989" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb7}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="dc1d77af-e0be-4115-929b-a463e11dcfc4" x="1093" y="2" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="109854b5-0382-4e72-8a9d-120d2029a700" x="1145" y="1" width="102" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b9516438-4129-4f4d-ae72-beb36cb6e51c" x="1249" y="2" width="50" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt}+$F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a2a6eb20-51fb-4006-b6f2-b623624be7da" x="1301" y="2" width="102" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}+$F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="171" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="223" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="327" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="379" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="483" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="535" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1004" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="796" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="692" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="952" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="848" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="640" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1471" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1263" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1159" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1419" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1315" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="1107" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</detail>
<summary>
<band height="48">
<staticText>
<reportElement uuid="d90b25e0-6f54-49fd-8507-a14bd0ac7bf6" x="3" y="3" width="155" height="28"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[J U M L A H T O T A L :]]></text>
</staticText>
<line>
<reportElement uuid="f45c64b1-8d63-44b8-8aa9-21e489eb29a0" x="3" y="32" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f45c64b1-8d63-44b8-8aa9-21e489eb29a0" x="3" y="34" width="1578" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="486b0ebd-5727-40f4-8158-70932e6e4f6e" x="172" y="0" width="1403" height="31"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset3" uuid="0c64322e-059c-430a-a780-fd6881aad153">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_awal">
<datasetParameterExpression><![CDATA[$P{Ptgl_awal}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_akhir">
<datasetParameterExpression><![CDATA[$P{Ptgl_akhir}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="31" width="1403">
<textField>
<reportElement uuid="25ab751f-f5be-476c-8409-b4a479d71dc3" x="1301" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}+$F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8603dc55-9fb6-44d9-aeca-cac8f6c76a16" x="1249" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}+$F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c61add76-6817-4eea-8822-8dbad930076b" x="1145" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="184c379c-21e0-48c7-a602-d6dea1a452f7" x="1093" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a8cd5b1a-65e6-4e13-92f1-5fec4485c8f9" x="989" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb7}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5be363e2-5a3c-4458-9896-e1dc0dc2deeb" x="937" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt7}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="98797710-0296-457a-b176-d747038a27de" x="833" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb6}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="05f6675e-d936-4e0f-aaa0-d955d3af3ef1" x="781" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt6}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f2cc2a58-4fc0-4252-8787-b21f403c7d53" x="677" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb5}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="288219d9-2945-48b0-b9eb-24c055dcd936" x="625" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt5}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e9d959d-0d54-492b-9c0e-3ab59b97d272" x="521" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb4}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f8433a27-2557-49f9-8567-58acaef154d7" x="469" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt4}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c62496bc-3b91-48dd-a9db-9191d9b7189e" x="365" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bbbbe47a-06af-4eec-a5fa-f922e806ee6b" x="313" y="4" width="49" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0225f37b-e6f0-481d-9bc8-0184e580fd6c" x="209" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b619d5d8-a795-4c1c-b16e-f160e15e06b7" x="157" y="4" width="49" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5d81b50d-aeaa-4e91-b9e6-8a531abbe772" x="53" y="4" width="102" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ea4349f4-35ea-46ba-b3e5-bf109facf6a2" x="1" y="4" width="50" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="208" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="52" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="520" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="624" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="780" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="832" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="988" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="1092" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="1248" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="1300" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Solid"/>
</graphicElement>
</line>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="328" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="484" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="536" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="640" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="848" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="1108" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="1316" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="171" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
</band>
</summary>
</jasperReport>