src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 726 dac2a1486bd3
child 1103 e7244ff427e5
permissions -rw-r--r--
Removed old frame parameter of windowTableId
juanpablo@726
     1
<?xml version="1.0" encoding="UTF-8"  ?>
juanpablo@726
     2
<!-- Created with iReport - A designer for JasperReports -->
juanpablo@726
     3
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
juanpablo@726
     4
<jasperReport
juanpablo@726
     5
		 name="ReportWorkRequirementJR"
juanpablo@726
     6
		 columnCount="1"
juanpablo@726
     7
		 printOrder="Vertical"
juanpablo@726
     8
		 orientation="Portrait"
juanpablo@726
     9
		 pageWidth="595"
juanpablo@726
    10
		 pageHeight="842"
juanpablo@726
    11
		 columnWidth="535"
juanpablo@726
    12
		 columnSpacing="0"
juanpablo@726
    13
		 leftMargin="30"
juanpablo@726
    14
		 rightMargin="30"
juanpablo@726
    15
		 topMargin="20"
juanpablo@726
    16
		 bottomMargin="20"
juanpablo@726
    17
		 whenNoDataType="NoPages"
juanpablo@726
    18
		 isTitleNewPage="false"
juanpablo@726
    19
		 isSummaryNewPage="false">
juanpablo@726
    20
	<property name="ireport.scriptlethandling" value="0" />
juanpablo@726
    21
	<property name="ireport.encoding" value="UTF-8" />
juanpablo@726
    22
	<import value="java.util.*" />
juanpablo@726
    23
	<import value="net.sf.jasperreports.engine.*" />
juanpablo@726
    24
	<import value="net.sf.jasperreports.engine.data.*" />
juanpablo@726
    25
juanpablo@726
    26
	<style 
juanpablo@726
    27
		name="default"
juanpablo@726
    28
		isDefault="false"
juanpablo@726
    29
		vAlign="Middle"
juanpablo@726
    30
		fontName="Bitstream Vera Sans"
juanpablo@726
    31
		fontSize="8"
juanpablo@726
    32
	/>
juanpablo@726
    33
	<style 
juanpablo@726
    34
		name="Report_Title"
juanpablo@726
    35
		isDefault="false"
juanpablo@726
    36
		leftPadding="5"
juanpablo@726
    37
		fontName="Bitstream Vera Sans"
juanpablo@726
    38
		fontSize="18"
juanpablo@726
    39
	/>
juanpablo@726
    40
	<style 
juanpablo@726
    41
		name="Report_Subtitle"
juanpablo@726
    42
		isDefault="false"
juanpablo@726
    43
		forecolor="#555555"
juanpablo@726
    44
		leftPadding="5"
juanpablo@726
    45
		fontName="Bitstream Vera Sans"
juanpablo@726
    46
		fontSize="14"
juanpablo@726
    47
	/>
juanpablo@726
    48
	<style 
juanpablo@726
    49
		name="Report_Data_Label"
juanpablo@726
    50
		isDefault="false"
juanpablo@726
    51
		fontName="Bitstream Vera Sans"
juanpablo@726
    52
		fontSize="11"
juanpablo@726
    53
		isBold="true"
juanpablo@726
    54
	/>
juanpablo@726
    55
	<style 
juanpablo@726
    56
		name="Report_Data_Field"
juanpablo@726
    57
		isDefault="false"
juanpablo@726
    58
		fontName="Bitstream Vera Sans"
juanpablo@726
    59
		fontSize="11"
juanpablo@726
    60
		isBold="false"
juanpablo@726
    61
	/>
juanpablo@726
    62
	<style 
juanpablo@726
    63
		name="Total_Field"
juanpablo@726
    64
		isDefault="false"
juanpablo@726
    65
		mode="Opaque"
juanpablo@726
    66
		forecolor="#000000"
juanpablo@726
    67
		backcolor="#CCCCCC"
juanpablo@726
    68
		vAlign="Middle"
juanpablo@726
    69
		leftPadding="5"
juanpablo@726
    70
		fontName="Bitstream Vera Sans"
juanpablo@726
    71
		fontSize="11"
juanpablo@726
    72
		isBold="true"
juanpablo@726
    73
	/>
juanpablo@726
    74
	<style 
juanpablo@726
    75
		name="GroupHeader_DarkGray"
juanpablo@726
    76
		isDefault="false"
juanpablo@726
    77
		mode="Opaque"
juanpablo@726
    78
		forecolor="#FFFFFF"
juanpablo@726
    79
		backcolor="#555555"
juanpablo@726
    80
		vAlign="Middle"
juanpablo@726
    81
		leftPadding="5"
juanpablo@726
    82
		fontName="Bitstream Vera Sans"
juanpablo@726
    83
		fontSize="12"
juanpablo@726
    84
		isBold="true"
juanpablo@726
    85
	/>
juanpablo@726
    86
	<style 
juanpablo@726
    87
		name="Group_Data_Label"
juanpablo@726
    88
		isDefault="false"
juanpablo@726
    89
		vAlign="Middle"
juanpablo@726
    90
		fontName="Bitstream Vera Sans"
juanpablo@726
    91
		fontSize="11"
juanpablo@726
    92
		isBold="true"
juanpablo@726
    93
	/>
juanpablo@726
    94
	<style 
juanpablo@726
    95
		name="Group_Data_Field"
juanpablo@726
    96
		isDefault="false"
juanpablo@726
    97
		vAlign="Middle"
