|
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/DataReferensi/ |
| [ 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="SKZntSismiop" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="42" bottomMargin="20" uuid="7dde52d8-fd21-4972-8006-a7f448087b14">
<property name="ireport.zoom" value="1.5"/>
<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"/>
<queryString>
<![CDATA[select b.nm_pegawai,b.nip, a.username,d.nm_jabatan from pbb.users a
join pbb.pegawai b
on a.nip=b.nip
join pbb.posisi_pegawai c
on b.nip=c.nip
join pbb.ref_jabatan d
on c.kd_jabatan = d.kd_jabatan]]>
</queryString>
<field name="nm_pegawai" class="java.lang.String"/>
<field name="nip" class="java.lang.String"/>
<field name="username" class="java.lang.String"/>
<field name="nm_jabatan" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="42" splitType="Stretch">
<staticText>
<reportElement uuid="982fd2c3-9b0e-4e07-98e2-697ff6f28438" x="0" y="14" width="555" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LAPORAN PEMAKAI/USER APLIKASI]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="42" splitType="Stretch">
<staticText>
<reportElement uuid="a8d4bcd4-82fb-455c-95d3-11818615090b" x="14" y="6" width="527" height="12"/>
<textElement verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="a8d4bcd4-82fb-455c-95d3-11818615090b" x="14" y="29" width="527" height="12"/>
<textElement verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="a6d293cc-cfa3-4239-bb02-3d228a23a994" x="19" y="15" width="80" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA PEGAWAI]]></text>
</staticText>
<staticText>
<reportElement uuid="a6d293cc-cfa3-4239-bb02-3d228a23a994" x="158" y="15" width="80" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NIP]]></text>
</staticText>
<staticText>
<reportElement uuid="a6d293cc-cfa3-4239-bb02-3d228a23a994" x="299" y="15" width="80" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[USERNAME]]></text>
</staticText>
<staticText>
<reportElement uuid="a6d293cc-cfa3-4239-bb02-3d228a23a994" x="414" y="15" width="80" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JABATAN]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="26" splitType="Stretch">
<textField>
<reportElement uuid="6a37129e-0a5a-44d2-8ae3-8bc18e3ae7f1" x="17" y="2" width="96" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6a37129e-0a5a-44d2-8ae3-8bc18e3ae7f1" x="158" y="2" width="102" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6a37129e-0a5a-44d2-8ae3-8bc18e3ae7f1" x="304" y="2" width="96" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{username}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6a37129e-0a5a-44d2-8ae3-8bc18e3ae7f1" x="419" y="2" width="96" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_jabatan}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="14">
<staticText>
<reportElement uuid="fc5ee52b-dcf9-40f2-888f-2c3326536858" x="14" y="0" width="527" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[========================================================================================]]></text>
</staticText>
</band>
</columnFooter>
</jasperReport>