src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
author Rafa Roda Palacios <rafael.roda@openbravo.com>
Thu, 30 Oct 2008 17:30:39 +0000
changeset 1868 b462ce988fa2
parent 726 dac2a1486bd3
child 2199 efd783b991af
permissions -rw-r--r--
Merged back 'multi-currency-reports-review' branch into trunk.
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="ReportInvoiceCustomerJR"
juanpablo@726
     6
		 columnCount="1"
juanpablo@726
     7
		 printOrder="Vertical"
rafael@1868
     8
		 orientation="Landscape"
rafael@1868
     9
		 pageWidth="842"
rafael@1868
    10
		 pageHeight="595"
rafael@1868
    11
		 columnWidth="782"
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="11"
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="Total_Field"
juanpablo@726
    50
		isDefault="false"
juanpablo@726
    51
		mode="Opaque"
juanpablo@726
    52
		forecolor="#000000"
juanpablo@726
    53
		backcolor="#CCCCCC"
juanpablo@726
    54
		vAlign="Middle"
juanpablo@726
    55
		leftPadding="5"
juanpablo@726
    56
		fontName="Bitstream Vera Sans"
juanpablo@726
    57
		fontSize="11"
juanpablo@726
    58
		isBold="true"
juanpablo@726
    59
	/>
juanpablo@726
    60
	<style 
juanpablo@726
    61
		name="Detail_Header"
juanpablo@726
    62
		isDefault="false"
juanpablo@726
    63
		mode="Opaque"
juanpablo@726
    64
		forecolor="#FFFFFF"
juanpablo@726
    65
		backcolor="#5D5D5D"
juanpablo@726
    66
		vAlign="Middle"
juanpablo@726
    67
		leftBorder="1Point"
juanpablo@726
    68
		leftBorderColor="#FFFFFF"
juanpablo@726
    69
		leftPadding="5"
juanpablo@726
    70
		rightBorder="1Point"
juanpablo@726
    71
		rightBorderColor="#FFFFFF"
juanpablo@726
    72
		fontName="Bitstream Vera Sans"
juanpablo@726
    73
		fontSize="11"
juanpablo@726
    74
		isBold="true"
juanpablo@726
    75
	/>
juanpablo@726
    76
	<style 
juanpablo@726
    77
		name="GroupHeader_DarkGray"
juanpablo@726
    78
		isDefault="false"
juanpablo@726
    79
		mode="Opaque"
juanpablo@726
    80
		forecolor="#FFFFFF"
juanpablo@726
    81
		backcolor="#555555"
juanpablo@726
    82
		vAlign="Middle"
juanpablo@726
    83
		leftPadding="5"
juanpablo@726
    84
		fontName="Bitstream Vera Sans"
juanpablo@726
    85
		fontSize="18"
juanpablo@726
    86
		isBold="true"
juanpablo@726
    87
	/>
juanpablo@726
    88
	<style 
juanpablo@726
    89
		name="GroupHeader_Gray"
juanpablo@726
    90
		isDefault="false"
juanpablo@726
    91
		mode="Opaque"
juanpablo@726
    92
		backcolor="#999999"
juanpablo@726
    93
	/>
juanpablo@726
    94
	<style 
juanpablo@726
    95
		name="Detail_Line"
juanpablo@726
    96
		isDefault="false"
juanpablo@726
    97
		fontName="Bitstream Vera Sans"
juanpablo@726
    98
		fontSize="11"
juanpablo@726
    99
	>
juanpablo@726
   100
juanpablo@726
   101
		<conditionalStyle>
juanpablo@726
   102
			<conditionExpression><![CDATA[new Boolean($V{DOCUMENTNO_COUNT}.intValue()%2==0)]]></conditionExpression>
juanpablo@726
   103
			<style 
juanpablo@726
   104
				name="Detail_Line"
juanpablo@726
   105
				isDefault="false"
juanpablo@726
   106
				mode="Opaque"
juanpablo@726
   107
				backcolor="#CCCCCC"
juanpablo@726
   108
			/>
juanpablo@726
   109
		</conditionalStyle>
juanpablo@726
   110
	</style>
juanpablo@726
   111
	<style 
juanpablo@726
   112
		name="Total_Gray"
juanpablo@726
   113
		isDefault="false"
juanpablo@726
   114
		mode="Opaque"
juanpablo@726
   115
		forecolor="#000000"
juanpablo@726
   116
		backcolor="#CCCCCC"
juanpablo@726
   117
	/>
juanpablo@726
   118
	<style 
juanpablo@726
   119
		name="Report_Data_Label"
juanpablo@726
   120
		isDefault="false"
juanpablo@726
   121
		fontName="Bitstream Vera Sans"
juanpablo@726
   122
		fontSize="11"
juanpablo@726
   123
		isBold="true"
juanpablo@726
   124
	/>
juanpablo@726
   125
	<style 
juanpablo@726
   126
		name="Report_Data_Field"
juanpablo@726
   127
		isDefault="false"
juanpablo@726
   128
		fontName="Bitstream Vera Sans"
juanpablo@726
   129
		fontSize="11"
juanpablo@726
   130
		isBold="false"
juanpablo@726
   131
	/>
juanpablo@726
   132
	<style 
juanpablo@726
   133
		name="Report_Footer"
juanpablo@726
   134
		isDefault="true"
juanpablo@726
   135
		fontName="Bitstream Vera Sans"
juanpablo@726
   136
		fontSize="11"
juanpablo@726
   137
	/>
juanpablo@726
   138
	<style 
juanpablo@726
   139
		name="Group_Data_Label"
juanpablo@726
   140
		isDefault="false"
juanpablo@726
   141
		fontName="Bitstream Vera Sans"
juanpablo@726
   142
		fontSize="14"
juanpablo@726
   143
		isBold="true"
juanpablo@726
   144
	/>
juanpablo@726
   145
	<style 
juanpablo@726
   146
		name="Group_Data_Field"
juanpablo@726
   147
		isDefault="false"
