|
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="SKJalanStandard_2" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="cde0a881-9a83-45a7-9de7-02acc82718d8">
<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="DEFA_VALUE" class="java.lang.Integer">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT KD_PROPINSI,
KD_DATI2, KD_KECAMATAN, KD_KELURAHAN,
NM_JLN_SEMENTARA, NM_JLN_STANDARD
FROM pbb.JALAN_STANDARD
WHERE
KD_PROPINSI = $P{kd_propinsi} AND
KD_DATI2 = $P{kd_dati2} AND
KD_KECAMATAN LIKE $P{kd_kecamatan} AND
KD_KELURAHAN LIKE $P{kd_kelurahan}]]>
</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="nm_jln_sementara" class="java.lang.String"/>
<field name="nm_jln_standard" class="java.lang.String"/>
<variable name="NOURUT" class="java.lang.Integer" resetType="None" calculation="Count">
<variableExpression><![CDATA[$V{NOURUT}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="21" splitType="Stretch">
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="-2" y="-2" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="-2" y="7" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="26" y="-1" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="26" y="7" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="272" y="-1" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="272" y="7" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="522" y="-1" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c459ce0f-77bd-43fa-b669-d9a90c342793" x="522" y="8" width="5" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="0a3a33d4-ac7c-4f3e-9ae3-50af30f4a164" x="44" y="1" width="197" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_jln_sementara}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8b1cbc52-8e9e-4a28-8411-400dd1caede1" x="293" y="1" width="190" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_jln_standard}==null?
"":$F{nm_jln_standard}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8de996ac-e233-4665-acb1-cfc2661b9bf5" x="3" y="1" width="19" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{NOURUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>