src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 726 dac2a1486bd3
child 1785 6fcdedddde3d
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="ReportInvoicesEditJR"
juanpablo@726
     6
		 columnCount="1"
juanpablo@726
     7
		 printOrder="Vertical"
juanpablo@726
     8
		 orientation="Portrait"
juanpablo@726
     9
		 pageWidth="595"
juanpablo@726
    10
		 pageHeight="842"
juanpablo@726
    11
		 columnWidth="535"
juanpablo@726
    12
		 columnSpacing="0"
juanpablo@726
    13
		 leftMargin="30"
juanpablo@726
    14
		 rightMargin="30"
juanpablo@726
    15
		 topMargin="20"
juanpablo@726
    16
		 bottomMargin="20"
juanpablo@726
    17
		 whenNoDataType="NoPages"
juanpablo@726
    18
		 isTitleNewPage="false"
juanpablo@726
    19
		 isSummaryNewPage="false">
juanpablo@726
    20
	<property name="ireport.scriptlethandling" value="0" />
juanpablo@726
    21
	<property name="ireport.encoding" value="UTF-8" />
juanpablo@726
    22
	<import value="java.util.*" />
juanpablo@726
    23
	<import value="net.sf.jasperreports.engine.*" />
juanpablo@726
    24
	<import value="net.sf.jasperreports.engine.data.*" />
juanpablo@726
    25
juanpablo@726
    26
	<style 
juanpablo@726
    27
		name="default"
juanpablo@726
    28
		isDefault="false"
juanpablo@726
    29
		vAlign="Middle"
juanpablo@726
    30
		fontName="Bitstream Vera Sans"
juanpablo@726
    31
		fontSize="8"
juanpablo@726
    32
	/>
juanpablo@726
    33
	<style 
juanpablo@726
    34
		name="Report_Title"
juanpablo@726
    35
		isDefault="false"
juanpablo@726
    36
		leftPadding="5"
juanpablo@726
    37
		fontName="Bitstream Vera Sans"
juanpablo@726
    38
		fontSize="18"
juanpablo@726
    39
	/>
juanpablo@726
    40
	<style 
juanpablo@726
    41
		name="Report_Subtitle"
juanpablo@726
    42
		isDefault="false"
juanpablo@726
    43
		forecolor="#555555"
juanpablo@726
    44
		leftPadding="5"
juanpablo@726
    45
		fontName="Bitstream Vera Sans"
juanpablo@726
    46
		fontSize="14"
juanpablo@726
    47
	/>
juanpablo@726
    48
	<style 
juanpablo@726
    49
		name="Report_Data_Label"
juanpablo@726
    50
		isDefault="false"
juanpablo@726
    51
		fontName="Bitstream Vera Sans"
juanpablo@726
    52
		fontSize="11"
juanpablo@726
    53
		isBold="true"
juanpablo@726
    54
	/>
juanpablo@726
    55
	<style 
juanpablo@726
    56
		name="Report_Data_Field"
juanpablo@726
    57
		isDefault="false"
juanpablo@726
    58
		fontName="Bitstream Vera Sans"
juanpablo@726
    59
		fontSize="11"
juanpablo@726
    60
		isBold="false"
juanpablo@726
    61
	/>
juanpablo@726
    62
	<style 
juanpablo@726
    63
		name="Total_Field"
juanpablo@726
    64
		isDefault="false"
juanpablo@726
    65
		mode="Opaque"
juanpablo@726
    66
		forecolor="#000000"
juanpablo@726
    67
		backcolor="#CCCCCC"
juanpablo@726
    68
		vAlign="Middle"
juanpablo@726
    69
		leftPadding="5"
juanpablo@726
    70
		fontName="Bitstream Vera Sans"
juanpablo@726
    71
		fontSize="11"
juanpablo@726
    72
		isBold="true"
juanpablo@726
    73
	/>
juanpablo@726
    74
	<style 
juanpablo@726
    75
		name="GroupHeader_DarkGray"
juanpablo@726
    76
		isDefault="false"
juanpablo@726
    77
		mode="Opaque"
juanpablo@726
    78
		forecolor="#FFFFFF"
juanpablo@726
    79
		backcolor="#555555"
juanpablo@726
    80
		vAlign="Middle"
juanpablo@726
    81
		leftPadding="5"
juanpablo@726
    82
		fontName="Bitstream Vera Sans"
juanpablo@726
    83
		fontSize="12"
juanpablo@726
    84
		isBold="true"
juanpablo@726
    85
	/>
juanpablo@726
    86
	<style 
juanpablo@726
    87
		name="Group_Data_Label"
juanpablo@726
    88
		isDefault="false"
