src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 726 dac2a1486bd3
child 1868 b462ce988fa2
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="ReportSalesOrderProvidedJR"
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="10"
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
	/>
juanpablo@726
    57
	<style 
juanpablo@726
    58
		name="Detail_Header"
juanpablo@726
    59
		isDefault="false"
juanpablo@726
    60
		mode="Opaque"
juanpablo@726
    61
		forecolor="#FFFFFF"
juanpablo@726
    62
		backcolor="#555555"
juanpablo@726
    63
		vAlign="Middle"
juanpablo@726
    64
		leftBorder="1Point"
juanpablo@726
    65
		leftBorderColor="#FFFFFF"
juanpablo@726
    66
		leftPadding="5"
juanpablo@726
    67
		rightBorder="1Point"
juanpablo@726
    68
		rightBorderColor="#FFFFFF"
juanpablo@726
    69
	/>
juanpablo@726
    70
	<style 
juanpablo@726
    71
		name="GroupHeader_DarkGray"
juanpablo@726
    72
		isDefault="false"
juanpablo@726
    73
		mode="Opaque"
juanpablo@726
    74
		forecolor="#FFFFFF"
juanpablo@726
    75
		backcolor="#555555"
juanpablo@726
    76
		vAlign="Middle"
juanpablo@726
    77
		leftPadding="5"
juanpablo@726
    78
		fontName="Bitstream Vera Sans"
juanpablo@726
    79
		fontSize="14"
juanpablo@726
    80
	/>
juanpablo@726
    81
	<style 
juanpablo@726
    82
		name="GroupHeader_Gray"
juanpablo@726
    83
		isDefault="false"
juanpablo@726
    84
		mode="Opaque"
juanpablo@726
    85
		backcolor="#999999"
juanpablo@726
    86
	/>
juanpablo@726
    87
	<style 
juanpablo@726
    88
		name="Detail_Line"
juanpablo@726
    89
		isDefault="false"
juanpablo@726
    90
	>
juanpablo@726
    91
juanpablo@726
    92
		<conditionalStyle>
juanpablo@726
    93
			<conditionExpression><![CDATA[new Boolean($V{PROJECTNAME_COUNT}.intValue()%2==0)]]></conditionExpression>
juanpablo@726
    94
			<style 
juanpablo@726
    95
				name="Detail_Line"
juanpablo@726
    96
				isDefault="false"
juanpablo@726
    97
				mode="Opaque"
juanpablo@726
    98
				backcolor="#CCCCCC"
juanpablo@726
    99
			/>
juanpablo@726
   100
		</conditionalStyle>
juanpablo@726
   101
	</style>
juanpablo@726
   102
	<style 
juanpablo@726
   103
		name="Total_Gray"
juanpablo@726
   104
		isDefault="false"
juanpablo@726
   105
		mode="Opaque"
juanpablo@726
   106
		forecolor="#000000"
juanpablo@726
   107
		backcolor="#CCCCCC"
juanpablo@726
   108
	/>
juanpablo@726
   109
juanpablo@726
   110
	<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   111
	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   112
	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   113
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   114
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
juanpablo@726
   115
	</parameter>
juanpablo@726
   116
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
juanpablo@726
   117
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
juanpablo@726
   118
	</parameter>
juanpablo@726
   119
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
juanpablo@726
   120
		<defaultValueExpression ><![CDATA["(0)"]]></defaultValueExpression>
juanpablo@726
   121
	</parameter>
juanpablo@726
   122
	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
juanpablo@726
   123
		<defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
juanpablo@726
   124
	</parameter>