juanpablo@726
    98
		fontName="Bitstream Vera Sans"
juanpablo@726
    99
		fontSize="11"
juanpablo@726
   100
	/>
juanpablo@726
   101
	<style 
juanpablo@726
   102
		name="Detail_Header"
juanpablo@726
   103
		isDefault="false"
juanpablo@726
   104
		mode="Opaque"
juanpablo@726
   105
		forecolor="#FFFFFF"
juanpablo@726
   106
		backcolor="#5D5D5D"
juanpablo@726
   107
		vAlign="Middle"
juanpablo@726
   108
		leftBorder="1Point"
juanpablo@726
   109
		leftBorderColor="#FFFFFF"
juanpablo@726
   110
		leftPadding="5"
juanpablo@726
   111
		rightBorder="1Point"
juanpablo@726
   112
		rightBorderColor="#FFFFFF"
juanpablo@726
   113
		fontName="Bitstream Vera Sans"
juanpablo@726
   114
		fontSize="10"
juanpablo@726
   115
		isBold="true"
juanpablo@726
   116
	/>
juanpablo@726
   117
	<style 
juanpablo@726
   118
		name="Detail_Line"
juanpablo@726
   119
		isDefault="false"
juanpablo@726
   120
		vAlign="Middle"
juanpablo@726
   121
		fontName="Bitstream Vera Sans"
juanpablo@726
   122
		fontSize="9"
juanpablo@726
   123
	>
juanpablo@726
   124
juanpablo@726
   125
		<conditionalStyle>
juanpablo@726
   126
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression>
juanpablo@726
   127
			<style 
juanpablo@726
   128
				name="Detail_Line"
juanpablo@726
   129
				isDefault="false"
juanpablo@726
   130
				mode="Opaque"
juanpablo@726
   131
				backcolor="#CCCCCC"
juanpablo@726
   132
				vAlign="Middle"
juanpablo@726
   133
				fontName="Bitstream Vera Sans"
juanpablo@726
   134
				fontSize="9"
juanpablo@726
   135
			/>
juanpablo@726
   136
		</conditionalStyle>
juanpablo@726
   137
	</style>
juanpablo@726
   138
	<style 
juanpablo@726
   139
		name="Total_Gray"
juanpablo@726
   140
		isDefault="false"
juanpablo@726
   141
		mode="Opaque"
juanpablo@726
   142
		forecolor="#000000"
juanpablo@726
   143
		backcolor="#CCCCCC"
juanpablo@726
   144
	/>
juanpablo@726
   145
	<style 
juanpablo@726
   146
		name="Detail_Data_Label"
juanpablo@726
   147
		isDefault="false"
juanpablo@726
   148
		mode="Opaque"
juanpablo@726
   149
		backcolor="#CCCCCC"
juanpablo@726
   150
		fontName="Bitstream Vera Sans"
juanpablo@726
   151
		fontSize="10"
juanpablo@726
   152
		isBold="true"
juanpablo@726
   153
	/>
juanpablo@726
   154
	<style 
juanpablo@726
   155
		name="Detail_Data_Field"
juanpablo@726
   156
		isDefault="false"
juanpablo@726
   157
		mode="Opaque"
juanpablo@726
   158
		backcolor="#CCCCCC"
juanpablo@726
   159
		fontName="Bitstream Vera Sans"
juanpablo@726
   160
		fontSize="10"
juanpablo@726
   161
	/>
juanpablo@726
   162
	<style 
juanpablo@726
   163
		name="Group_Footer"
juanpablo@726
   164
		isDefault="false"
juanpablo@726
   165
		fontName="Bitstream Vera Sans"
juanpablo@726
   166
		fontSize="11"
juanpablo@726
   167
		isBold="true"
juanpablo@726
   168
	/>
juanpablo@726
   169
	<style 
juanpablo@726
   170
		name="Report_Footer"
juanpablo@726
   171
		isDefault="true"
juanpablo@726
   172
		vAlign="Middle"
juanpablo@726
   173
		fontName="Bitstream Vera Sans"
juanpablo@726
   174
		fontSize="11"
juanpablo@726
   175
	/>
juanpablo@726
   176
	<style 
juanpablo@726
   177
		name="Detail_Red"
juanpablo@726
   178
		isDefault="false"
juanpablo@726
   179
		vAlign="Middle"
juanpablo@726
   180
		fontName="Bitstream Vera Sans"
juanpablo@726
   181
		fontSize="9"
juanpablo@726
   182
	>
juanpablo@726
   183
juanpablo@726
   184
		<conditionalStyle>
juanpablo@726
   185
			<conditionExpression><![CDATA[new Boolean($F{NEEDED}.floatValue()>$F{STOCK}.add($F{INPROCESS}).floatValue())]]></conditionExpression>
juanpablo@726
   186
			<style 
juanpablo@726
   187
				isDefault="false"
juanpablo@726
   188
				forecolor="#FF0000"
juanpablo@726
   189
				vAlign="Middle"
juanpablo@726
   190
				fontName="Bitstream Vera Sans"
juanpablo@726
   191
				fontSize="9"
juanpablo@726
   192
			/>
juanpablo@726
   193
		</conditionalStyle>
juanpablo@726
   194
	</style>
juanpablo@726
   195
juanpablo@726
   196
	<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   197
	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   198
	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   199
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   200
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
juanpablo@726
   201
	</parameter>
juanpablo@726
   202
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
juanpablo@726
   203
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
juanpablo@726
   204
	</parameter>