juanpablo@726
   148
		fontName="Bitstream Vera Sans"
juanpablo@726
   149
		fontSize="14"
juanpablo@726
   150
	/>
juanpablo@726
   151
	<style 
juanpablo@726
   152
		name="Detail_Data_Label"
juanpablo@726
   153
		isDefault="false"
juanpablo@726
   154
		mode="Opaque"
juanpablo@726
   155
		backcolor="#CCCCCC"
juanpablo@726
   156
		fontName="Bitstream Vera Sans"
juanpablo@726
   157
		fontSize="11"
juanpablo@726
   158
		isBold="true"
juanpablo@726
   159
	/>
juanpablo@726
   160
	<style 
juanpablo@726
   161
		name="Detail_Data_Field"
juanpablo@726
   162
		isDefault="false"
juanpablo@726
   163
		mode="Opaque"
juanpablo@726
   164
		backcolor="#CCCCCC"
juanpablo@726
   165
		fontName="Bitstream Vera Sans"
juanpablo@726
   166
		fontSize="11"
juanpablo@726
   167
	/>
juanpablo@726
   168
	<style 
juanpablo@726
   169
		name="Group_Footer"
juanpablo@726
   170
		isDefault="false"
juanpablo@726
   171
		fontName="Bitstream Vera Sans"
juanpablo@726
   172
		fontSize="11"
juanpablo@726
   173
		isBold="true"
juanpablo@726
   174
	/>
juanpablo@726
   175
juanpablo@726
   176
	<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   177
	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   178
	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   179
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   180
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
juanpablo@726
   181
	</parameter>
juanpablo@726
   182
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
juanpablo@726
   183
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
juanpablo@726
   184
	</parameter>
juanpablo@726
   185
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
juanpablo@726
   186
		<defaultValueExpression ><![CDATA["(0)"]]></defaultValueExpression>
juanpablo@726
   187
	</parameter>
juanpablo@726
   188
	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   189
		<defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
juanpablo@726
   190
	</parameter>
juanpablo@726
   191
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   192
	<parameter name="ReportData" isForPrompting="false" class="java.lang.String">
juanpablo@726
   193
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   194
	</parameter>
juanpablo@726
   195
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
juanpablo@726
   196
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
rafael@1868
   197
	<queryString><![CDATA[SELECT COALESCE(C_INVOICE.POREFERENCE, C_INVOICE.DOCUMENTNO) AS DOCUMENTNO, C_INVOICE.DATEINVOICED AS DATEINVOICED, 
rafael@1868
   198
      C_BPARTNER.NAME AS CLIENT_NAME, M_PRODUCT.NAME AS PRODUCT_NAME, SUM(C_INVOICELINE.QTYINVOICED) AS QUANTITYORDER, C_UOM.NAME AS UOMNAME, 
rafael@1868
   199
      C_INVOICELINE.PRICEACTUAL AS PRICEACTUAL, 
rafael@1868
   200
      C_CURRENCY_SYMBOL (C_INVOICE.C_CURRENCY_ID, C_INVOICELINE.PRICEACTUAL, 'Y') AS PRICEACTUALSYM,
rafael@1868
   201
	  C_CURRENCY_CONVERT(C_INVOICELINE.PRICEACTUAL, C_INVOICE.C_CURRENCY_ID, '102', TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID) AS CONVPRICEACTUAL,
rafael@1868
   202
      SUM(C_INVOICELINE.LINENETAMT) AS PRICELIST,
rafael@1868
   203
      C_CURRENCY_SYMBOL (C_INVOICE.C_CURRENCY_ID, C_INVOICELINE.LINENETAMT, 'Y') AS PRICELISTSYM,
rafael@1868
   204
	  SUM(C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT, C_INVOICE.C_CURRENCY_ID, '102', TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID)) AS CONVPRICELIST,
rafael@1868
   205
	  C_CURRENCY_SYMBOL('102', '0', 'Y') AS CONVSYM,
rafael@1868
   206
	  C_CURRENCY_ISOSYM('102') AS CONVISOSYM,
rafael@1868
   207
	  TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRANSDATE,
rafael@1868
   208
	  C_INVOICE.C_CURRENCY_ID AS TRANSCURRENCYID,
rafael@1868
   209
      C_INVOICELINE.AD_CLIENT_ID AS TRANSCLIENTID, 
rafael@1868
   210
	  C_INVOICELINE.AD_ORG_ID AS TRANSORGID
carlos@0
   211
      FROM C_INVOICE LEFT JOIN C_PROJECT ON C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID 
carlos@0
   212
                     LEFT JOIN C_LOCATION ON C_PROJECT.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID, C_INVOICELINE, M_PRODUCT, C_UOM, C_BPARTNER
carlos@0
   213
      WHERE C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID
carlos@0
   214
      AND C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
carlos@0
   215
      AND C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID
rafael@1868
   216
      AND C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID      
rafael@1868
   217
      AND C_INVOICE.AD_ORG_ID IN ('1')
rafael@1868
   218
      AND C_INVOICE.AD_CLIENT_ID IN ('1')
carlos@0
   219
      AND C_INVOICE.ISSOTRX = 'Y'
carlos@0
   220
      AND 1=1
rafael@1868
   221
      GROUP BY C_BPARTNER.NAME, M_PRODUCT.NAME, C_UOM.NAME, C_INVOICELINE.PRICEACTUAL, 
rafael@1868
   222
      COALESCE(C_INVOICE.POREFERENCE, C_INVOICE.DOCUMENTNO), C_INVOICE.DATEINVOICED,
rafael@1868
   223
      C_INVOICE.C_CURRENCY_ID, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID, C_INVOICELINE.LINENETAMT
juanpablo@726
   224
      ORDER BY C_BPARTNER.NAME, COALESCE(C_INVOICE.POREFERENCE, C_INVOICE.DOCUMENTNO), C_INVOICE.DATEINVOICED]]></queryString>
juanpablo@726
   225
juanpablo@726
   226
	<field name="DOCUMENTNO" class="java.lang.String"/>