juanpablo@726
    89
		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{INVOICEID_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="ATTACH" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   172
	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   173
	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   174
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   175
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
juanpablo@726
   176
	</parameter>
juanpablo@726
   177
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
juanpablo@726
   178
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
juanpablo@726
   179
	</parameter>
juanpablo@726
   180
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
juanpablo@726
   181
		<defaultValueExpression ><![CDATA["(0)"]]></defaultValueExpression>
juanpablo@726
   182
	</parameter>
juanpablo@726
   183
	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   184
		<defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
juanpablo@726
   185
	</parameter>
juanpablo@726
   186
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   187
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   188
	</parameter>
juanpablo@726
   189
	<parameter name="ReportData" isForPrompting="false" class="java.lang.String">
juanpablo@726
   190
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@726
   191
	</parameter>
juanpablo@726
   192
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
juanpablo@726
   193
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
carlos@0
   194
	<queryString><![CDATA[SELECT NAMEBPARTNER,INVOICEID, INVOICEDOCUMENTNO, DOCNOORDER, DESCRIPTIONINVOICE, DATEINVOICED,
carlos@0
   195
      LINE, NAMEPRODUCT, QTYINVOICED, UOMSYMBOL, PRICEACTUAL, TAX, BASE, LINENETAMT
carlos@0
   196
      FROM (
carlos@0
   197
      SELECT B.NAME AS NAMEBPARTNER, I.C_INVOICE_ID AS INVOICEID, I.DOCUMENTNO AS INVOICEDOCUMENTNO, O.DOCUMENTNO AS DOCNOORDER,I.DESCRIPTION AS DESCRIPTIONINVOICE, I.DATEINVOICED AS DATEINVOICED,
carlos@0
   198
      C_INVOICELINE.LINE, P.NAME AS NAMEPRODUCT,
carlos@0
   199
      IL.QTYINVOICED AS QTYINVOICED, TO_CHAR(C_UOM.UOMSYMBOL) AS UOMSYMBOL,IL.PRICEACTUAL AS PRICEACTUAL, C_TAX.RATE AS TAX, IL.LINENETAMT AS LINENETAMT,
carlos@0
   200
      NULL AS BASE
carlos@0
   201
      FROM C_INVOICE I left join C_ORDER O on I.C_ORDER_ID = O.C_ORDER_ID
carlos@0
   202
                       right join RV_C_INVOICELINE IL on IL.C_INVOICE_ID = I.C_INVOICE_ID,
carlos@0
   203
           C_BPARTNER B, M_PRODUCT P, C_UOM, C_INVOICELINE, C_TAX
carlos@0
   204
      WHERE IL.M_PRODUCT_ID = P.M_PRODUCT_ID
carlos@0
   205
      AND IL.C_BPARTNER_ID = B.C_BPARTNER_ID
carlos@0
   206
      AND IL.C_INVOICELINE_ID = C_INVOICELINE.C_INVOICELINE_ID
carlos@0
   207
      AND C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID
carlos@0
   208
      AND C_INVOICELINE.C_TAX_ID = C_TAX.C_TAX_ID
carlos@0
   209
      AND 1=1
carlos@0
   210
      UNION 
carlos@0
   211
      SELECT B.NAME AS NAMEBPARTNER, I2.C_INVOICE_ID AS INVOICEID, I2.DOCUMENTNO AS INVOICEDOCUMENTNO, O.DOCUMENTNO AS DOCNOORDER, I2.DESCRIPTION AS DESCRIPTIONINVOICE, I2.DATEINVOICED AS DATEINVOICED,
carlos@0
   212
      NULL AS LINE , C_TAX.NAME AS NAMEPRODUCT,
carlos@0
   213
      NULL AS QTYINVOICED, '' AS UOMSYMBOL, NULL AS PRICEACTUAL, NULL AS TAX, C_INVOICETAX.TAXAMT AS LINENETAMT, C_INVOICETAX.TAXBASEAMT AS BASE
carlos@0
   214
      FROM C_INVOICE I2 left join RV_C_INVOICELINE IL on IL.C_INVOICE_ID = I2.C_INVOICE_ID
carlos@0
   215
                        left join C_ORDER O           on I2.C_ORDER_ID = O.C_ORDER_ID,
carlos@0
   216
       C_BPARTNER B, M_PRODUCT P, C_TAX, C_INVOICETAX
carlos@0
   217
      WHERE IL.M_PRODUCT_ID = P.M_PRODUCT_ID
carlos@0
   218
      AND IL.C_BPARTNER_ID = B.C_BPARTNER_ID
carlos@0
   219
      AND C_INVOICETAX.C_INVOICE_ID= I2.C_INVOICE_ID
carlos@0
   220
      AND C_INVOICETAX.C_TAX_ID = C_TAX.C_TAX_ID
carlos@0
   221
      AND 2=2) A
juanpablo@726
   222
      ORDER BY NAMEBPARTNER, INVOICEDOCUMENTNO, LINE]]></queryString>
juanpablo@726
   223
juanpablo@726
   224
	<field name="NAMEBPARTNER" class="java.lang.String"/>
juanpablo@726
   225
	<field name="INVOICEID" class="java.math.BigDecimal"/>
juanpablo@726
   226
	<field name="INVOICEDOCUMENTNO" class="java.lang.String"/>
juanpablo@726
   227
	<field name="DOCNOORDER" class="java.lang.String"/>
juanpablo@726
   228
	<field name="DESCRIPTIONINVOICE" class="java.lang.String"/>
juanpablo@726
   229
	<field name="DATEINVOICED" class="java.util.Date"/>
juanpablo@726
   230
	<field name="LINE" class="java.math.BigDecimal"/>
juanpablo@726
   231
	<field name="NAMEPRODUCT" class="java.lang.String"/>
juanpablo@726
   232
	<field name="QTYINVOICED" class="java.math.BigDecimal"/>
juanpablo@726
   233
	<field name="UOMSYMBOL" class="java.lang.String"/>
juanpablo@726
   234
	<field name="PRICEACTUAL" class="java.math.BigDecimal"/>
juanpablo@726
   235
	<field name="TAX" class="java.math.BigDecimal"/>
juanpablo@726
   236
	<field name="BASE" class="java.math.BigDecimal"/>
juanpablo@726
   237
	<field name="LINENETAMT" class="java.math.BigDecimal"/>
juanpablo@726
   238
juanpablo@726
   239
	<variable name="DetailFieldTotal" class="java.lang.String" resetType="Report" calculation="Nothing">
juanpablo@726
   240
	</variable>
juanpablo@726
   241
	<variable name="TOTAL_INVOICE" class="java.math.BigDecimal" resetType="Group" resetGroup="INVOICEID" calculation="Sum">
juanpablo@726
   242
		<variableExpression><![CDATA[$F{LINENETAMT}]]></variableExpression>
juanpablo@726
   243
	</variable>
juanpablo@726
   244
	<variable name="TOTAL_PARTNER" class="java.math.BigDecimal" resetType="Group" resetGroup="NAMEBPARTNER" calculation="Sum">
juanpablo@726
   245
		<variableExpression><![CDATA[$F{LINENETAMT}]]></variableExpression>
juanpablo@726
   246
	</variable>
juanpablo@726
   247
juanpablo@726
   248
		<group  name="NAMEBPARTNER" >
juanpablo@726
   249
			<groupExpression><![CDATA[$F{NAMEBPARTNER}]]></groupExpression>
juanpablo@726
   250
			<groupHeader>
juanpablo@726
   251
			<band height="42"  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="120"
carlos@0
   258
						height="18"
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/>
juanpablo@726
   263
					</textElement>
juanpablo@726
   264
				<text><![CDATA[PARTNER]]></text>
juanpablo@726
   265
				</staticText>
juanpablo@726
   266
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   267
					<reportElement
carlos@0
   268
						style="GroupHeader_DarkGray"
carlos@0
   269
						x="120"
carlos@0
   270
						y="0"
carlos@0
   271
						width="415"
carlos@0
   272
						height="18"
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{NAMEBPARTNER}!=null)?$F{NAMEBPARTNER}:new String(" ")]]></textFieldExpression>
juanpablo@726
   279
				</textField>
