src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 752 bc18bf2d37e1
child 1666 38b3edbe3894
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="ReportPurchaseOrder"
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="10"
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="10"
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
		fontName="Bitstream Vera Sans"
juanpablo@726
    90
		fontSize="11"
juanpablo@726
    91
		isBold="true"
juanpablo@726
    92
	/>
juanpablo@726
    93
	<style 
juanpablo@726
    94
		name="Group_Data_Field"
juanpablo@726
    95
		isDefault="false"
juanpablo@726
    96
		fontName="Bitstream Vera Sans"
juanpablo@726
    97
		fontSize="11"
juanpablo@726
    98
	/>
juanpablo@726
    99
	<style 
juanpablo@726
   100
		name="Detail_Header"
juanpablo@726
   101
		isDefault="false"
juanpablo@726
   102
		mode="Opaque"
juanpablo@726
   103
		forecolor="#FFFFFF"
juanpablo@726
   104
		backcolor="#5D5D5D"
juanpablo@726
   105
		vAlign="Middle"
juanpablo@726
   106
		leftBorder="1Point"
juanpablo@726
   107
		leftBorderColor="#FFFFFF"
juanpablo@726
   108
		leftPadding="5"
juanpablo@726
   109
		rightBorder="1Point"
juanpablo@726
   110
		rightBorderColor="#FFFFFF"
juanpablo@726
   111
		fontName="Bitstream Vera Sans"
juanpablo@726
   112
		fontSize="10"
juanpablo@726
   113
		isBold="true"
juanpablo@726
   114
	/>
juanpablo@726
   115
	<style 
juanpablo@726
   116
		name="Detail_Line"
juanpablo@726
   117
		isDefault="false"
juanpablo@726
   118
		fontName="Bitstream Vera Sans"
juanpablo@726
   119
		fontSize="10"
juanpablo@726
   120
	>
juanpablo@726
   121
juanpablo@726
   122
		<conditionalStyle>
juanpablo@726
   123
			<conditionExpression><![CDATA[new Boolean($V{DOCUMENTNO_COUNT}.intValue()%2==0)]]></conditionExpression>
juanpablo@726
   124
			<style 
juanpablo@726
   125
				name="Detail_Line"
juanpablo@726
   126
				isDefault="false"
juanpablo@726
   127
				mode="Opaque"
juanpablo@726
   128
				backcolor="#CCCCCC"
juanpablo@726
   129
			/>
juanpablo@726
   130
		</conditionalStyle>
juanpablo@726
   131
	</style>
juanpablo@726
   132
	<style 
juanpablo@726
   133
		name="Total_Gray"
juanpablo@726
   134
		isDefault="false"
juanpablo@726
   135
		mode="Opaque"
juanpablo@726
   136
		forecolor="#000000"
juanpablo@726
   137
		backcolor="#CCCCCC"
juanpablo@726
   138
	/>
juanpablo@726
   139
	<style 
juanpablo@726
   140
		name="Detail_Data_Label"
juanpablo@726
   141
		isDefault="false"
juanpablo@726
   142
		mode="Opaque"
juanpablo@726
   143
		backcolor="#CCCCCC"
juanpablo@726
   144
		fontName="Bitstream Vera Sans"
juanpablo@726
   145
		fontSize="10"
juanpablo@726
   146
		isBold="true"
juanpablo@726
   147
	/>
juanpablo@726
   148
	<style 
juanpablo@726
   149
		name="Detail_Data_Field"
juanpablo@726
   150
		isDefault="false"
juanpablo@726
   151
		mode="Opaque"
juanpablo@726
   152
		backcolor="#CCCCCC"
juanpablo@726
   153
		fontName="Bitstream Vera Sans"
juanpablo@726
   154
		fontSize="10"
juanpablo@726
   155
	/>
juanpablo@726
   156
	<style 
juanpablo@726
   157
		name="Group_Footer"
juanpablo@726
   158
		isDefault="false"
juanpablo@726
   159
		fontName="Bitstream Vera Sans"
juanpablo@726
   160
		fontSize="11"
juanpablo@726
   161
		isBold="true"
juanpablo@726
   162
	/>
juanpablo@726
   163
	<style 
juanpablo@726
   164
		name="Report_Footer"
juanpablo@726
   165
		isDefault="true"
juanpablo@726
   166
		vAlign="Middle"
juanpablo@726
   167
		fontName="Bitstream Vera Sans"
juanpablo@726
   168
		fontSize="11"
juanpablo@726
   169
	/>
juanpablo@726
   170
juanpablo@726
   171
	<parameter name="C_BPartner_ID" isForPrompting="true" class="java.lang.String">