juanpablo@726
   227
	<field name="DATEINVOICED" class="java.util.Date"/>
juanpablo@726
   228
	<field name="CLIENT_NAME" class="java.lang.String"/>
juanpablo@726
   229
	<field name="PRODUCT_NAME" class="java.lang.String"/>
juanpablo@726
   230
	<field name="QUANTITYORDER" class="java.math.BigDecimal"/>
juanpablo@726
   231
	<field name="UOMNAME" class="java.lang.String"/>
juanpablo@726
   232
	<field name="PRICEACTUAL" class="java.math.BigDecimal"/>
juanpablo@726
   233
	<field name="PRICELIST" class="java.math.BigDecimal"/>
rafael@1868
   234
	<field name="CONVPRICELIST" class="java.math.BigDecimal"/>
rafael@1868
   235
	<field name="CONVPRICEACTUAL" class="java.math.BigDecimal"/>
rafael@1868
   236
	<field name="PRICEACTUALSYM" class="java.lang.String"/>
rafael@1868
   237
	<field name="CONVSYM" class="java.lang.String"/>
rafael@1868
   238
	<field name="CONVISOSYM" class="java.lang.String"/>
rafael@1868
   239
	<field name="PRICELISTSYM" class="java.lang.String"/>
juanpablo@726
   240
juanpablo@726
   241
	<variable name="DetailFieldTotal" class="java.math.BigDecimal" resetType="Group" resetGroup="CLIENT_NAME" calculation="Sum">
rafael@1868
   242
		<variableExpression><![CDATA[$F{CONVPRICELIST}]]></variableExpression>
juanpablo@726
   243
	</variable>
juanpablo@726
   244
	<variable name="TotalQty" class="java.math.BigDecimal" resetType="Group" resetGroup="CLIENT_NAME" calculation="Sum">
juanpablo@726
   245
		<variableExpression><![CDATA[$F{QUANTITYORDER}]]></variableExpression>
juanpablo@726
   246
	</variable>
juanpablo@726
   247
juanpablo@726
   248
		<group  name="CLIENT_NAME" >
juanpablo@726
   249
			<groupExpression><![CDATA[$F{CLIENT_NAME}]]></groupExpression>
juanpablo@726
   250
			<groupHeader>
juanpablo@726
   251
			<band height="24"  isSplitAllowed="true" >
juanpablo@726
   252
				<staticText>
carlos@0
   253
					<reportElement
carlos@0
   254
						style="GroupHeader_DarkGray"
carlos@0
   255
						x="0"
carlos@0
   256
						y="0"
carlos@0
   257
						width="108"
carlos@0
   258
						height="24"
juanpablo@726
   259
						key="staticText"/>
juanpablo@726
   260
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   261
					<textElement>
juanpablo@726
   262
						<font pdfFontName="Helvetica"/>
juanpablo@726
   263
					</textElement>
juanpablo@726
   264
				<text><![CDATA[Client]]></text>
juanpablo@726
   265
				</staticText>
juanpablo@726
   266
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   267
					<reportElement
carlos@0
   268
						style="GroupHeader_DarkGray"
carlos@0
   269
						x="108"
carlos@0
   270
						y="0"
rafael@1868
   271
						width="598"
carlos@0
   272
						height="24"
juanpablo@726
   273
						key="textField"/>
juanpablo@726
   274
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   275
					<textElement>
juanpablo@726
   276
						<font/>
juanpablo@726
   277
					</textElement>
juanpablo@726
   278
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CLIENT_NAME}]]></textFieldExpression>
juanpablo@726
   279
				</textField>
juanpablo@726
   280
				<line direction="TopDown">
carlos@0
   281
					<reportElement
rafael@1868
   282
						x="706"
carlos@0
   283
						y="0"
carlos@0
   284
						width="0"
carlos@0
   285
						height="24"
carlos@0
   286
						forecolor="#555555"
carlos@0
   287
						key="line-3"
juanpablo@726
   288
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   289
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   290
				</line>
juanpablo@726
   291
			</band>
juanpablo@726
   292
			</groupHeader>
juanpablo@726
   293
			<groupFooter>
juanpablo@726
   294
			<band height="32"  isSplitAllowed="true" >
juanpablo@726
   295
				<line direction="TopDown">
carlos@0
   296
					<reportElement
carlos@0
   297
						x="0"
carlos@0
   298
						y="0"
carlos@0
   299
						width="0"
carlos@0
   300
						height="24"
carlos@0
   301
						forecolor="#555555"
carlos@0
   302
						key="line-32"
juanpablo@726
   303
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   304
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   305
				</line>
juanpablo@726
   306
				<line direction="TopDown">
carlos@0
   307
					<reportElement
rafael@1868
   308
						x="706"
carlos@0
   309
						y="0"
carlos@0
   310
						width="0"
rafael@1868
   311
						height="25"
carlos@0
   312
						forecolor="#555555"
carlos@0
   313
						key="line-33"
juanpablo@726
   314
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   315
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   316
				</line>
juanpablo@726
   317
				<line direction="TopDown">
carlos@0
   318
					<reportElement
carlos@0
   319
						x="0"
carlos@0
   320
						y="24"
rafael@1868
   321
						width="706"
carlos@0
   322
						height="0"
carlos@0
   323
						forecolor="#555555"
juanpablo@726
   324
						key="line-34"/>
juanpablo@726
   325
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   326
				</line>
juanpablo@726
   327
				<staticText>
carlos@0
   328
					<reportElement
carlos@0
   329
						style="Report_Footer"
carlos@0
   330
						x="10"
carlos@0
   331
						y="2"
carlos@0
   332
						width="80"
carlos@0
   333
						height="18"
juanpablo@726
   334
						key="staticText-10"/>
juanpablo@726
   335
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   336
					<textElement textAlignment="Right">
juanpablo@726
   337
						<font/>
juanpablo@726
   338
					</textElement>
juanpablo@726
   339
				<text><![CDATA[Total Client:]]></text>
