|
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/report/DHR/ |
| [ 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="report1" language="groovy" pageWidth="623" pageHeight="595" orientation="Landscape" columnWidth="583" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9084658a-b077-4967-9a48-3e0421767ca9">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="211"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="8d859f92-0ed1-403c-8909-754f6c3effcb">
<parameter name="thn_pajak" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select /*+ parallel(sppt,8) */
kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt ,thn_pajak_sppt Tahun_Pajak,
sum(pbb_terhutang_sppt) PBB_Terhutang,
sum(pbb_yg_harus_dibayar_sppt) PBB_Hrs_Dibayar,
count(kd_propinsi) Jml_SPPT
from sppt
where thn_pajak_sppt=$P{thn_pajak} and kd_propinsi=$P{kd_propinsi} and kd_kecamatan=$P{kd_kecamatan} and kd_kelurahan=$P{kd_kelurahan}
group by kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt]]>
</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="thn_pajak_sppt" class="java.lang.String"/>
<field name="tahun_pajak" class="java.lang.String"/>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="pbb_hrs_dibayar" class="java.math.BigDecimal"/>
<field name="jml_sppt" class="java.lang.Long"/>
</subDataset>
<subDataset name="dataset2" uuid="ca14a1dd-b624-499e-8f07-def8470de16e">
<parameter name="thn_pajak" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt ,
count(kd_propinsi) Jml_SPPT_Lunas
from sppt
where status_pembayaran_sppt = '1' and
thn_pajak_sppt=$P{thn_pajak} and kd_propinsi=$P{kd_propinsi} and kd_kecamatan=$P{kd_kecamatan} and kd_kelurahan=$P{kd_kelurahan}
group by kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt]]>
</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="thn_pajak_sppt" class="java.lang.String"/>
<field name="jml_sppt_lunas" class="java.lang.Long"/>
</subDataset>
<subDataset name="dataset3" uuid="8a1b2b6d-5c93-4f4e-b8cd-15fa053de438">
<parameter name="thn_pajak" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<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 kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt ,
count(kd_propinsi) Jml_SPPT_Blm_Lunas
from sppt
where status_pembayaran_sppt = '0' and
thn_pajak_sppt=$P{thn_pajak} and kd_kecamatan = $P{kd_kecamatan} and kd_propinsi=$P{kd_propinsi} and kd_kelurahan = $P{kd_kelurahan} and kd_dati2 = $P{kd_dati2}
group by kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt]]>
</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="thn_pajak_sppt" class="java.lang.String"/>
<field name="jml_sppt_blm_lunas" class="java.lang.Long"/>
</subDataset>
<subDataset name="dataset4" uuid="a44c23d5-b339-478a-a257-f5ef8950d0a7">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt ,
count(kd_propinsi) Jml_SPPT_Jth_Tempo
from sppt
where status_pembayaran_sppt = '0' and
tgl_jatuh_tempo_sppt < now() and thn_pajak_sppt=$P{thn_pajak} and kd_kecamatan = $P{kd_kecamatan} and kd_propinsi=$P{kd_propinsi} and kd_kelurahan = $P{kd_kelurahan} and kd_dati2 = $P{kd_dati2}
group by kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt]]>
</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="thn_pajak_sppt" class="java.lang.String"/>
<field name="jml_sppt_jth_tempo" class="java.lang.Long"/>
</subDataset>
<subDataset name="dataset5" uuid="0fa86e06-1e78-4c99-8bdf-66af04c4f4d0">
<parameter name="thn_pajak" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt ,
sum(jml_sppt_yg_dibayar) Jml_SPPT_Dibayar
from pembayaran_sppt
where thn_pajak_sppt=$P{thn_pajak} and kd_kecamatan = $P{kd_kecamatan} and kd_propinsi=$P{kd_propinsi} and kd_kelurahan = $P{kd_kelurahan} and kd_dati2 = $P{kd_dati2}
group by kd_propinsi,kd_dati2,
kd_kecamatan,kd_kelurahan,thn_pajak_sppt]]>
</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="thn_pajak_sppt" class="java.lang.String"/>
<field name="jml_sppt_dibayar" 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" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT DISTINCT
a.kd_propinsi ,a.kd_dati2 ,a.kd_kecamatan ,a.kd_kelurahan,a.kd_propinsi||'.'||a.kd_dati2||'.'||
a.kd_kecamatan||'.'||a.kd_kelurahan Kode,
(a.kd_kecamatan ||' - '||(select nm_kecamatan from ref_kecamatan where kd_kecamatan = a.kd_kecamatan)) as Kecamatan,
(a.kd_dati2 ||' - '||(select nm_dati2 from ref_dati2 where kd_dati2= a.kd_dati2)) as Dati2,
date_part('year', Now()) as tahun,
b.nm_kelurahan Kelurahan,
a.kd_propinsi ||' - '|| c.nm_propinsi as Propinsi,
count(a.kd_propinsi) Jml_OP,
sum(a.total_luas_bumi) L_Bumi,
sum(a.total_luas_bng) L_Bng,
sum(a.njop_bumi) NJOP_Bumi,
sum(a.njop_bng) NJOP_Bng
from dat_objek_pajak a,
ref_kelurahan b,
ref_propinsi c
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_propinsi = $P{kd_propinsi} and
a.kd_dati2 =$P{kd_dati2} and
a.kd_kecamatan =$P{kd_kecamatan} and
b.kd_kelurahan = $P{kd_kelurahan}
group by a.kd_propinsi,a.kd_dati2,
a.kd_kecamatan,a.kd_kelurahan,
b.nm_kelurahan,
c.nm_propinsi]]>
</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="kode" class="java.lang.String"/>
<field name="kecamatan" class="java.lang.String"/>
<field name="dati2" class="java.lang.String"/>
<field name="tahun" class="java.lang.Double"/>
<field name="kelurahan" class="java.lang.String"/>
<field name="propinsi" class="java.lang.String"/>
<field name="jml_op" class="java.lang.Long"/>
<field name="l_bumi" class="java.math.BigDecimal"/>
<field name="l_bng" class="java.math.BigDecimal"/>
<field name="njop_bumi" class="java.math.BigDecimal"/>
<field name="njop_bng" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="52" splitType="Stretch">
<staticText>
<reportElement uuid="25e5fdb9-40b2-4555-a648-68f80552ed67" x="229" y="21" width="163" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[REKAPITULASI OBJECT PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="09ef5159-1758-4cce-bcd9-78b8b9e790d6" x="232" y="35" width="94" height="17"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[PER 30 NOVEMBER]]></text>
</staticText>
<textField>
<reportElement uuid="455a1ab2-0827-4ba6-903a-282bec5a3eaf" x="332" y="35" width="41" height="17"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{tahun}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height="50" splitType="Stretch">
<staticText>
<reportElement uuid="214e2f8e-9ae1-436e-a135-9771f89a872c" x="0" y="8" width="51" height="19"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[PROPINSI ]]></text>
</staticText>
<staticText>
<reportElement uuid="567ff3ef-2b88-4269-b670-787c4ecd9a04" x="0" y="21" width="51" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[KOTA/KAB ]]></text>
</staticText>
<staticText>
<reportElement uuid="bec91fbe-cb5e-41fb-9b1e-1453a6d0dfbd" x="0" y="35" width="61" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[KECAMATAN ]]></text>
</staticText>
<staticText>
<reportElement uuid="af53f5e8-b523-4690-b992-022e92ca4c01" x="61" y="8" width="16" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<textField>
<reportElement uuid="ed582cbc-166b-40eb-bb85-d3757b2ee33e" x="79" y="8" width="113" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{propinsi}]]></textFieldExpression>
</textField>
<elementGroup/>
<textField>
<reportElement uuid="0d4b57a9-1984-4251-b0b6-665498103964" x="80" y="34" width="112" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="102ce63a-a6c2-4d0e-96fc-b00103a846d4" x="80" y="21" width="112" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{dati2}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="19d0af03-3693-48f6-995f-910fff5618b6" x="61" y="22" width="16" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement uuid="3a6e787e-b3a2-44fd-a68c-0ca5732ad294" x="61" y="34" width="16" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="58" splitType="Stretch">
<staticText>
<reportElement uuid="e036e3f2-df97-4056-8247-4eed3b24d017" x="0" y="12" width="61" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[NO. KODE / KELURAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="c91b1325-c809-42d7-bb9c-f2ed658ade46" x="61" y="12" width="58" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[JML OP /
JML BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="990af0da-02aa-492c-b013-6840e8395d6d" x="109" y="11" width="55" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[L.BUMI / L.BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="86304eff-0377-423c-b0c3-42b17568a95b" x="151" y="12" width="80" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[NJOB BUMI /
NJOP BANGUNAN]]></text>
</staticText>
<staticText>
<reportElement uuid="d57a634f-7eb3-4c4e-b1fe-b5cdf6688c40" x="230" y="12" width="65" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[THN.PJK /
JML SPPT ]]></text>
</staticText>
<staticText>
<reportElement uuid="d0efc2c6-84aa-4762-9166-173fa9d320f3" x="286" y="12" width="93" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[PBB TERHUTANG / PBB HRS DIBAYAR]]></text>
</staticText>
<staticText>
<reportElement uuid="9645ef1f-eb78-4099-b320-828a5cd9ec33" x="381" y="12" width="45" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[LUNAS / BELUM]]></text>
</staticText>
<staticText>
<reportElement uuid="a74086f4-ef23-4f1b-9ca8-332cafb37aab" x="428" y="12" width="63" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[SPPT TLH JATUH TEMPO]]></text>
</staticText>
<staticText>
<reportElement uuid="3d9dab7f-af9f-44bd-9504-a73d98876896" x="483" y="12" width="89" height="25"/>
<textElement>
<font fontName="Courier New" size="10" isBold="false"/>
</textElement>
<text><![CDATA[PEMBAYARAN SPPT / TUNGGAKAN SPPT]]></text>
</staticText>
<line>
<reportElement uuid="1ccab209-c984-4d98-8b96-7d23f18040a9" x="0" y="4" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="961d3cac-9c55-488c-98e2-4da03fa58444" x="0" y="6" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="1ecfa0ba-bf94-4298-830d-298f00a9585c" x="0" y="40" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="88f4a315-380e-4cd4-9c2b-bd4da7bad620" x="0" y="42" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</columnHeader>
<detail>
<band height="40" splitType="Stretch">
<textField pattern="#,##0">
<reportElement uuid="f2abe46f-4f08-4c25-b283-c8d764ce2f8e" x="150" y="0" width="80" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="527a42c6-e685-4cf9-83ec-7792c9af81ee" x="108" y="0" width="41" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{l_bumi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="951157d9-58f3-4aef-a952-2836f70788f9" x="108" y="13" width="41" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{l_bng}]]></textFieldExpression>
</textField>
<textField pattern="#,##0">
<reportElement uuid="d5e7aa6c-1edc-44ae-9413-0f5edaa150a1" x="150" y="13" width="80" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d072f792-7c66-452b-be8a-fb7852ced6de" x="0" y="0" width="61" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{kode}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="40bff54e-4d17-48a4-999c-e5f6326cb151" x="61" y="0" width="45" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_op}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="0249885f-4022-425c-a6cf-e9254226b3a7" x="230" y="0" width="144" height="40"/>
<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="c2dcfe03-4d1a-4cd8-9ed1-98e34b47282c">
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="40" width="144">
<textField>
<reportElement uuid="8d4d6614-bea1-4549-a046-554cdfd187e0" x="0" y="0" width="47" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="062095a5-67c7-4426-ae1c-6c540553f3d8" x="41" y="0" width="80" height="0"/>
<textElement/>
<textFieldExpression><![CDATA[$F{pbb_terhutang}]]></textFieldExpression>
</textField>
<textField pattern="#,##0">
<reportElement uuid="f5e18682-a9e0-415f-bd62-3efcf5c20b29" x="56" y="14" width="78" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_hrs_dibayar}]]></textFieldExpression>
</textField>
<textField pattern="#,##0" isBlankWhenNull="true">
<reportElement uuid="4ce66c4c-f785-4727-8228-0bb386d1f737" x="56" y="1" width="78" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_terhutang}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="51079096-0955-4c2d-a918-18b08522f723" x="0" y="13" width="47" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="506c02e4-b346-4a34-8bb2-32017ff52f99" x="382" y="1" width="45" height="20"/>
<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="67adc165-9baf-4cb7-bb52-7c0f44bdb9b0">
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="20" width="45">
<textField>
<reportElement uuid="fd765a78-c7f4-4434-b3e0-ceeda85e50a2" x="0" y="0" width="44" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_lunas}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="34e51c9a-52f1-46bb-a25b-97cccd295e59" x="380" y="13" width="45" height="18"/>
<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="00dfc727-a163-46ee-9bd2-b96cee04a827">
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="18" width="45">
<textField>
<reportElement uuid="0322df15-5e35-47fc-8018-4f0fc3ee01d6" x="2" y="2" width="38" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_blm_lunas}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="36eb24ea-840a-45a9-9141-530c86f199fc" mode="Opaque" x="419" y="0" width="63" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
<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="bc6ff54c-3edc-49de-9a97-c9ade1f7d62c">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="15" width="63">
<textField>
<reportElement uuid="7c557ff6-b493-42ef-957d-cd3e7b082e56" x="8" y="1" width="47" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_jth_tempo}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="b6f5c2c0-d7bf-46d9-b99c-0c0e37577fac" x="483" y="0" width="90" height="14"/>
<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="8c8b6a37-0a6d-422b-8592-5ff9d8aaf3a9">
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="14" width="90">
<textField pattern="#,##0">
<reportElement uuid="70a77d4a-2672-4996-8a51-b8cd333ef640" x="1" y="1" width="88" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_dibayar}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<textField>
<reportElement uuid="c6e8b092-66d8-4054-ae98-a2a3f33a0902" x="1" y="12" width="61" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kelurahan}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="76" splitType="Stretch">
<staticText>
<reportElement uuid="bd70cca7-cd37-47bd-9029-871ee58b61ae" x="4" y="20" width="31" height="20"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[TOTAL]]></text>
</staticText>
<line>
<reportElement uuid="c5d6ea5e-8ccf-4615-9b9d-260eddfb4406" x="0" y="47" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="2952b4f2-3494-4299-9432-46d3263f28ce" x="0" y="49" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="17ec9f36-fe1a-4337-9cf5-98c3f8aa06f9" x="0" y="13" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="22b3190e-eaff-4191-a06e-2f6b5f0a27e8" x="0" y="15" width="572" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField pattern="#,##0">
<reportElement uuid="652dfc83-1017-4f9c-9c85-c91aa1957030" x="151" y="19" width="80" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="44d55688-2cb2-44e1-b9be-247bc4e336c1" x="62" y="19" width="45" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_op}]]></textFieldExpression>
</textField>
<textField pattern="#,##0">
<reportElement uuid="2dcb2c79-6e5b-429f-97f5-291623c3fe54" x="151" y="32" width="80" height="20"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6c25585b-6c7b-46eb-93ea-d4d8732dff94" x="107" y="32" width="41" height="20"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{l_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c7e91c67-bee9-49bc-9e5d-f149657399c8" x="106" y="20" width="41" height="20"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{l_bumi}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="f3f1c9de-d0d4-44b6-b66c-13bb981a80cc" x="378" y="33" width="45" height="18"/>
<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="652befac-0957-4421-bd72-593f19f4722d">
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="18" width="45">
<textField>
<reportElement uuid="0a0a8fd4-f674-4f8e-8740-d16542dbd469" x="3" y="2" width="38" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_blm_lunas}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="d9a8dd6f-1cae-477d-9603-9b33edc87152" x="380" y="18" width="45" height="20"/>
<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="8aa6296d-63d5-4b52-9a71-8bb282641e20">
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="20" width="45">
<textField>
<reportElement uuid="c4a5d420-ab90-4a42-b571-4550a1e97a1a" x="1" y="3" width="44" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_lunas}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="3dd401e6-f071-418f-bf4e-970eb8769024" mode="Opaque" x="421" y="20" width="63" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
<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="0b15e403-c4be-4b23-a677-b87c8389a9ec">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="15" width="63">
<textField>
<reportElement uuid="cf912242-becf-49b4-8b9b-bb7597b0aea0" x="6" y="2" width="47" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_jth_tempo}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="680feecf-a572-4521-88ab-4fad68920cdc" x="229" y="16" width="144" height="40"/>
<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="9dc2e680-b8bd-42df-8b94-3ff6a43c89bb">
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="40" width="144">
<textField>
<reportElement uuid="347060a8-599c-4990-9106-bae7dfa2bf7e" x="0" y="3" width="47" height="20"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="02df45a0-8ea4-4cf3-aebe-9a247012e40f" x="41" y="0" width="80" height="0"/>
<textElement/>
<textFieldExpression><![CDATA[$F{pbb_terhutang}]]></textFieldExpression>
</textField>
<textField pattern="#,##0">
<reportElement uuid="c9d873cb-2575-4d91-bf21-4ac7786e1e15" x="56" y="17" width="78" height="13"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_hrs_dibayar}]]></textFieldExpression>
</textField>
<textField pattern="#,##0" isBlankWhenNull="true">
<reportElement uuid="e271c000-94db-4d17-9fc6-c396e1051f5a" x="56" y="4" width="78" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_terhutang}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="97f6c841-4acd-4419-91e2-c1706bd1d64d" x="0" y="16" width="47" height="20"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="9248159c-bfdb-4a25-94d1-26db01806419" x="484" y="19" width="90" height="19"/>
<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="879240f0-a32a-404a-a1a3-54d75639bd2d">
<datasetParameter name="thn_pajak">
<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="19" width="90">
<textField pattern="#,##0">
<reportElement uuid="4995ba03-afcc-4cbd-ab8d-20d5525c6699" x="0" y="3" width="74" height="12"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt_dibayar}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>