juanpablo@726
   172
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   173
	</parameter>
juanpablo@726
   174
	<parameter name="DateFrom" isForPrompting="false" class="java.util.Date">
juanpablo@726
   175
		<defaultValueExpression ><![CDATA[(new SimpleDateFormat("dd-MM-yyyy")).parse("01-04-1900")]]></defaultValueExpression>
juanpablo@726
   176
	</parameter>
juanpablo@726
   177
	<parameter name="aux_datefrom" isForPrompting="false" class="java.lang.String">
juanpablo@726
   178
		<defaultValueExpression ><![CDATA[$P{DateFrom}==null ? "" : " AND C_ORDER.DATEORDERED >= TO_DATE('01-01-2000', "+ $P{DateFormat} + ")"]]></defaultValueExpression>
juanpablo@726
   179
	</parameter>
juanpablo@726
   180
	<parameter name="aux_partner" isForPrompting="false" class="java.lang.String">
juanpablo@726
   181
		<defaultValueExpression ><![CDATA[$P{C_BPartner_ID}.equals("") ? " " : " AND C_ORDER.C_BPARTNER_ID = " + $P{C_BPartner_ID}]]></defaultValueExpression>
juanpablo@726
   182
	</parameter>
juanpablo@726
   183
	<parameter name="DateFormat" isForPrompting="false" class="java.lang.String">
juanpablo@726
   184
		<defaultValueExpression ><![CDATA["DD-MM-YYYY"]]></defaultValueExpression>
juanpablo@726
   185
	</parameter>
juanpablo@726
   186
	<parameter name="DateTo" isForPrompting="false" class="java.util.Date">
juanpablo@726
   187
		<defaultValueExpression ><![CDATA[(new SimpleDateFormat("dd-MM-yyyy")).parse("01-04-3000")]]></defaultValueExpression>
juanpablo@726
   188
	</parameter>
juanpablo@726
   189
	<parameter name="M_Warehouse_ID" isForPrompting="false" class="java.lang.String">
juanpablo@726
   190
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   191
	</parameter>
juanpablo@726
   192
	<parameter name="aux_warehouse" isForPrompting="false" class="java.lang.String">
juanpablo@726
   193
		<defaultValueExpression ><![CDATA[$P{M_Warehouse_ID}.equals("") ? " " : " AND C_ORDER.M_WAREHOUSE_ID = " + $P{M_Warehouse_ID}]]></defaultValueExpression>
juanpablo@726
   194
	</parameter>
juanpablo@726
   195
	<parameter name="C_Project_ID" isForPrompting="false" class="java.lang.String">
juanpablo@726
   196
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   197
	</parameter>
juanpablo@726
   198
	<parameter name="aux_project" isForPrompting="false" class="java.lang.String">
juanpablo@726
   199
		<defaultValueExpression ><![CDATA[$P{C_Project_ID}.equals("") ? " " : " AND C_ORDER.C_PROJECT_ID = " + $P{C_Project_ID}]]></defaultValueExpression>
juanpablo@726
   200
	</parameter>
juanpablo@726
   201
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   202
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
juanpablo@726
   203
	</parameter>
juanpablo@726
   204
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
juanpablo@726
   205
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
carlos@0
   206
	<queryString><![CDATA[SELECT C_ORDER.DOCUMENTNO AS DOCUMENTNO, C_ORDER.DATEORDERED AS DATEORDERED, C_BPARTNER.NAME AS CLIENT_NAME, SUM(C_ORDERLINE.QTYORDERED) AS QUANTITYORDER, 
carlos@0
   207
  C_ORDERLINE.PRICEACTUAL AS PRICEACTUAL, SUM(C_ORDERLINE.LINENETAMT) AS PRICELIST, M_PRODUCT.NAME AS PRODUCT_NAME, C_UOM.NAME AS UOMNAME
carlos@0
   208
FROM C_ORDER, C_ORDERLINE, C_BPARTNER, M_PRODUCT, C_UOM
carlos@0
   209
WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
carlos@0
   210
  AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID
carlos@0
   211
  AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
carlos@0
   212
  AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
carlos@0
   213
  AND 1=1  $P!{aux_partner}
carlos@0
   214
  $P!{aux_warehouse} 
carlos@0
   215
  $P!{aux_project}
carlos@0
   216
  AND C_ORDER.DATEORDERED >= $P{DateFrom}
phillip@752
   217
  AND C_ORDER.DATEORDERED <= $P{DateTo}
carlos@0
   218
  AND C_ORDER.ISSOTRX = 'N'
carlos@0
   219
GROUP BY C_BPARTNER.NAME, C_ORDERLINE.PRICEACTUAL, M_PRODUCT.NAME, C_UOM.NAME, C_ORDER.DOCUMENTNO, C_ORDER.DATEORDERED
juanpablo@726
   220
ORDER BY C_BPARTNER.NAME, C_ORDER.DATEORDERED]]></queryString>
juanpablo@726
   221