juanpablo@726
   205
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
juanpablo@726
   206
		<defaultValueExpression ><![CDATA["(0)"]]></defaultValueExpression>
juanpablo@726
   207
	</parameter>
juanpablo@726
   208
	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   209
		<defaultValueExpression ><![CDATA["Pending Work Requirement"]]></defaultValueExpression>
juanpablo@726
   210
	</parameter>
juanpablo@726
   211
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   212
	<parameter name="ReportData" isForPrompting="false" class="java.lang.String">
juanpablo@726
   213
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   214
	</parameter>
juanpablo@726
   215
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
juanpablo@726
   216
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
carlos@0
   217
	<queryString><![CDATA[SELECT wr.MA_WorkRequirement_ID AS wrid, AD_COLUMN_IDENTIFIER('MA_WorkRequirement', wr.MA_WORKREQUIREMENT_ID, 'es_ES') AS wrname, 
carlos@0
   218
       AD_COLUMN_IDENTIFIER('MA_ProcessPlan', pp.MA_ProcessPlan_ID, 'es_ES') AS processplan, 
carlos@0
   219
       wr.STARTDATE AS startdate, wr.ENDDATE AS enddate, wrp.SeqNO,
carlos@0
   220
       AD_COLUMN_IDENTIFIER('MA_WRPhase', wrp.MA_WRPhase_ID, 'es_ES') AS wrpname, 
carlos@0
   221
       AD_COLUMN_IDENTIFIER('MA_Process', ps.MA_Process_ID, 'es_ES') AS process, 
carlos@0
   222
       wrp.DONEQUANTITY AS quantity, wrp.QUANTITY AS needqty, wrpp.M_PRODUCT_ID AS productid, 
carlos@0
   223
       AD_COLUMN_IDENTIFIER('M_Product', pd.M_Product_ID, 'es_ES') AS product, 
carlos@0
   224
       SUM(T.QTYONHAND) AS stock, (wrp.QUANTITY - wrp.DONEQUANTITY) * wrpp.MOVEMENTQTY AS needed, 
carlos@0
   225
       'Bordes' AS negative, '123' AS inprocess, wrp.MA_WRPHASE_ID AS WRPID
carlos@0
   226
FROM MA_WorkRequirement wr, MA_WRPhase wrp, MA_WRPhaseProduct wrpp, MA_Process ps, MA_ProcessPlan pp, M_Product pd, M_STORAGE_DETAIL T
carlos@0
   227
WHERE wr.MA_WORKREQUIREMENT_ID = wrp.MA_WORKREQUIREMENT_ID
carlos@0
   228
AND wr.MA_PROCESSPLAN_ID = pp.MA_PROCESSPLAN_ID
carlos@0
   229
AND wrp.MA_WRPHASE_ID = wrpp.MA_WRPHASE_ID
carlos@0
   230
AND wrpp.M_PRODUCT_ID = pd.M_PRODUCT_ID
carlos@0
   231
AND wrp.MA_PROCESS_ID = ps.MA_PROCESS_ID
carlos@0
   232
AND pd.M_PRODUCT_ID = T.M_PRODUCT_ID
carlos@0
   233
AND wrp.CLOSED = 'N'
carlos@0
   234
AND wrpp.PRODUCTIONTYPE = '-'
carlos@0
   235
GROUP BY wr.MA_WorkRequirement_ID, wrp.MA_WRPHASE_ID, wr.DOCUMENTNO, pp.MA_ProcessPlan_ID, wr.STARTDATE, wr.ENDDATE,
carlos@0
   236
         ps.MA_Process_ID, wrp.DONEQUANTITY, wrp.QUANTITY, pd.M_PRODUCT_ID, wrpp.MOVEMENTQTY, wrp.SeqNo, wrpp.M_PRODUCT_ID
juanpablo@726
   237
ORDER BY enddate, wr.MA_WorkRequirement_ID, wrp.SeqNo, wrp.MA_WRPHASE_ID]]></queryString>
juanpablo@726
   238
juanpablo@726
   239
	<field name="WRID" class="java.math.BigDecimal"/>
juanpablo@726
   240
	<field name="WRNAME" class="java.lang.String"/>
juanpablo@726
   241
	<field name="PROCESSPLAN" class="java.lang.String"/>
juanpablo@726
   242
	<field name="STARTDATE" class="java.util.Date"/>
juanpablo@726
   243
	<field name="ENDDATE" class="java.util.Date"/>
juanpablo@726
   244
	<field name="SEQNO" class="java.math.BigDecimal"/>
juanpablo@726
   245
	<field name="WRPNAME" class="java.lang.String"/>
juanpablo@726
   246
	<field name="PROCESS" class="java.lang.String"/>
juanpablo@726
   247
	<field name="QUANTITY" class="java.math.BigDecimal"/>
juanpablo@726
   248
	<field name="NEEDQTY" class="java.math.BigDecimal"/>
juanpablo@726
   249
	<field name="PRODUCTID" class="java.math.BigDecimal"/>
juanpablo@726
   250
	<field name="PRODUCT" class="java.lang.String"/>
juanpablo@726
   251
	<field name="STOCK" class="java.math.BigDecimal"/>
juanpablo@726
   252
	<field name="NEEDED" class="java.math.BigDecimal"/>
juanpablo@726
   253
	<field name="INPROCESS" class="java.math.BigDecimal"/>
juanpablo@726
   254
	<field name="WRPID" class="java.math.BigDecimal"/>
juanpablo@726
   255