juanpablo@726
   125
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
juanpablo@726
   126
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
juanpablo@726
   127
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
carlos@0
   128
	<queryString><![CDATA[SELECT C_BPARTNER.NAME AS BPARTNERNAME, C_PROJECT.VALUE||' '||C_PROJECT.NAME AS PROJECTNAME, 
carlos@0
   129
      M_PRODUCT.NAME AS PRODUCTNAME, SUM(C_ORDERLINE.QTYDELIVERED) AS QTYDELIVERED, 
carlos@0
   130
      SUM(C_ORDERLINE.QTYDELIVERED*C_ORDERLINE.PRICEACTUAL) AS LINENETAMT, C_UOM.NAME AS UOMNAME, C_ORDERLINE.PRICEACTUAL, '' AS NAME
carlos@0
   131
      FROM C_PROJECT right join C_ORDER on C_ORDER.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID
carlos@0
   132
                     left join C_BPARTNER on C_PROJECT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
carlos@0
   133
                     left join C_BPARTNER_LOCATION on C_PROJECT.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
carlos@0
   134
                     left join C_LOCATION on C_BPARTNER_LOCATION.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID,
carlos@0
   135
       C_ORDERLINE,  M_PRODUCT, C_UOM
carlos@0
   136
      WHERE C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID 
carlos@0
   137
      AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
carlos@0
   138
      AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
carlos@0
   139
      AND C_ORDER.AD_CLIENT_ID IN ('1')
carlos@0
   140
      AND C_ORDER.AD_ORG_ID IN ('1')
carlos@0
   141
      AND 1=1
carlos@0
   142
      GROUP BY C_BPARTNER.NAME, C_PROJECT.VALUE, C_PROJECT.NAME, M_PRODUCT.NAME, C_UOM.NAME, C_ORDERLINE.PRICEACTUAL
juanpablo@726
   143
      HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0]]></queryString>
juanpablo@726
   144
juanpablo@726
   145
	<field name="BPARTNERNAME" class="java.lang.String"/>
juanpablo@726
   146
	<field name="PROJECTNAME" class="java.lang.String"/>
juanpablo@726
   147
	<field name="PRODUCTNAME" class="java.lang.String"/>
juanpablo@726
   148
	<field name="QTYDELIVERED" class="java.math.BigDecimal"/>
juanpablo@726
   149
	<field name="LINENETAMT" class="java.math.BigDecimal"/>
juanpablo@726
   150
	<field name="UOMNAME" class="java.lang.String"/>
juanpablo@726
   151
	<field name="PRICEACTUAL" class="java.math.BigDecimal"/>
juanpablo@726
   152
	<field name="NAME" class="java.lang.String"/>
juanpablo@726
   153
juanpablo@726
   154
	<variable name="sumTotalQty" class="java.math.BigDecimal" resetType="Group" resetGroup="PROJECTNAME" calculation="Sum">
juanpablo@726
   155
		<variableExpression><![CDATA[$F{QTYDELIVERED}]]></variableExpression>
juanpablo@726
   156
	</variable>
juanpablo@726
   157
	<variable name="sumTotalAmount" class="java.math.BigDecimal" resetType="Group" resetGroup="PROJECTNAME" calculation="Sum">
juanpablo@726
   158
		<variableExpression><![CDATA[$F{LINENETAMT}]]></variableExpression>
juanpablo@726
   159
	</variable>
juanpablo@726
   160
juanpablo@726
   161
		<group  name="BPARTNERNAME" >
juanpablo@726
   162
			<groupExpression><![CDATA[$F{BPARTNERNAME}]]></groupExpression>
juanpablo@726
   163
			<groupHeader>
juanpablo@726
   164
			<band height="33"  isSplitAllowed="true" >
juanpablo@726
   165
				<staticText>
carlos@0
   166
					<reportElement
carlos@0
   167
						style="GroupHeader_DarkGray"
carlos@0
   168
						x="0"
carlos@0
   169
						y="0"
carlos@0
   170
						width="130"
carlos@0
   171
						height="23"
juanpablo@726
   172
						key="staticText"/>
juanpablo@726
   173
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   174
					<textElement>
juanpablo@726
   175
						<font pdfFontName="Helvetica"/>
juanpablo@726
   176
					</textElement>
juanpablo@726
   177
				<text><![CDATA[Business Partner]]></text>
juanpablo@726
   178
				</staticText>