juanpablo@726
   222
	<field name="DOCUMENTNO" class="java.lang.String"/>
juanpablo@726
   223
	<field name="DATEORDERED" class="java.util.Date"/>
juanpablo@726
   224
	<field name="CLIENT_NAME" class="java.lang.String"/>
juanpablo@726
   225
	<field name="QUANTITYORDER" class="java.math.BigDecimal"/>
juanpablo@726
   226
	<field name="PRICEACTUAL" class="java.math.BigDecimal"/>
juanpablo@726
   227
	<field name="PRICELIST" class="java.math.BigDecimal"/>
juanpablo@726
   228
	<field name="PRODUCT_NAME" class="java.lang.String"/>
juanpablo@726
   229
	<field name="UOMNAME" class="java.lang.String"/>
juanpablo@726
   230
juanpablo@726
   231
	<variable name="LOCALE" class="java.util.Locale" resetType="Report" calculation="Nothing">
juanpablo@726
   232
		<variableExpression><![CDATA[new Locale($P{LANGUAGE}.substring(0,2),$P{LANGUAGE}.substring(3,5))]]></variableExpression>
juanpablo@726
   233
	</variable>
juanpablo@726
   234
	<variable name="TOTAL_CLIENT" class="java.math.BigDecimal" resetType="Group" resetGroup="CLIENT_NAME" calculation="Sum">
juanpablo@726
   235
		<variableExpression><![CDATA[$F{PRICELIST}]]></variableExpression>
juanpablo@726
   236
	</variable>
juanpablo@726
   237
	<variable name="TOTAL_DOCNO" class="java.math.BigDecimal" resetType="Group" resetGroup="DOCUMENTNO" calculation="Sum">
juanpablo@726
   238
		<variableExpression><![CDATA[$F{PRICELIST}]]></variableExpression>
juanpablo@726
   239
	</variable>
juanpablo@726
   240
juanpablo@726
   241
		<group  name="CLIENT_NAME" >
juanpablo@726
   242
			<groupExpression><![CDATA[$F{CLIENT_NAME}]]></groupExpression>
juanpablo@726
   243
			<groupHeader>
juanpablo@726
   244
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   245
				<staticText>
carlos@0
   246
					<reportElement
carlos@0
   247
						style="GroupHeader_DarkGray"
carlos@0
   248
						mode="Opaque"
carlos@0
   249
						x="0"
carlos@0
   250
						y="0"
carlos@0
   251
						width="80"
carlos@0
   252
						height="16"
juanpablo@726
   253
						key="staticText"/>
juanpablo@726
   254
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   255
					<textElement>
juanpablo@726
   256
						<font/>
juanpablo@726
   257
					</textElement>
juanpablo@726
   258
				<text><![CDATA[Client]]></text>
juanpablo@726
   259
				</staticText>
juanpablo@726
   260
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   261
					<reportElement
carlos@0
   262
						style="GroupHeader_DarkGray"
carlos@0
   263
						mode="Opaque"
carlos@0
   264
						x="80"
carlos@0
   265
						y="0"
carlos@0
   266
						width="455"
carlos@0
   267
						height="16"
juanpablo@726
   268
						key="textField"/>
juanpablo@726
   269
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   270
					<textElement>
juanpablo@726
   271
						<font/>
juanpablo@726
   272
					</textElement>
juanpablo@726
   273
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CLIENT_NAME}]]></textFieldExpression>
juanpablo@726
   274
				</textField>
juanpablo@726
   275
				<line direction="TopDown">
carlos@0
   276
					<reportElement
carlos@0
   277
						style="Report_Footer"
carlos@0
   278
						x="535"
carlos@0
   279
						y="0"
carlos@0
   280
						width="0"
carlos@0
   281
						height="14"
carlos@0
   282
						forecolor="#555555"
juanpablo@726
   283
						key="line-7"/>
juanpablo@726
   284
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   285
				</line>
juanpablo@726
   286
			</band>
juanpablo@726
   287
			</groupHeader>
juanpablo@726
   288
			<groupFooter>
juanpablo@726
   289
			<band height="48"  isSplitAllowed="true" >
juanpablo@726
   290
				<line direction="TopDown">
