src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 0 0247c26f10c6
child 2199 efd783b991af
permissions -rw-r--r--
Removed old frame parameter of windowTableId
carlos@0
     1
<?xml version="1.0" encoding="UTF-8"  ?>
carlos@0
     2
<!-- Created with iReport - A designer for JasperReports -->
carlos@0
     3
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
carlos@0
     4
<jasperReport
carlos@0
     5
		 name="ReportGuaranteeDateJR"
carlos@0
     6
		 columnCount="1"
carlos@0
     7
		 printOrder="Vertical"
carlos@0
     8
		 orientation="Portrait"
carlos@0
     9
		 pageWidth="595"
carlos@0
    10
		 pageHeight="842"
carlos@0
    11
		 columnWidth="535"
carlos@0
    12
		 columnSpacing="0"
carlos@0
    13
		 leftMargin="30"
carlos@0
    14
		 rightMargin="30"
carlos@0
    15
		 topMargin="20"
carlos@0
    16
		 bottomMargin="20"
carlos@0
    17
		 whenNoDataType="NoPages"
carlos@0
    18
		 isTitleNewPage="false"
carlos@0
    19
		 isSummaryNewPage="false">
carlos@0
    20
	<property name="ireport.scriptlethandling" value="0" />
carlos@0
    21
	<property name="ireport.encoding" value="UTF-8" />
carlos@0
    22
	<import value="java.util.*" />
carlos@0
    23
	<import value="net.sf.jasperreports.engine.*" />
carlos@0
    24
	<import value="net.sf.jasperreports.engine.data.*" />
carlos@0
    25
carlos@0
    26
	<style 
carlos@0
    27
		name="default"
carlos@0
    28
		isDefault="false"
carlos@0
    29
		vAlign="Middle"
carlos@0
    30
		fontName="Bitstream Vera Sans"
carlos@0
    31
		fontSize="10"
carlos@0
    32
	/>
carlos@0
    33
	<style 
carlos@0
    34
		name="Report_Title"
carlos@0
    35
		isDefault="false"
carlos@0
    36
		leftPadding="5"
carlos@0
    37
		fontName="Bitstream Vera Sans"
carlos@0
    38
		fontSize="18"
carlos@0
    39
	/>
carlos@0
    40
	<style 
carlos@0
    41
		name="Report_Subtitle"
carlos@0
    42
		isDefault="false"
carlos@0
    43
		forecolor="#555555"
carlos@0
    44
		leftPadding="5"
carlos@0
    45
		fontName="Bitstream Vera Sans"
carlos@0
    46
		fontSize="14"
carlos@0
    47
	/>
carlos@0
    48
	<style 
carlos@0
    49
		name="Total_Field"
carlos@0
    50
		isDefault="false"
carlos@0
    51
		mode="Opaque"
carlos@0
    52
		forecolor="#000000"
carlos@0
    53
		backcolor="#CCCCCC"
carlos@0
    54
		vAlign="Middle"
carlos@0
    55
		leftPadding="5"
carlos@0
    56
	/>
carlos@0
    57
	<style 
carlos@0
    58
		name="Detail_Header"
carlos@0
    59
		isDefault="false"
carlos@0
    60
		mode="Opaque"
carlos@0
    61
		forecolor="#FFFFFF"
carlos@0
    62
		backcolor="#555555"
carlos@0
    63
		vAlign="Middle"
carlos@0
    64
		leftBorder="1Point"
carlos@0
    65
		leftBorderColor="#FFFFFF"
carlos@0
    66
		leftPadding="5"
carlos@0
    67
		rightBorder="1Point"
carlos@0
    68
		rightBorderColor="#FFFFFF"
carlos@0
    69
	/>
carlos@0
    70
	<style 
carlos@0
    71
		name="GroupHeader_DarkGray"
carlos@0
    72
		isDefault="false"
carlos@0
    73
		mode="Opaque"
carlos@0
    74
		forecolor="#FFFFFF"
carlos@0
    75
		backcolor="#555555"
carlos@0
    76
		vAlign="Middle"
carlos@0
    77
		leftPadding="5"
carlos@0
    78
		fontName="Bitstream Vera Sans"
carlos@0
    79
		fontSize="14"
carlos@0
    80
	/>
carlos@0
    81
	<style 
carlos@0
    82
		name="GroupHeader_Gray"
carlos@0
    83
		isDefault="false"
carlos@0
    84
		mode="Opaque"
carlos@0
    85
		backcolor="#999999"
carlos@0
    86
	/>