juanpablo@726
   280
				<line direction="TopDown">
carlos@0
   281
					<reportElement
carlos@0
   282
						x="0"
carlos@0
   283
						y="18"
carlos@0
   284
						width="0"
carlos@0
   285
						height="24"
carlos@0
   286
						forecolor="#555555"
carlos@0
   287
						key="line-2"
juanpablo@726
   288
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   289
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   290
				</line>
juanpablo@726
   291
				<line direction="TopDown">
carlos@0
   292
					<reportElement
carlos@0
   293
						x="535"
carlos@0
   294
						y="0"
carlos@0
   295
						width="0"
carlos@0
   296
						height="42"
carlos@0
   297
						forecolor="#555555"
carlos@0
   298
						key="line-3"
juanpablo@726
   299
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   300
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   301
				</line>
juanpablo@726
   302
			</band>
juanpablo@726
   303
			</groupHeader>
juanpablo@726
   304
			<groupFooter>
juanpablo@726
   305
			<band height="32"  isSplitAllowed="true" >
juanpablo@726
   306
				<line direction="TopDown">
carlos@0
   307
					<reportElement
carlos@0
   308
						x="0"
carlos@0
   309
						y="0"
carlos@0
   310
						width="0"
carlos@0
   311
						height="22"
carlos@0
   312
						forecolor="#555555"
carlos@0
   313
						key="line-32"
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="535"
carlos@0
   320
						y="0"
carlos@0
   321
						width="0"
carlos@0
   322
						height="22"
carlos@0
   323
						forecolor="#555555"
carlos@0
   324
						key="line-33"
juanpablo@726
   325
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   326
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   327
				</line>
juanpablo@726
   328
				<line direction="TopDown">
carlos@0
   329
					<reportElement
carlos@0
   330
						x="0"
carlos@0
   331
						y="22"
carlos@0
   332
						width="535"
carlos@0
   333
						height="0"
carlos@0
   334
						forecolor="#555555"
juanpablo@726
   335
						key="line-34"/>
juanpablo@726
   336
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   337
				</line>
juanpablo@726
   338
				<staticText>
carlos@0
   339
					<reportElement
carlos@0
   340
						style="Report_Data_Label"
carlos@0
   341
						x="10"
carlos@0
   342
						y="0"
carlos@0
   343
						width="150"
carlos@0
   344
						height="16"
juanpablo@726
   345
						key="staticText-4"/>
juanpablo@726
   346
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   347
					<textElement textAlignment="Left">
juanpablo@726
   348
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   349
					</textElement>
juanpablo@726
   350
				<text><![CDATA[Total Partner:]]></text>
juanpablo@726
   351
				</staticText>
juanpablo@726
   352
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NAMEBPARTNER"  hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   353
					<reportElement
carlos@0
   354
						style="Total_Field"
carlos@0
   355
						x="160"
carlos@0
   356
						y="0"
carlos@0
   357
						width="369"
carlos@0
   358
						height="16"
juanpablo@726
   359
						key="textField-3"/>
juanpablo@726
   360
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   361
					<textElement textAlignment="Right">
juanpablo@726
   362
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   363
					</textElement>
juanpablo@726
   364
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{TOTAL_PARTNER}!=null)?$P{NUMBERFORMAT}.format($V{TOTAL_PARTNER}):new String(" ")]]></textFieldExpression>
juanpablo@726
   365
				</textField>