juanpablo@726
   179
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   180
					<reportElement
carlos@0
   181
						style="GroupHeader_DarkGray"
carlos@0
   182
						x="130"
carlos@0
   183
						y="0"
carlos@0
   184
						width="405"
carlos@0
   185
						height="23"
juanpablo@726
   186
						key="textField"/>
juanpablo@726
   187
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   188
					<textElement>
juanpablo@726
   189
						<font pdfFontName="Helvetica"/>
juanpablo@726
   190
					</textElement>
juanpablo@726
   191
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{BPARTNERNAME}]]></textFieldExpression>
juanpablo@726
   192
				</textField>
juanpablo@726
   193
				<line direction="TopDown">
carlos@0
   194
					<reportElement
carlos@0
   195
						x="0"
carlos@0
   196
						y="23"
carlos@0
   197
						width="0"
carlos@0
   198
						height="10"
carlos@0
   199
						forecolor="#555555"
carlos@0
   200
						key="line-2"
juanpablo@726
   201
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   202
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   203
				</line>
juanpablo@726
   204
				<line direction="TopDown">
carlos@0
   205
					<reportElement
carlos@0
   206
						x="535"
carlos@0
   207
						y="23"
carlos@0
   208
						width="0"
carlos@0
   209
						height="10"
carlos@0
   210
						forecolor="#555555"
carlos@0
   211
						key="line-3"
juanpablo@726
   212
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   213
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   214
				</line>
juanpablo@726
   215
			</band>
juanpablo@726
   216
			</groupHeader>
juanpablo@726
   217
			<groupFooter>
juanpablo@726
   218
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
   219
				<line direction="TopDown">
carlos@0
   220
					<reportElement
carlos@0
   221
						x="0"
carlos@0
   222
						y="0"
carlos@0
   223
						width="0"
carlos@0
   224
						height="10"
carlos@0
   225
						forecolor="#555555"
carlos@0
   226
						key="line-32"
juanpablo@726
   227
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   228
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   229
				</line>
juanpablo@726
   230
				<line direction="TopDown">
carlos@0
   231
					<reportElement
carlos@0
   232
						x="535"
carlos@0
   233
						y="0"
carlos@0
   234
						width="0"
carlos@0
   235
						height="10"
carlos@0
   236
						forecolor="#555555"
carlos@0
   237
						key="line-33"
juanpablo@726
   238
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   239
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   240
				</line>
juanpablo@726
   241
				<line direction="TopDown">
carlos@0
   242
					<reportElement
carlos@0
   243
						x="0"
carlos@0
   244
						y="10"
carlos@0
   245
						width="535"
carlos@0
   246
						height="0"
carlos@0
   247
						forecolor="#555555"
juanpablo@726
   248
						key="line-34"/>
juanpablo@726
   249
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   250
				</line>
juanpablo@726
   251
			</band>
juanpablo@726
   252
			</groupFooter>
juanpablo@726
   253
		</group>
juanpablo@726
   254
		<group  name="PROJECTNAME" >
juanpablo@726
   255
			<groupExpression><![CDATA[$F{PROJECTNAME}]]></groupExpression>
juanpablo@726
   256
			<groupHeader>
juanpablo@726
   257
			<band height="50"  isSplitAllowed="true" >
juanpablo@726
   258
				<staticText>
carlos@0
   259
					<reportElement
carlos@0
   260
						style="GroupHeader_DarkGray"
carlos@0
   261
						x="10"
carlos@0
   262
						y="0"
carlos@0
   263
						width="120"
carlos@0
   264
						height="23"
juanpablo@726
   265
						key="staticText"/>
juanpablo@726
   266
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   267
					<textElement>
juanpablo@726
   268
						<font pdfFontName="Helvetica"/>
juanpablo@726
   269
					</textElement>
juanpablo@726
   270
				<text><![CDATA[PROJECT]]></text>
juanpablo@726
   271
				</staticText>
juanpablo@726
   272
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   273
					<reportElement