carlos@0
   291
					<reportElement
carlos@0
   292
						style="Report_Footer"
carlos@0
   293
						x="0"
carlos@0
   294
						y="20"
carlos@0
   295
						width="535"
carlos@0
   296
						height="0"
carlos@0
   297
						forecolor="#555555"
juanpablo@726
   298
						key="line-13"/>
juanpablo@726
   299
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   300
				</line>
juanpablo@726
   301
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="CLIENT_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   302
					<reportElement
carlos@0
   303
						style="Total_Gray"
carlos@0
   304
						x="330"
carlos@0
   305
						y="0"
carlos@0
   306
						width="200"
carlos@0
   307
						height="16"
juanpablo@726
   308
						key="textField"/>
juanpablo@726
   309
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   310
					<textElement textAlignment="Right">
juanpablo@726
   311
						<font/>
juanpablo@726
   312
					</textElement>
juanpablo@726
   313
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{TOTAL_CLIENT}!=null)?$P{NUMBERFORMAT}.format($V{TOTAL_CLIENT}):new String(" ")]]></textFieldExpression>
juanpablo@726
   314
				</textField>
juanpablo@726
   315
				<line direction="TopDown">
carlos@0
   316
					<reportElement
carlos@0
   317
						style="Report_Footer"
carlos@0
   318
						x="535"
carlos@0
   319
						y="0"
carlos@0
   320
						width="0"
carlos@0
   321
						height="20"
carlos@0
   322
						forecolor="#555555"
juanpablo@726
   323
						key="line-14"/>
juanpablo@726
   324
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   325
				</line>
juanpablo@726
   326
				<line direction="TopDown">
carlos@0
   327
					<reportElement
carlos@0
   328
						style="Report_Footer"
carlos@0
   329
						x="0"
carlos@0
   330
						y="0"
carlos@0
   331
						width="0"
carlos@0
   332
						height="20"
carlos@0
   333
						forecolor="#555555"
juanpablo@726
   334
						key="line-15"/>
juanpablo@726
   335
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   336
				</line>
juanpablo@726
   337
				<staticText>
carlos@0
   338
					<reportElement
carlos@0
   339
						style="Report_Footer"
carlos@0
   340
						x="180"
carlos@0
   341
						y="0"
carlos@0
   342
						width="150"
carlos@0
   343
						height="16"
juanpablo@726
   344
						key="staticText-2"/>
juanpablo@726
   345
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   346
					<textElement textAlignment="Right">
juanpablo@726
   347
						<font/>
juanpablo@726
   348
					</textElement>
juanpablo@726
   349
				<text><![CDATA[Total Client:]]></text>
juanpablo@726
   350
				</staticText>
juanpablo@726
   351
			</band>
juanpablo@726
   352
			</groupFooter>
juanpablo@726
   353
		</group>
juanpablo@726
   354
		<group  name="DOCUMENTNO" >
juanpablo@726
   355
			<groupExpression><![CDATA[$F{DOCUMENTNO}]]></groupExpression>
juanpablo@726
   356
			<groupHeader>
juanpablo@726
   357
			<band height="48"  isSplitAllowed="true" >
juanpablo@726
   358
				<staticText>
carlos@0
   359
					<reportElement
carlos@0
   360
						style="GroupHeader_DarkGray"
carlos@0
   361
						x="10"
carlos@0
   362
						y="10"
carlos@0
   363
						width="110"
carlos@0
   364
						height="14"
juanpablo@726
   365
						key="staticText"/>
juanpablo@726
   366
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   367
					<textElement>
juanpablo@726
   368
						<font/>
juanpablo@726
   369
					</textElement>
juanpablo@726
   370
				<text><![CDATA[Document No.]]></text>
juanpablo@726
   371
				</staticText>
juanpablo@726
   372
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   373
					<reportElement
carlos@0
   374
						style="GroupHeader_DarkGray"
carlos@0
   375
						x="120"
carlos@0
   376
						y="10"
carlos@0
   377
						width="140"
carlos@0
   378
						height="14"
juanpablo@726
   379
						key="textField"/>
juanpablo@726
   380
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   381
					<textElement>
juanpablo@726
   382
						<font pdfFontName="Helvetica"/>
juanpablo@726
   383
					</textElement>
juanpablo@726
   384
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
juanpablo@726
   385
				</textField>
juanpablo@726
   386
				<textField isStretchWithOverflow="false" pattern="dd-MM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   387
					<reportElement
carlos@0
   388
						style="GroupHeader_DarkGray"
carlos@0
   389
						x="340"
