<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.5.1  -->
<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="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="09f39661-4462-4d2f-8cf9-856ddc3e13d0">
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="438"/>
	<property name="ireport.y" value="0"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="lokal"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="0"/>
	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="1000"/>
	<parameter name="parameter" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="namars" class="java.lang.String"/>
	<parameter name="alamatrs" class="java.lang.String"/>
	<parameter name="kotars" class="java.lang.String"/>
	<parameter name="propinsirs" class="java.lang.String"/>
	<parameter name="kontakrs" class="java.lang.String"/>
	<parameter name="emailrs" class="java.lang.String"/>
	<parameter name="logo" class="java.io.InputStream"/>
	<parameter name="tanggal1" class="java.lang.String"/>
	<parameter name="tanggal2" class="java.lang.String"/>
	<parameter name="barang" class="java.lang.String"/>
	<queryString>
		<![CDATA[select detail_surat_pemesanan_medis.kode_brng,databarang.nama_brng,databarang.kode_sat,jenis.nama as namajenis,
kodesatuan.satuan,detail_surat_pemesanan_medis.jumlah,detail_surat_pemesanan_medis.total from surat_pemesanan_medis 
inner join datasuplier inner join pegawai  
 inner join detail_surat_pemesanan_medis inner join databarang 
inner join kodesatuan inner join jenis inner join industrifarmasi 
on detail_surat_pemesanan_medis.kode_brng=databarang.kode_brng 
and databarang.kode_sat=kodesatuan.kode_sat 
and surat_pemesanan_medis.no_pemesanan=detail_surat_pemesanan_medis.no_pemesanan 
and surat_pemesanan_medis.kode_suplier=datasuplier.kode_suplier 
and databarang.kode_industri=industrifarmasi.kode_industri 
and surat_pemesanan_medis.nip=pegawai.nik and databarang.kdjns=jenis.kdjns]]>
	</queryString>
	<field name="kode_brng" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="kode_brng"/>
		<property name="com.jaspersoft.studio.field.label" value="kode_brng"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="detail_surat_pemesanan_medis"/>
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nama_brng" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nama_brng"/>
		<property name="com.jaspersoft.studio.field.label" value="nama_brng"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="databarang"/>
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="kode_sat" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="kode_sat"/>
		<property name="com.jaspersoft.studio.field.label" value="kode_sat"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="databarang"/>
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="namajenis" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nama"/>
		<property name="com.jaspersoft.studio.field.label" value="namajenis"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="jenis"/>
	</field>
	<field name="satuan" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="satuan"/>
		<property name="com.jaspersoft.studio.field.label" value="satuan"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="kodesatuan"/>
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="jumlah" class="java.lang.Double">
		<property name="com.jaspersoft.studio.field.name" value="jumlah"/>
		<property name="com.jaspersoft.studio.field.label" value="jumlah"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="detail_surat_pemesanan_medis"/>
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="total" class="java.lang.Double">
		<property name="com.jaspersoft.studio.field.name" value="total"/>
		<property name="com.jaspersoft.studio.field.label" value="total"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="detail_surat_pemesanan_medis"/>
	</field>
	<variable name="total" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{total}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="84" splitType="Stretch">
			<textField>
				<reportElement x="0" y="49" width="555" height="18" uuid="276e1db2-a7f7-46f4-bf2f-b82c78bfd799"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="Tahoma" size="11" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA["Ringkasan Pemesanan Obat/Alkes/BHP Medis Periode "+$P{tanggal1}+" s.d. "+$P{tanggal2}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1" uuid="382cf3e0-db48-4cf2-bd89-6fbf774cc004"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement x="2" y="14" width="553" height="14" uuid="5c9dbeb7-703c-4c44-b102-2fa74528c819"/>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="9"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="2" y="35" width="553" height="14" uuid="275ac47b-b588-4a38-b939-f38dd41adc03"/>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="9"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="2" y="25" width="553" height="14" uuid="7c1edb41-bf73-41b0-9a13-67f88d814a8a"/>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="9"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{kontakrs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="2" y="0" width="553" height="17" uuid="d7751b36-4d9c-40c4-887e-42fa93a335d5"/>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="12"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{namars}]]></textFieldExpression>
			</textField>
			<image scaleImage="FillFrame" onErrorType="Blank">
				<reportElement x="0" y="2" width="48" height="45" uuid="69dc3268-634b-4d09-acd9-1affd9551086"/>
				<imageExpression><![CDATA[$P{logo}]]></imageExpression>
			</image>
			<line>
				<reportElement x="0" y="48" width="555" height="1" uuid="082c1f56-ed25-4bc3-8109-e49b9e7af4b8"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double"/>
				</graphicElement>
			</line>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="15" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="471" y="0" width="84" height="15" forecolor="#000000" backcolor="#F0F0DC" uuid="8c0b6e29-5e4d-429f-a8bb-e633ed2bff92"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="435" y="0" width="36" height="15" forecolor="#000000" backcolor="#F0F0DC" uuid="3b26dd2b-3bd1-419c-a6ce-5a9337554d50"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Jumlah]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="278" y="0" width="51" height="15" forecolor="#000000" backcolor="#F0F0DC" uuid="73314418-74aa-4bbc-8c8c-4c9728015728"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Satuan]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="328" y="0" width="107" height="15" forecolor="#000000" backcolor="#F0F0DC" uuid="fdd5f4ba-79bb-49e8-b4ff-5bfa6ae244cb"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Jenis]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="80" height="15" forecolor="#000000" backcolor="#F0F0DC" uuid="063e834f-d61e-4b6a-972e-96653af7dbf5"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Kode Barang]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="80" y="0" width="198" height="15" forecolor="#000000" backcolor="#F0F0DC" uuid="a61c8e94-86cf-4089-9a95-01a1e5f18229"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Nama Barang]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="14" width="555" height="1" uuid="5e9e2da9-2b5f-4d6d-8870-d2e0f0a57bf8"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="12" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="2" y="0" width="78" height="10" uuid="7416f23f-1603-434a-ba41-6cd25142d96b"/>
				<textElement>
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kode_brng}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="80" y="0" width="198" height="10" uuid="bf782998-ed90-4cea-912b-75dcf0a5ed0d"/>
				<textElement>
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nama_brng}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="278" y="0" width="50" height="10" uuid="d0368733-326d-4c78-90a0-b8ece2677959"/>
				<textElement>
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{satuan}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="329" y="0" width="106" height="10" uuid="3d8e395d-7c6f-4e60-ac73-9b397c82e18b"/>
				<textElement>
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{namajenis}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="435" y="0" width="36" height="10" uuid="9e269a23-9a2c-4edb-9fd7-709e99c8ce76"/>
				<textElement>
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{jumlah}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0">
				<reportElement positionType="Float" mode="Transparent" x="471" y="0" width="84" height="10" uuid="db6cd46c-f6ff-4739-a1db-d0313b774b2a"/>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement positionType="Float" x="0" y="11" width="555" height="1" uuid="2447a133-65a6-46cb-bdef-a420174d348c">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</line>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="26" splitType="Stretch">
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="41ec8638-0623-4288-9633-18ec89401ed4"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="edb61e89-26a6-4508-a907-bbf575a453f0"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="a2e4acaf-2db1-4fd5-9ac9-ffdaecc7c62e"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font fontName="Tahoma" size="8" isBold="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="0" width="555" height="1" uuid="892d70b9-67a2-44fb-9142-2fac52fffd96"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement x="0" y="23" width="555" height="1" uuid="fbf72801-cbcc-4f2f-b975-429320b41115"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
		</band>
	</pageFooter>
	<summary>
		<band height="20" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField isStretchWithOverflow="true" pattern="#,##0">
				<reportElement positionType="Float" mode="Transparent" x="400" y="1" width="155" height="10" uuid="3c445ffe-f4c9-4ff8-8b72-32134765f61a"/>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{total}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="80" y="1" width="64" height="10" uuid="0cf40061-fe60-43a1-8484-282d723fef89"/>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="8"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Total :]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