carlos@0
   274
						style="GroupHeader_DarkGray"
carlos@0
   275
						x="130"
carlos@0
   276
						y="0"
carlos@0
   277
						width="405"
carlos@0
   278
						height="23"
juanpablo@726
   279
						key="textField"/>
juanpablo@726
   280
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   281
					<textElement>
juanpablo@726
   282
						<font pdfFontName="Helvetica" isBold="false"/>
juanpablo@726
   283
					</textElement>
juanpablo@726
   284
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PROJECTNAME}]]></textFieldExpression>
juanpablo@726
   285
				</textField>
juanpablo@726
   286
				<line direction="TopDown">
carlos@0
   287
					<reportElement
carlos@0
   288
						x="10"
carlos@0
   289
						y="23"
carlos@0
   290
						width="0"
carlos@0
   291
						height="27"
carlos@0
   292
						forecolor="#555555"
carlos@0
   293
						key="line-4"
juanpablo@726
   294
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   295
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   296
				</line>
juanpablo@726
   297
				<line direction="TopDown">
carlos@0
   298
					<reportElement
carlos@0
   299
						x="535"
carlos@0
   300
						y="0"
carlos@0
   301
						width="0"
carlos@0
   302
						height="50"
carlos@0
   303
						forecolor="#555555"
carlos@0
   304
						key="line-6"
juanpablo@726
   305
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   306
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   307
				</line>
juanpablo@726
   308
				<line direction="TopDown">
carlos@0
   309
					<reportElement
carlos@0
   310
						x="0"
carlos@0
   311
						y="0"
carlos@0
   312
						width="0"
carlos@0
   313
						height="50"
carlos@0
   314
						forecolor="#555555"
carlos@0
   315
						key="line-8"
juanpablo@726
   316
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   317
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   318
				</line>
juanpablo@726
   319
				<staticText>
carlos@0
   320
					<reportElement
carlos@0
   321
						style="Detail_Header"
carlos@0
   322
						x="20"
carlos@0
   323
						y="34"
carlos@0
   324
						width="150"
carlos@0
   325
						height="16"
juanpablo@726
   326
						key="element-90"/>
juanpablo@726
   327
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   328
					<textElement>
juanpablo@726
   329
						<font/>
juanpablo@726
   330
					</textElement>
juanpablo@726
   331
				<text><![CDATA[PRODUCT]]></text>
juanpablo@726
   332
				</staticText>
juanpablo@726
   333
				<staticText>
carlos@0
   334
					<reportElement
carlos@0
   335
						style="Detail_Header"
carlos@0
   336
						x="170"
carlos@0
   337
						y="34"
carlos@0
   338
						width="90"
carlos@0
   339
						height="16"
juanpablo@726
   340
						key="element-90"/>
juanpablo@726
   341
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   342
					<textElement textAlignment="Right">
juanpablo@726
   343
						<font/>
juanpablo@726
   344
					</textElement>
juanpablo@726
   345
				<text><![CDATA[Quantity]]></text>
juanpablo@726
   346
				</staticText>
juanpablo@726
   347
				<staticText>
carlos@0
   348
					<reportElement
carlos@0
   349
						style="Detail_Header"
carlos@0
   350
						x="420"
carlos@0
   351
						y="34"
carlos@0
   352
						width="110"
carlos@0
   353
						height="16"
juanpablo@726
   354
						key="element-90"/>
juanpablo@726
   355
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="5" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   356
					<textElement textAlignment="Right">
juanpablo@726
   357
						<font/>
juanpablo@726
   358
					</textElement>
juanpablo@726
   359
				<text><![CDATA[Amount]]></text>
juanpablo@726
   360
				</staticText>
juanpablo@726
   361
				<staticText>
carlos@0
   362
					<reportElement
carlos@0
   363
						style="Detail_Header"
carlos@0
   364
						x="350"
carlos@0
   365
						y="34"
carlos@0
   366
						width="70"
carlos@0
   367
						height="16"