carlos@0
   390
						y="10"
carlos@0
   391
						width="195"
carlos@0
   392
						height="14"
juanpablo@726
   393
						key="textField"/>
juanpablo@726
   394
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   395
					<textElement>
juanpablo@726
   396
						<font/>
juanpablo@726
   397
					</textElement>
juanpablo@726
   398
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{DATEORDERED}]]></textFieldExpression>
juanpablo@726
   399
				</textField>
juanpablo@726
   400
				<staticText>
carlos@0
   401
					<reportElement
carlos@0
   402
						style="GroupHeader_DarkGray"
carlos@0
   403
						x="260"
carlos@0
   404
						y="10"
carlos@0
   405
						width="80"
carlos@0
   406
						height="14"
juanpablo@726
   407
						key="element-90"/>
juanpablo@726
   408
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   409
					<textElement>
juanpablo@726
   410
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   411
					</textElement>
juanpablo@726
   412
				<text><![CDATA[Date:]]></text>
juanpablo@726
   413
				</staticText>
juanpablo@726
   414
				<staticText>
carlos@0
   415
					<reportElement
carlos@0
   416
						style="Detail_Header"
carlos@0
   417
						x="20"
carlos@0
   418
						y="34"
carlos@0
   419
						width="160"
carlos@0
   420
						height="14"
juanpablo@726
   421
						key="element-90"/>
juanpablo@726
   422
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   423
					<textElement>
juanpablo@726
   424
						<font/>
juanpablo@726
   425
					</textElement>
juanpablo@726
   426
				<text><![CDATA[Product]]></text>
juanpablo@726
   427
				</staticText>
juanpablo@726
   428
				<staticText>
carlos@0
   429
					<reportElement
carlos@0
   430
						style="Detail_Header"
carlos@0
   431
						x="180"
carlos@0
   432
						y="34"
carlos@0
   433
						width="80"
carlos@0
   434
						height="14"
juanpablo@726
   435
						key="element-90"/>
juanpablo@726
   436
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   437
					<textElement textAlignment="Right">
juanpablo@726
   438
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   439
					</textElement>
juanpablo@726
   440
				<text><![CDATA[Quantity]]></text>
juanpablo@726
   441
				</staticText>
juanpablo@726
   442
				<staticText>
carlos@0
   443
					<reportElement
carlos@0
   444
						style="Detail_Header"
carlos@0
   445
						x="260"
carlos@0
   446
						y="34"
carlos@0
   447
						width="70"
carlos@0
   448
						height="14"
juanpablo@726
   449
						key="element-90"/>
juanpablo@726
   450
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   451
					<textElement textAlignment="Left">
juanpablo@726
   452
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   453
					</textElement>
juanpablo@726
   454
				<text><![CDATA[UOM]]></text>
juanpablo@726
   455
				</staticText>
juanpablo@726
   456
				<staticText>
carlos@0
   457
					<reportElement
carlos@0
   458
						style="Detail_Header"
carlos@0
   459
						x="330"
carlos@0
   460
						y="34"
carlos@0
   461
						width="100"
carlos@0
   462
						height="14"
juanpablo@726
   463
						key="element-90"/>
juanpablo@726
   464
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   465
					<textElement textAlignment="Right">
juanpablo@726
   466
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   467
					</textElement>
juanpablo@726
   468
				<text><![CDATA[Price]]></text>
juanpablo@726
   469
				</staticText>
juanpablo@726
   470
				<staticText>
carlos@0
   471
					<reportElement
carlos@0
   472
						style="Detail_Header"
carlos@0
   473
						x="430"
carlos@0
   474
						y="34"
carlos@0
   475
						width="100"
carlos@0
   476
						height="14"
juanpablo@726
   477
						key="element-90"/>
juanpablo@726
   478
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   479
					<textElement textAlignment="Right">
juanpablo@726
   480
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   481
					</textElement>
juanpablo@726
   482
				<text><![CDATA[Amount]]></text>
juanpablo@726
   483
				</staticText>
juanpablo@726
   484
				<line direction="TopDown">
carlos@0
   485
					<reportElement
carlos@0
   486
						style="Report_Footer"
carlos@0
   487
						x="0"
carlos@0
   488
						y="0"
carlos@0
   489
						width="0"
carlos@0
   490
						height="48"
carlos@0
   491
						forecolor="#555555"
juanpablo@726
   492
						key="line-1"/>
juanpablo@726
   493
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   494
				</line>
juanpablo@726
   495
				<line direction="TopDown">
carlos@0
   496
					<reportElement
carlos@0
   497
						style="Report_Footer"
