|
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/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="SKPemantauanOP_1" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="8e2acbc9-9d8c-4da0-9e1f-d64220ae7b6c">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="tahun_pajak" class="java.lang.String"/>
<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="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="DEFA_VALUE" class="java.lang.Integer">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select distinct
c.kd_kelurahan,c.nm_kelurahan,
a.jalan_op, b.kd_znt,d.nm_propinsi,
e.nm_dati2, f.nm_kecamatan
from pbb.dat_objek_pajak a,
pbb.dat_op_bumi b,
pbb.ref_kelurahan c,
pbb.ref_propinsi d,
pbb.ref_dati2 e,
pbb.ref_kecamatan f,
pbb.SPPT G
where a.kd_propinsi = d.kd_propinsi and
a.kd_propinsi = e.kd_propinsi and
a.kd_dati2 = e.kd_dati2 and
a.kd_propinsi = f.kd_propinsi and
a.kd_dati2 = f.kd_dati2 and
a.kd_kecamatan = f.kd_kecamatan and
a.kd_propinsi = c.kd_propinsi and
a.kd_dati2 = c.kd_dati2 and
a.kd_kecamatan = c.kd_kecamatan and
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.kd_propinsi = G.kd_propinsi and
a.kd_dati2 = G.kd_dati2 and
a.kd_kecamatan = G.kd_kecamatan and
a.kd_kelurahan = G.kd_kelurahan and
a.kd_blok = G.kd_blok and
a.no_urut = G.no_urut and
a.kd_jns_op = G.kd_jns_op and
G.THN_PAJAK_SPPT = $P{tahun_pajak} AND
b.kd_propinsi = c.kd_propinsi and
b.kd_dati2 = c.kd_dati2 and
b.kd_kecamatan = c.kd_kecamatan and
b.kd_kelurahan = c.kd_kelurahan and
c.kd_propinsi = $P{kd_propinsi} and
c.kd_dati2 = $P{kd_dati2} and
c.kd_kecamatan like $P{kd_kecamatan} and
c.kd_kelurahan like $P{kd_kelurahan}
ORDER BY b.kd_znt, a.jalan_op]]>
</queryString>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="jalan_op" class="java.lang.String"/>
<field name="kd_znt" 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"/>
<variable name="no_urut" class="java.lang.Integer" resetType="None" calculation="Count">
<variableExpression><![CDATA[$V{no_urut}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="22" splitType="Stretch">
<textField>
<reportElement uuid="a2abef43-50ac-4de6-bc8c-26c32b98e81c" x="52" y="0" width="109" height="17"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jalan_op}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="27" y="0" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="27" y="9" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="192" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="192" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="240" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="122588be-0ece-4b38-93ed-7ea979838bf6" x="203" y="1" width="31" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_znt}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="240" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="756" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="756" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<subreport>
<reportElement uuid="2b9de7fe-df94-4c45-85e3-c7ec90941666" x="326" y="0" width="373" height="17"/>
<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>
<subreportParameter name="jalan_op">
<subreportParameterExpression><![CDATA[$F{jalan_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pajak_sppt">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_znt">
<subreportParameterExpression><![CDATA[$F{kd_znt}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKPemantauanOP_3.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="-2" y="0" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="-2" y="9" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="dfc28b84-d631-4875-99f6-37f5afcb25d1" x="5" y="1" width="20" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{no_urut}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="b1b49e14-99a3-452b-8ff7-a808f9495144" x="253" y="1" width="70" height="16"/>
<subreportParameter name="jalan_op">
<subreportParameterExpression><![CDATA[$F{jalan_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_znt">
<subreportParameterExpression><![CDATA[$F{kd_znt}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKPemantauanOP_2.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
</jasperReport>