juanpablo@726
   256
	<variable name="DetailFieldTotal" class="java.lang.String" resetType="Report" calculation="Nothing">
juanpablo@726
   257
	</variable>
juanpablo@726
   258
juanpablo@726
   259
		<group  name="WRID" >
juanpablo@726
   260
			<groupExpression><![CDATA[$F{WRID}]]></groupExpression>
juanpablo@726
   261
			<groupHeader>
juanpablo@726
   262
			<band height="68"  isSplitAllowed="true" >
juanpablo@726
   263
				<staticText>
carlos@0
   264
					<reportElement
carlos@0
   265
						style="GroupHeader_DarkGray"
carlos@0
   266
						x="1"
carlos@0
   267
						y="0"
carlos@0
   268
						width="149"
carlos@0
   269
						height="23"
juanpablo@726
   270
						key="staticText"/>
juanpablo@726
   271
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   272
					<textElement>
juanpablo@726
   273
						<font pdfFontName="Helvetica"/>
juanpablo@726
   274
					</textElement>
juanpablo@726
   275
				<text><![CDATA[Work Requirement:]]></text>
juanpablo@726
   276
				</staticText>
juanpablo@726
   277
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   278
					<reportElement
carlos@0
   279
						style="GroupHeader_DarkGray"
carlos@0
   280
						x="150"
carlos@0
   281
						y="0"
carlos@0
   282
						width="385"
carlos@0
   283
						height="23"
juanpablo@726
   284
						key="textField"/>
juanpablo@726
   285
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   286
					<textElement>
juanpablo@726
   287
						<font/>
juanpablo@726
   288
					</textElement>
juanpablo@726
   289
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{WRNAME}]]></textFieldExpression>
juanpablo@726
   290
				</textField>
juanpablo@726
   291
				<line direction="TopDown">
carlos@0
   292
					<reportElement
carlos@0
   293
						x="0"
carlos@0
   294
						y="1"
carlos@0
   295
						width="0"
carlos@0
   296
						height="67"
carlos@0
   297
						forecolor="#555555"
carlos@0
   298
						key="line-2"
juanpablo@726
   299
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   300
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   301
				</line>
juanpablo@726
   302
				<line direction="TopDown">
carlos@0
   303
					<reportElement
carlos@0
   304
						x="535"
carlos@0
   305
						y="1"
carlos@0
   306
						width="0"
carlos@0
   307
						height="67"
carlos@0
   308
						forecolor="#555555"
carlos@0
   309
						key="line-3"
juanpablo@726
   310
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   311
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   312
				</line>
juanpablo@726
   313
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   314
					<reportElement
carlos@0
   315
						style="Group_Data_Field"
carlos@0
   316
						x="131"
carlos@0
   317
						y="48"
carlos@0
   318
						width="296"
carlos@0
   319
						height="18"
juanpablo@726
   320
						key="textField"/>
juanpablo@726
   321
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   322
					<textElement verticalAlignment="Middle">
juanpablo@726
   323
						<font/>
juanpablo@726
   324
					</textElement>
juanpablo@726
   325
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PROCESSPLAN}]]></textFieldExpression>
juanpablo@726
   326
				</textField>
juanpablo@726
   327
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   328
					<reportElement
carlos@0
   329
						style="Group_Data_Field"
carlos@0
   330
						x="101"
carlos@0
   331
						y="28"
carlos@0
   332
						width="103"
carlos@0
   333
						height="18"
juanpablo@726
   334
						key="textField"/>
juanpablo@726
   335
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   336
					<textElement verticalAlignment="Middle">
juanpablo@726
   337
						<font/>
juanpablo@726
   338
					</textElement>
juanpablo@726
   339
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{STARTDATE}]]></textFieldExpression>
juanpablo@726
   340
				</textField>
juanpablo@726
   341
				<staticText>
carlos@0
   342
					<reportElement
carlos@0
   343
						style="Group_Data_Label"
carlos@0
   344
						x="10"
carlos@0
   345
						y="28"
carlos@0
   346
						width="91"
carlos@0
   347
						height="18"
juanpablo@726
   348
						key="element-90"/>
juanpablo@726
   349
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   350
					<textElement>
juanpablo@726
   351
						<font/>
juanpablo@726
   352
					</textElement>
juanpablo@726
   353
				<text><![CDATA[Initial Date:]]></text>
juanpablo@726
   354
				</staticText>
juanpablo@726
   355
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   356
					<reportElement
carlos@0
   357
						style="Group_Data_Field"
carlos@0
   358
						x="325"
carlos@0
   359
						y="28"
carlos@0
   360
						width="103"
carlos@0
   361
						height="18"
juanpablo@726
   362
						key="textField"/>
juanpablo@726
   363
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   364
					<textElement verticalAlignment="Middle">
juanpablo@726
   365
						<font/>
juanpablo@726
   366
					</textElement>
juanpablo@726
   367
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{ENDDATE}]]></textFieldExpression>
juanpablo@726
   368
				</textField>
juanpablo@726
   369
				<staticText>
carlos@0
   370
					<reportElement
carlos@0
   371
						style="Group_Data_Label"
carlos@0
   372
						x="243"
carlos@0
   373
						y="28"
carlos@0
   374
						width="82"
carlos@0
   375
						height="18"
juanpablo@726
   376
						key="element-90"/>
juanpablo@726
   377
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   378
					<textElement>
juanpablo@726
   379
						<font/>
juanpablo@726
   380
					</textElement>
