|
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/LaporanNop/ |
| [ 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="subBelumLunas" language="groovy" pageWidth="1093" pageHeight="830" whenNoDataType="AllSectionsNoDetail" columnWidth="1053" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryNewPage="true" isFloatColumnFooter="true" uuid="961d9169-beb3-4fed-aa16-b6ff4e2950ff">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="398"/>
<property name="ireport.y" value="288"/>
<subDataset name="dataset1" uuid="ae460763-164f-42d4-8d1b-948334e73866">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak_sppt" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select coalesce(sum(jml_sppt_yg_dibayar),0) as jumlah_dibayar,
coalesce(max(tgl_pembayaran_sppt),null) as maxtgl from pembayaran_sppt
where kd_propinsi = $P{kd_propinsi} and kd_dati2 = $P{kd_dati2}
and kd_kecamatan = $P{kd_kecamatan} and kd_kelurahan = $P{kd_kelurahan} and kd_blok = $P{kd_blok} and no_urut = $P{no_urut} and kd_jns_op = $P{kd_jns_op} and thn_pajak_sppt = $P{thn_pajak_sppt}]]>
</queryString>
<field name="jumlah_dibayar" class="java.math.BigDecimal"/>
<field name="maxtgl" class="java.sql.Timestamp"/>
</subDataset>
<subDataset name="dataset2" uuid="6d8c3906-7768-4d11-b723-c884231f5a1f">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT
(CASE WHEN jml_sppt_yg_dibayar > 0 THEN
CASE WHEN (DENDA_SPPT = 0 and POKOK_DENDA_ADM <> 0) THEN POKOK_DENDA_ADM::double precision
ELSE DENDA_SPPT::double precision
END
ELSE
CASE WHEN (date_part('year'::text, age(now()::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) > 24::double precision THEN round(24::numeric * 0.02 * pbb_yg_harus_dibayar_sppt::numeric)::double precision
WHEN (date_part('year'::text, age(now()::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) >= 12::double precision THEN round((date_part('month'::text, age(now()::timestamp without time zone, tgl_jatuh_tempo_sppt))+ 1 + 12::double precision) * 0.02::double precision * pbb_yg_harus_dibayar_sppt::double precision)
WHEN (date_part('year'::text, age(now()::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) < 12::double precision THEN round((date_part('month'::text, age(now()::timestamp without time zone, tgl_jatuh_tempo_sppt))+ 1::double precision) * 0.02::double precision * pbb_yg_harus_dibayar_sppt::double precision)
ELSE NULL::double precision
END
END
) AS denda
FROM (
SELECT A.KD_PROPINSI , A.KD_DATI2,
A.KD_KECAMATAN ,
A.KD_KELURAHAN ,
A.KD_BLOK ,
A.NO_URUT ,
A.KD_JNS_OP,
A.THN_PAJAK_SPPT ,A.STATUS_PEMBAYARAN_SPPT,A.TGL_JATUH_TEMPO_SPPT,A.pbb_yg_harus_dibayar_sppt,
(SELECT jml_sppt_yg_dibayar FROM PEMBAYARAN_SPPT B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_PAJAK_SPPT ) AS jml_sppt_yg_dibayar,
(SELECT DENDA_SPPT FROM PEMBAYARAN_SPPT B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_PAJAK_SPPT ) AS DENDA_SPPT,
(SELECT POKOK_DENDA_ADM FROM DENDA_ADMINISTRASI B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_DENDA) AS POKOK_DENDA_ADM
FROM SPPT A
WHERE A.KD_PROPINSI = $P{kd_propinsi}
AND A.KD_DATI2 = $P{kd_dati2}
AND A.KD_KECAMATAN = $P{kd_kecamatan}
AND A.KD_KELURAHAN = $P{kd_kelurahan}
AND A.KD_BLOK = $P{kd_blok}
AND A.NO_URUT = $P{no_urut}
AND A.KD_JNS_OP = $P{kd_jns_op}
AND A.THN_PAJAK_SPPT = $P{thn_pajak} )AS A]]>
</queryString>
<field name="denda" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset3" uuid="30f859e4-73cf-4ca1-b805-6a0e56932fe0">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select kd_kecamatan_induk||'.'|| kd_kelurahan_induk||'.'||no_urut_induk||'.'||kd_jns_op_induk as nop_induk from dat_op_anggota where kd_propinsi = $P{kd_propinsi} and kd_dati2 = $P{kd_dati2} and kd_kecamatan = $P{kd_kecamatan} and kd_kelurahan = $P{kd_kelurahan} and kd_blok = $P{kd_blok} and no_urut = $P{no_urut} and kd_jns_op = $P{kd_jns_op}]]>
</queryString>
<field name="nop_induk" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset5" uuid="88515cc4-bd24-4105-9867-3d7cfa3fcc1a">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_denda),0) as total_denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT <= 100000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '1'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="total_denda" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset6" uuid="dad6e897-8fba-421e-9e7e-9decdb0ace10">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_bayar),0) as jumlah_bayar,
sum(CASE WHEN (jumlah_denda = 0 and POKOK_DENDA_ADM <> 0) THEN POKOK_DENDA_ADM::double precision
ELSE jumlah_denda::double precision
END) AS denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(sum(A.jml_sppt_yg_dibayar)) as jumlah_bayar,coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join DENDA_ADMINISTRASI B
ON SPPT.KD_PROPINSI = B.KD_PROPINSI
AND SPPT.KD_DATI2 = B.KD_DATI2
AND SPPT.KD_KECAMATAN = B.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = B.KD_KELURAHAN
AND SPPT.KD_BLOK = B.KD_BLOK
AND SPPT.NO_URUT = B.NO_URUT
AND SPPT.KD_JNS_OP = B.KD_JNS_OP
AND SPPT.THN_PAJAK_SPPT = B.THN_DENDA
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT <= 100000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '0'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="jumlah_bayar" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset7" uuid="a696fea9-e134-4da7-a944-973c930434b4">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang
FROM pbb.SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 100001 AND 500000
AND SPPT.STATUS_PEMBAYARAN_SPPT <> '2'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset8" uuid="e9945440-9ce9-4509-8288-af7c7d1c8a6e">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_denda),0) as total_denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 100001 AND 500000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '1'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="total_denda" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset9" uuid="913a2612-9b19-4e5a-b6de-e0e27eea07e8">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_bayar),0) as jumlah_bayar,
sum(CASE WHEN (jumlah_denda = 0 and POKOK_DENDA_ADM <> 0) THEN POKOK_DENDA_ADM::double precision
ELSE jumlah_denda::double precision
END) AS denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(sum(A.jml_sppt_yg_dibayar)) as jumlah_bayar,coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join DENDA_ADMINISTRASI B
ON SPPT.KD_PROPINSI = B.KD_PROPINSI
AND SPPT.KD_DATI2 = B.KD_DATI2
AND SPPT.KD_KECAMATAN = B.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = B.KD_KELURAHAN
AND SPPT.KD_BLOK = B.KD_BLOK
AND SPPT.NO_URUT = B.NO_URUT
AND SPPT.KD_JNS_OP = B.KD_JNS_OP
AND SPPT.THN_PAJAK_SPPT = B.THN_DENDA
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 100001 AND 500000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '0'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="jumlah_bayar" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset10" uuid="63c1ec62-3266-464c-bd1c-aeddb89b05e2">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang
FROM pbb.SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 500001 AND 2000000
AND SPPT.STATUS_PEMBAYARAN_SPPT <> '2'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset11" uuid="ddc80e92-4fed-4250-bda2-49740bd885ac">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_denda),0) as total_denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 500001 AND 2000000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '1'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="total_denda" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset12" uuid="7382ea21-764e-4c7a-b5be-a05bf3ee3046">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_bayar),0) as jumlah_bayar,
sum(CASE WHEN (jumlah_denda = 0 and POKOK_DENDA_ADM <> 0) THEN POKOK_DENDA_ADM::double precision
ELSE jumlah_denda::double precision
END) AS denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(sum(A.jml_sppt_yg_dibayar)) as jumlah_bayar,coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join DENDA_ADMINISTRASI B
ON SPPT.KD_PROPINSI = B.KD_PROPINSI
AND SPPT.KD_DATI2 = B.KD_DATI2
AND SPPT.KD_KECAMATAN = B.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = B.KD_KELURAHAN
AND SPPT.KD_BLOK = B.KD_BLOK
AND SPPT.NO_URUT = B.NO_URUT
AND SPPT.KD_JNS_OP = B.KD_JNS_OP
AND SPPT.THN_PAJAK_SPPT = B.THN_DENDA
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 500001 AND 2000000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '0'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="jumlah_bayar" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset13" uuid="f5b502d1-cc64-499b-af72-dbd1306b421f">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang
FROM pbb.SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 2000001 AND 5000000
AND SPPT.STATUS_PEMBAYARAN_SPPT <> '2'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset14" uuid="f2786e4e-8e38-43fd-ba70-009ae82381e9">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_denda),0) as total_denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 2000001 AND 5000000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '1'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="total_denda" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset15" uuid="0be1bfcb-a524-40a3-9125-2a3bb195616b">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_bayar),0) as jumlah_bayar,
sum(CASE WHEN (jumlah_denda = 0 and POKOK_DENDA_ADM <> 0) THEN POKOK_DENDA_ADM::double precision
ELSE jumlah_denda::double precision
END) AS denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(sum(A.jml_sppt_yg_dibayar)) as jumlah_bayar,coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join DENDA_ADMINISTRASI B
ON SPPT.KD_PROPINSI = B.KD_PROPINSI
AND SPPT.KD_DATI2 = B.KD_DATI2
AND SPPT.KD_KECAMATAN = B.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = B.KD_KELURAHAN
AND SPPT.KD_BLOK = B.KD_BLOK
AND SPPT.NO_URUT = B.NO_URUT
AND SPPT.KD_JNS_OP = B.KD_JNS_OP
AND SPPT.THN_PAJAK_SPPT = B.THN_DENDA
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN 2000001 AND 5000000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '0'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="jumlah_bayar" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset16" uuid="da59e0f5-0622-44ec-b0c0-938c35008868">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang
FROM pbb.SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT > 5000000
AND SPPT.STATUS_PEMBAYARAN_SPPT <> '2'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset17" uuid="9a71067f-53c0-4de5-a739-930b75b29633">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_denda),0) as total_denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT > 5000000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '1'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="total_denda" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset18" uuid="2ff6a63f-1491-4742-9371-62998b5354b3">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang,
coalesce(sum(C.jumlah_bayar),0) as jumlah_bayar,
sum(CASE WHEN (jumlah_denda = 0 and POKOK_DENDA_ADM <> 0) THEN POKOK_DENDA_ADM::double precision
ELSE jumlah_denda::double precision
END) AS denda
FROM pbb.SPPT
INNER JOIN (SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT, coalesce(sum(A.jml_sppt_yg_dibayar)) as jumlah_bayar,coalesce(max(A.denda_sppt),0) as jumlah_denda FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) C on SPPT.KD_PROPINSI = C.KD_PROPINSI AND
SPPT.KD_DATI2 = C.KD_DATI2 AND
SPPT.KD_KECAMATAN = C.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = C.KD_KELURAHAN AND
SPPT.KD_BLOK = C.KD_BLOK AND
SPPT.NO_URUT = C.NO_URUT AND
SPPT.KD_JNS_OP = C.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = C.THN_PAJAK_SPPT
left join DENDA_ADMINISTRASI B
ON SPPT.KD_PROPINSI = B.KD_PROPINSI
AND SPPT.KD_DATI2 = B.KD_DATI2
AND SPPT.KD_KECAMATAN = B.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = B.KD_KELURAHAN
AND SPPT.KD_BLOK = B.KD_BLOK
AND SPPT.NO_URUT = B.NO_URUT
AND SPPT.KD_JNS_OP = B.KD_JNS_OP
AND SPPT.THN_PAJAK_SPPT = B.THN_DENDA
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT > 5000000
AND SPPT.STATUS_PEMBAYARAN_SPPT = '0'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="jumlah_bayar" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset19" uuid="ec3a6f5d-fd28-4f4b-920d-859cecc7d705">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select kota_terbit from pbb.ref_kantor where kd_kanwil in (SELECT DISTINCT KD_KANWIL FROM pbb.REF_ADM_kantor
WHERE KD_PROPINSI = $P{kd_propinsi}
AND KD_DATI2 = $P{kd_dati2}
and kd_kantor in( SELECT DISTINCT KD_kantor
FROM pbb.REF_ADM_kantor
WHERE KD_PROPINSI = $P{kd_propinsi}
AND KD_DATI2 = $P{kd_dati2}))]]>
</queryString>
<field name="kota_terbit" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset20" uuid="a9409712-cd43-47c6-866b-8cc398407492">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select a.nip,a.nm_pegawai from pbb.pegawai a,pbb.posisi_pegawai b
where a.nip=b.nip and
kd_kanwil in (SELECT DISTINCT KD_KANWIL FROM pbb.REF_ADM_kantor
WHERE KD_PROPINSI = $P{kd_propinsi}
AND KD_DATI2 = $P{kd_dati2})
and kd_kantor in( SELECT DISTINCT KD_kantor
FROM pbb.REF_ADM_kantor
WHERE KD_PROPINSI = $P{kd_propinsi}
AND KD_DATI2 = $P{kd_dati2}) and
kd_jabatan='10']]>
</queryString>
<field name="nip" class="java.lang.String"/>
<field name="nm_pegawai" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset21" uuid="91e0ab13-60ce-4c8e-b25d-2a13be858046">
<parameter name="tgl_now2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select pbb.fmt_bln($P{tgl_now2})]]>
</queryString>
<field name="fmt_bln" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset22" uuid="b6cfefd6-f9ca-4a85-8a43-b1d08330afd7">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT D.nm_propinsi,C.nm_dati2,B.nm_kecamatan,A.nm_kelurahan from ref_kelurahan A
inner join ref_kecamatan B on A.kd_kecamatan=B.kd_kecamatan and A.kd_dati2=B.kd_dati2 and A.kd_propinsi=B.kd_propinsi
inner join ref_dati2 C on A.kd_propinsi=C.kd_propinsi and A.kd_dati2=C.kd_dati2
inner join ref_propinsi D on A.kd_propinsi=B.kd_propinsi
where A.kd_propinsi = $P{kd_propinsi} and A.kd_dati2 = $P{kd_dati2} and A.kd_kecamatan=$P{kd_kecamatan} and A.kd_kelurahan=$P{kd_kelurahan}]]>
</queryString>
<field name="nm_propinsi" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="nm_kecamatan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset4" uuid="9f3da0d9-4584-4ad8-a673-646c2a116cd5">
<parameter name="kd_propinsi1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati21" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir1" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT count(SPPT.KD_PROPINSI) as jumlah_objek, coalesce(sum(SPPT.PBB_YG_HARUS_DIBAYAR_SPPT),0) as pbb_terhutang
FROM pbb.SPPT
left join pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK AND
SPPT.NO_URUT = SPPT_OP_BERSAMA.NO_URUT AND
SPPT.KD_JNS_OP = SPPT_OP_BERSAMA.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = SPPT_OP_BERSAMA.THN_PAJAK_SPPT
, pbb.DAT_OBJEK_PAJAK, pbb.REF_PROPINSI, pbb.REF_DATI2, pbb.REF_KECAMATAN, pbb.REF_KELURAHAN,
pbb.TEMPAT_PEMBAYARAN
WHERE
SPPT.KD_PROPINSI = $P{kd_propinsi1}
AND SPPT.KD_DATI2 = $P{kd_dati21}
AND SPPT.KD_KECAMATAN = $P{kd_kecamatan1}
AND SPPT.KD_KELURAHAN = $P{kd_kelurahan1}
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal1} AND $P{p_akhir1}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT <= 100000
AND SPPT.STATUS_PEMBAYARAN_SPPT <> '2'
AND SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI
AND SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2
AND SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
AND SPPT.KD_PROPINSI = REF_PROPINSI.KD_PROPINSI
AND SPPT.KD_PROPINSI = REF_DATI2.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_DATI2.KD_DATI2
AND SPPT.KD_PROPINSI = REF_KECAMATAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KECAMATAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KECAMATAN.KD_KECAMATAN
AND SPPT.KD_PROPINSI = REF_KELURAHAN.KD_PROPINSI
AND SPPT.KD_DATI2 = REF_KELURAHAN.KD_DATI2
AND SPPT.KD_KECAMATAN = REF_KELURAHAN.KD_KECAMATAN
AND SPPT.KD_KELURAHAN = REF_KELURAHAN.KD_KELURAHAN
AND SPPT.KD_KANWIL = TEMPAT_PEMBAYARAN.KD_KANWIL
AND SPPT.KD_KANTOR = TEMPAT_PEMBAYARAN.KD_KANTOR
AND SPPT.KD_TP = TEMPAT_PEMBAYARAN.KD_TP
GROUP BY SPPT.KD_PROPINSI]]>
</queryString>
<field name="jumlah_objek" class="java.lang.Long"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
</subDataset>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak_sppt" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_awal2" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir2" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="buku" class="java.lang.String"/>
<parameter name="tgl_now" class="java.lang.String"/>
<queryString>
<![CDATA[select SPPT.KD_PROPINSI, SPPT.KD_DATI2, SPPT.KD_KECAMATAN, SPPT.KD_KELURAHAN,
SPPT.KD_BLOK, SPPT.NO_URUT, SPPT.KD_JNS_OP,
SPPT.NO_PERSIL_SPPT,SPPT.NM_WP_SPPT, SPPT.TGL_TERBIT_SPPT,
faktor_pengurang_sppt,
SPPT.LUAS_BUMI_SPPT TOTAL_LUAS_BUMI,
SPPT.LUAS_BNG_SPPT TOTAL_LUAS_BNG,
coalesce(SPPT.JLN_WP_SPPT,'')||' '||coalesce(SPPT.BLOK_KAV_NO_WP_SPPT,'') ALM_WP,
SPPT.THN_PAJAK_SPPT,SPPT.KD_BLOK||'.'||SPPT.NO_URUT||'-'||SPPT.KD_JNS_OP NOP,SPPT_OP_BERSAMA.LUAS_BUMI_BEBAN_SPPT,
SPPT_OP_BERSAMA.LUAS_BNG_BEBAN_SPPT,
SPPT.PBB_YG_HARUS_DIBAYAR_SPPT AS PBB_TERHUTANG_SPPT,
(Select coalesce(DAT_OBJEK_PAJAK.JALAN_OP,'')||' '||coalesce(DAT_OBJEK_PAJAK.BLOK_KAV_NO_OP,'') FROM DAT_OBJEK_PAJAK WHERE SPPT.KD_PROPINSI = DAT_OBJEK_PAJAK.KD_PROPINSI AND
SPPT.KD_DATI2 = DAT_OBJEK_PAJAK.KD_DATI2 AND
SPPT.KD_KECAMATAN = DAT_OBJEK_PAJAK.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = DAT_OBJEK_PAJAK.KD_KELURAHAN
AND SPPT.KD_BLOK = DAT_OBJEK_PAJAK.KD_BLOK
AND SPPT.NO_URUT = DAT_OBJEK_PAJAK.NO_URUT
AND SPPT.KD_JNS_OP = DAT_OBJEK_PAJAK.KD_JNS_OP
) ALM_OP,
(SELECT nm_propinsi from ref_propinsi where sppt.kd_propinsi=ref_propinsi.kd_propinsi) nm_propinsi
,(SELECT nm_dati2 from ref_dati2 where sppt.kd_dati2=ref_dati2.kd_dati2 and sppt.kd_propinsi=ref_dati2.kd_propinsi) nm_dati2
,(SELECT nm_kecamatan from ref_kecamatan where sppt.kd_kecamatan=ref_kecamatan.kd_kecamatan and sppt.kd_dati2=ref_kecamatan.kd_dati2 and sppt.kd_propinsi=ref_kecamatan.kd_propinsi) nm_kecamatan
,(SELECT nm_kelurahan from ref_kelurahan where sppt.kd_kelurahan=ref_kelurahan.kd_kelurahan and sppt.kd_kecamatan=ref_kelurahan.kd_kecamatan and sppt.kd_dati2=ref_kelurahan.kd_dati2 and sppt.kd_propinsi=ref_kelurahan.kd_propinsi) nm_kelurahan
from sppt
LEFT JOIN pbb.SPPT_OP_BERSAMA on
SPPT.KD_PROPINSI = SPPT_OP_BERSAMA.KD_PROPINSI AND
SPPT.KD_DATI2 = SPPT_OP_BERSAMA.KD_DATI2 AND
SPPT.KD_KECAMATAN = SPPT_OP_BERSAMA.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = SPPT_OP_BERSAMA.KD_KELURAHAN AND
SPPT.KD_BLOK = SPPT_OP_BERSAMA.KD_BLOK
INNER JOIN (select A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT FROM PEMBAYARAN_SPPT A GROUP BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP,A.THN_PAJAK_SPPT) F ON
SPPT.KD_PROPINSI = F.KD_PROPINSI AND
SPPT.KD_DATI2 = F.KD_DATI2 AND
SPPT.KD_KECAMATAN = F.KD_KECAMATAN AND
SPPT.KD_KELURAHAN = F.KD_KELURAHAN AND
SPPT.KD_BLOK = F.KD_BLOK AND
SPPT.NO_URUT = F.NO_URUT AND
SPPT.KD_JNS_OP = F.KD_JNS_OP AND
SPPT.THN_PAJAK_SPPT = F.THN_PAJAK_SPPT
where sppt.kd_propinsi = $P{kd_propinsi} and sppt.kd_dati2 = $P{kd_dati2} and sppt.kd_kecamatan = $P{kd_kecamatan} and sppt.kd_kelurahan = $P{kd_kelurahan}
AND SPPT.STATUS_PEMBAYARAN_SPPT = '0'
AND SPPT.THN_PAJAK_SPPT = $P{thn_pajak_sppt}
AND SPPT.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal2} AND $P{p_akhir2}]]>
</queryString>
<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="kd_blok" class="java.lang.String"/>
<field name="no_urut" class="java.lang.String"/>
<field name="kd_jns_op" class="java.lang.String"/>
<field name="no_persil_sppt" class="java.lang.String"/>
<field name="nm_wp_sppt" class="java.lang.String"/>
<field name="tgl_terbit_sppt" class="java.sql.Timestamp"/>
<field name="faktor_pengurang_sppt" class="java.lang.Long"/>
<field name="total_luas_bumi" class="java.lang.Long"/>
<field name="total_luas_bng" class="java.lang.Long"/>
<field name="alm_wp" class="java.lang.String"/>
<field name="thn_pajak_sppt" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<field name="luas_bumi_beban_sppt" class="java.lang.Long"/>
<field name="luas_bng_beban_sppt" class="java.lang.Long"/>
<field name="pbb_terhutang_sppt" class="java.lang.Long"/>
<field name="alm_op" class="java.lang.String"/>
<field name="nm_propinsi" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="nm_kecamatan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<columnHeader>
<band height="122" splitType="Stretch">
<textField>
<reportElement uuid="331f632e-b210-40eb-9c9a-a10bd4948596" x="12" y="1" width="1005" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["NOP BAYAR BELUM LUNAS"]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="f61cab54-6b1d-44fb-817d-eb23240c5c35" x="124" y="42" width="138" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_kelurahan}+" - "]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5de877a8-d828-482d-8566-604967711373" x="106" y="22" width="18" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[":"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1e04dc35-9f04-4e9c-b9a3-2e46cabd9b9c" x="108" y="42" width="16" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[":"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6b4d5d45-db65-47b0-945a-6debc126530b" x="8" y="42" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["KELURAHAN"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e8be5310-3e0f-4e75-8f87-e46365264959" x="8" y="22" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["KECAMATAN"]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="6f87d60c-1cc2-4466-a378-410e15d4fab7" x="124" y="22" width="138" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_kecamatan}+" - "]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="8afc155d-67a3-4cd5-ad05-ea29812cb229" x="520" y="97" width="85" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[WAJIB PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="fae6760b-647d-4507-b828-eef5ebbd681d" x="827" y="79" width="72" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PERUBAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="8531bd9a-98dc-4ad4-8b21-da0811740ccb" x="347" y="80" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA WAJIB PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="2626fa2f-bf73-4798-983d-03442ce0312a" x="71" y="80" width="91" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="9ad6594f-0252-4485-ba4d-57b41c828268" x="950" y="98" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TANGGAL BAYAR]]></text>
</staticText>
<staticText>
<reportElement uuid="b2a3e22c-8ae2-404d-994e-bf8174d47973" x="477" y="78" width="128" height="18"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[ALAMAT OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="373b1fe0-0946-4c94-bfb4-a944d38b4345" x="950" y="78" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JUMLAH BAYAR]]></text>
</staticText>
<staticText>
<reportElement uuid="c2089fcc-1818-460b-ac1f-2723fbc28bc9" x="827" y="99" width="72" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="8edbbbcb-f123-4822-9197-ed58f25a50da" x="212" y="80" width="77" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP INDUK]]></text>
</staticText>
<staticText>
<reportElement uuid="a5a493c7-8f97-4054-8ab8-f4ff5e218b4e" x="696" y="77" width="103" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[POKOK]]></text>
</staticText>
<staticText>
<reportElement uuid="09bf6833-14f4-462a-a2b4-132c5875e1ce" x="6" y="80" width="44" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMOR]]></text>
</staticText>
<staticText>
<reportElement uuid="daa1d4a2-a49a-4a53-9995-da1ec2b70594" x="696" y="97" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DENDA]]></text>
</staticText>
<line>
<reportElement uuid="60793979-4bf0-4b72-9b55-3bd9ba8cf9fb" x="3" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f36e93b2-a80b-45ba-922b-ec21dc7e4f58" x="1050" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d8be9011-0f09-4b2d-9c73-bd21d4869ce3" x="4" y="72" width="1046" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="5ef899bb-b795-4810-bd73-9e7466e59231" x="3" y="66" width="1047" height="2"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="338fd2d2-faca-4060-8d36-12d11a14be83" x="916" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="014c171c-e55d-41ba-87c8-e28aeb8fe4b8" x="815" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="510912ee-712e-4419-be5a-8de9fc0d352e" x="687" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="8350adc7-bb95-4f73-b334-9a2b9e89db55" x="465" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="cb4b7adb-b5e7-4ad5-ab1c-f6e35318a653" x="165" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="8536a77d-bcd7-497d-8c4e-5123e781fec8" x="52" y="68" width="1" height="54"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="dd6ad634-0f08-4c69-8a4b-836271995001" x="329" y="66" width="1" height="56"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="b6cc286f-23cb-4512-afdd-e16216f61675" x="3" y="117" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="7b9a81c5-0133-442f-8966-1fd6f443850a" x="3" y="121" width="1050" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField isBlankWhenNull="true">
<reportElement uuid="f61cab54-6b1d-44fb-817d-eb23240c5c35" x="261" y="42" width="138" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="6f87d60c-1cc2-4466-a378-410e15d4fab7" x="261" y="22" width="138" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="122a5160-8774-4d6a-b8f1-493ebd30aeb6" x="837" y="23" width="200" height="24"/>
<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">
<datasetRun subDataset="dataset21" uuid="ea966ec6-5173-43f0-96cb-2e536ec76d8b">
<datasetParameter name="tgl_now2">
<datasetParameterExpression><![CDATA[$P{tgl_now}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="24" width="200">
<textField>
<reportElement uuid="7ba1f735-a185-4a84-8b62-52ea8417305e" x="13" y="4" width="167" height="20"/>
<textElement textAlignment="Left">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{fmt_bln}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</columnHeader>
<detail>
<band height="49" splitType="Stretch">
<textField>
<reportElement uuid="e41cf0f8-356b-46a3-9294-169684016d1a" x="468" y="4" width="217" height="21"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alm_op}==null?
""
:$F{alm_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f76e9c8b-c783-4350-9ca2-bb5a8b0d1b2e" x="55" y="3" width="107" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ff25748d-069c-4b50-a771-34bdbf3fe331" x="693" y="5" width="104" height="21"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang_sppt}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e12f7cde-bee3-4560-a4b7-61890921cd76" x="332" y="4" width="131" height="27"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f6ebffd4-a4c4-42a7-a89c-5faf18059a51" x="468" y="26" width="217" height="21"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alm_wp}==null?
""
:$F{alm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="40ad02b2-5d8e-4578-ab1e-036bb5880176" x="7" y="3" width="42" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="ac9a8646-9d93-4d6d-9ecf-42184e7c27f2" x="928" y="5" width="117" height="42"/>
<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="de65cc96-93f5-4c8b-a876-a91660c5feee">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak_sppt">
<datasetParameterExpression><![CDATA[$F{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="42" width="117">
<textField>
<reportElement uuid="66564a16-7b3b-4dbd-9a28-bef7da36cd30" x="0" y="21" width="114" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{maxtgl}==null?
""
:new SimpleDateFormat("dd-MM-yyyy").format($F{maxtgl})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c19d4968-10cd-43f4-80fd-31b10659205f" x="0" y="1" width="114" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_dibayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="8d5fb4e6-6c5a-4454-858b-e95b490f77a1" x="694" y="26" width="105" height="21"/>
<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="4e53970a-e533-4008-9b0b-df9457738703">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$F{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="21" width="105">
<textField>
<reportElement uuid="4ba0b4aa-bded-483c-87c7-4e0ce70ce84d" x="1" y="1" width="104" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="5560552f-b647-4eb5-a08c-e59c4d70b122" x="168" y="3" width="160" 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="dataset3" uuid="5c8aac43-37c8-4362-b65c-4d4f4818d40c">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="28" width="160">
<textField>
<reportElement uuid="471441f7-9335-4042-98b2-7b9e757ec0df" x="4" y="1" width="156" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nop_induk}==null?
""
:$F{nop_induk}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="36316e9d-4da1-457f-af6a-513479ef2c62" x="1050" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="e934cc6f-3871-4725-adb0-7da8f8e37124" x="916" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="b3b1af30-1786-4a53-beda-bf377efafc1b" x="815" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="b7121ea2-6d74-43ba-8eb3-7964d0c00a87" x="687" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="8ffb8e39-e8ea-4642-a8c7-afb8459cdfa5" x="466" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="82839d54-2045-40a1-a9e7-3f32923fd4f7" x="3" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f29b4eb5-17d6-45bd-b430-c420c45c9247" x="52" y="0" width="1" height="47"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="7c55f746-4871-4572-b1dd-a19aa8d6c8f1" x="165" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fc85314e-ca4b-404e-8c3b-fe8202c98dc8" x="329" y="0" width="1" height="48"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField isBlankWhenNull="false">
<reportElement uuid="ff25748d-069c-4b50-a771-34bdbf3fe331" x="816" y="6" width="100" height="21"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{faktor_pengurang_sppt}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="30" splitType="Stretch">
<line>
<reportElement uuid="c717613e-1956-41f9-9d79-60136d315362" x="3" y="0" width="1045" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</columnFooter>
<summary>
<band height="403" splitType="Stretch">
<staticText>
<reportElement uuid="7d95a074-f882-4b24-b393-47e10daa5190" x="547" y="37" width="36" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[BUKU]]></text>
</staticText>
<textField>
<reportElement uuid="87468d56-984d-48ba-83a9-efb450476072" x="435" y="37" width="75" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA[$P{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cced42fb-dd64-4f41-96da-04f33a9ad26d" x="586" y="37" width="167" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA[$P{buku}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="024effb7-e46a-4c9d-a816-e0168380c46f" x="341" y="37" width="94" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[TAHUN PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="72473006-6fc1-4cf6-ab61-8d58330b4d17" x="422" y="52" width="29" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement uuid="64b06ca5-ab00-464e-8fce-d68faed1cd7b" x="328" y="77" width="81" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KECAMATAN]]></text>
</staticText>
<staticText>
<reportElement uuid="c775421d-d7fb-4731-9a9f-8e726581e82e" x="328" y="64" width="81" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KOTA / KAB]]></text>
</staticText>
<staticText>
<reportElement uuid="a4d8c374-4ebe-44b1-95b0-74deb59a03e7" x="422" y="77" width="29" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement uuid="ce3ff036-d199-4ab9-8b2e-488843de80e6" x="422" y="64" width="29" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement uuid="46369459-e4e1-4845-bf3c-b9ffab0a3d62" x="328" y="90" width="81" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KELURAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="8b7eadf4-9a5e-45f0-afa3-0786d221cc21" x="422" y="90" width="29" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement uuid="89f4ca1c-9be9-4916-a09f-a006e5dba844" x="328" y="52" width="57" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PROPINSI]]></text>
</staticText>
<staticText>
<reportElement uuid="e6f3a833-5999-48f1-8624-40a295b193ca" x="136" y="114" width="126" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[POKOK KETETAPAN]]></text>
</staticText>
<staticText>
<reportElement uuid="5e73dd25-f72e-433c-9ab2-c5d8c70b95b4" x="39" y="114" width="87" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JUMLAH OBJEK]]></text>
</staticText>
<staticText>
<reportElement uuid="2741f86b-aca4-4314-aef9-418fc0624d26" x="3" y="114" width="27" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[BUKU]]></text>
</staticText>
<staticText>
<reportElement uuid="b30df29f-6d46-455f-aa94-a6b03ec616c7" x="5" y="159" width="24" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[1]]></text>
</staticText>
<staticText>
<reportElement uuid="4b598fa1-a2ee-4211-9a8b-bfab805f4612" x="5" y="187" width="24" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[3]]></text>
</staticText>
<staticText>
<reportElement uuid="d34e694f-47a5-42c2-bde0-3fb59a5642d1" x="5" y="173" width="24" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[2]]></text>
</staticText>
<staticText>
<reportElement uuid="561d5370-9da7-464d-95b4-109c117c1a66" x="5" y="215" width="24" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[5]]></text>
</staticText>
<staticText>
<reportElement uuid="69905ce4-0288-4f96-ad3d-9440752aeead" x="5" y="201" width="24" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[4]]></text>
</staticText>
<componentElement>
<reportElement uuid="14835ced-7bed-4516-b42e-b6e8f96bb968" x="33" y="159" width="240" height="12"/>
<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="dataset4" uuid="6f62d65b-d5d8-4ce2-884a-f3a8e750142f">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="240">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="102" y="0" width="135" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74195422-bdb4-4624-8b0a-2f08dec7d87f" x="5" y="0" width="89" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="2ea6d9e3-7dc4-424a-8476-50b089d7d41b" x="289" y="114" width="162" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Pembayaran Sudah Lunas]]></text>
</staticText>
<staticText>
<reportElement uuid="4b16b9f6-b635-42e9-9ff8-09210aa8646b" x="289" y="136" width="69" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="31a96f04-cc50-4a2c-a6c2-4e93a8b64342" x="385" y="136" width="111" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMINAL]]></text>
</staticText>
<componentElement>
<reportElement uuid="5eae9030-e0c3-4271-9cf7-ca356806bc77" x="276" y="159" width="339" height="12"/>
<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="dataset5" uuid="896e9e25-b3e2-48c9-b64c-d3faebb21a07">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="339">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="85" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="91" y="0" width="136" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="232" y="0" width="107" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="31a96f04-cc50-4a2c-a6c2-4e93a8b64342" x="520" y="135" width="85" height="17"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DENDA]]></text>
</staticText>
<staticText>
<reportElement uuid="4b16b9f6-b635-42e9-9ff8-09210aa8646b" x="625" y="135" width="60" height="17"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="31a96f04-cc50-4a2c-a6c2-4e93a8b64342" x="709" y="135" width="106" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[POKOK]]></text>
</staticText>
<staticText>
<reportElement uuid="2ea6d9e3-7dc4-424a-8476-50b089d7d41b" x="685" y="113" width="296" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Pembayaran Sudah Bayar Belum Lunas]]></text>
</staticText>
<staticText>
<reportElement uuid="31a96f04-cc50-4a2c-a6c2-4e93a8b64342" x="837" y="135" width="74" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DENDA]]></text>
</staticText>
<componentElement>
<reportElement uuid="e83de651-828e-4f31-91e6-2a72e781d061" x="625" y="159" width="425" height="12"/>
<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="dataset6" uuid="34651e47-755a-406d-857f-9c2786105493">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="425">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="68" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="72" y="0" width="125" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="202" y="0" width="98" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="303" y="0" width="118" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="73e5806e-95e9-4a9c-b769-cc1976a6df0c" x="33" y="173" width="240" height="12"/>
<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="dataset7" uuid="f49f58b0-298a-491b-b054-c68514b82178">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="240">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="102" y="0" width="135" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74195422-bdb4-4624-8b0a-2f08dec7d87f" x="5" y="0" width="89" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="04d6dba0-2f1c-4407-9480-c32f3c85566a" x="276" y="173" width="339" height="12"/>
<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="dataset8" uuid="5b48c095-659a-45ca-a388-d8e1bc984f6b">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="339">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="85" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="91" y="0" width="136" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="232" y="0" width="107" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="ebc2a0b5-b6dd-4b14-a4e5-8cda079cc023" x="625" y="173" width="425" height="12"/>
<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="dataset9" uuid="03521c45-6617-463b-b323-073b97d5ba3c">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="425">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="202" y="0" width="98" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="303" y="0" width="118" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="68" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="72" y="0" width="125" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="40868e65-4603-4955-b818-4fc2468da91b" x="33" y="187" width="240" height="12"/>
<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="dataset10" uuid="6658d74e-3d26-4010-84bb-5df4ba3750b9">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="240">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="102" y="0" width="135" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74195422-bdb4-4624-8b0a-2f08dec7d87f" x="5" y="0" width="89" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="da943367-1320-454c-b1f2-ac71dc71507c" x="277" y="187" width="338" height="12"/>
<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="dataset11" uuid="6625d334-e1e4-4ba3-93f9-70731e23b156">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="338">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="85" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="90" y="0" width="136" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="231" y="0" width="107" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="00b162b9-e4b8-47c9-b90d-81779a8ab079" x="625" y="187" width="425" height="12"/>
<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="dataset12" uuid="6a0329b6-66e4-4f69-890b-82b0947d2d45">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="425">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="202" y="0" width="98" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="303" y="0" width="118" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="68" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="72" y="0" width="125" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="5403509d-a787-458b-b40c-541e8c557ad1" x="33" y="201" width="240" height="12"/>
<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="dataset13" uuid="cdc5800b-0cca-41f0-a282-b1fe163693f6">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="240">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="102" y="0" width="135" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74195422-bdb4-4624-8b0a-2f08dec7d87f" x="5" y="0" width="89" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="3fd35918-46a8-46f7-96ac-c66776567954" x="277" y="201" width="338" height="12"/>
<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="dataset14" uuid="e6b89239-b76c-4747-a721-c9057ce4f06b">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="338">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="85" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="90" y="0" width="136" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="231" y="0" width="107" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="1d36bac8-8faf-4725-9463-6c456228951b" x="625" y="201" width="425" height="12"/>
<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="dataset15" uuid="09ca32e8-71c5-47b1-a77f-247b91aa36f7">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="425">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="202" y="0" width="98" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="303" y="0" width="118" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="68" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="72" y="0" width="125" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="9e196198-1f58-44d4-9c96-3716497b5573" x="33" y="215" width="240" height="12"/>
<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="dataset16" uuid="65d100a6-898f-4297-a716-a5ed7b1a33e2">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="240">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="102" y="0" width="135" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74195422-bdb4-4624-8b0a-2f08dec7d87f" x="5" y="0" width="89" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="12d8675b-dc5c-419c-a7ce-9c2d4ca6694a" x="277" y="215" width="338" height="12"/>
<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="dataset17" uuid="26c29d99-77c6-41ed-8870-09986645f4a2">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="338">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="85" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="90" y="0" width="136" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="231" y="0" width="107" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="dfab1ccc-72af-477f-8117-97e5644ab6dc" x="625" y="215" width="425" height="12"/>
<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="dataset18" uuid="6aece046-09a7-4a2d-b54a-70ef7dc74103">
<datasetParameter name="kd_propinsi1">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati21">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan1">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan1">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak1">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_awal1">
<datasetParameterExpression><![CDATA[$P{p_awal2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="p_akhir1">
<datasetParameterExpression><![CDATA[$P{p_akhir2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="425">
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="202" y="0" width="98" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="303" y="0" width="118" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="1" y="0" width="68" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_objek}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2214ac29-f3cc-4a0d-9f1e-a4ec3aed6465" x="72" y="0" width="125" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="31a96f04-cc50-4a2c-a6c2-4e93a8b64342" x="936" y="135" width="112" height="17"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMINAL]]></text>
</staticText>
<line>
<reportElement uuid="3d7c7e10-a9ac-499c-a1db-a72ede4b652a" x="0" y="106" width="1" height="134"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="06c80a81-8b92-4ba4-8dc0-b205924ee328" x="3" y="105" width="1050" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="a556ae16-9365-4f83-ba23-9d44c312f7d2" x="0" y="109" width="1053" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d87e3313-2b5d-43a4-b0bd-967da6e3f783" x="0" y="233" width="1053" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="2981a450-5f11-4988-812b-f19ddd5b156d" x="0" y="239" width="1053" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="584f0b1b-cae5-4952-a522-f355403a3aef" x="33" y="106" width="1" height="134"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="5ff36670-c062-4879-bb91-7c8115a1539f" x="131" y="106" width="1" height="133"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f0e1719c-003e-4b67-8377-1585341f04ab" x="274" y="106" width="1" height="134"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="8d7c8fc3-1837-4cc1-b4c0-3ecba76587a7" x="275" y="129" width="345" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4f17cdc2-8bdf-41bd-94b0-21a20c7ec94d" x="620" y="106" width="1" height="134"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="2f3ee650-61f5-4c4d-92b9-6f2aba515ee9" x="365" y="130" width="1" height="110"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="5a4132b6-6e57-45f3-b868-957823ae86df" x="505" y="130" width="1" height="109"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="8e34a804-114b-4db1-928e-93c400fe0e6f" x="1051" y="106" width="1" height="134"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="e283515a-1bf8-45c1-9116-eddc5e7c5339" x="621" y="129" width="431" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="b36dadcb-a6f2-43cb-a955-09a3e89da2ad" x="926" y="129" width="1" height="110"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="83eadd82-98fc-4e88-84c1-8db1815cd113" x="824" y="130" width="1" height="109"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="615616fc-be7e-490a-b7d1-a4e1bb71d3e1" x="696" y="130" width="1" height="110"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="45907aca-0497-44ba-9c05-788b9d9f77e7" x="0" y="152" width="1052" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="853960a1-d204-4766-b91f-d70b6e295c37" x="0" y="157" width="1052" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="95d1215f-7328-4350-9d92-3df9e480dbf2" x="734" y="258" width="133" height="24"/>
<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="dataset19" uuid="3f3ab1a3-2430-4032-a179-c84538fc688d">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="24" width="133">
<textField>
<reportElement uuid="ba70cec8-9224-46ea-93e5-9af91c0efd91" x="3" y="1" width="127" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kota_terbit} + " ,"]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="d7d731c9-439c-4b6b-9eff-2f565d5173ad" x="753" y="359" width="264" height="39"/>
<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="dataset20" uuid="95901a5b-5bd3-40d6-a73e-96be559b79ce">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="39" width="264">
<textField>
<reportElement uuid="449c785b-b3ad-449a-8183-85227dc8eb8b" x="10" y="18" width="254" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74444016-9d2c-40de-b839-279c481b78ed" x="10" y="0" width="254" height="17"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="6141f635-751b-42d7-af0a-09bdb11d7cc1" x="763" y="279" width="254" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KEPALA DINAS]]></text>
</staticText>
<componentElement>
<reportElement uuid="b218a17f-5d40-4080-be3a-5a689459bafd" x="870" y="258" width="172" height="24"/>
<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="dataset21" uuid="e9f17956-6def-42b9-9c04-10a2d14f93f4">
<datasetParameter name="tgl_now2">
<datasetParameterExpression><![CDATA[$P{tgl_now}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="24" width="172">
<textField>
<reportElement uuid="7ba1f735-a185-4a84-8b62-52ea8417305e" x="0" y="0" width="167" height="20"/>
<textElement textAlignment="Left">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{fmt_bln}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="9187b2ce-9f92-497f-99ef-8f0116a57a09" x="49" y="4" width="996" height="106"/>
<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="dataset22" uuid="48dde058-1611-4f5b-8fba-c1ef1541dabc">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="106" width="996">
<textField>
<reportElement uuid="2645e7aa-e233-4da9-a5dc-0e5964198af8" x="424" y="86" width="22" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="55836d95-a471-4fa7-9d0c-8e27bb02bccb" x="424" y="48" width="22" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a9d5de97-8790-4478-8efa-a49f3434ea47" x="472" y="60" width="223" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="05a63904-846b-4c90-8ee8-e06fb986b684" x="424" y="73" width="22" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5f0401b4-d740-4c31-b699-cacb58a14d19" x="472" y="86" width="223" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d8f497d1-6e9e-42d9-a950-b2f305be8568" x="424" y="60" width="22" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d49afb25-0058-4882-a578-cbdacc31fb63" x="472" y="48" width="223" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5892080f-aeb2-4618-b83a-c1080302b6ac" x="472" y="73" width="223" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="94487f4d-3906-4751-b62a-fc8f4799d780" x="450" y="86" width="17" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<staticText>
<reportElement uuid="8d892b3e-b234-478a-b068-bc37b44235a9" x="451" y="60" width="17" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<staticText>
<reportElement uuid="b2e39b60-8dd5-43cc-8911-a6ac5ba99c93" x="450" y="48" width="17" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<staticText>
<reportElement uuid="4bc03e00-c526-48c8-bdcf-8d23900526cc" x="450" y="73" width="17" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="1df4c095-5173-4b0b-8300-84361f3bd4f5" x="10" y="7" width="983" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA["LAPORAN PAJAK BUMI DAN BANGUNAN KECAMATAN "+$F{nm_kecamatan}+" KELURAHAN "+$F{nm_kelurahan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</summary>
</jasperReport>