juanpablo@726
   366
			</band>
juanpablo@726
   367
			</groupFooter>
juanpablo@726
   368
		</group>
juanpablo@726
   369
		<group  name="INVOICEID" >
juanpablo@726
   370
			<groupExpression><![CDATA[$F{INVOICEID}]]></groupExpression>
juanpablo@726
   371
			<groupHeader>
juanpablo@726
   372
			<band height="46"  isSplitAllowed="true" >
juanpablo@726
   373
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   374
					<reportElement
carlos@0
   375
						style="GroupHeader_DarkGray"
carlos@0
   376
						x="90"
carlos@0
   377
						y="0"
carlos@0
   378
						width="90"
carlos@0
   379
						height="18"
juanpablo@726
   380
						key="textField"/>
juanpablo@726
   381
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   382
					<textElement>
juanpablo@726
   383
						<font/>
juanpablo@726
   384
					</textElement>
juanpablo@726
   385
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{INVOICEID}!=null)?$F{INVOICEID}.toString():new String(" ")]]></textFieldExpression>
juanpablo@726
   386
				</textField>
juanpablo@726
   387
				<line direction="TopDown">
carlos@0
   388
					<reportElement
carlos@0
   389
						x="10"
carlos@0
   390
						y="18"
carlos@0
   391
						width="0"
carlos@0
   392
						height="28"
carlos@0
   393
						forecolor="#555555"
carlos@0
   394
						key="line-4"
juanpablo@726
   395
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   396
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   397
				</line>
juanpablo@726
   398
				<line direction="TopDown">
carlos@0
   399
					<reportElement
carlos@0
   400
						x="535"
carlos@0
   401
						y="0"
carlos@0
   402
						width="0"
carlos@0
   403
						height="46"
carlos@0
   404
						forecolor="#555555"
carlos@0
   405
						key="line-6"
juanpablo@726
   406
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   407
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   408
				</line>
juanpablo@726
   409
				<line direction="TopDown">
carlos@0
   410
					<reportElement
carlos@0
   411
						x="0"
carlos@0
   412
						y="0"
carlos@0
   413
						width="0"
carlos@0
   414
						height="46"
carlos@0
   415
						forecolor="#555555"
carlos@0
   416
						key="line-8"
juanpablo@726
   417
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   418
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   419
				</line>
juanpablo@726
   420
				<staticText>
carlos@0
   421
					<reportElement
carlos@0
   422
						style="GroupHeader_DarkGray"
carlos@0
   423
						x="10"
carlos@0
   424
						y="0"
carlos@0
   425
						width="80"
carlos@0
   426
						height="18"
juanpablo@726
   427
						key="staticText-9"/>
juanpablo@726
   428
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   429
					<textElement>
juanpablo@726
   430
						<font/>
juanpablo@726
   431
					</textElement>
juanpablo@726
   432
				<text><![CDATA[INVOICE]]></text>
juanpablo@726
   433
				</staticText>
juanpablo@726
   434
				<staticText>
carlos@0
   435
					<reportElement
carlos@0
   436
						style="GroupHeader_DarkGray"
carlos@0
   437
						x="180"
carlos@0
   438
						y="0"
carlos@0
   439
						width="100"
carlos@0
   440
						height="18"
juanpablo@726
   441
						key="staticText-10"/>
juanpablo@726
   442
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   443
					<textElement>
juanpablo@726
   444
						<font/>
juanpablo@726
   445
					</textElement>
juanpablo@726
   446
				<text><![CDATA[ORDER NO.]]></text>
juanpablo@726
   447
				</staticText>
juanpablo@726
   448
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   449
					<reportElement
carlos@0
   450
						style="GroupHeader_DarkGray"
carlos@0
   451
						x="280"
carlos@0
   452
						y="0"
carlos@0
   453
						width="90"
carlos@0
   454
						height="18"
juanpablo@726
   455
						key="textField-4"/>
juanpablo@726
   456
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   457
					<textElement>
juanpablo@726
   458
						<font/>
juanpablo@726
   459
					</textElement>
juanpablo@726
   460
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{DOCNOORDER}!=null)?$F{DOCNOORDER}:new String(" ")]]></textFieldExpression>
juanpablo@726
   461
				</textField>
juanpablo@726
   462
				<staticText>
carlos@0
   463
					<reportElement
carlos@0
   464
						style="GroupHeader_DarkGray"
carlos@0
   465
						x="370"
carlos@0
   466
						y="0"
carlos@0
   467
						width="60"
carlos@0
   468
						height="18"
juanpablo@726
   469
						key="staticText-11"/>
juanpablo@726
   470
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   471
					<textElement>
juanpablo@726
   472
						<font/>
juanpablo@726
   473
					</textElement>
juanpablo@726
   474
				<text><![CDATA[DATE]]></text>
juanpablo@726
   475
				</staticText>
juanpablo@726
   476
				<textField isStretchWithOverflow="false" pattern="dd-MM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   477
					<reportElement
carlos@0
   478
						style="GroupHeader_DarkGray"
carlos@0
   479
						x="430"
carlos@0
   480
						y="0"
carlos@0
   481
						width="105"
carlos@0
   482
						height="18"
juanpablo@726
   483
						key="textField-5"/>
juanpablo@726
   484
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   485
					<textElement>
