<?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 detailpesan.kode_brng,databarang.nama_brng,databarang.kode_sat,kodesatuan.satuan,
jenis.nama as namajenis,sum(detailpesan.jumlah2) as jumlah,sum(detailpesan.total) as total 
from pemesanan inner join datasuplier inner join petugas inner join bangsal  
 inner join detailpesan inner join databarang inner join kodesatuan 
inner join jenis inner join industrifarmasi 
on detailpesan.kode_brng=databarang.kode_brng 
 and databarang.kode_sat=kodesatuan.kode_sat
and pemesanan.kd_bangsal=bangsal.kd_bangsal 
and pemesanan.no_faktur=detailpesan.no_faktur 
and pemesanan.kode_suplier=datasuplier.kode_suplier
and databarang.kode_industri=industrifarmasi.kode_industri 
 and pemesanan.nip=petugas.nip 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="detailpesan"/>
		<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="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="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="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 Penerimaan 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>
