src/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml
author Asier Lostalé <asier.lostale@openbravo.com>
Mon, 05 May 2008 06:59:24 +0000
changeset 799 fef2c5e2feb7
parent 726 dac2a1486bd3
child 1605 8a0fe0193bef
permissions -rw-r--r--
Merged cleanup branch (r3931) with trunk
<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
		 name="RptMA_ProcessPlan"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Portrait"
		 pageWidth="595"
		 pageHeight="842"
		 columnWidth="535"
		 columnSpacing="0"
		 leftMargin="30"
		 rightMargin="30"
		 topMargin="20"
		 bottomMargin="20"
		 whenNoDataType="NoPages"
		 isTitleNewPage="false"
		 isSummaryNewPage="false">
	<property name="ireport.scriptlethandling" value="0" />
	<property name="ireport.encoding" value="UTF-8" />
	<import value="java.util.*" />
	<import value="net.sf.jasperreports.engine.*" />
	<import value="net.sf.jasperreports.engine.data.*" />

	<style 
		name="default"
		isDefault="false"
		vAlign="Middle"
		fontName="Bitstream Vera Sans"
		fontSize="9"
	/>
	<style 
		name="Report_Title"
		isDefault="false"
		leftPadding="5"
		fontName="Bitstream Vera Sans"
		fontSize="18"
	/>
	<style 
		name="Report_Subtitle"
		isDefault="false"
		forecolor="#555555"
		leftPadding="5"
		fontName="Bitstream Vera Sans"
		fontSize="14"
	/>
	<style 
		name="Total_Field"
		isDefault="false"
		mode="Opaque"
		forecolor="#000000"
		backcolor="#CCCCCC"
		vAlign="Middle"
		leftPadding="5"
	/>
	<style 
		name="Detail_Header"
		isDefault="false"
		mode="Opaque"
		forecolor="#FFFFFF"
		backcolor="#555555"
		vAlign="Middle"
		leftBorder="1Point"
		leftBorderColor="#FFFFFF"
		leftPadding="5"
		rightBorder="1Point"
		rightBorderColor="#FFFFFF"
	/>
	<style 
		name="GroupHeader_DarkGray"
		isDefault="false"
		mode="Opaque"
		forecolor="#FFFFFF"
		backcolor="#555555"
		vAlign="Middle"
		leftPadding="5"
		fontName="Bitstream Vera Sans"
		fontSize="14"
	/>
	<style 
		name="GroupHeader_Gray"
		isDefault="false"
		mode="Opaque"
		backcolor="#999999"
	/>
	<style 
		name="Detail_Line"
		isDefault="false"
	>

		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{SECUENCIA_COUNT}.intValue()%2==1)]]></conditionExpression>
			<style 
				name="Detail_Line"
				isDefault="false"
				mode="Opaque"
				backcolor="#CCCCCC"
			/>
		</conditionalStyle>
	</style>
	<style 
		name="Total_Gray"
		isDefault="false"
		mode="Opaque"
		forecolor="#000000"
		backcolor="#CCCCCC"
	/>

	<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
	</parameter>
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
	</parameter>
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
		<defaultValueExpression ><![CDATA["(0)"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
		<defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
	<queryString><![CDATA[SELECT pp.NAME as processplan, pp.CONVERSIONRATE as ratio, pp.SECONDARYUNIT as secud, v.DATEFROM as desde, 
              v.DATETO as hasta, s.NAME as secuencia, s.VALUE as sec, s.DESCRIPTION, pr.NAME as proceso,
              s.SEQNO, (CASE s.GROUPUSE WHEN 'Y' THEN 'SI' ELSE 'NO' END) as groupuse, (CASE s.NOQTY WHEN 'Y' THEN 'SI' ELSE 'NO' END) as vacio,
              p.name as producto, sp.PRODUCTIONTYPE as tipo, (CASE sp.PRODUCTIONTYPE WHEN '+' THEN 'bold' ELSE 'normal' END) as bold,
              sp.QUANTITY, c.UOMSYMBOL as ud, sp.COMPONENTCOST, sp.DECREASE, sp.REJECTED,
              pp.MA_ProcessPlan_ID, s.MA_Sequence_ID, AD_MESSAGE_GET2(pp.EXPLODEPHASES, 'es_ES') as explodephases
          FROM MA_Processplan pp, MA_processplan_version v, ma_sequence s, ma_sequenceproduct sp, 
              m_product p, ma_process pr, C_UOM c
          where pp.MA_PROCESSPLAN_ID = v.MA_PROCESSPLAN_ID
            and v.MA_PROCESSPLAN_VERSION_ID = s.MA_PROCESSPLAN_VERSION_ID
            and s.MA_SEQUENCE_ID = sp.MA_SEQUENCE_ID
            and sp.M_PRODUCT_ID = p.M_PRODUCT_ID
            and sp.C_UOM_ID = c.C_UOM_ID
            and s.MA_PROCESS_ID = pr.MA_PROCESS_ID
            and v.DATEFROM <= now()
            and v.DATETO > now()
            and 1=1
          order by pp.ma_processplan_id, pp.NAME, s.seqno, sp.productiontype, p.name]]></queryString>

	<field name="PROCESSPLAN" class="java.lang.String"/>
	<field name="RATIO" class="java.math.BigDecimal"/>
	<field name="SECUD" class="java.lang.String"/>
	<field name="DESDE" class="java.util.Date"/>
	<field name="HASTA" class="java.util.Date"/>
	<field name="SECUENCIA" class="java.lang.String"/>
	<field name="SEC" class="java.lang.String"/>
	<field name="DESCRIPTION" class="java.lang.String"/>
	<field name="PROCESO" class="java.lang.String"/>
	<field name="SEQNO" class="java.math.BigDecimal"/>
	<field name="GROUPUSE" class="java.lang.String"/>
	<field name="VACIO" class="java.lang.String"/>
	<field name="PRODUCTO" class="java.lang.String"/>
	<field name="TIPO" class="java.lang.String"/>
	<field name="BOLD" class="java.lang.String"/>
	<field name="QUANTITY" class="java.math.BigDecimal"/>
	<field name="UD" class="java.lang.String"/>
	<field name="COMPONENTCOST" class="java.math.BigDecimal"/>
	<field name="DECREASE" class="java.math.BigDecimal"/>
	<field name="REJECTED" class="java.math.BigDecimal"/>
	<field name="MA_PROCESSPLAN_ID" class="java.math.BigDecimal"/>
	<field name="MA_SEQUENCE_ID" class="java.math.BigDecimal"/>
	<field name="EXPLODEPHASES" class="java.lang.String"/>


		<group  name="PRODUCTION PLAN" isStartNewPage="true" >
			<groupExpression><![CDATA[$F{MA_PROCESSPLAN_ID}]]></groupExpression>
			<groupHeader>
			<band height="86"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="PRODUCTION PLAN"  hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="110"
						y="63"
						width="78"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{SECUD}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="PRODUCTION PLAN"  hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="299"
						y="63"
						width="78"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{RATIO}!=null)?$P{NUMBERFORMAT}.format($F{RATIO}):new String(" ")]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="default"
						x="11"
						y="63"
						width="99"
						height="18"
						key="element-93"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Secondary Unit: ]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="default"
						x="199"
						y="63"
						width="100"
						height="18"
						key="element-94"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Conversion ratio:]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="default"
						x="402"
						y="40"
						width="51"
						height="18"
						key="element-95"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Explode: phases:]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="453"
						y="40"
						width="69"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{EXPLODEPHASES}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="default"
						x="11"
						y="40"
						width="34"
						height="18"
						key="element-96"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[From:]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="default"
						x="199"
						y="40"
						width="25"
						height="18"
						key="element-97"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[To:]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="PRODUCTION PLAN"  hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="45"
						y="40"
						width="100"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{DESDE}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="PRODUCTION PLAN"  hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="224"
						y="40"
						width="100"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{HASTA}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Report_Title"
						x="1"
						y="0"
						width="534"
						height="25"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PROCESSPLAN}]]></textFieldExpression>
				</textField>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="29"
						width="535"
						height="0"
						forecolor="#000000"
						key="line-18"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
			</groupFooter>
		</group>
		<group  name="SECUENCIA" >
			<groupExpression><![CDATA[$F{SECUENCIA}]]></groupExpression>
			<groupHeader>
			<band height="51"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="SECUENCIA"  hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="GroupHeader_DarkGray"
						x="98"
						y="0"
						width="437"
						height="20"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font pdfFontName="Helvetica"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{SECUENCIA}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="PROCESO"  hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						mode="Opaque"
						x="78"
						y="28"
						width="95"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PROCESO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						mode="Opaque"
						x="358"
						y="28"
						width="24"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{GROUPUSE}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						mode="Opaque"
						x="469"
						y="28"
						width="22"
						height="18"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{VACIO}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="default"
						mode="Opaque"
						x="258"
						y="28"
						width="98"
						height="18"
						key="element-91"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Global consume:]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="default"
						mode="Opaque"
						x="393"
						y="28"
						width="70"
						height="18"
						key="element-92"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Empty qty:]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="1"
						y="0"
						width="97"
						height="20"
						key="staticText-3"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font pdfFontName="Helvetica"/>
					</textElement>
				<text><![CDATA[Sequence:]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="default"
						x="13"
						y="28"
						width="65"
						height="18"
						key="element-98"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Process:]]></text>
				</staticText>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="1"
						y="1"
						width="0"
						height="50"
						forecolor="#555555"
						key="line-21"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="535"
						y="1"
						width="0"
						height="50"
						forecolor="#555555"
						key="line-28"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="19"  isSplitAllowed="true" >
				<line direction="TopDown">
					<reportElement
						x="1"
						y="11"
						width="534"
						height="0"
						forecolor="#555555"
						key="line-25"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="1"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-24"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="535"
						y="1"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-35"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="10"
						y="0"
						width="512"
						height="0"
						forecolor="#666666"
						key="line-36"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="Thin"/>
				</line>
			</band>
			</groupFooter>
		</group>
		<group  name="PROCESO" >
			<groupExpression><![CDATA[$F{PROCESO}]]></groupExpression>
			<groupHeader>
			<band height="18"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						style="Detail_Header"
						x="10"
						y="0"
						width="143"
						height="18"
						key="element-90"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#CCCCCC" leftPadding="5" rightBorder="None" rightBorderColor="#CCCCCC" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font/>
					</textElement>
				<text><![CDATA[Product]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="Detail_Header"
						x="153"
						y="0"
						width="46"
						height="18"
						key="element-90"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#CCCCCC" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font/>
					</textElement>
				<text><![CDATA[Type]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="Detail_Header"
						x="199"
						y="0"
						width="96"
						height="18"
						key="element-90"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#CCCCCC" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right">
						<font/>
					</textElement>
				<text><![CDATA[Quantity]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="Detail_Header"
						x="295"
						y="0"
						width="53"
						height="18"
						key="element-90"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#CCCCCC" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right">
						<font/>
					</textElement>
				<text><![CDATA[Decrease]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="Detail_Header"
						x="348"
						y="0"
						width="66"
						height="18"
						key="element-90"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#CCCCCC" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right">
						<font/>
					</textElement>
				<text><![CDATA[Rejected]]></text>
				</staticText>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="1"
						y="0"
						width="0"
						height="18"
						forecolor="#555555"
						key="line-22"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="535"
						y="0"
						width="0"
						height="18"
						forecolor="#555555"
						key="line-30"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
			</groupFooter>
		</group>
		<background>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</background>
		<title>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</title>
		<pageHeader>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</pageHeader>
		<columnHeader>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</columnHeader>
		<detail>
			<band height="16"  isSplitAllowed="true" >
				<frame>					<reportElement
						style="Detail_Line"
						x="10"
						y="0"
						width="512"
						height="16"
						key="frame-2"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="0"
						y="0"
						width="143"
						height="16"
						key="textField-1"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement verticalAlignment="Middle">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PRODUCTO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="143"
						y="0"
						width="46"
						height="16"
						key="textField-2"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement verticalAlignment="Middle">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{TIPO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="189"
						y="0"
						width="66"
						height="16"
						key="textField-3"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{QUANTITY}!=null)?$P{NUMBERFORMAT}.format($F{QUANTITY}):new String(" ")]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="255"
						y="0"
						width="30"
						height="16"
						key="textField-4"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement verticalAlignment="Middle">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UD}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="285"
						y="0"
						width="53"
						height="16"
						key="textField-5"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{DECREASE}!=null)?$P{NUMBERFORMAT}.format($F{DECREASE}):new String(" ")]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="default"
						x="338"
						y="0"
						width="66"
						height="16"
						key="textField-6"
						stretchType="RelativeToBandHeight"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{REJECTED}!=null)?$P{NUMBERFORMAT}.format($F{REJECTED}):new String(" ")]]></textFieldExpression>
				</textField>
				</frame>				<line direction="TopDown">
					<reportElement
						style="default"
						x="1"
						y="0"
						width="0"
						height="16"
						forecolor="#555555"
						key="line-23"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<line direction="TopDown">
					<reportElement
						style="default"
						x="535"
						y="0"
						width="0"
						height="16"
						forecolor="#555555"
						key="line-32"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
			</band>
		</detail>
		<columnFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</columnFooter>
		<pageFooter>
			<band height="28"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="398"
						y="7"
						width="95"
						height="19"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Helvetica" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="497"
						y="7"
						width="36"
						height="19"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="4"
						width="535"
						height="0"
						forecolor="#000000"
						key="line"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
				</line>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="275"
						y="7"
						width="69"
						height="19"
						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Times-Roman" size="10"/>
					</textElement>
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						x="211"
						y="7"
						width="60"
						height="19"
						key="staticText-1"/>
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right">
						<font/>
					</textElement>
				<text><![CDATA[Printed on]]></text>
				</staticText>
			</band>
		</pageFooter>
		<summary>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</summary>
</jasperReport>