juanpablo@726
   368
						key="element-90"/>
juanpablo@726
   369
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="4" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   370
					<textElement>
juanpablo@726
   371
						<font/>
juanpablo@726
   372
					</textElement>
juanpablo@726
   373
				<text><![CDATA[Unit]]></text>
juanpablo@726
   374
				</staticText>
juanpablo@726
   375
				<staticText>
carlos@0
   376
					<reportElement
carlos@0
   377
						style="Detail_Header"
carlos@0
   378
						x="260"
carlos@0
   379
						y="34"
carlos@0
   380
						width="90"
carlos@0
   381
						height="16"
juanpablo@726
   382
						key="element-90"/>
juanpablo@726
   383
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   384
					<textElement textAlignment="Right">
juanpablo@726
   385
						<font/>
juanpablo@726
   386
					</textElement>
juanpablo@726
   387
				<text><![CDATA[Price (/m2)]]></text>
juanpablo@726
   388
				</staticText>
juanpablo@726
   389
			</band>
juanpablo@726
   390
			</groupHeader>
juanpablo@726
   391
			<groupFooter>
juanpablo@726
   392
			<band height="35"  isSplitAllowed="true" >
juanpablo@726
   393
				<line direction="TopDown">
carlos@0
   394
					<reportElement
carlos@0
   395
						x="0"
carlos@0
   396
						y="0"
carlos@0
   397
						width="0"
carlos@0
   398
						height="35"
carlos@0
   399
						forecolor="#555555"
carlos@0
   400
						key="line-28"
juanpablo@726
   401
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   402
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   403
				</line>
juanpablo@726
   404
				<line direction="TopDown">
carlos@0
   405
					<reportElement
carlos@0
   406
						x="10"
carlos@0
   407
						y="0"
carlos@0
   408
						width="0"
carlos@0
   409
						height="8"
carlos@0
   410
						forecolor="#555555"
carlos@0
   411
						key="line-29"
juanpablo@726
   412
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   413
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   414
				</line>
juanpablo@726
   415
				<line direction="TopDown">
carlos@0
   416
					<reportElement
carlos@0
   417
						x="535"
carlos@0
   418
						y="0"
carlos@0
   419
						width="0"
carlos@0
   420
						height="35"
carlos@0
   421
						forecolor="#555555"
carlos@0
   422
						key="line-30"
juanpablo@726
   423
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   424
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   425
				</line>
juanpablo@726
   426
				<line direction="TopDown">
carlos@0
   427
					<reportElement
carlos@0
   428
						x="10"
carlos@0
   429
						y="8"
carlos@0
   430
						width="525"
carlos@0
   431
						height="0"
carlos@0
   432
						forecolor="#666666"
juanpablo@726
   433
						key="line-31"/>
juanpablo@726
   434
					<graphicElement stretchType="NoStretch" pen="1Point"/>
juanpablo@726
   435
				</line>
juanpablo@726
   436
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   437
					<reportElement
carlos@0
   438
						mode="Opaque"
carlos@0
   439
						x="110"
carlos@0
   440
						y="12"
carlos@0
   441
						width="150"
carlos@0
   442
						height="16"
carlos@0
   443
						backcolor="#CCCCCC"
juanpablo@726
   444
						key="textField"/>
juanpablo@726
   445
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   446
					<textElement textAlignment="Right">
juanpablo@726
   447
						<font size="12"/>
juanpablo@726
   448
					</textElement>
juanpablo@726
   449
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{sumTotalQty}!=null)?$P{NUMBERFORMAT}.format($V{sumTotalQty}):new String(" ")]]></textFieldExpression>
juanpablo@726
   450
				</textField>
juanpablo@726
   451
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   452
					<reportElement
carlos@0
   453
						mode="Opaque"
carlos@0
   454
						x="260"
carlos@0
   455
						y="12"
carlos@0
   456
						width="270"
carlos@0
   457
						height="16"
carlos@0
   458
						backcolor="#CCCCCC"