juanpablo@726
   381
				<text><![CDATA[Final Date:]]></text>
juanpablo@726
   382
				</staticText>
juanpablo@726
   383
				<staticText>
carlos@0
   384
					<reportElement
carlos@0
   385
						style="Group_Data_Label"
carlos@0
   386
						x="10"
carlos@0
   387
						y="48"
carlos@0
   388
						width="121"
carlos@0
   389
						height="18"
juanpablo@726
   390
						key="element-90"/>
juanpablo@726
   391
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   392
					<textElement>
juanpablo@726
   393
						<font/>
juanpablo@726
   394
					</textElement>
juanpablo@726
   395
				<text><![CDATA[Production Plan:]]></text>
juanpablo@726
   396
				</staticText>
juanpablo@726
   397
			</band>
juanpablo@726
   398
			</groupHeader>
juanpablo@726
   399
			<groupFooter>
juanpablo@726
   400
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   401
				<line direction="TopDown">
carlos@0
   402
					<reportElement
carlos@0
   403
						x="0"
carlos@0
   404
						y="0"
carlos@0
   405
						width="0"
carlos@0
   406
						height="14"
carlos@0
   407
						forecolor="#555555"
carlos@0
   408
						key="line-32"
juanpablo@726
   409
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   410
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   411
				</line>
juanpablo@726
   412
				<line direction="TopDown">
carlos@0
   413
					<reportElement
carlos@0
   414
						x="535"
carlos@0
   415
						y="0"
carlos@0
   416
						width="0"
carlos@0
   417
						height="14"
carlos@0
   418
						forecolor="#555555"
carlos@0
   419
						key="line-33"
juanpablo@726
   420
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   421
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   422
				</line>
juanpablo@726
   423
				<line direction="TopDown">
carlos@0
   424
					<reportElement
carlos@0
   425
						x="0"
carlos@0
   426
						y="14"
carlos@0
   427
						width="535"
carlos@0
   428
						height="0"
carlos@0
   429
						forecolor="#555555"
juanpablo@726
   430
						key="line-34"/>
juanpablo@726
   431
					<graphicElement stretchType="NoStretch" pen="2Point"/>
juanpablo@726
   432
				</line>
juanpablo@726
   433
			</band>
juanpablo@726
   434
			</groupFooter>
juanpablo@726
   435
		</group>
juanpablo@726
   436
		<group  name="WRPID" >
juanpablo@726
   437
			<groupExpression><![CDATA[$F{WRPID}]]></groupExpression>
juanpablo@726
   438
			<groupHeader>
juanpablo@726
   439
			<band height="63"  isSplitAllowed="true" >
juanpablo@726
   440
				<staticText>
carlos@0
   441
					<reportElement
carlos@0
   442
						style="GroupHeader_DarkGray"
carlos@0
   443
						x="11"
carlos@0
   444
						y="0"
carlos@0
   445
						width="65"
carlos@0
   446
						height="23"
juanpablo@726
   447
						key="staticText"/>
juanpablo@726
   448
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   449
					<textElement>
juanpablo@726
   450
						<font pdfFontName="Helvetica"/>
juanpablo@726
   451
					</textElement>
juanpablo@726
   452
				<text><![CDATA[Phase:]]></text>
juanpablo@726
   453
				</staticText>
juanpablo@726
   454
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   455
					<reportElement
carlos@0
   456
						style="GroupHeader_DarkGray"
carlos@0
   457
						x="76"
carlos@0
   458
						y="0"
carlos@0
   459
						width="459"
carlos@0
   460
						height="23"
juanpablo@726
   461
						key="textField"/>
juanpablo@726
   462
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   463
					<textElement>
juanpablo@726
   464
						<font/>
juanpablo@726
   465
					</textElement>
juanpablo@726
   466
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{SEQNO}.toPlainString() + " - " + $F{PROCESS}]]></textFieldExpression>
juanpablo@726
   467
				</textField>
juanpablo@726
   468
				<line direction="TopDown">
carlos@0
   469
					<reportElement
carlos@0
   470
						x="10"
carlos@0
   471
						y="1"
carlos@0
   472
						width="0"
carlos@0
   473
						height="62"
carlos@0
   474
						forecolor="#555555"
carlos@0
   475
						key="line-4"
juanpablo@726
   476
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   477
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   478
				</line>
juanpablo@726
   479
				<line direction="TopDown">
carlos@0
   480
					<reportElement
carlos@0
   481
						x="535"
carlos@0
   482
						y="0"
carlos@0
   483
						width="0"
carlos@0
   484
						height="63"
carlos@0
   485
						forecolor="#555555"
carlos@0
   486
						key="line-6"
juanpablo@726
   487
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   488
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   489
				</line>
juanpablo@726
   490
				<line direction="TopDown">
carlos@0
   491
					<reportElement
carlos@0
   492
						x="0"
carlos@0
   493
						y="0"
carlos@0
   494
						width="0"
carlos@0
   495
						height="63"
carlos@0
   496
						forecolor="#555555"
carlos@0
   497
						key="line-8"
juanpablo@726
   498
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   499
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   500
				</line>
juanpablo@726
   501
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   502
					<reportElement
carlos@0
   503
						style="Group_Data_Field"
carlos@0
   504
						x="299"
carlos@0
   505
						y="25"
carlos@0
   506
						width="100"
carlos@0
   507
						height="18"
juanpablo@726
   508
						key="textField"/>
juanpablo@726
   509
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   510
					<textElement verticalAlignment="Middle">