juanpablo@726
   340
				</staticText>
juanpablo@726
   341
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="CLIENT_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   342
					<reportElement
carlos@0
   343
						style="Total_Field"
carlos@0
   344
						mode="Opaque"
carlos@0
   345
						x="275"
carlos@0
   346
						y="2"
rafael@1868
   347
						width="407"
carlos@0
   348
						height="18"
juanpablo@726
   349
						key="textField-13"/>
juanpablo@726
   350
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   351
					<textElement textAlignment="Right">
juanpablo@726
   352
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   353
					</textElement>
juanpablo@726
   354
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{DetailFieldTotal}!=null)?$P{NUMBERFORMAT}.format($V{DetailFieldTotal}):new String(" ")]]></textFieldExpression>
juanpablo@726
   355
				</textField>
juanpablo@726
   356
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="CLIENT_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   357
					<reportElement
carlos@0
   358
						style="Total_Field"
carlos@0
   359
						x="90"
carlos@0
   360
						y="2"
carlos@0
   361
						width="185"
carlos@0
   362
						height="18"
juanpablo@726
   363
						key="textField-14"/>
juanpablo@726
   364
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   365
					<textElement textAlignment="Right">
juanpablo@726
   366
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   367
					</textElement>
juanpablo@726
   368
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{TotalQty}!=null)?$P{NUMBERFORMAT}.format($V{TotalQty}):new String(" ")]]></textFieldExpression>
juanpablo@726
   369
				</textField>
rafael@1868
   370
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="CLIENT_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   371
					<reportElement
rafael@1868
   372
						style="Total_Field"
rafael@1868
   373
						mode="Opaque"
rafael@1868
   374
						x="682"
rafael@1868
   375
						y="2"
rafael@1868
   376
						width="22"
rafael@1868
   377
						height="18"
rafael@1868
   378
						key="textField-19"/>
rafael@1868
   379
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   380
					<textElement textAlignment="Center">
rafael@1868
   381
						<font pdfFontName="Helvetica-Bold"/>
rafael@1868
   382
					</textElement>
rafael@1868
   383
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CONVSYM}]]></textFieldExpression>
rafael@1868
   384
				</textField>
juanpablo@726
   385
			</band>
juanpablo@726
   386
			</groupFooter>
juanpablo@726
   387
		</group>
juanpablo@726
   388
		<group  name="DOCUMENTNO" >
juanpablo@726
   389
			<groupExpression><![CDATA[$F{DOCUMENTNO}]]></groupExpression>
juanpablo@726
   390
			<groupHeader>
juanpablo@726
   391
			<band height="48"  isSplitAllowed="true" >
juanpablo@726
   392
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   393
					<reportElement
carlos@0
   394
						style="Detail_Header"
carlos@0
   395
						x="90"
carlos@0
   396
						y="10"
carlos@0
   397
						width="238"
carlos@0
   398
						height="16"
juanpablo@726
   399
						key="textField"/>
juanpablo@726
   400
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   401
					<textElement>
juanpablo@726
   402
						<font/>
juanpablo@726
   403
					</textElement>
juanpablo@726
   404
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
juanpablo@726
   405
				</textField>
juanpablo@726
   406
				<line direction="TopDown">
carlos@0
   407
					<reportElement
rafael@1868
   408
						x="706"
carlos@0
   409
						y="0"
carlos@0
   410
						width="0"
carlos@0
   411
						height="48"
carlos@0
   412
						forecolor="#555555"
carlos@0
   413
						key="line-6"
juanpablo@726
   414
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   415
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   416
				</line>
juanpablo@726
   417
				<line direction="TopDown">
carlos@0
   418
					<reportElement
carlos@0
   419
						x="0"
carlos@0
   420
						y="0"
carlos@0
   421
						width="0"
carlos@0
   422
						height="48"
carlos@0
   423
						forecolor="#555555"
carlos@0
   424
						key="line-8"
juanpablo@726
   425
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   426
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   427
				</line>
juanpablo@726
   428
				<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   429
					<reportElement
carlos@0
   430
						style="Detail_Header"
carlos@0
   431
						x="420"
carlos@0
   432
						y="10"
rafael@1868
   433
						width="286"
carlos@0
   434
						height="16"
juanpablo@726
   435
						key="textField"/>
juanpablo@726
   436
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   437
					<textElement verticalAlignment="Middle">
juanpablo@726
   438
						<font fontName="Times-Roman" size="10"/>
juanpablo@726
   439
					</textElement>
juanpablo@726
   440
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
juanpablo@726
   441
				</textField>
juanpablo@726
   442
				<staticText>
carlos@0
   443
					<reportElement
carlos@0
   444
						style="Detail_Header"
carlos@0
   445
						x="20"
carlos@0
   446
						y="32"
carlos@0
   447
						width="176"
carlos@0
   448
						height="16"
juanpablo@726
   449
						key="element-90"/>
juanpablo@726
   450
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   451
					<textElement>
rafael@1868
   452
						<font size="8"/>
juanpablo@726
   453
					</textElement>
juanpablo@726
   454
				<text><![CDATA[Article]]></text>
juanpablo@726
   455
				</staticText>
juanpablo@726
   456
				<staticText>
carlos@0
   457
					<reportElement
carlos@0
   458
						style="Detail_Header"
carlos@0
   459
						x="196"
carlos@0
   460
						y="32"
carlos@0
   461
						width="80"
carlos@0
   462
						height="16"
juanpablo@726
   463
						key="element-90"/>
rafael@1868
   464
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   465
					<textElement textAlignment="Center">
rafael@1868
   466
						<font pdfFontName="Helvetica-Bold" size="8"/>
juanpablo@726
   467
					</textElement>
juanpablo@726
   468
				<text><![CDATA[Quantity]]></text>
juanpablo@726
   469
				</staticText>
juanpablo@726
   470
				<staticText>
carlos@0
   471
					<reportElement
carlos@0
   472
						style="Detail_Header"
carlos@0
   473
						x="276"
carlos@0
   474
						y="32"