carlos@0
   498
						x="10"
carlos@0
   499
						y="24"
carlos@0
   500
						width="0"
carlos@0
   501
						height="24"
carlos@0
   502
						forecolor="#555555"
juanpablo@726
   503
						key="line-2"/>
juanpablo@726
   504
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   505
				</line>
juanpablo@726
   506
				<line direction="TopDown">
carlos@0
   507
					<reportElement
carlos@0
   508
						style="Report_Footer"
carlos@0
   509
						x="535"
carlos@0
   510
						y="0"
carlos@0
   511
						width="0"
carlos@0
   512
						height="48"
carlos@0
   513
						forecolor="#555555"
juanpablo@726
   514
						key="line-6"/>
juanpablo@726
   515
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   516
				</line>
juanpablo@726
   517
			</band>
juanpablo@726
   518
			</groupHeader>
juanpablo@726
   519
			<groupFooter>
juanpablo@726
   520
			<band height="32"  isSplitAllowed="true" >
juanpablo@726
   521
				<line direction="TopDown">
carlos@0
   522
					<reportElement
carlos@0
   523
						style="Report_Footer"
carlos@0
   524
						x="20"
carlos@0
   525
						y="0"
carlos@0
   526
						width="510"
carlos@0
   527
						height="0"
carlos@0
   528
						forecolor="#555555"
juanpablo@726
   529
						key="line-8"/>
juanpablo@726
   530
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   531
				</line>
juanpablo@726
   532
				<line direction="TopDown">
carlos@0
   533
					<reportElement
carlos@0
   534
						style="Report_Footer"
carlos@0
   535
						x="10"
carlos@0
   536
						y="0"
carlos@0
   537
						width="0"
carlos@0
   538
						height="28"
carlos@0
   539
						forecolor="#555555"
juanpablo@726
   540
						key="line-9"/>
juanpablo@726
   541
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   542
				</line>
juanpablo@726
   543
				<line direction="TopDown">
carlos@0
   544
					<reportElement
carlos@0
   545
						style="Report_Footer"
carlos@0
   546
						x="535"
carlos@0
   547
						y="0"
carlos@0
   548
						width="0"
carlos@0
   549
						height="32"
carlos@0
   550
						forecolor="#555555"
juanpablo@726
   551
						key="line-10"/>
juanpablo@726
   552
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   553
				</line>
juanpablo@726
   554
				<line direction="TopDown">
carlos@0
   555
					<reportElement
carlos@0
   556
						style="Report_Footer"
carlos@0
   557
						x="10"
carlos@0
   558
						y="28"
carlos@0
   559
						width="525"
carlos@0
   560
						height="0"
carlos@0
   561
						forecolor="#555555"
juanpablo@726
   562
						key="line-11"/>
juanpablo@726
   563
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   564
				</line>
juanpablo@726
   565
				<line direction="TopDown">
carlos@0
   566
					<reportElement
carlos@0
   567
						style="Report_Footer"
carlos@0
   568
						x="0"
carlos@0
   569
						y="0"
carlos@0
   570
						width="0"
carlos@0
   571
						height="32"
carlos@0
   572
						forecolor="#555555"
juanpablo@726
   573
						key="line-12"/>
juanpablo@726
   574
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   575
				</line>
juanpablo@726
   576
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="DOCUMENTNO"  hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   577
					<reportElement
carlos@0
   578
						style="Total_Gray"
carlos@0
   579
						x="330"
carlos@0
   580
						y="6"
carlos@0
   581
						width="200"
carlos@0
   582
						height="16"
juanpablo@726
   583
						key="textField-1"/>
juanpablo@726
   584
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   585
					<textElement textAlignment="Right">
juanpablo@726
   586
						<font/>
juanpablo@726
   587
					</textElement>
juanpablo@726
   588
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{TOTAL_DOCNO}!=null)?$P{NUMBERFORMAT}.format($V{TOTAL_DOCNO}):new String(" ")]]></textFieldExpression>
juanpablo@726
   589
				</textField>
juanpablo@726
   590
				<staticText>
carlos@0
   591
					<reportElement
carlos@0
   592
						style="Report_Footer"
carlos@0
   593
						x="180"
carlos@0
   594
						y="6"
carlos@0
   595
						width="150"
carlos@0
   596
						height="16"
juanpablo@726
   597
						key="staticText-1"/>
juanpablo@726
   598
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   599
					<textElement textAlignment="Right">
juanpablo@726
   600
						<font/>
juanpablo@726
   601
					</textElement>
juanpablo@726
   602
				<text><![CDATA[Total Order:]]></text>