juanpablo@726
   511
						<font/>
juanpablo@726
   512
					</textElement>
juanpablo@726
   513
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{QUANTITY}!=null)?$P{NUMBERFORMAT}.format($F{QUANTITY}):new String(" ")]]></textFieldExpression>
juanpablo@726
   514
				</textField>
juanpablo@726
   515
				<staticText>
carlos@0
   516
					<reportElement
carlos@0
   517
						style="Group_Data_Label"
carlos@0
   518
						x="19"
carlos@0
   519
						y="25"
carlos@0
   520
						width="82"
carlos@0
   521
						height="18"
juanpablo@726
   522
						key="element-90"/>
juanpablo@726
   523
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   524
					<textElement>
juanpablo@726
   525
						<font/>
juanpablo@726
   526
					</textElement>
juanpablo@726
   527
				<text><![CDATA[Quantity:]]></text>
juanpablo@726
   528
				</staticText>
juanpablo@726
   529
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   530
					<reportElement
carlos@0
   531
						style="Group_Data_Field"
carlos@0
   532
						x="101"
carlos@0
   533
						y="25"
carlos@0
   534
						width="100"
carlos@0
   535
						height="18"
juanpablo@726
   536
						key="textField"/>
juanpablo@726
   537
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   538
					<textElement verticalAlignment="Middle">
juanpablo@726
   539
						<font/>
juanpablo@726
   540
					</textElement>
juanpablo@726
   541
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{NEEDQTY}!=null)?$P{NUMBERFORMAT}.format($F{NEEDQTY}):new String(" ")]]></textFieldExpression>
juanpablo@726
   542
				</textField>
juanpablo@726
   543
				<staticText>
carlos@0
   544
					<reportElement
carlos@0
   545
						style="Group_Data_Label"
carlos@0
   546
						x="243"
carlos@0
   547
						y="25"
carlos@0
   548
						width="56"
carlos@0
   549
						height="18"
juanpablo@726
   550
						key="element-90"/>
juanpablo@726
   551
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   552
					<textElement>
juanpablo@726
   553
						<font/>
juanpablo@726
   554
					</textElement>
juanpablo@726
   555
				<text><![CDATA[Done:]]></text>
juanpablo@726
   556
				</staticText>
juanpablo@726
   557
				<staticText>
carlos@0
   558
					<reportElement
carlos@0
   559
						style="Detail_Header"
carlos@0
   560
						x="18"
carlos@0
   561
						y="47"
carlos@0
   562
						width="307"
carlos@0
   563
						height="16"
juanpablo@726
   564
						key="element-90"/>
juanpablo@726
   565
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   566
					<textElement>
juanpablo@726
   567
						<font/>
juanpablo@726
   568
					</textElement>
juanpablo@726
   569
				<text><![CDATA[PRODUCT]]></text>
juanpablo@726
   570
				</staticText>
juanpablo@726
   571
				<staticText>
carlos@0
   572
					<reportElement
carlos@0
   573
						style="Detail_Header"
carlos@0
   574
						x="395"
carlos@0
   575
						y="47"
carlos@0
   576
						width="70"
carlos@0
   577
						height="16"
juanpablo@726
   578
						key="element-90"/>
juanpablo@726
   579
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   580
					<textElement>
juanpablo@726
   581
						<font/>
juanpablo@726
   582
					</textElement>
juanpablo@726
   583
				<text><![CDATA[Available]]></text>
juanpablo@726
   584
				</staticText>
juanpablo@726
   585
				<staticText>
carlos@0
   586
					<reportElement
carlos@0
   587
						style="Detail_Header"
carlos@0
   588
						x="325"
carlos@0
   589
						y="47"
carlos@0
   590
						width="70"
carlos@0
   591
						height="16"
juanpablo@726
   592
						key="element-90"/>
juanpablo@726
   593
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   594
					<textElement>
juanpablo@726
   595
						<font/>
juanpablo@726
   596
					</textElement>
juanpablo@726
   597
				<text><![CDATA[Required]]></text>
juanpablo@726
   598
				</staticText>
juanpablo@726
   599
				<staticText>
carlos@0
   600
					<reportElement
carlos@0
   601
						style="Detail_Header"
carlos@0
   602
						x="465"
carlos@0
   603
						y="47"
carlos@0
   604
						width="70"
carlos@0
   605
						height="16"
juanpablo@726
   606
						key="element-90"/>
juanpablo@726
   607
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   608
					<textElement>
juanpablo@726
   609
						<font/>
juanpablo@726
   610
					</textElement>
juanpablo@726
   611
				<text><![CDATA[On hand]]></text>
juanpablo@726
   612
				</staticText>
juanpablo@726
   613
			</band>
juanpablo@726
   614
			</groupHeader>
juanpablo@726
   615
			<groupFooter>
juanpablo@726
   616
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   617
				<line direction="TopDown">
carlos@0
   618
					<reportElement
carlos@0
   619
						x="0"
carlos@0
   620
						y="0"
carlos@0
   621
						width="0"
carlos@0
   622
						height="20"
carlos@0
   623
						forecolor="#555555"
carlos@0
   624
						key="line-28"
juanpablo@726
   625
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   626
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   627
				</line>
juanpablo@726
   628
				<line direction="TopDown">
carlos@0
   629
					<reportElement
carlos@0
   630
						x="10"
carlos@0
   631
						y="0"
carlos@0
   632
						width="0"
carlos@0
   633
						height="10"