carlos@0
   475
						width="80"
carlos@0
   476
						height="16"
juanpablo@726
   477
						key="element-90"/>
juanpablo@726
   478
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   479
					<textElement textAlignment="Center">
rafael@1868
   480
						<font pdfFontName="Helvetica-Bold" size="8"/>
juanpablo@726
   481
					</textElement>
juanpablo@726
   482
				<text><![CDATA[UOM]]></text>
juanpablo@726
   483
				</staticText>
juanpablo@726
   484
				<staticText>
carlos@0
   485
					<reportElement
carlos@0
   486
						style="Detail_Header"
carlos@0
   487
						x="356"
carlos@0
   488
						y="32"
carlos@0
   489
						width="90"
carlos@0
   490
						height="16"
juanpablo@726
   491
						key="element-90"/>
juanpablo@726
   492
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   493
					<textElement textAlignment="Center">
rafael@1868
   494
						<font pdfFontName="Helvetica-Bold" size="8"/>
juanpablo@726
   495
					</textElement>
juanpablo@726
   496
				<text><![CDATA[Price	]]></text>
juanpablo@726
   497
				</staticText>
juanpablo@726
   498
				<staticText>
carlos@0
   499
					<reportElement
carlos@0
   500
						style="Detail_Header"
carlos@0
   501
						x="328"
carlos@0
   502
						y="10"
carlos@0
   503
						width="92"
carlos@0
   504
						height="16"
juanpablo@726
   505
						key="staticText-9"/>
juanpablo@726
   506
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   507
					<textElement>
juanpablo@726
   508
						<font/>
juanpablo@726
   509
					</textElement>
juanpablo@726
   510
				<text><![CDATA[Invoice Date:]]></text>
juanpablo@726
   511
				</staticText>
juanpablo@726
   512
				<staticText>
carlos@0
   513
					<reportElement
carlos@0
   514
						style="Detail_Header"
carlos@0
   515
						x="10"
carlos@0
   516
						y="10"
carlos@0
   517
						width="80"
carlos@0
   518
						height="16"
juanpablo@726
   519
						key="staticText-11"/>
juanpablo@726
   520
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   521
					<textElement>
juanpablo@726
   522
						<font/>
juanpablo@726
   523
					</textElement>
juanpablo@726
   524
				<text><![CDATA[Order No.]]></text>
juanpablo@726
   525
				</staticText>
juanpablo@726
   526
				<line direction="TopDown">
carlos@0
   527
					<reportElement
carlos@0
   528
						style="Report_Footer"
carlos@0
   529
						x="10"
carlos@0
   530
						y="26"
carlos@0
   531
						width="0"
carlos@0
   532
						height="22"
carlos@0
   533
						forecolor="#555555"
juanpablo@726
   534
						key="line-39"/>
juanpablo@726
   535
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   536
				</line>
rafael@1868
   537
				<staticText>
rafael@1868
   538
					<reportElement
rafael@1868
   539
						style="Detail_Header"
rafael@1868
   540
						x="446"
rafael@1868
   541
						y="32"
rafael@1868
   542
						width="41"
rafael@1868
   543
						height="16"
rafael@1868
   544
						key="element-91"/>
rafael@1868
   545
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   546
					<textElement textAlignment="Right">
rafael@1868
   547
						<font pdfFontName="Helvetica-Bold" size="8"/>
rafael@1868
   548
					</textElement>
rafael@1868
   549
				<text><![CDATA[Price	]]></text>
rafael@1868
   550
				</staticText>
rafael@1868
   551
				<staticText>
rafael@1868
   552
					<reportElement
rafael@1868
   553
						style="Detail_Header"
rafael@1868
   554
						x="621"
rafael@1868
   555
						y="32"
rafael@1868
   556
						width="36"
rafael@1868
   557
						height="16"
rafael@1868
   558
						key="element-92"/>
rafael@1868
   559
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   560
					<textElement textAlignment="Right">
rafael@1868
   561
						<font pdfFontName="Helvetica-Bold" size="8"/>
rafael@1868
   562
					</textElement>
rafael@1868
   563
				<text><![CDATA[Total]]></text>
rafael@1868
   564
				</staticText>
rafael@1868
   565
				<staticText>
rafael@1868
   566
					<reportElement
rafael@1868
   567
						style="Detail_Header"
rafael@1868
   568
						x="536"
rafael@1868
   569
						y="32"
rafael@1868
   570
						width="85"
rafael@1868
   571
						height="16"
rafael@1868
   572
						key="element-93"/>
rafael@1868
   573
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="2" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
rafael@1868
   574
					<textElement textAlignment="Center">
rafael@1868
   575
						<font pdfFontName="Helvetica-Bold" size="8"/>
rafael@1868
   576
					</textElement>
rafael@1868
   577
				<text><![CDATA[Total]]></text>
rafael@1868
   578
				</staticText>
rafael@1868
   579
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   580
					<reportElement
rafael@1868
   581
						style="Detail_Header"
rafael@1868
   582
						x="487"
rafael@1868
   583
						y="32"
rafael@1868
   584
						width="49"
rafael@1868
   585
						height="16"
rafael@1868
   586
						key="textField-23"/>
rafael@1868
   587
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   588
					<textElement textAlignment="Left" verticalAlignment="Middle">
rafael@1868
   589
						<font pdfFontName="Helvetica-Bold" size="8"/>
rafael@1868
   590
					</textElement>
rafael@1868
   591
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
rafael@1868
   592
				</textField>
rafael@1868
   593
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   594
					<reportElement
rafael@1868
   595
						style="Detail_Header"
rafael@1868
   596
						x="657"
rafael@1868
   597
						y="32"
rafael@1868
   598
						width="49"
rafael@1868
   599
						height="16"
rafael@1868
   600
						key="textField-24"/>
rafael@1868
   601
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   602
					<textElement textAlignment="Left" verticalAlignment="Middle">
rafael@1868
   603
						<font pdfFontName="Helvetica-Bold" size="8"/>
