|
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/SKKepalaDaerah/ |
| [ 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="SKJalanStandard" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="dd42d7b3-47c1-481a-b957-044f56e8fe04">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<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="kd_kelurahan" class="java.lang.String"/>
<parameter name="tahun_pajak" class="java.lang.String"/>
<parameter name="no_keputusan" class="java.lang.String"/>
<parameter name="tgl_keputusan" class="java.lang.String"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select a.kd_propinsi, a.nm_propinsi, b.kd_dati2, b.nm_dati2, c.kd_kecamatan, c.nm_kecamatan, d.kd_kelurahan, d.nm_kelurahan
from pbb.ref_propinsi a, pbb.ref_dati2 b, pbb.ref_kecamatan c, pbb.ref_kelurahan d
where
b.kd_propinsi= a.kd_propinsi and
c.kd_dati2= b.kd_dati2 and
d.kd_kecamatan= c.kd_kecamatan and
a.kd_propinsi=$P{kd_propinsi} and
b.kd_dati2=$P{kd_dati2} and
c.kd_kecamatan=$P{kd_kecamatan} and
d.kd_kelurahan=$P{kd_kelurahan};]]>
</queryString>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="nm_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="nm_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="108" splitType="Stretch">
<staticText>
<reportElement uuid="1f807a87-d013-41b8-86d8-fe4d0bf5e8ee" x="207" y="4" width="132" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TABEL JALAN STANDAR]]></text>
</staticText>
<staticText>
<reportElement uuid="19ec7529-6be7-4ee0-be64-1b85867e8be5" x="302" y="39" width="68" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Propinsi : ]]></text>
</staticText>
<staticText>
<reportElement uuid="22640efd-21ae-471b-82f9-89bea948de9f" x="389" y="39" width="13" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="b5b17b0d-a811-43cb-bc3a-f1aeb1ea9e5f" x="401" y="39" width="114" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_propinsi}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="19ec7529-6be7-4ee0-be64-1b85867e8be5" x="302" y="53" width="68" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kota/Kab :]]></text>
</staticText>
<textField>
<reportElement uuid="9f0b8add-2527-44be-a9ee-38f93fa0d711" x="369" y="53" width="21" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_dati2}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="22640efd-21ae-471b-82f9-89bea948de9f" x="389" y="53" width="13" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<staticText>
<reportElement uuid="19ec7529-6be7-4ee0-be64-1b85867e8be5" x="302" y="67" width="68" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kecamatan :]]></text>
</staticText>
<textField>
<reportElement uuid="014b4f5c-c7f4-4459-9dea-c7f8b74a52f9" x="370" y="67" width="20" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_kecamatan}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="22640efd-21ae-471b-82f9-89bea948de9f" x="389" y="67" width="13" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="2a864fe6-2661-432d-b40e-a0cb90b51908" x="401" y="67" width="125" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="19ec7529-6be7-4ee0-be64-1b85867e8be5" x="302" y="81" width="68" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kelurahan :]]></text>
</staticText>
<staticText>
<reportElement uuid="22640efd-21ae-471b-82f9-89bea948de9f" x="389" y="81" width="13" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="dc1ed86b-c260-4fd2-82e3-543ea8386a89" x="401" y="81" width="114" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6a33b75f-e080-49aa-80a0-83910f46ce42" x="369" y="39" width="21" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cbfc78d4-ad64-417d-906a-7620f211f0f1" x="369" y="81" width="21" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_kelurahan}]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="c36a314e-48d0-42fc-8442-0440f9ffe607" x="17" y="39" width="190" height="56"/>
<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} + "SKJalanStandard_1.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="61c8eee2-0797-497d-91a1-dd3470d26442" x="402" y="53" width="113" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ae43138f-1ea2-408c-82da-caef3b2c8a1b" x="522" y="4" width="28" height="18"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="02b1335d-7aa6-41ec-b8cc-aa93e3a33524" x="497" y="4" width="25" height="17"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Hal]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="46" splitType="Stretch">
<staticText>
<reportElement uuid="51cc836f-0a6e-4c65-853e-cb26466488c7" x="11" y="8" width="530" height="12"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="9" y="16" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="51cc836f-0a6e-4c65-853e-cb26466488c7" x="11" y="34" width="530" height="12"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="9" y="25" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="50254586-1c47-499b-bd12-021e51107221" x="15" y="20" width="21" height="18"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[No]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="37" y="16" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="37" y="25" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="50254586-1c47-499b-bd12-021e51107221" x="55" y="20" width="162" height="18"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Jalan Asal]]></text>
</staticText>
<staticText>
<reportElement uuid="50254586-1c47-499b-bd12-021e51107221" x="304" y="20" width="162" height="18"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Jalan Pemutakhiran]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="283" y="16" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="283" y="25" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="534" y="16" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9531252-203d-4d54-869f-d88130689755" x="534" y="25" width="5" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="37" splitType="Stretch">
<subreport>
<reportElement uuid="35bfbbdb-e78e-4ad4-9360-812b3edd9b4d" x="11" y="0" width="530" height="36"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="DEFA_VALUE"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKJalanStandard_2.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
<summary>
<band height="171" splitType="Stretch">
<staticText>
<reportElement uuid="511f88b5-35cf-4405-8e0e-9cb4717c8f58" x="11" y="-1" width="546" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[========================================================================================]]></text>
</staticText>
<subreport>
<reportElement uuid="b35c7d37-4c65-4b3a-a113-efc28d556210" x="19" y="31" width="520" height="129"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKJalanStandard_3.jasper"]]></subreportExpression>
</subreport>
</band>
</summary>
</jasperReport>