carlos@0
   634
						forecolor="#555555"
carlos@0
   635
						key="line-29"
juanpablo@726
   636
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   637
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   638
				</line>
juanpablo@726
   639
				<line direction="TopDown">
carlos@0
   640
					<reportElement
carlos@0
   641
						x="535"
carlos@0
   642
						y="0"
carlos@0
   643
						width="0"
carlos@0
   644
						height="20"
carlos@0
   645
						forecolor="#555555"
carlos@0
   646
						key="line-30"
juanpablo@726
   647
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   648
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   649
				</line>
juanpablo@726
   650
				<line direction="TopDown">
carlos@0
   651
					<reportElement
carlos@0
   652
						x="10"
carlos@0
   653
						y="10"
carlos@0
   654
						width="525"
carlos@0
   655
						height="0"
carlos@0
   656
						forecolor="#555555"
juanpablo@726
   657
						key="line-31"/>
juanpablo@726
   658
					<graphicElement stretchType="NoStretch" pen="2Point"/>
juanpablo@726
   659
				</line>
juanpablo@726
   660
				<line direction="TopDown">
carlos@0
   661
					<reportElement
carlos@0
   662
						x="19"
carlos@0
   663
						y="0"
carlos@0
   664
						width="516"
carlos@0
   665
						height="0"
carlos@0
   666
						forecolor="#555555"
juanpablo@726
   667
						key="line-35"/>
juanpablo@726
   668
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   669
				</line>
juanpablo@726
   670
			</band>
juanpablo@726
   671
			</groupFooter>
juanpablo@726
   672
		</group>
juanpablo@726
   673
		<background>
juanpablo@726
   674
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   675
			</band>
juanpablo@726
   676
		</background>
juanpablo@726
   677
		<title>
juanpablo@726
   678
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   679
			</band>
juanpablo@726
   680
		</title>
juanpablo@726
   681
		<pageHeader>
juanpablo@726
   682
			<band height="35"  isSplitAllowed="true" >
juanpablo@726
   683
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   684
					<reportElement
carlos@0
   685
						style="Report_Title"
carlos@0
   686
						mode="Transparent"
carlos@0
   687
						x="0"
carlos@0
   688
						y="0"
carlos@0
   689
						width="535"
carlos@0
   690
						height="25"
juanpablo@726
   691
						key="textField"/>
juanpablo@726
   692
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   693
					<textElement>
juanpablo@726
   694
						<font/>
juanpablo@726
   695
					</textElement>
juanpablo@726
   696
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
juanpablo@726
   697
				</textField>
juanpablo@726
   698
				<line direction="TopDown">
carlos@0
   699
					<reportElement
carlos@0
   700
						x="0"
carlos@0
   701
						y="26"
carlos@0
   702
						width="535"
carlos@0
   703
						height="0"
juanpablo@726
   704
						key="line-1"/>
juanpablo@726
   705
					<graphicElement stretchType="NoStretch" pen="2Point"/>
juanpablo@726
   706
				</line>
juanpablo@726
   707
			</band>
juanpablo@726
   708
		</pageHeader>
juanpablo@726
   709
		<columnHeader>
juanpablo@726
   710
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   711
			</band>
juanpablo@726
   712
		</columnHeader>
juanpablo@726
   713
		<detail>
juanpablo@726
   714
			<band height="14"  isSplitAllowed="true" >
juanpablo@726
   715
				<line direction="TopDown">
carlos@0
   716
					<reportElement
carlos@0
   717
						x="535"
carlos@0
   718
						y="0"
carlos@0
   719
						width="0"
carlos@0
   720
						height="14"
carlos@0
   721
						forecolor="#555555"
carlos@0
   722
						key="line-16"
juanpablo@726
   723
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   724
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   725
				</line>
juanpablo@726
   726
				<line direction="TopDown">
carlos@0
   727
					<reportElement
carlos@0
   728
						x="0"
carlos@0
   729
						y="0"
carlos@0
   730
						width="0"
carlos@0
   731
						height="14"
carlos@0
   732
						forecolor="#555555"
carlos@0
   733
						key="line-17"
juanpablo@726
   734
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   735
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   736
				</line>
juanpablo@726
   737
				<line direction="TopDown">
carlos@0
   738
					<reportElement
carlos@0
   739
						x="10"
carlos@0
   740
						y="0"
carlos@0
   741
						width="0"
carlos@0
   742
						height="14"
carlos@0
   743
						forecolor="#555555"
carlos@0
   744
						key="line-18"
juanpablo@726
   745
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   746
					<graphicElement stretchType="RelativeToBandHeight" pen="2Point"/>
juanpablo@726
   747
				</line>
carlos@0
   748
				<frame>					<reportElement
carlos@0
   749
						style="Detail_Line"
carlos@0
   750
						x="18"
carlos@0
   751
						y="0"
carlos@0
   752
						width="517"
carlos@0
   753
						height="14"
juanpablo@726
   754
						key="frame-1"/>
juanpablo@726
   755
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   756
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   757
					<reportElement
carlos@0
   758
						style="Detail_Red"
carlos@0
   759
						x="0"
carlos@0
   760
						y="0"
carlos@0
   761
						width="307"
carlos@0
   762
						height="14"
juanpablo@726
   763
						key="textField-4"/>
juanpablo@726
   764
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#666666" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   765
					<textElement>
juanpablo@726
   766
						<font/>
juanpablo@726
   767
					</textElement>