rafael@1868
   604
					</textElement>
rafael@1868
   605
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
rafael@1868
   606
				</textField>
juanpablo@726
   607
			</band>
juanpablo@726
   608
			</groupHeader>
juanpablo@726
   609
			<groupFooter>
juanpablo@726
   610
			<band height="15"  isSplitAllowed="true" >
juanpablo@726
   611
				<line direction="TopDown">
carlos@0
   612
					<reportElement
carlos@0
   613
						x="0"
carlos@0
   614
						y="0"
carlos@0
   615
						width="0"
carlos@0
   616
						height="15"
carlos@0
   617
						forecolor="#555555"
carlos@0
   618
						key="line-35"
juanpablo@726
   619
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   620
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   621
				</line>
juanpablo@726
   622
				<line direction="TopDown">
carlos@0
   623
					<reportElement
rafael@1868
   624
						x="706"
carlos@0
   625
						y="0"
carlos@0
   626
						width="0"
carlos@0
   627
						height="15"
carlos@0
   628
						forecolor="#555555"
carlos@0
   629
						key="line-36"
juanpablo@726
   630
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   631
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   632
				</line>
juanpablo@726
   633
				<line direction="TopDown">
carlos@0
   634
					<reportElement
carlos@0
   635
						style="Report_Footer"
carlos@0
   636
						x="20"
carlos@0
   637
						y="0"
rafael@1868
   638
						width="686"
carlos@0
   639
						height="0"
carlos@0
   640
						forecolor="#555555"
juanpablo@726
   641
						key="line-37"/>
juanpablo@726
   642
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   643
				</line>
juanpablo@726
   644
				<line direction="TopDown">
carlos@0
   645
					<reportElement
carlos@0
   646
						style="Report_Footer"
carlos@0
   647
						x="10"
carlos@0
   648
						y="0"
carlos@0
   649
						width="0"
carlos@0
   650
						height="10"
carlos@0
   651
						forecolor="#555555"
juanpablo@726
   652
						key="line-40"/>
juanpablo@726
   653
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   654
				</line>
juanpablo@726
   655
				<line direction="TopDown">
carlos@0
   656
					<reportElement
carlos@0
   657
						style="Report_Footer"
carlos@0
   658
						x="10"
carlos@0
   659
						y="10"
rafael@1868
   660
						width="696"
carlos@0
   661
						height="0"
carlos@0
   662
						forecolor="#555555"
juanpablo@726
   663
						key="line-41"/>
juanpablo@726
   664
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   665
				</line>
juanpablo@726
   666
			</band>
juanpablo@726
   667
			</groupFooter>
juanpablo@726
   668
		</group>
juanpablo@726
   669
		<background>
juanpablo@726
   670
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   671
			</band>
juanpablo@726
   672
		</background>
juanpablo@726
   673
		<title>
juanpablo@726
   674
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   675
			</band>
juanpablo@726
   676
		</title>
juanpablo@726
   677
		<pageHeader>
juanpablo@726
   678
			<band height="59"  isSplitAllowed="true" >
juanpablo@726
   679
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   680
					<reportElement
carlos@0
   681
						style="Report_Title"
carlos@0
   682
						mode="Transparent"
carlos@0
   683
						x="0"
carlos@0
   684
						y="0"
rafael@1868
   685
						width="705"
carlos@0
   686
						height="20"
juanpablo@726
   687
						key="textField"/>
juanpablo@726
   688
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   689
					<textElement>
juanpablo@726
   690
						<font/>
juanpablo@726
   691
					</textElement>
juanpablo@726
   692
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
juanpablo@726
   693
				</textField>
juanpablo@726
   694
				<line direction="TopDown">
carlos@0
   695
					<reportElement
carlos@0
   696
						x="0"
carlos@0
   697
						y="20"
rafael@1868
   698
						width="706"
carlos@0
   699
						height="0"
juanpablo@726
   700
						key="line-1"/>
juanpablo@726
   701
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   702
				</line>
juanpablo@726
   703
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   704
					<reportElement
carlos@0
   705
						style="Report_Subtitle"
carlos@0
   706
						x="0"
carlos@0
   707
						y="20"
rafael@1868
   708
						width="705"
carlos@0
   709
						height="20"
juanpablo@726
   710
						key="textField"/>
juanpablo@726
   711
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   712
					<textElement>
juanpablo@726
   713
						<font size="14"/>
juanpablo@726
   714
					</textElement>
juanpablo@726
   715
				<textFieldExpression   class="java.lang.String"><![CDATA[($P{REPORT_SUBTITLE}!=null)?$P{REPORT_SUBTITLE}:new String(" ")]]></textFieldExpression>
juanpablo@726
   716
				</textField>
juanpablo@726
   717
			</band>
juanpablo@726
   718
		</pageHeader>
juanpablo@726
   719
		<columnHeader>
juanpablo@726
   720
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   721
			</band>
juanpablo@726
   722
		</columnHeader>
juanpablo@726
   723
		<detail>
juanpablo@726
   724
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   725
				<line direction="TopDown">
carlos@0
   726
					<reportElement
rafael@1868
   727
						x="706"
carlos@0
   728
						y="0"
carlos@0
   729
						width="0"
carlos@0
   730
						height="16"
carlos@0
   731
						forecolor="#555555"
carlos@0
   732
						key="line-16"
juanpablo@726
   733
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   734
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   735
				</line>
juanpablo@726
   736
				<line direction="TopDown">
carlos@0
   737
					<reportElement
carlos@0
   738
						x="0"
carlos@0
   739
						y="0"
carlos@0
   740
						width="0"
carlos@0
   741
						height="16"
carlos@0
   742
						forecolor="#555555"
carlos@0
   743
						key="line-17"
juanpablo@726
   744
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   745
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   746
				</line>
juanpablo@726
   747
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   748
					<reportElement
carlos@0
   749
						style="Detail_Line"
carlos@0
   750
						x="20"
carlos@0
   751
						y="0"
carlos@0
   752
						width="176"