carlos@0
    87
	<style 
carlos@0
    88
		name="Detail_Line"
carlos@0
    89
		isDefault="false"
carlos@0
    90
	>
carlos@0
    91
carlos@0
    92
		<conditionalStyle>
carlos@0
    93
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression>
carlos@0
    94
			<style 
carlos@0
    95
				name="Detail_Line"
carlos@0
    96
				isDefault="false"
carlos@0
    97
				mode="Opaque"
carlos@0
    98
				backcolor="#CCCCCC"
carlos@0
    99
			/>
carlos@0
   100
		</conditionalStyle>
carlos@0
   101
	</style>
carlos@0
   102
	<style 
carlos@0
   103
		name="Total_Gray"
carlos@0
   104
		isDefault="false"
carlos@0
   105
		mode="Opaque"
carlos@0
   106
		forecolor="#000000"
carlos@0
   107
		backcolor="#CCCCCC"
carlos@0
   108
	/>
carlos@0
   109
carlos@0
   110
	<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
carlos@0
   111
	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
carlos@0
   112
	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
carlos@0
   113
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
carlos@0
   114
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
carlos@0
   115
	</parameter>
carlos@0
   116
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
carlos@0
   117
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
carlos@0
   118
	</parameter>
carlos@0
   119
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
carlos@0
   120
		<defaultValueExpression ><![CDATA["(0)"]]></defaultValueExpression>
carlos@0
   121
	</parameter>
carlos@0
   122
	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String"/>
carlos@0
   123
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
carlos@0
   124
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat">
carlos@0
   125
		<defaultValueExpression ><![CDATA[new DecimalFormat()]]></defaultValueExpression>
carlos@0
   126
	</parameter>
carlos@0
   127
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale">
carlos@0
   128
		<defaultValueExpression ><![CDATA[new Locale("en","US")]]></defaultValueExpression>
carlos@0
   129
	</parameter>
carlos@0
   130
	<queryString><![CDATA[SELECT M_PRODUCT.NAME, C_BPARTNER.NAME AS PARTNERNAME, M_ATTRIBUTESETINSTANCE.GUARANTEEDATE AS GUARANTEEDATE, S.QTYONHAND  AS MOVEMENTQTY, C1.NAME AS UOM,
carlos@0
   131
        (CASE WHEN S.M_PRODUCT_UOM_ID IS NULL THEN (CASE C1.C_UOM_ID WHEN 1000001 THEN NULL ELSE ((CASE WHEN M_PRODUCT.WEIGHT=0 THEN NULL WHEN M_PRODUCT.WEIGHT IS NULL THEN NULL ELSE M_PRODUCT.WEIGHT*S.QTYONHAND END)) END) ELSE S.QTYORDERONHAND END) AS WEIGHT, C2.NAME AS UOM2
carlos@0
   132
        FROM M_STORAGE_DETAIL S left join M_PRODUCT on S.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
carlos@0
   133
                                left join M_PRODUCT_UOM on S.M_PRODUCT_UOM_ID = M_PRODUCT_UOM.M_PRODUCT_UOM_ID
carlos@0
   134
                                left join C_BPARTNER on M_PRODUCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID 
carlos@0
   135
                                left join C_UOM C2 on M_PRODUCT_UOM.C_UOM_ID = C2.C_UOM_ID
carlos@0
   136
                                left join M_ATTRIBUTESETINSTANCE on S.M_ATTRIBUTESETINSTANCE_ID =  M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, 
carlos@0
   137
             C_UOM C1, M_LOCATOR, M_WAREHOUSE
carlos@0
   138
        WHERE S.M_LOCATOR_ID = M_LOCATOR.M_LOCATOR_ID
carlos@0
   139
        AND M_LOCATOR.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID
carlos@0
   140
        AND S.C_UOM_ID = C1.C_UOM_ID      
carlos@0
   141
        AND S.QTYONHAND <>0 
carlos@0
   142
        ORDER BY C_BPARTNER.NAME, GUARANTEEDATE DESC]]></queryString>
carlos@0
   143
carlos@0
   144
	<field name="NAME" class="java.lang.String"/>
carlos@0
   145
	<field name="PARTNERNAME" class="java.lang.String"/>
carlos@0
   146
	<field name="GUARANTEEDATE" class="java.util.Date"/>
carlos@0
   147
	<field name="MOVEMENTQTY" class="java.math.BigDecimal"/>
carlos@0
   148
	<field name="UOM" class="java.lang.String"/>
