|
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/KeteranganMasal/ |
| [ 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="afifTest_subreport1" language="groovy" pageWidth="440" pageHeight="70" columnWidth="440" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="d3d7a1c7-d02a-40c1-ac5c-588c752bdfd0">
<property name="ireport.zoom" value="1.3310000000000013"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT a.nm_kantor, a.al_kantor, a.kota_terbit, a.no_faksimili, a.no_telpon, b.nm_kanwil, b.al_kanwil, b.kota_terbit_kanwil, b.no_faksimili no_faksimili_kanwil, b.no_telpon no_telpon_kanwil
FROM pbb.ref_kantor AS a
INNER JOIN pbb.ref_kanwil AS b ON a.kd_kanwil = b.kd_kanwil
WHERE a.kd_kanwil = $P{kd_kanwil}
AND a.kd_kantor = $P{kd_kantor};]]>
</queryString>
<field name="nm_kantor" class="java.lang.String"/>
<field name="al_kantor" class="java.lang.String"/>
<field name="kota_terbit" class="java.lang.String"/>
<field name="no_faksimili" class="java.lang.String"/>
<field name="no_telpon" class="java.lang.String"/>
<field name="nm_kanwil" class="java.lang.String"/>
<field name="al_kanwil" class="java.lang.String"/>
<field name="kota_terbit_kanwil" class="java.lang.String"/>
<field name="no_faksimili_kanwil" class="java.lang.String"/>
<field name="no_telpon_kanwil" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="49" splitType="Stretch">
<textField>
<reportElement uuid="9dd18a27-a094-4c4a-a8a2-8a1d2d64e76d" x="124" y="3" width="173" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kanwil}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9c152d64-7152-43b9-b5d3-a2253e44ff36" x="40" y="26" width="141" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{al_kanwil}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4a979b52-7e1d-44fd-87c2-29724031ec45" x="335" y="26" width="91" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_faksimili_kanwil}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="f9ec7309-cc4c-449b-bdbc-2fccb51c7679" x="0" y="26" width="40" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat]]></text>
</staticText>
<staticText>
<reportElement uuid="4683f4ed-4356-40a2-9d46-85531f05fa30" x="181" y="26" width="38" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[, TELP]]></text>
</staticText>
<textField>
<reportElement uuid="295b05d0-65e7-43b3-a0c5-75ccec9dcad9" x="219" y="26" width="96" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_telpon_kanwil}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="233f6e66-ca0a-4f27-953c-c76125069b51" x="315" y="26" width="20" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[FAX]]></text>
</staticText>
<textField>
<reportElement uuid="9dd18a27-a094-4c4a-a8a2-8a1d2d64e76d" x="124" y="14" width="173" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kantor}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
</jasperReport>