carlos@0
   753
						height="16"
juanpablo@726
   754
						key="textField-8"/>
juanpablo@726
   755
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   756
					<textElement verticalAlignment="Middle">
rafael@1868
   757
						<font fontName="Times-Roman" size="8"/>
juanpablo@726
   758
					</textElement>
juanpablo@726
   759
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRODUCT_NAME}!=null)?$F{PRODUCT_NAME}:new String(" ")]]></textFieldExpression>
juanpablo@726
   760
				</textField>
juanpablo@726
   761
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   762
					<reportElement
carlos@0
   763
						style="Detail_Line"
carlos@0
   764
						x="196"
carlos@0
   765
						y="0"
carlos@0
   766
						width="80"
carlos@0
   767
						height="16"
juanpablo@726
   768
						key="textField-9"/>
rafael@1868
   769
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   770
					<textElement textAlignment="Right" verticalAlignment="Middle">
rafael@1868
   771
						<font fontName="Times-Roman" size="8"/>
juanpablo@726
   772
					</textElement>
juanpablo@726
   773
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{QUANTITYORDER}!=null)?$P{NUMBERFORMAT}.format($F{QUANTITYORDER}):new String(" ")]]></textFieldExpression>
juanpablo@726
   774
				</textField>
juanpablo@726
   775
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   776
					<reportElement
carlos@0
   777
						style="Detail_Line"
carlos@0
   778
						x="276"
carlos@0
   779
						y="0"
carlos@0
   780
						width="80"
carlos@0
   781
						height="16"
juanpablo@726
   782
						key="textField-10"/>
juanpablo@726
   783
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   784
					<textElement textAlignment="Center" verticalAlignment="Middle">
rafael@1868
   785
						<font fontName="Times-Roman" size="8"/>
juanpablo@726
   786
					</textElement>
juanpablo@726
   787
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{UOMNAME}!=null)?$F{UOMNAME}:new String(" ")]]></textFieldExpression>
juanpablo@726
   788
				</textField>
juanpablo@726
   789
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   790
					<reportElement
carlos@0
   791
						style="Detail_Line"
carlos@0
   792
						x="356"
carlos@0
   793
						y="0"
rafael@1868
   794
						width="66"
carlos@0
   795
						height="16"
juanpablo@726
   796
						key="textField-11"/>
juanpablo@726
   797
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   798
					<textElement textAlignment="Right" verticalAlignment="Middle">
rafael@1868
   799
						<font fontName="Times-Roman" size="8"/>
juanpablo@726
   800
					</textElement>
juanpablo@726
   801
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRICEACTUAL}!=null)?$P{NUMBERFORMAT}.format($F{PRICEACTUAL}):new String(" ")]]></textFieldExpression>
juanpablo@726
   802
				</textField>
juanpablo@726
   803
				<line direction="TopDown">
carlos@0
   804
					<reportElement
carlos@0
   805
						style="Report_Footer"
carlos@0
   806
						x="10"
carlos@0
   807
						y="0"
carlos@0
   808
						width="0"
carlos@0
   809
						height="16"
carlos@0
   810
						forecolor="#555555"
juanpablo@726
   811
						key="line-38"/>
juanpablo@726
   812
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   813
				</line>
rafael@1868
   814
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   815
					<reportElement
rafael@1868
   816
						style="Detail_Line"
rafael@1868
   817
						x="446"
rafael@1868
   818
						y="0"
rafael@1868
   819
						width="66"
rafael@1868
   820
						height="16"
rafael@1868
   821
						key="textField-15"/>
rafael@1868
   822
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   823
					<textElement textAlignment="Right" verticalAlignment="Middle">
rafael@1868
   824
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   825
					</textElement>
rafael@1868
   826
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{CONVPRICEACTUAL}!=null)?$P{NUMBERFORMAT}.format($F{CONVPRICEACTUAL}):new String(" ")]]></textFieldExpression>
rafael@1868
   827
				</textField>
rafael@1868
   828
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   829
					<reportElement
rafael@1868
   830
						style="Detail_Line"
rafael@1868
   831
						x="621"
rafael@1868
   832
						y="0"
rafael@1868
   833
						width="61"
rafael@1868
   834
						height="16"
rafael@1868
   835
						key="textField-16"/>
rafael@1868
   836
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   837
					<textElement textAlignment="Right" verticalAlignment="Middle">
rafael@1868
   838
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   839
					</textElement>
rafael@1868
   840
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{CONVPRICELIST}!=null)?$P{NUMBERFORMAT}.format($F{CONVPRICELIST}):new String(" ")]]></textFieldExpression>
rafael@1868
   841
				</textField>
rafael@1868
   842
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   843
					<reportElement
rafael@1868
   844
						style="Detail_Line"
rafael@1868
   845
						x="536"
rafael@1868
   846
						y="0"
rafael@1868
   847
						width="61"
rafael@1868
   848
						height="16"
rafael@1868
   849
						key="textField-17"/>
rafael@1868
   850
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   851
					<textElement textAlignment="Right" verticalAlignment="Middle">
rafael@1868
   852
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   853
					</textElement>
rafael@1868
   854
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRICELIST}!=null)?$P{NUMBERFORMAT}.format($F{PRICELIST}):new String(" ")]]></textFieldExpression>
rafael@1868
   855
				</textField>
rafael@1868
   856
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   857
					<reportElement
rafael@1868
   858
						style="Detail_Line"
rafael@1868
   859
						x="682"
rafael@1868
   860
						y="0"
rafael@1868
   861
						width="24"
rafael@1868
   862
						height="16"
rafael@1868
   863
						key="textField-18"/>
rafael@1868
   864
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#555555" leftPadding="2" rightBorder="1Point" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   865
					<textElement textAlignment="Center" verticalAlignment="Middle">
rafael@1868
   866
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   867
					</textElement>
rafael@1868
   868
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CONVSYM}]]></textFieldExpression>
rafael@1868
   869
				</textField>
rafael@1868
   870
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   871
					<reportElement