carlos@0
   149
	<field name="WEIGHT" class="java.math.BigDecimal"/>
carlos@0
   150
	<field name="UOM2" class="java.lang.String"/>
carlos@0
   151
carlos@0
   152
	<variable name="UOM2" class="java.lang.String" resetType="Report" calculation="Nothing">
carlos@0
   153
		<variableExpression><![CDATA[($F{WEIGHT}!=null && $F{UOM2} == null)?"Kgs":$F{UOM2}]]></variableExpression>
carlos@0
   154
	</variable>
carlos@0
   155
carlos@0
   156
		<group  name="PARTNERNAME" isReprintHeaderOnEachPage="true" >
carlos@0
   157
			<groupExpression><![CDATA[$F{PARTNERNAME}]]></groupExpression>
carlos@0
   158
			<groupHeader>
carlos@0
   159
			<band height="50"  isSplitAllowed="true" >
carlos@0
   160
				<staticText>
carlos@0
   161
					<reportElement
carlos@0
   162
						style="Detail_Header"
carlos@0
   163
						x="113"
carlos@0
   164
						y="34"
carlos@0
   165
						width="215"
carlos@0
   166
						height="16"
carlos@0
   167
						key="element-90"/>
carlos@0
   168
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   169
					<textElement>
carlos@0
   170
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   171
					</textElement>
carlos@0
   172
				<text><![CDATA[Description]]></text>
carlos@0
   173
				</staticText>
carlos@0
   174
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   175
					<reportElement
carlos@0
   176
						style="Detail_Header"
carlos@0
   177
						x="0"
carlos@0
   178
						y="0"
carlos@0
   179
						width="535"
carlos@0
   180
						height="23"
carlos@0
   181
						key="textField"/>
carlos@0
   182
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   183
					<textElement verticalAlignment="Middle">
carlos@0
   184
						<font fontName="Bitstream Vera Sans" size="12"/>
carlos@0
   185
					</textElement>
carlos@0
   186
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PARTNERNAME}]]></textFieldExpression>
carlos@0
   187
				</textField>
carlos@0
   188
				<staticText>
carlos@0
   189
					<reportElement
carlos@0
   190
						style="Detail_Header"
carlos@0
   191
						x="6"
carlos@0
   192
						y="34"
carlos@0
   193
						width="107"
carlos@0
   194
						height="16"
carlos@0
   195
						key="element-90"/>
carlos@0
   196
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   197
					<textElement>
carlos@0
   198
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   199
					</textElement>
carlos@0
   200
				<text><![CDATA[Shell-by-date]]></text>
carlos@0
   201
				</staticText>
carlos@0
   202
				<staticText>
carlos@0
   203
					<reportElement
carlos@0
   204
						style="Detail_Header"
carlos@0
   205
						x="328"
carlos@0
   206
						y="34"
carlos@0
   207
						width="107"
carlos@0
   208
						height="16"
carlos@0
   209
						key="element-90"/>
carlos@0
   210
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   211
					<textElement>
carlos@0
   212
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   213
					</textElement>
carlos@0
   214
				<text><![CDATA[Article unit]]></text>
carlos@0
   215
				</staticText>
carlos@0
   216
				<staticText>
carlos@0
   217
					<reportElement
carlos@0
   218
						style="Detail_Header"
carlos@0
   219
						x="435"
carlos@0
   220
						y="34"
carlos@0
   221
						width="98"
carlos@0
   222
						height="16"
carlos@0
   223
						key="element-90"/>
carlos@0
   224
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#FFFFFF" leftPadding="5" rightBorder="1Point" rightBorderColor="#FFFFFF" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   225
					<textElement>
carlos@0
   226
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   227
					</textElement>
carlos@0
   228
				<text><![CDATA[Other units]]></text>
carlos@0
   229
				</staticText>
carlos@0
   230
				<line direction="TopDown">
carlos@0
   231
					<reportElement
carlos@0
   232
						x="1"
carlos@0
   233
						y="23"
carlos@0
   234
						width="0"
carlos@0
   235
						height="27"
carlos@0
   236
						forecolor="#555555"
carlos@0
   237
						backcolor="#555555"
carlos@0
   238
						key="line-2"/>
carlos@0
   239
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   240
				</line>
carlos@0
   241
				<line direction="TopDown">
carlos@0
   242
					<reportElement
carlos@0
   243
						x="535"
carlos@0
   244
						y="23"
carlos@0
   245
						width="0"
carlos@0
   246
						height="27"