juanpablo@726
   486
						<font/>
juanpablo@726
   487
					</textElement>
juanpablo@726
   488
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
juanpablo@726
   489
				</textField>
juanpablo@726
   490
				<staticText>
carlos@0
   491
					<reportElement
carlos@0
   492
						style="Detail_Header"
carlos@0
   493
						x="20"
carlos@0
   494
						y="32"
carlos@0
   495
						width="40"
carlos@0
   496
						height="14"
juanpablo@726
   497
						key="staticText-12"/>
juanpablo@726
   498
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   499
					<textElement>
juanpablo@726
   500
						<font/>
juanpablo@726
   501
					</textElement>
juanpablo@726
   502
				<text><![CDATA[Line]]></text>
juanpablo@726
   503
				</staticText>
juanpablo@726
   504
				<staticText>
carlos@0
   505
					<reportElement
carlos@0
   506
						style="Detail_Header"
carlos@0
   507
						x="60"
carlos@0
   508
						y="32"
carlos@0
   509
						width="100"
carlos@0
   510
						height="14"
juanpablo@726
   511
						key="staticText-13"/>
juanpablo@726
   512
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   513
					<textElement>
juanpablo@726
   514
						<font/>
juanpablo@726
   515
					</textElement>
juanpablo@726
   516
				<text><![CDATA[Concept]]></text>
juanpablo@726
   517
				</staticText>
juanpablo@726
   518
				<staticText>
carlos@0
   519
					<reportElement
carlos@0
   520
						style="Detail_Header"
carlos@0
   521
						x="160"
carlos@0
   522
						y="32"
carlos@0
   523
						width="60"
carlos@0
   524
						height="14"
juanpablo@726
   525
						key="staticText-14"/>
juanpablo@726
   526
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   527
					<textElement textAlignment="Right">
juanpablo@726
   528
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   529
					</textElement>
juanpablo@726
   530
				<text><![CDATA[Quantity]]></text>
juanpablo@726
   531
				</staticText>
juanpablo@726
   532
				<staticText>
carlos@0
   533
					<reportElement
carlos@0
   534
						style="Detail_Header"
carlos@0
   535
						x="220"
carlos@0
   536
						y="32"
carlos@0
   537
						width="60"
carlos@0
   538
						height="14"
juanpablo@726
   539
						key="staticText-15"/>
juanpablo@726
   540
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   541
					<textElement textAlignment="Left">
juanpablo@726
   542
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   543
					</textElement>
juanpablo@726
   544
				<text><![CDATA[UOM]]></text>
juanpablo@726
   545
				</staticText>
juanpablo@726
   546
				<staticText>
carlos@0
   547
					<reportElement
carlos@0
   548
						style="Detail_Header"
carlos@0
   549
						x="280"
carlos@0
   550
						y="32"
carlos@0
   551
						width="60"
carlos@0
   552
						height="14"
juanpablo@726
   553
						key="staticText-16"/>
juanpablo@726
   554
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   555
					<textElement textAlignment="Right">
juanpablo@726
   556
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   557
					</textElement>
juanpablo@726
   558
				<text><![CDATA[Price]]></text>
juanpablo@726
   559
				</staticText>
juanpablo@726
   560
				<staticText>
carlos@0
   561
					<reportElement
carlos@0
   562
						style="Detail_Header"
carlos@0
   563
						x="340"
carlos@0
   564
						y="32"
carlos@0
   565
						width="60"
carlos@0
   566
						height="14"
juanpablo@726
   567
						key="staticText-17"/>
juanpablo@726
   568
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   569
					<textElement textAlignment="Right">
juanpablo@726
   570
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   571
					</textElement>
juanpablo@726
   572
				<text><![CDATA[% Tax]]></text>
juanpablo@726
   573
				</staticText>
juanpablo@726
   574
				<staticText>
carlos@0
   575
					<reportElement
carlos@0
   576
						style="Detail_Header"
carlos@0
   577
						x="400"
carlos@0
   578
						y="32"
carlos@0
   579
						width="60"
carlos@0
   580
						height="14"
juanpablo@726
   581
						key="staticText-18"/>
juanpablo@726
   582
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   583
					<textElement textAlignment="Right">
juanpablo@726
   584
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   585
					</textElement>
juanpablo@726
   586
				<text><![CDATA[Base]]></text>
juanpablo@726
   587
				</staticText>
juanpablo@726
   588
				<staticText>
carlos@0
   589
					<reportElement
carlos@0
   590
						style="Detail_Header"
carlos@0
   591
						x="460"
carlos@0
   592
						y="32"
carlos@0
   593
						width="70"
carlos@0
   594
						height="14"
juanpablo@726
   595
						key="staticText-19"/>
juanpablo@726
   596
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   597
					<textElement textAlignment="Right">
juanpablo@726
   598
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   599
					</textElement>
juanpablo@726
   600
				<text><![CDATA[Amount]]></text>
juanpablo@726
   601
				</staticText>
juanpablo@726
   602
			</band>
juanpablo@726
   603
			</groupHeader>
juanpablo@726
   604
			<groupFooter>
juanpablo@726
   605
			<band height="36"  isSplitAllowed="true" >
juanpablo@726
   606
				<line direction="TopDown">
carlos@0
   607
					<reportElement
carlos@0
   608
						x="0"
carlos@0
   609
						y="0"
carlos@0
   610
						width="0"