rafael@1868
   872
						style="Detail_Line"
rafael@1868
   873
						x="597"
rafael@1868
   874
						y="0"
rafael@1868
   875
						width="24"
rafael@1868
   876
						height="16"
rafael@1868
   877
						key="textField-20"/>
rafael@1868
   878
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#555555" leftPadding="2" rightBorder="1Point" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   879
					<textElement textAlignment="Center" verticalAlignment="Middle">
rafael@1868
   880
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   881
					</textElement>
rafael@1868
   882
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PRICELISTSYM}]]></textFieldExpression>
rafael@1868
   883
				</textField>
rafael@1868
   884
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   885
					<reportElement
rafael@1868
   886
						style="Detail_Line"
rafael@1868
   887
						x="512"
rafael@1868
   888
						y="0"
rafael@1868
   889
						width="24"
rafael@1868
   890
						height="16"
rafael@1868
   891
						key="textField-21"/>
rafael@1868
   892
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#555555" leftPadding="2" rightBorder="1Point" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   893
					<textElement textAlignment="Center" verticalAlignment="Middle">
rafael@1868
   894
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   895
					</textElement>
rafael@1868
   896
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CONVSYM}]]></textFieldExpression>
rafael@1868
   897
				</textField>
rafael@1868
   898
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
rafael@1868
   899
					<reportElement
rafael@1868
   900
						style="Detail_Line"
rafael@1868
   901
						x="422"
rafael@1868
   902
						y="0"
rafael@1868
   903
						width="24"
rafael@1868
   904
						height="16"
rafael@1868
   905
						key="textField-22"/>
rafael@1868
   906
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#555555" leftPadding="2" rightBorder="1Point" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#555555"/>
rafael@1868
   907
					<textElement textAlignment="Center" verticalAlignment="Middle">
rafael@1868
   908
						<font fontName="Times-Roman" size="8"/>
rafael@1868
   909
					</textElement>
rafael@1868
   910
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PRICEACTUALSYM}]]></textFieldExpression>
rafael@1868
   911
				</textField>
juanpablo@726
   912
			</band>
juanpablo@726
   913
		</detail>
juanpablo@726
   914
		<columnFooter>
juanpablo@726
   915
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   916
			</band>
juanpablo@726
   917
		</columnFooter>
juanpablo@726
   918
		<pageFooter>
juanpablo@726
   919
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   920
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   921
					<reportElement
carlos@0
   922
						style="Report_Footer"
rafael@1868
   923
						x="573"
carlos@0
   924
						y="4"
carlos@0
   925
						width="95"
carlos@0
   926
						height="16"
juanpablo@726
   927
						key="textField"/>
juanpablo@726
   928
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   929
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   930
						<font fontName="Helvetica" size="10"/>
juanpablo@726
   931
					</textElement>
juanpablo@726
   932
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@726
   933
				</textField>
juanpablo@726
   934
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   935
					<reportElement
carlos@0
   936
						style="Report_Footer"
rafael@1868
   937
						x="670"
carlos@0
   938
						y="4"
carlos@0
   939
						width="36"
carlos@0
   940
						height="16"
carlos@0
   941
						forecolor="#000000"
carlos@0
   942
						backcolor="#FFFFFF"
juanpablo@726
   943
						key="textField"/>
juanpablo@726
   944
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   945
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
juanpablo@726
   946
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
juanpablo@726
   947
					</textElement>
juanpablo@726
   948
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@726
   949
				</textField>
juanpablo@726
   950
				<line direction="TopDown">
carlos@0
   951
					<reportElement
carlos@0
   952
						x="0"
carlos@0
   953
						y="1"
rafael@1868
   954
						width="706"
carlos@0
   955
						height="0"
carlos@0
   956
						forecolor="#000000"
juanpablo@726
   957
						key="line"/>
juanpablo@726
   958
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   959
				</line>
juanpablo@726
   960
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   961
					<reportElement
carlos@0
   962
						style="Report_Footer"
carlos@0
   963
						x="277"
carlos@0
   964
						y="4"
carlos@0
   965
						width="69"
carlos@0
   966
						height="16"
juanpablo@726
   967
						key="textField"/>
juanpablo@726
   968
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   969
					<textElement verticalAlignment="Middle">
juanpablo@726
   970
						<font fontName="Times-Roman" size="10"/>
juanpablo@726
   971
					</textElement>
juanpablo@726
   972
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@726
   973
				</textField>
juanpablo@726
   974
				<staticText>
carlos@0
   975
					<reportElement
carlos@0
   976
						style="Report_Footer"
carlos@0
   977
						x="198"
carlos@0
   978
						y="4"
carlos@0
   979
						width="76"
carlos@0
   980
						height="16"
juanpablo@726
   981
						key="staticText-1"/>
juanpablo@726
   982
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   983
					<textElement textAlignment="Right">
juanpablo@726
   984
						<font/>
juanpablo@726
   985
					</textElement>
juanpablo@726
   986
				<text><![CDATA[Printed on]]></text>
juanpablo@726
   987
				</staticText>
juanpablo@726
   988
				<staticText>
carlos@0
   989
					<reportElement
carlos@0
   990
						style="Report_Footer"
carlos@0
   991
						x="0"
carlos@0
   992
						y="4"
carlos@0
   993
						width="140"
carlos@0
   994
						height="16"
juanpablo@726
   995
						key="staticText-5">
juanpablo@726
   996
							<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
juanpablo@726
   997
						</reportElement>
juanpablo@726
   998
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   999
					<textElement>
juanpablo@726
  1000
						<font/>
juanpablo@726
  1001
					</textElement>
juanpablo@726
  1002
				<text><![CDATA[other footer data]]></text>
juanpablo@726
  1003
				</staticText>
juanpablo@726
  1004
			</band>
juanpablo@726
  1005
		</pageFooter>
juanpablo@726
  1006
		<summary>
juanpablo@726
  1007
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
  1008
			</band>
juanpablo@726
  1009
		</summary>
juanpablo@726
  1010
</jasperReport>