|
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/../yii/../report/ |
| [ 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="KelurahanReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f8152524-c9a1-44a8-9958-3e825ad75350">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
<defaultValueExpression><![CDATA["C:\\xampp\\htdocs\\bhumie\\report\\"]]></defaultValueExpression>
</parameter>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="thn_spt_masal" class="java.lang.String"/>
<queryString>
<![CDATA[select b.kd_kantor, b.nm_kantor, c.kd_kanwil, c.nm_kanwil from pbb.ref_adm_kantor a, pbb.ref_kantor b, pbb.ref_kanwil c
where
a.kd_kanwil = c.kd_kanwil AND
a.kd_kantor = b.kd_kantor AND
a.kd_propinsi = $P{kd_propinsi} AND
a.kd_dati2 = $P{kd_dati2} AND
a.kd_kecamatan = $P{kd_kecamatan}]]>
</queryString>
<field name="kd_kantor" class="java.lang.String"/>
<field name="nm_kantor" class="java.lang.String"/>
<field name="kd_kanwil" class="java.lang.String"/>
<field name="nm_kanwil" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="63" splitType="Stretch">
<staticText>
<reportElement uuid="59aa8b8f-06bc-4889-a5a2-cd96bc2305d7" x="192" y="29" width="156" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[TABEL KELURAHAN]]></text>
</staticText>
</band>
</title>
<columnHeader>
<band height="280" splitType="Stretch">
<staticText>
<reportElement uuid="ca5d3340-7892-4e23-af30-622b429513fe" x="30" y="28" width="13" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="c79e4e75-8f4e-4fe2-89ef-90c8d1523f47" x="43" y="28" width="407" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kanwil}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="ca5d3340-7892-4e23-af30-622b429513fe" x="30" y="44" width="13" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="98048d2a-7f1b-4a08-b9c2-d22fea329005" x="43" y="44" width="407" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kantor}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="51cc836f-0a6e-4c65-853e-cb26466488c7" x="17" y="122" width="507" height="12"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-------------------------------------------------------------------------------------]]></text>
</staticText>
<staticText>
<reportElement uuid="51cc836f-0a6e-4c65-853e-cb26466488c7" x="16" y="154" width="507" height="12"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-------------------------------------------------------------------------------------]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="68" y="132" width="69" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KD SISTEP/]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="19" y="132" width="46" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KD KEL]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="146" y="131" width="69" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KD SEKTOR]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="68" y="142" width="69" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KD TP]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="222" y="130" width="133" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA KELURAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="222" y="144" width="159" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA TEMPAT PEMBAYARAN]]></text>
</staticText>
<staticText>
<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="459" y="131" width="62" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KODE POS]]></text>
</staticText>
<staticText>
<reportElement uuid="770b1a79-5146-44b6-a4bb-284ad26cbcf4" x="17" y="60" width="65" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PROPINSI ]]></text>
</staticText>
<staticText>
<reportElement uuid="3e04a991-7864-498b-aa99-4230ddc56cb3" x="17" y="76" width="65" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KAB/KODYA]]></text>
</staticText>
<staticText>
<reportElement uuid="c2ebd0b4-b79a-4329-8a6a-db54060e34ef" x="17" y="92" width="65" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KECAMATAN]]></text>
</staticText>
<textField>
<reportElement uuid="52135d16-9d9d-42c7-a76a-94589ad0abf6" x="17" y="29" width="13" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_kanwil}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f414a650-5a0a-4418-8868-2c8c2672aa7f" x="17" y="44" width="13" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_kantor}]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="bba46946-6f73-4c35-836e-1b089c4f04b8" x="82" y="60" width="200" height="100"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_1.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="0180f96a-024b-465f-bbd5-e51e2e9b7ac3" x="82" y="76" width="200" height="100"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_2.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="209ba300-76d8-4e12-8bfe-8380b7dbafca" x="82" y="92" width="200" height="100"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_3.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="f1b4d16d-fd58-43b3-b784-5cc9a4710964" x="19" y="166" width="502" height="100"/>
<subreportParameter name="KD_KANWIL">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="KD_KANTOR">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_spt_masal">
<subreportParameterExpression><![CDATA[$P{thn_spt_masal}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_4.jasper"]]></subreportExpression>
</subreport>
</band>
</columnHeader>
</jasperReport>