carlos@0
   611
						height="36"
carlos@0
   612
						forecolor="#555555"
carlos@0
   613
						key="line-28"
juanpablo@726
   614
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   615
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   616
				</line>
juanpablo@726
   617
				<line direction="TopDown">
carlos@0
   618
					<reportElement
carlos@0
   619
						x="10"
carlos@0
   620
						y="0"
carlos@0
   621
						width="0"
carlos@0
   622
						height="24"
carlos@0
   623
						forecolor="#555555"
carlos@0
   624
						key="line-29"
juanpablo@726
   625
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   626
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   627
				</line>
juanpablo@726
   628
				<line direction="TopDown">
carlos@0
   629
					<reportElement
carlos@0
   630
						x="535"
carlos@0
   631
						y="0"
carlos@0
   632
						width="0"
carlos@0
   633
						height="36"
carlos@0
   634
						forecolor="#555555"
carlos@0
   635
						key="line-30"
juanpablo@726
   636
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   637
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   638
				</line>
juanpablo@726
   639
				<line direction="TopDown">
carlos@0
   640
					<reportElement
carlos@0
   641
						x="10"
carlos@0
   642
						y="24"
carlos@0
   643
						width="525"
carlos@0
   644
						height="0"
carlos@0
   645
						forecolor="#555555"
juanpablo@726
   646
						key="line-31"/>
juanpablo@726
   647
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   648
				</line>
juanpablo@726
   649
				<line direction="TopDown">
carlos@0
   650
					<reportElement
carlos@0
   651
						style="Report_Footer"
carlos@0
   652
						x="20"
carlos@0
   653
						y="0"
carlos@0
   654
						width="510"
carlos@0
   655
						height="0"
carlos@0
   656
						forecolor="#555555"
juanpablo@726
   657
						key="line-35"/>
juanpablo@726
   658
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   659
				</line>
juanpablo@726
   660
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="INVOICEID"  hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   661
					<reportElement
carlos@0
   662
						style="Total_Gray"
carlos@0
   663
						x="400"
carlos@0
   664
						y="4"
carlos@0
   665
						width="130"
carlos@0
   666
						height="16"
juanpablo@726
   667
						key="textField"/>
juanpablo@726
   668
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   669
					<textElement textAlignment="Right">
juanpablo@726
   670
						<font/>
juanpablo@726
   671
					</textElement>
juanpablo@726
   672
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{TOTAL_INVOICE}!=null)?$P{NUMBERFORMAT}.format($V{TOTAL_INVOICE}):new String(" ")]]></textFieldExpression>
juanpablo@726
   673
				</textField>
juanpablo@726
   674
				<staticText>
carlos@0
   675
					<reportElement
carlos@0
   676
						style="Group_Footer"
carlos@0
   677
						x="300"
carlos@0
   678
						y="4"
carlos@0
   679
						width="99"
carlos@0
   680
						height="16"
juanpablo@726
   681
						key="staticText-20"/>
juanpablo@726
   682
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   683
					<textElement textAlignment="Right">
juanpablo@726
   684
						<font pdfFontName="Helvetica-Bold"/>
juanpablo@726
   685
					</textElement>
juanpablo@726
   686
				<text><![CDATA[Total]]></text>
juanpablo@726
   687
				</staticText>
juanpablo@726
   688
			</band>
juanpablo@726
   689
			</groupFooter>
juanpablo@726
   690
		</group>
juanpablo@726
   691
		<background>
juanpablo@726
   692
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   693
			</band>
juanpablo@726
   694
		</background>
juanpablo@726
   695
		<title>
juanpablo@726
   696
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   697
			</band>
juanpablo@726
   698
		</title>
juanpablo@726
   699
		<pageHeader>
juanpablo@726
   700
			<band height="59"  isSplitAllowed="true" >
juanpablo@726
   701
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   702
					<reportElement
carlos@0
   703
						style="Report_Title"
carlos@0
   704
						mode="Transparent"
carlos@0
   705
						x="0"
carlos@0
   706
						y="4"
carlos@0
   707
						width="535"
carlos@0
   708
						height="20"
juanpablo@726
   709
						key="textField"/>
juanpablo@726
   710
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   711
					<textElement>
juanpablo@726
   712
						<font/>
juanpablo@726
   713
					</textElement>
juanpablo@726
   714
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
juanpablo@726
   715
				</textField>
juanpablo@726
   716
				<line direction="TopDown">
carlos@0
   717
					<reportElement
carlos@0
   718
						x="0"
carlos@0
   719
						y="24"
carlos@0
   720
						width="535"
carlos@0
   721
						height="0"
juanpablo@726
   722
						key="line-1"/>
juanpablo@726
   723
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   724
				</line>
juanpablo@726
   725
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   726
					<reportElement
carlos@0
   727
						style="Report_Subtitle"
carlos@0
   728
						x="0"
carlos@0
   729
						y="27"
carlos@0
   730
						width="535"
carlos@0
   731
						height="20"
juanpablo@726
   732
						key="textField"/>
juanpablo@726
   733
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   734
					<textElement>
juanpablo@726
   735
						<font size="14"/>
juanpablo@726
   736
					</textElement>
juanpablo@726
   737
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_SUBTITLE}]]></textFieldExpression>
juanpablo@726
   738
				</textField>
juanpablo@726
   739
			</band>
juanpablo@726
   740
		</pageHeader>
juanpablo@726
   741
		<columnHeader>