juanpablo@726
   459
						key="textField"/>
juanpablo@726
   460
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   461
					<textElement textAlignment="Right">
juanpablo@726
   462
						<font size="12"/>
juanpablo@726
   463
					</textElement>
juanpablo@726
   464
				<textFieldExpression   class="java.lang.String"><![CDATA[($V{sumTotalAmount}!=null)?$P{NUMBERFORMAT}.format($V{sumTotalAmount}):new String(" ")]]></textFieldExpression>
juanpablo@726
   465
				</textField>
juanpablo@726
   466
				<staticText>
carlos@0
   467
					<reportElement
carlos@0
   468
						x="20"
carlos@0
   469
						y="12"
carlos@0
   470
						width="90"
carlos@0
   471
						height="16"
juanpablo@726
   472
						key="staticText-4"/>
juanpablo@726
   473
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   474
					<textElement>
juanpablo@726
   475
						<font fontName="Bitstream Vera Sans" size="12"/>
juanpablo@726
   476
					</textElement>
juanpablo@726
   477
				<text><![CDATA[Total:]]></text>
juanpablo@726
   478
				</staticText>
juanpablo@726
   479
				<line direction="TopDown">
carlos@0
   480
					<reportElement
carlos@0
   481
						x="20"
carlos@0
   482
						y="0"
carlos@0
   483
						width="510"
carlos@0
   484
						height="0"
carlos@0
   485
						forecolor="#555555"
juanpablo@726
   486
						key="line-35"/>
juanpablo@726
   487
					<graphicElement stretchType="NoStretch"/>
juanpablo@726
   488
				</line>
juanpablo@726
   489
			</band>
juanpablo@726
   490
			</groupFooter>
juanpablo@726
   491
		</group>
juanpablo@726
   492
		<background>
juanpablo@726
   493
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   494
			</band>
juanpablo@726
   495
		</background>
juanpablo@726
   496
		<title>
juanpablo@726
   497
			<band height="9"  isSplitAllowed="true" >
juanpablo@726
   498
			</band>
juanpablo@726
   499
		</title>
juanpablo@726
   500
		<pageHeader>
juanpablo@726
   501
			<band height="47"  isSplitAllowed="true" >
juanpablo@726
   502
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   503
					<reportElement
carlos@0
   504
						style="Report_Subtitle"
carlos@0
   505
						x="0"
carlos@0
   506
						y="24"
carlos@0
   507
						width="535"
carlos@0
   508
						height="20"
juanpablo@726
   509
						key="textField-1"/>
juanpablo@726
   510
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   511
					<textElement>
juanpablo@726
   512
						<font/>
juanpablo@726
   513
					</textElement>
juanpablo@726
   514
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_SUBTITLE}]]></textFieldExpression>
juanpablo@726
   515
				</textField>
juanpablo@726
   516
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   517
					<reportElement
carlos@0
   518
						style="Report_Title"
carlos@0
   519
						mode="Transparent"
carlos@0
   520
						x="0"
carlos@0
   521
						y="4"
carlos@0
   522
						width="535"
carlos@0
   523
						height="20"
juanpablo@726
   524
						key="textField-2"/>
juanpablo@726
   525
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   526
					<textElement>
juanpablo@726
   527
						<font/>
juanpablo@726
   528
					</textElement>
juanpablo@726
   529
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
juanpablo@726
   530
				</textField>
juanpablo@726
   531
			</band>
juanpablo@726
   532
		</pageHeader>
juanpablo@726
   533
		<columnHeader>
juanpablo@726
   534
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   535
			</band>
juanpablo@726
   536
		</columnHeader>
juanpablo@726
   537
		<detail>
juanpablo@726
   538
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   539
				<line direction="TopDown">
carlos@0
   540
					<reportElement
carlos@0
   541
						x="535"
carlos@0
   542
						y="0"
carlos@0
   543
						width="0"
carlos@0
   544
						height="16"
carlos@0
   545
						forecolor="#555555"