juanpablo@726
   603
				</staticText>
juanpablo@726
   604
			</band>
juanpablo@726
   605
			</groupFooter>
juanpablo@726
   606
		</group>
juanpablo@726
   607
		<background>
juanpablo@726
   608
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   609
			</band>
juanpablo@726
   610
		</background>
juanpablo@726
   611
		<title>
juanpablo@726
   612
			<band height="24"  isSplitAllowed="true" >
juanpablo@726
   613
				<staticText>
carlos@0
   614
					<reportElement
carlos@0
   615
						style="Report_Title"
carlos@0
   616
						x="0"
carlos@0
   617
						y="0"
carlos@0
   618
						width="412"
carlos@0
   619
						height="24"
juanpablo@726
   620
						key="staticText"/>
juanpablo@726
   621
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   622
					<textElement>
juanpablo@726
   623
						<font/>
juanpablo@726
   624
					</textElement>
juanpablo@726
   625
				<text><![CDATA[Purchase Order Report]]></text>
juanpablo@726
   626
				</staticText>
juanpablo@726
   627
			</band>
juanpablo@726
   628
		</title>
juanpablo@726
   629
		<pageHeader>
juanpablo@726
   630
			<band height="9"  isSplitAllowed="true" >
juanpablo@726
   631
			</band>
juanpablo@726
   632
		</pageHeader>
juanpablo@726
   633
		<columnHeader>
juanpablo@726
   634
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   635
			</band>
juanpablo@726
   636
		</columnHeader>
juanpablo@726
   637
		<detail>
juanpablo@726
   638
			<band height="14"  isSplitAllowed="true" >
juanpablo@726
   639
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   640
					<reportElement
carlos@0
   641
						style="Detail_Line"
carlos@0
   642
						x="20"
carlos@0
   643
						y="0"
carlos@0
   644
						width="160"
carlos@0
   645
						height="14"
carlos@0
   646
						forecolor="#000000"
juanpablo@726
   647
						key="textField"/>
juanpablo@726
   648
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="5" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   649
					<textElement>
juanpablo@726
   650
						<font/>
juanpablo@726
   651
					</textElement>
juanpablo@726
   652
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRODUCT_NAME}!=null)?$F{PRODUCT_NAME}:new String(" ")]]></textFieldExpression>
juanpablo@726
   653
				</textField>
juanpablo@726
   654
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   655
					<reportElement
carlos@0
   656
						style="Detail_Line"
carlos@0
   657
						x="180"
carlos@0
   658
						y="0"
carlos@0
   659
						width="80"
carlos@0
   660
						height="14"
juanpablo@726
   661
						key="textField"/>
juanpablo@726
   662
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   663
					<textElement textAlignment="Right">
juanpablo@726
   664
						<font/>
juanpablo@726
   665
					</textElement>
juanpablo@726
   666
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{QUANTITYORDER}!=null)?$P{NUMBERFORMAT}.format($F{QUANTITYORDER}):new String(" ")]]></textFieldExpression>
juanpablo@726
   667
				</textField>
juanpablo@726
   668
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   669
					<reportElement
carlos@0
   670
						style="Detail_Line"
carlos@0
   671
						x="260"
carlos@0
   672
						y="0"
carlos@0
   673
						width="70"
carlos@0
   674
						height="14"
juanpablo@726
   675
						key="textField"/>
juanpablo@726
   676
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   677
					<textElement textAlignment="Left">
juanpablo@726
   678
						<font/>
juanpablo@726
   679
					</textElement>
juanpablo@726
   680
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{UOMNAME}!=null)?$F{UOMNAME}:new String(" ")]]></textFieldExpression>
juanpablo@726
   681
				</textField>
juanpablo@726
   682
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   683
					<reportElement
carlos@0
   684
						style="Detail_Line"
carlos@0
   685
						x="330"
carlos@0
   686
						y="0"
carlos@0
   687
						width="100"
carlos@0
   688
						height="14"
juanpablo@726
   689
						key="textField"/>
juanpablo@726
   690
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   691
					<textElement textAlignment="Right">
juanpablo@726
   692
						<font/>
juanpablo@726
   693
					</textElement>
juanpablo@726
   694
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRICEACTUAL}!=null)?$P{NUMBERFORMAT}.format($F{PRICEACTUAL}):new String(" ")]]></textFieldExpression>
juanpablo@726
   695
				</textField>
juanpablo@726
   696
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   697
					<reportElement
carlos@0
   698
						style="Detail_Line"
carlos@0
   699
						x="430"
carlos@0
   700
						y="0"
carlos@0
   701
						width="100"