carlos@0
   247
						forecolor="#555555"
carlos@0
   248
						backcolor="#555555"
carlos@0
   249
						key="line-3"/>
carlos@0
   250
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   251
				</line>
carlos@0
   252
			</band>
carlos@0
   253
			</groupHeader>
carlos@0
   254
			<groupFooter>
carlos@0
   255
			<band height="0"  isSplitAllowed="true" >
carlos@0
   256
			</band>
carlos@0
   257
			</groupFooter>
carlos@0
   258
		</group>
carlos@0
   259
		<background>
carlos@0
   260
			<band height="0"  isSplitAllowed="true" >
carlos@0
   261
			</band>
carlos@0
   262
		</background>
carlos@0
   263
		<title>
carlos@0
   264
			<band height="20"  isSplitAllowed="true" >
carlos@0
   265
			</band>
carlos@0
   266
		</title>
carlos@0
   267
		<pageHeader>
carlos@0
   268
			<band height="50"  isSplitAllowed="true" >
carlos@0
   269
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   270
					<reportElement
carlos@0
   271
						style="Report_Title"
carlos@0
   272
						mode="Transparent"
carlos@0
   273
						x="0"
carlos@0
   274
						y="0"
carlos@0
   275
						width="535"
carlos@0
   276
						height="26"
carlos@0
   277
						key="textField-2"/>
carlos@0
   278
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   279
					<textElement>
carlos@0
   280
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   281
					</textElement>
carlos@0
   282
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
carlos@0
   283
				</textField>
carlos@0
   284
				<line direction="TopDown">
carlos@0
   285
					<reportElement
carlos@0
   286
						x="0"
carlos@0
   287
						y="32"
carlos@0
   288
						width="535"
carlos@0
   289
						height="0"
carlos@0
   290
						key="line-1"/>
carlos@0
   291
					<graphicElement stretchType="NoStretch"/>
carlos@0
   292
				</line>
carlos@0
   293
			</band>
carlos@0
   294
		</pageHeader>
carlos@0
   295
		<columnHeader>
carlos@0
   296
			<band height="0"  isSplitAllowed="true" >
carlos@0
   297
			</band>
carlos@0
   298
		</columnHeader>
carlos@0
   299
		<detail>
carlos@0
   300
			<band height="16"  isSplitAllowed="true" >
carlos@0
   301
				<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   302
					<reportElement
carlos@0
   303
						style="Detail_Line"
carlos@0
   304
						x="6"
carlos@0
   305
						y="0"
carlos@0
   306
						width="107"
carlos@0
   307
						height="16"
carlos@0
   308
						key="textField"
carlos@0
   309
						stretchType="RelativeToBandHeight"/>
carlos@0
   310
					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   311
					<textElement verticalAlignment="Middle">
carlos@0
   312
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   313
					</textElement>
carlos@0
   314
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{GUARANTEEDATE}]]></textFieldExpression>
carlos@0
   315
				</textField>
carlos@0
   316
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   317
					<reportElement
carlos@0
   318
						style="Detail_Line"
carlos@0
   319
						x="113"
carlos@0
   320
						y="0"
carlos@0
   321
						width="215"
carlos@0
   322
						height="16"
carlos@0
   323
						key="textField"
carlos@0
   324
						stretchType="RelativeToBandHeight"/>
carlos@0
   325
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   326
					<textElement verticalAlignment="Middle">
carlos@0
   327
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   328
					</textElement>
carlos@0
   329
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression>
carlos@0
   330
				</textField>
carlos@0
   331
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   332
					<reportElement
carlos@0
   333
						style="Detail_Line"
carlos@0
   334
						x="328"
carlos@0
   335
						y="0"
carlos@0
   336
						width="107"
carlos@0
   337
						height="16"
carlos@0
   338
						key="textField"
carlos@0
   339
						stretchType="RelativeToBandHeight"/>
carlos@0
   340
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   341
					<textElement textAlignment="Right" verticalAlignment="Middle">
carlos@0
   342
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   343
					</textElement>
carlos@0
   344
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{MOVEMENTQTY}!=null)?$P{NUMBERFORMAT}.format($F{MOVEMENTQTY})+" "+$F{UOM}:new String(" ")]]></textFieldExpression>
carlos@0
   345
				</textField>
carlos@0
   346
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   347
					<reportElement
carlos@0
   348
						style="Detail_Line"
carlos@0
   349
						x="435"
carlos@0
   350
						y="0"
carlos@0
   351
						width="98"