carlos@0
   546
						key="line-16"
juanpablo@726
   547
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   548
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   549
				</line>
juanpablo@726
   550
				<line direction="TopDown">
carlos@0
   551
					<reportElement
carlos@0
   552
						x="0"
carlos@0
   553
						y="0"
carlos@0
   554
						width="0"
carlos@0
   555
						height="16"
carlos@0
   556
						forecolor="#555555"
carlos@0
   557
						key="line-17"
juanpablo@726
   558
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   559
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   560
				</line>
juanpablo@726
   561
				<line direction="TopDown">
carlos@0
   562
					<reportElement
carlos@0
   563
						x="10"
carlos@0
   564
						y="0"
carlos@0
   565
						width="0"
carlos@0
   566
						height="16"
carlos@0
   567
						forecolor="#555555"
carlos@0
   568
						key="line-18"
juanpablo@726
   569
						stretchType="RelativeToBandHeight"/>
juanpablo@726
   570
					<graphicElement stretchType="RelativeToBandHeight" pen="1Point"/>
juanpablo@726
   571
				</line>
juanpablo@726
   572
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   573
					<reportElement
carlos@0
   574
						style="Detail_Line"
carlos@0
   575
						x="20"
carlos@0
   576
						y="0"
carlos@0
   577
						width="150"
carlos@0
   578
						height="16"
juanpablo@726
   579
						key="textField"/>
juanpablo@726
   580
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   581
					<textElement verticalAlignment="Middle">
juanpablo@726
   582
						<font fontName="Times-Roman" size="12"/>
juanpablo@726
   583
					</textElement>
juanpablo@726
   584
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRODUCTNAME}!=null)?$F{PRODUCTNAME}:new String(" ")]]></textFieldExpression>
juanpablo@726
   585
				</textField>
juanpablo@726
   586
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   587
					<reportElement
carlos@0
   588
						style="Detail_Line"
carlos@0
   589
						x="170"
carlos@0
   590
						y="0"
carlos@0
   591
						width="90"
carlos@0
   592
						height="16"
juanpablo@726
   593
						key="textField"/>
juanpablo@726
   594
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   595
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   596
						<font fontName="Times-Roman" size="12"/>
juanpablo@726
   597
					</textElement>
juanpablo@726
   598
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{QTYDELIVERED}!=null)?$P{NUMBERFORMAT}.format($F{QTYDELIVERED}):new String(" ")]]></textFieldExpression>
juanpablo@726
   599
				</textField>
juanpablo@726
   600
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   601
					<reportElement
carlos@0
   602
						style="Detail_Line"
carlos@0
   603
						x="420"
carlos@0
   604
						y="0"
carlos@0
   605
						width="110"
carlos@0
   606
						height="16"
juanpablo@726
   607
						key="textField"/>
juanpablo@726
   608
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="1Point" rightBorderColor="#555555" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   609
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   610
						<font fontName="Times-Roman" size="12"/>
juanpablo@726
   611
					</textElement>
juanpablo@726
   612
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{LINENETAMT}!=null)?$P{NUMBERFORMAT}.format($F{LINENETAMT}):new String(" ")]]></textFieldExpression>
juanpablo@726
   613
				</textField>
juanpablo@726
   614
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   615
					<reportElement
carlos@0
   616
						style="Detail_Line"
carlos@0
   617
						x="350"
carlos@0
   618
						y="0"
carlos@0
   619
						width="70"
carlos@0
   620
						height="16"
juanpablo@726
   621
						key="textField"/>
juanpablo@726
   622
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   623
					<textElement verticalAlignment="Middle">
juanpablo@726
   624
						<font fontName="Times-Roman" size="12"/>
juanpablo@726
   625
					</textElement>
juanpablo@726
   626
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{UOMNAME}!=null)?$F{UOMNAME}:new String(" ")]]></textFieldExpression>
juanpablo@726
   627
				</textField>
juanpablo@726
   628
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   629
					<reportElement
carlos@0
   630
						style="Detail_Line"