carlos@0
   702
						height="14"
juanpablo@726
   703
						key="textField"/>
juanpablo@726
   704
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="1Point" rightBorderColor="#555555" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   705
					<textElement textAlignment="Right">
juanpablo@726
   706
						<font/>
juanpablo@726
   707
					</textElement>
juanpablo@726
   708
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRICELIST}!=null)?$P{NUMBERFORMAT}.format($F{PRICELIST}):new String(" ")]]></textFieldExpression>
juanpablo@726
   709
				</textField>
juanpablo@726
   710
				<line direction="TopDown">
carlos@0
   711
					<reportElement
carlos@0
   712
						style="Report_Footer"
carlos@0
   713
						x="10"
carlos@0
   714
						y="0"
carlos@0
   715
						width="0"
carlos@0
   716
						height="14"
carlos@0
   717
						forecolor="#555555"
juanpablo@726
   718
						key="line-3"/>
juanpablo@726
   719
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   720
				</line>
juanpablo@726
   721
				<line direction="TopDown">
carlos@0
   722
					<reportElement
carlos@0
   723
						style="Report_Footer"
carlos@0
   724
						x="0"
carlos@0
   725
						y="0"
carlos@0
   726
						width="0"
carlos@0
   727
						height="14"
carlos@0
   728
						forecolor="#555555"
juanpablo@726
   729
						key="line-4"/>
juanpablo@726
   730
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   731
				</line>
juanpablo@726
   732
				<line direction="TopDown">
carlos@0
   733
					<reportElement
carlos@0
   734
						style="Report_Footer"
carlos@0
   735
						x="535"
carlos@0
   736
						y="0"
carlos@0
   737
						width="0"
carlos@0
   738
						height="14"
carlos@0
   739
						forecolor="#555555"
juanpablo@726
   740
						key="line-5"/>
juanpablo@726
   741
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   742
				</line>
juanpablo@726
   743
			</band>
juanpablo@726
   744
		</detail>
juanpablo@726
   745
		<columnFooter>
juanpablo@726
   746
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   747
			</band>
juanpablo@726
   748
		</columnFooter>
juanpablo@726
   749
		<pageFooter>
juanpablo@726
   750
			<band height="27"  isSplitAllowed="true" >
juanpablo@726
   751
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   752
					<reportElement
carlos@0
   753
						x="325"
carlos@0
   754
						y="4"
carlos@0
   755
						width="170"
carlos@0
   756
						height="19"
juanpablo@726
   757
						key="textField"/>
juanpablo@726
   758
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   759
					<textElement textAlignment="Right">
juanpablo@726
   760
						<font fontName="Helvetica" size="10"/>
juanpablo@726
   761
					</textElement>
juanpablo@726
   762
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@726
   763
				</textField>
juanpablo@726
   764
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   765
					<reportElement
carlos@0
   766
						x="499"
carlos@0
   767
						y="4"
carlos@0
   768
						width="36"
carlos@0
   769
						height="19"
carlos@0
   770
						forecolor="#000000"
carlos@0
   771
						backcolor="#FFFFFF"
juanpablo@726
   772
						key="textField"/>
juanpablo@726
   773
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   774
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
juanpablo@726
   775
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
juanpablo@726
   776
					</textElement>
juanpablo@726
   777
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@726
   778
				</textField>
juanpablo@726
   779
				<line direction="TopDown">
carlos@0
   780
					<reportElement
carlos@0
   781
						x="0"
carlos@0
   782
						y="1"
carlos@0
   783
						width="535"
carlos@0
   784
						height="0"
carlos@0
   785
						forecolor="#000000"
juanpablo@726
   786
						key="line"/>
juanpablo@726
   787
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   788
				</line>
juanpablo@726
   789
				<textField isStretchWithOverflow="false" pattern="dd-MM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   790
					<reportElement
carlos@0
   791
						style="default"
carlos@0
   792
						x="1"
carlos@0
   793
						y="6"
carlos@0
   794
						width="79"
carlos@0
   795
						height="14"
juanpablo@726
   796
						key="textField"/>
juanpablo@726
   797
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   798
					<textElement>
juanpablo@726
   799
						<font fontName="Times-Roman" size="10"/>
juanpablo@726
   800
					</textElement>
juanpablo@726
   801
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@726
   802
				</textField>
juanpablo@726
   803
			</band>
juanpablo@726
   804
		</pageFooter>
juanpablo@726
   805
		<summary>
juanpablo@726
   806
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   807
			</band>
juanpablo@726
   808
		</summary>
juanpablo@726
   809
</jasperReport>