juanpablo@726
   768
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PRODUCT}]]></textFieldExpression>
juanpablo@726
   769
				</textField>
juanpablo@726
   770
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   771
					<reportElement
carlos@0
   772
						style="Detail_Red"
carlos@0
   773
						x="307"
carlos@0
   774
						y="0"
carlos@0
   775
						width="70"
carlos@0
   776
						height="14"
juanpablo@726
   777
						key="textField-5"/>
juanpablo@726
   778
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#666666" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   779
					<textElement textAlignment="Right">
juanpablo@726
   780
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   781
					</textElement>
juanpablo@726
   782
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{NEEDED}!=null)?$P{NUMBERFORMAT}.format($F{NEEDED}):new String(" ")]]></textFieldExpression>
juanpablo@726
   783
				</textField>
juanpablo@726
   784
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   785
					<reportElement
carlos@0
   786
						style="Detail_Red"
carlos@0
   787
						x="377"
carlos@0
   788
						y="0"
carlos@0
   789
						width="70"
carlos@0
   790
						height="14"
juanpablo@726
   791
						key="textField-6"/>
juanpablo@726
   792
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#666666" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   793
					<textElement textAlignment="Right">
juanpablo@726
   794
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   795
					</textElement>
juanpablo@726
   796
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{STOCK}!=null)?$P{NUMBERFORMAT}.format($F{STOCK}):new String(" ")]]></textFieldExpression>
juanpablo@726
   797
				</textField>
juanpablo@726
   798
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   799
					<reportElement
carlos@0
   800
						style="Detail_Red"
carlos@0
   801
						x="447"
carlos@0
   802
						y="0"
carlos@0
   803
						width="70"
carlos@0
   804
						height="14"
juanpablo@726
   805
						key="textField-7"/>
juanpablo@726
   806
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#666666" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   807
					<textElement textAlignment="Right">
juanpablo@726
   808
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   809
					</textElement>
juanpablo@726
   810
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{INPROCESS}!=null)?$P{NUMBERFORMAT}.format($F{INPROCESS}):new String(" ")]]></textFieldExpression>
juanpablo@726
   811
				</textField>
juanpablo@726
   812
				</frame>			</band>
juanpablo@726
   813
		</detail>
juanpablo@726
   814
		<columnFooter>
juanpablo@726
   815
			<band height="4"  isSplitAllowed="true" >
juanpablo@726
   816
			</band>
juanpablo@726
   817
		</columnFooter>
juanpablo@726
   818
		<pageFooter>
juanpablo@726
   819
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   820
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   821
					<reportElement
carlos@0
   822
						style="Report_Footer"
carlos@0
   823
						x="402"
carlos@0
   824
						y="4"
carlos@0
   825
						width="95"
carlos@0
   826
						height="16"
juanpablo@726
   827
						key="textField"/>
juanpablo@726
   828
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   829
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   830
						<font fontName="Helvetica" size="10"/>
juanpablo@726
   831
					</textElement>
juanpablo@726
   832
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@726
   833
				</textField>
juanpablo@726
   834
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   835
					<reportElement
carlos@0
   836
						style="Report_Footer"
carlos@0
   837
						x="499"
carlos@0
   838
						y="4"
carlos@0
   839
						width="36"
carlos@0
   840
						height="16"
carlos@0
   841
						forecolor="#000000"
carlos@0
   842
						backcolor="#FFFFFF"
juanpablo@726
   843
						key="textField"/>
juanpablo@726
   844
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   845
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
juanpablo@726
   846
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
juanpablo@726
   847
					</textElement>
juanpablo@726
   848
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@726
   849
				</textField>
juanpablo@726
   850
				<line direction="TopDown">
carlos@0
   851
					<reportElement
carlos@0
   852
						x="0"
carlos@0
   853
						y="1"
carlos@0
   854
						width="535"
carlos@0
   855
						height="0"
carlos@0
   856
						forecolor="#000000"
juanpablo@726
   857
						key="line"/>
juanpablo@726
   858
					<graphicElement stretchType="NoStretch" pen="2Point"/>
juanpablo@726
   859
				</line>
juanpablo@726
   860
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   861
					<reportElement
carlos@0
   862
						style="Report_Footer"
carlos@0
   863
						x="277"
carlos@0
   864
						y="4"
carlos@0
   865
						width="69"
carlos@0
   866
						height="16"
juanpablo@726
   867
						key="textField"/>
juanpablo@726
   868
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   869
					<textElement verticalAlignment="Middle">
juanpablo@726
   870
						<font fontName="Times-Roman" size="10"/>
juanpablo@726
   871
					</textElement>
juanpablo@726
   872
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@726
   873
				</textField>
juanpablo@726
   874
				<staticText>
carlos@0
   875
					<reportElement
carlos@0
   876
						style="Report_Footer"
carlos@0
   877
						x="198"
carlos@0
   878
						y="4"
carlos@0
   879
						width="76"
carlos@0
   880
						height="16"
juanpablo@726
   881
						key="staticText-1"/>
juanpablo@726
   882
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   883
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   884
						<font/>
juanpablo@726
   885
					</textElement>
juanpablo@726
   886
				<text><![CDATA[Printed on]]></text>
juanpablo@726
   887
				</staticText>
juanpablo@726
   888
			</band>
juanpablo@726
   889
		</pageFooter>
juanpablo@726
   890
		<summary>
juanpablo@726
   891
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   892
			</band>
juanpablo@726
   893
		</summary>
juanpablo@726
   894
</jasperReport>