juanpablo@726
   742
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   743
			</band>
juanpablo@726
   744
		</columnHeader>
juanpablo@726
   745
		<detail>
juanpablo@726
   746
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   747
				<line direction="TopDown">
carlos@0
   748
					<reportElement
carlos@0
   749
						x="535"
carlos@0
   750
						y="0"
carlos@0
   751
						width="0"
carlos@0
   752
						height="16"
carlos@0
   753
						forecolor="#555555"
carlos@0
   754
						key="line-16"
juanpablo@726
   755
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   756
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   757
				</line>
juanpablo@726
   758
				<line direction="TopDown">
carlos@0
   759
					<reportElement
carlos@0
   760
						x="0"
carlos@0
   761
						y="0"
carlos@0
   762
						width="0"
carlos@0
   763
						height="16"
carlos@0
   764
						forecolor="#555555"
carlos@0
   765
						key="line-17"
juanpablo@726
   766
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   767
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   768
				</line>
juanpablo@726
   769
				<line direction="TopDown">
carlos@0
   770
					<reportElement
carlos@0
   771
						x="10"
carlos@0
   772
						y="0"
carlos@0
   773
						width="0"
carlos@0
   774
						height="16"
carlos@0
   775
						forecolor="#555555"
carlos@0
   776
						key="line-18"
juanpablo@726
   777
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   778
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   779
				</line>
juanpablo@726
   780
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   781
					<reportElement
carlos@0
   782
						style="Detail_Line"
carlos@0
   783
						x="20"
carlos@0
   784
						y="0"
carlos@0
   785
						width="40"
carlos@0
   786
						height="16"
juanpablo@726
   787
						key="textField"/>
juanpablo@726
   788
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   789
					<textElement textAlignment="Right">
juanpablo@726
   790
						<font/>
juanpablo@726
   791
					</textElement>
juanpablo@726
   792
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{LINE}!=null)?$F{LINE}.toString():new String(" ")]]></textFieldExpression>
juanpablo@726
   793
				</textField>
juanpablo@726
   794
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   795
					<reportElement
carlos@0
   796
						style="Detail_Line"
carlos@0
   797
						x="60"
carlos@0
   798
						y="0"
carlos@0
   799
						width="100"
carlos@0
   800
						height="16"
juanpablo@726
   801
						key="textField"/>
juanpablo@726
   802
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   803
					<textElement>
juanpablo@726
   804
						<font/>
juanpablo@726
   805
					</textElement>
juanpablo@726
   806
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{NAMEPRODUCT}!=null)?$F{NAMEPRODUCT}:new String(" ")]]></textFieldExpression>
juanpablo@726
   807
				</textField>
juanpablo@726
   808
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   809
					<reportElement
carlos@0
   810
						style="Detail_Line"
carlos@0
   811
						x="160"
carlos@0
   812
						y="0"
carlos@0
   813
						width="60"
carlos@0
   814
						height="16"
juanpablo@726
   815
						key="textField"/>
juanpablo@726
   816
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   817
					<textElement textAlignment="Right">
juanpablo@726
   818
						<font/>
juanpablo@726
   819
					</textElement>
juanpablo@726
   820
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{QTYINVOICED}!=null)?$P{NUMBERFORMAT}.format($F{QTYINVOICED}):new String(" ")]]></textFieldExpression>
juanpablo@726
   821
				</textField>
juanpablo@726
   822
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   823
					<reportElement
carlos@0
   824
						style="Detail_Line"
carlos@0
   825
						x="220"
carlos@0
   826
						y="0"
carlos@0
   827
						width="60"
carlos@0
   828
						height="16"
juanpablo@726
   829
						key="textField"/>
juanpablo@726
   830
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   831
					<textElement>
juanpablo@726
   832
						<font/>
juanpablo@726
   833
					</textElement>
juanpablo@726
   834
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{UOMSYMBOL}!=null)?$F{UOMSYMBOL}:new String(" ")]]></textFieldExpression>
juanpablo@726
   835
				</textField>
juanpablo@726
   836
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   837
					<reportElement
carlos@0
   838
						style="Detail_Line"
carlos@0
   839
						x="280"
carlos@0
   840
						y="0"
carlos@0
   841
						width="60"
carlos@0
   842
						height="16"
juanpablo@726
   843
						key="textField"/>
juanpablo@726
   844
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   845
					<textElement textAlignment="Right">
juanpablo@726
   846
						<font/>
juanpablo@726
   847
					</textElement>
juanpablo@726
   848
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRICEACTUAL}!=null)?$P{NUMBERFORMAT}.format($F{PRICEACTUAL}):new String(" ")]]></textFieldExpression>
juanpablo@726
   849
				</textField>
juanpablo@726
   850
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   851
					<reportElement
carlos@0
   852
						style="Detail_Line"
carlos@0
   853
						x="340"
carlos@0
   854
						y="0"
carlos@0
   855
						width="60"
carlos@0
   856
						height="16"
juanpablo@726
   857
						key="textField"/>
juanpablo@726
   858
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   859
					<textElement textAlignment="Right">
juanpablo@726
   860
						<font/>
juanpablo@726
   861
					</textElement>
juanpablo@726
   862
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{TAX}!=null)?$P{NUMBERFORMAT}.format($F{TAX}):new String(" ")]]></textFieldExpression>
juanpablo@726
   863
				</textField>