carlos@0
   352
						height="16"
carlos@0
   353
						key="textField"
carlos@0
   354
						stretchType="RelativeToBandHeight"/>
carlos@0
   355
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   356
					<textElement textAlignment="Right" verticalAlignment="Middle">
carlos@0
   357
						<font fontName="Bitstream Vera Sans"/>
carlos@0
   358
					</textElement>
carlos@0
   359
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{WEIGHT}!=null)?$P{NUMBERFORMAT}.format($F{WEIGHT})+" "+$V{UOM2}:new String(" ")]]></textFieldExpression>
carlos@0
   360
				</textField>
carlos@0
   361
				<line direction="TopDown">
carlos@0
   362
					<reportElement
carlos@0
   363
						x="535"
carlos@0
   364
						y="0"
carlos@0
   365
						width="0"
carlos@0
   366
						height="16"
carlos@0
   367
						forecolor="#555555"
carlos@0
   368
						backcolor="#555555"
carlos@0
   369
						key="line-4"/>
carlos@0
   370
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   371
				</line>
carlos@0
   372
				<line direction="TopDown">
carlos@0
   373
					<reportElement
carlos@0
   374
						x="1"
carlos@0
   375
						y="0"
carlos@0
   376
						width="0"
carlos@0
   377
						height="16"
carlos@0
   378
						forecolor="#555555"
carlos@0
   379
						backcolor="#555555"
carlos@0
   380
						key="line-5"/>
carlos@0
   381
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   382
				</line>
carlos@0
   383
			</band>
carlos@0
   384
		</detail>
carlos@0
   385
		<columnFooter>
carlos@0
   386
			<band height="0"  isSplitAllowed="true" >
carlos@0
   387
			</band>
carlos@0
   388
		</columnFooter>
carlos@0
   389
		<pageFooter>
carlos@0
   390
			<band height="35"  isSplitAllowed="true" >
carlos@0
   391
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   392
					<reportElement
carlos@0
   393
						x="400"
carlos@0
   394
						y="13"
carlos@0
   395
						width="95"
carlos@0
   396
						height="19"
carlos@0
   397
						key="textField"/>
carlos@0
   398
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   399
					<textElement textAlignment="Right" verticalAlignment="Middle">
carlos@0
   400
						<font fontName="Helvetica" size="10"/>
carlos@0
   401
					</textElement>
carlos@0
   402
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
carlos@0
   403
				</textField>
carlos@0
   404
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   405
					<reportElement
carlos@0
   406
						x="499"
carlos@0
   407
						y="13"
carlos@0
   408
						width="36"
carlos@0
   409
						height="19"
carlos@0
   410
						forecolor="#000000"
carlos@0
   411
						backcolor="#FFFFFF"
carlos@0
   412
						key="textField"/>
carlos@0
   413
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   414
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
carlos@0
   415
						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
carlos@0
   416
					</textElement>
carlos@0
   417
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
carlos@0
   418
				</textField>
carlos@0
   419
				<line direction="TopDown">
carlos@0
   420
					<reportElement
carlos@0
   421
						x="1"
carlos@0
   422
						y="8"
carlos@0
   423
						width="534"
carlos@0
   424
						height="0"
carlos@0
   425
						forecolor="#555555"
carlos@0
   426
						backcolor="#555555"
carlos@0
   427
						key="line"/>
carlos@0
   428
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   429
				</line>
carlos@0
   430
				<line direction="TopDown">
carlos@0
   431
					<reportElement
carlos@0
   432
						x="1"
carlos@0
   433
						y="0"
carlos@0
   434
						width="0"
carlos@0
   435
						height="8"
carlos@0
   436
						forecolor="#555555"
carlos@0
   437
						backcolor="#555555"
carlos@0
   438
						key="line-6"/>
carlos@0
   439
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   440
				</line>
carlos@0
   441
				<line direction="TopDown">
carlos@0
   442
					<reportElement
carlos@0
   443
						x="535"
carlos@0
   444
						y="0"
carlos@0
   445
						width="0"
carlos@0
   446
						height="8"
carlos@0
   447
						forecolor="#555555"
carlos@0
   448
						key="line-7"/>
carlos@0
   449
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   450
				</line>
carlos@0
   451
			</band>
carlos@0
   452
		</pageFooter>
carlos@0
   453
		<summary>
carlos@0
   454
			<band height="0"  isSplitAllowed="true" >
carlos@0
   455
			</band>
carlos@0
   456
		</summary>
carlos@0
   457
</jasperReport>