carlos@0
   631
						x="260"
carlos@0
   632
						y="0"
carlos@0
   633
						width="90"
carlos@0
   634
						height="16"
juanpablo@726
   635
						key="textField"/>
juanpablo@726
   636
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#555555" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#555555"/>
juanpablo@726
   637
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   638
						<font fontName="Times-Roman" size="12"/>
juanpablo@726
   639
					</textElement>
juanpablo@726
   640
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{PRICEACTUAL}!=null)?$P{NUMBERFORMAT}.format($F{PRICEACTUAL}):new String(" ")]]></textFieldExpression>
juanpablo@726
   641
				</textField>
juanpablo@726
   642
			</band>
juanpablo@726
   643
		</detail>
juanpablo@726
   644
		<columnFooter>
juanpablo@726
   645
			<band height="16"  isSplitAllowed="true" >
juanpablo@726
   646
			</band>
juanpablo@726
   647
		</columnFooter>
juanpablo@726
   648
		<pageFooter>
juanpablo@726
   649
			<band height="27"  isSplitAllowed="true" >
juanpablo@726
   650
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   651
					<reportElement
carlos@0
   652
						x="400"
carlos@0
   653
						y="4"
carlos@0
   654
						width="95"
carlos@0
   655
						height="19"
juanpablo@726
   656
						key="textField"/>
juanpablo@726
   657
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   658
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@726
   659
						<font fontName="Helvetica" size="10"/>
juanpablo@726
   660
					</textElement>
juanpablo@726
   661
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@726
   662
				</textField>
juanpablo@726
   663
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   664
					<reportElement
carlos@0
   665
						x="499"
carlos@0
   666
						y="4"
carlos@0
   667
						width="36"
carlos@0
   668
						height="19"
carlos@0
   669
						forecolor="#000000"
carlos@0
   670
						backcolor="#FFFFFF"
juanpablo@726
   671
						key="textField"/>
juanpablo@726
   672
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   673
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
juanpablo@726
   674
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
juanpablo@726
   675
					</textElement>
juanpablo@726
   676
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@726
   677
				</textField>
juanpablo@726
   678
				<line direction="TopDown">
carlos@0
   679
					<reportElement
carlos@0
   680
						x="0"
carlos@0
   681
						y="1"
carlos@0
   682
						width="535"
carlos@0
   683
						height="0"
carlos@0
   684
						forecolor="#000000"
juanpablo@726
   685
						key="line"/>
juanpablo@726
   686
					<graphicElement stretchType="NoStretch" pen="2Point"/>
juanpablo@726
   687
				</line>
juanpablo@726
   688
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   689
					<reportElement
carlos@0
   690
						x="277"
carlos@0
   691
						y="4"
carlos@0
   692
						width="69"
carlos@0
   693
						height="19"
juanpablo@726
   694
						key="textField"/>
juanpablo@726
   695
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   696
					<textElement verticalAlignment="Middle">
juanpablo@726
   697
						<font fontName="Times-Roman" size="10"/>
juanpablo@726
   698
					</textElement>
juanpablo@726
   699
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@726
   700
				</textField>
juanpablo@726
   701
				<staticText>
carlos@0
   702
					<reportElement
carlos@0
   703
						x="213"
carlos@0
   704
						y="4"
carlos@0
   705
						width="60"
carlos@0
   706
						height="19"
juanpablo@726
   707
						key="staticText-1"/>
juanpablo@726
   708
					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   709
					<textElement textAlignment="Right">
juanpablo@726
   710
						<font/>
juanpablo@726
   711
					</textElement>
juanpablo@726
   712
				<text><![CDATA[Printed on]]></text>
juanpablo@726
   713
				</staticText>
juanpablo@726
   714
			</band>
juanpablo@726
   715
		</pageFooter>
juanpablo@726
   716
		<summary>
juanpablo@726
   717
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   718
			</band>
juanpablo@726
   719
		</summary>
juanpablo@726
   720
</jasperReport>