juanpablo@726
   864
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   865
					<reportElement
carlos@0
   866
						style="Detail_Line"
carlos@0
   867
						x="400"
carlos@0
   868
						y="0"
carlos@0
   869
						width="60"
carlos@0
   870
						height="16"
juanpablo@726
   871
						key="textField"/>
juanpablo@726
   872
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   873
					<textElement textAlignment="Right">
juanpablo@726
   874
						<font/>
juanpablo@726
   875
					</textElement>
juanpablo@726
   876
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{BASE}!=null)?$P{NUMBERFORMAT}.format($F{BASE}):new String(" ")]]></textFieldExpression>
juanpablo@726
   877
				</textField>
juanpablo@726
   878
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   879
					<reportElement
carlos@0
   880
						style="Detail_Line"
carlos@0
   881
						x="460"
carlos@0
   882
						y="0"
carlos@0
   883
						width="70"
carlos@0
   884
						height="16"
juanpablo@726
   885
						key="textField"/>
juanpablo@726
   886
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="4" rightBorder="1Point" rightBorderColor="#555555" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   887
					<textElement textAlignment="Right">
juanpablo@726
   888
						<font/>
juanpablo@726
   889
					</textElement>
juanpablo@726
   890
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{LINENETAMT}!=null)?$P{NUMBERFORMAT}.format($F{LINENETAMT}):new String(" ")]]></textFieldExpression>
juanpablo@726
   891
				</textField>
juanpablo@726
   892
			</band>
juanpablo@726
   893
		</detail>
juanpablo@726
   894
		<columnFooter>
juanpablo@726
   895
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   896
			</band>
juanpablo@726
   897
		</columnFooter>
juanpablo@726
   898
		<pageFooter>
juanpablo@726
   899
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   900
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   901
					<reportElement
carlos@0
   902
						style="Report_Footer"
carlos@0
   903
						x="402"
carlos@0
   904
						y="4"
carlos@0
   905
						width="95"
carlos@0
   906
						height="16"
juanpablo@726
   907
						key="textField"/>
juanpablo@726
   908
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   909
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   910
						<font fontName="Helvetica" size="10"/>
juanpablo@726
   911
					</textElement>
juanpablo@726
   912
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@726
   913
				</textField>
juanpablo@726
   914
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   915
					<reportElement
carlos@0
   916
						style="Report_Footer"
carlos@0
   917
						x="499"
carlos@0
   918
						y="4"
carlos@0
   919
						width="36"
carlos@0
   920
						height="16"
carlos@0
   921
						forecolor="#000000"
carlos@0
   922
						backcolor="#FFFFFF"
juanpablo@726
   923
						key="textField"/>
juanpablo@726
   924
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   925
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
juanpablo@726
   926
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
juanpablo@726
   927
					</textElement>
juanpablo@726
   928
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@726
   929
				</textField>
juanpablo@726
   930
				<line direction="TopDown">
carlos@0
   931
					<reportElement
carlos@0
   932
						x="0"
carlos@0
   933
						y="1"
carlos@0
   934
						width="535"
carlos@0
   935
						height="0"
carlos@0
   936
						forecolor="#000000"
juanpablo@726
   937
						key="line"/>
juanpablo@726
   938
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   939
				</line>
juanpablo@726
   940
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   941
					<reportElement
carlos@0
   942
						style="Report_Footer"
carlos@0
   943
						x="277"
carlos@0
   944
						y="4"
carlos@0
   945
						width="69"
carlos@0
   946
						height="16"
juanpablo@726
   947
						key="textField"/>
juanpablo@726
   948
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   949
					<textElement verticalAlignment="Middle">
juanpablo@726
   950
						<font fontName="Times-Roman" size="10"/>
juanpablo@726
   951
					</textElement>
juanpablo@726
   952
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@726
   953
				</textField>
juanpablo@726
   954
				<staticText>
carlos@0
   955
					<reportElement
carlos@0
   956
						style="Report_Footer"
carlos@0
   957
						x="198"
carlos@0
   958
						y="4"
carlos@0
   959
						width="76"
carlos@0
   960
						height="16"
juanpablo@726
   961
						key="staticText-1"/>
juanpablo@726
   962
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   963
					<textElement textAlignment="Right">
juanpablo@726
   964
						<font/>
juanpablo@726
   965
					</textElement>
juanpablo@726
   966
				<text><![CDATA[Printed on]]></text>
juanpablo@726
   967
				</staticText>
juanpablo@726
   968
				<staticText>
carlos@0
   969
					<reportElement
carlos@0
   970
						style="Report_Footer"
carlos@0
   971
						x="0"
carlos@0
   972
						y="4"
carlos@0
   973
						width="140"
carlos@0
   974
						height="16"
juanpablo@726
   975
						key="staticText-5">
juanpablo@726
   976
							<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
juanpablo@726
   977
						</reportElement>
juanpablo@726
   978
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   979
					<textElement>
juanpablo@726
   980
						<font/>
juanpablo@726
   981
					</textElement>
juanpablo@726
   982
				<text><![CDATA[other footer data]]></text>
juanpablo@726
   983
				</staticText>
juanpablo@726
   984
			</band>
juanpablo@726
   985
		</pageFooter>
juanpablo@726
   986
		<summary>
juanpablo@726
   987
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   988
			</band>
juanpablo@726
   989
		</summary>
juanpablo@726
   990
</jasperReport>