src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 0 0247c26f10c6
child 1605 8a0fe0193bef
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="ReportGeneralLedgerJournal"
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="11"
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
		fontName="Bitstream Vera Sans"
carlos@0
    57
		fontSize="11"
carlos@0
    58
		isBold="true"
carlos@0
    59
	/>
carlos@0
    60
	<style 
carlos@0
    61
		name="Detail_Header"
carlos@0
    62
		isDefault="false"
carlos@0
    63
		mode="Opaque"
carlos@0
    64
		forecolor="#FFFFFF"
carlos@0
    65
		backcolor="#5D5D5D"
carlos@0
    66
		vAlign="Middle"
carlos@0
    67
		leftBorder="1Point"
carlos@0
    68
		leftBorderColor="#FFFFFF"
carlos@0
    69
		leftPadding="5"
carlos@0
    70
		rightBorder="1Point"
carlos@0
    71
		rightBorderColor="#FFFFFF"
carlos@0
    72
		fontName="Bitstream Vera Sans"
carlos@0
    73
		fontSize="11"
carlos@0
    74
		isBold="true"
carlos@0
    75
	/>
carlos@0
    76
	<style 
carlos@0
    77
		name="GroupHeader_DarkGray"
carlos@0
    78
		isDefault="false"
carlos@0
    79
		mode="Opaque"
carlos@0
    80
		forecolor="#FFFFFF"
carlos@0
    81
		backcolor="#555555"
carlos@0
    82
		vAlign="Middle"
carlos@0
    83
		leftPadding="5"
carlos@0
    84
		fontName="Bitstream Vera Sans"
carlos@0
    85
		fontSize="18"
carlos@0
    86
		isBold="true"
carlos@0
    87
	/>
carlos@0
    88
	<style 
carlos@0
    89
		name="GroupHeader_Gray"
carlos@0
    90
		isDefault="false"
carlos@0
    91
		mode="Opaque"
carlos@0
    92
		backcolor="#999999"
carlos@0
    93
	/>
carlos@0
    94
	<style 
carlos@0
    95
		name="Detail_Line"
carlos@0
    96
		isDefault="false"
carlos@0
    97
		fontName="Bitstream Vera Sans"
carlos@0
    98
		fontSize="11"
carlos@0
    99
	>
carlos@0
   100
carlos@0
   101
		<conditionalStyle>
carlos@0
   102
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression>
carlos@0
   103
			<style 
carlos@0
   104
				name="Detail_Line"
carlos@0
   105
				isDefault="false"
carlos@0
   106
				mode="Opaque"
carlos@0
   107
				backcolor="#CCCCCC"
carlos@0
   108
			/>
carlos@0
   109
		</conditionalStyle>
carlos@0
   110
	</style>
carlos@0
   111
	<style 
carlos@0
   112
		name="Total_Gray"
carlos@0
   113
		isDefault="false"
carlos@0
   114
		mode="Opaque"
carlos@0
   115
		forecolor="#000000"
carlos@0
   116
		backcolor="#CCCCCC"
carlos@0
   117
	/>
carlos@0
   118
	<style 
carlos@0
   119
		name="Report_Data_Label"
carlos@0
   120
		isDefault="false"
carlos@0
   121
		fontName="Bitstream Vera Sans"
carlos@0
   122
		fontSize="11"
carlos@0
   123
		isBold="true"
carlos@0
   124
	/>
carlos@0
   125
	<style 
carlos@0
   126
		name="Report_Data_Field"
carlos@0
   127
		isDefault="false"
carlos@0
   128
		fontName="Bitstream Vera Sans"
carlos@0
   129
		fontSize="11"
carlos@0
   130
		isBold="false"
carlos@0
   131
	/>
carlos@0
   132
	<style 
carlos@0
   133
		name="Report_Footer"
carlos@0
   134
		isDefault="true"
carlos@0
   135
		fontName="Bitstream Vera Sans"
carlos@0
   136
		fontSize="11"
carlos@0
   137
	/>
carlos@0
   138
	<style 
carlos@0
   139
		name="Group_Data_Label"
carlos@0
   140
		isDefault="false"
carlos@0
   141
		fontName="Bitstream Vera Sans"
carlos@0
   142
		fontSize="14"
carlos@0
   143
		isBold="true"
carlos@0
   144
	/>
carlos@0
   145
	<style 
carlos@0
   146
		name="Group_Data_Field"
carlos@0
   147
		isDefault="false"
carlos@0
   148
		fontName="Bitstream Vera Sans"
carlos@0
   149
		fontSize="14"
carlos@0
   150
	/>
carlos@0
   151
	<style 
carlos@0
   152
		name="Detail_Data_Label"
carlos@0
   153
		isDefault="false"
carlos@0
   154
		mode="Opaque"
carlos@0
   155
		backcolor="#CCCCCC"
carlos@0
   156
		fontName="Bitstream Vera Sans"
carlos@0
   157
		fontSize="11"
carlos@0
   158
		isBold="true"
carlos@0
   159
	/>
carlos@0
   160
	<style 
carlos@0
   161
		name="Detail_Data_Field"
carlos@0
   162
		isDefault="false"
carlos@0
   163
		mode="Opaque"
carlos@0
   164
		backcolor="#CCCCCC"
carlos@0
   165
		fontName="Bitstream Vera Sans"
carlos@0
   166
		fontSize="11"
carlos@0
   167
	/>
carlos@0
   168
	<style 
carlos@0
   169
		name="Group_Footer"
carlos@0
   170
		isDefault="false"
carlos@0
   171
		fontName="Bitstream Vera Sans"
carlos@0
   172
		fontSize="11"
carlos@0
   173
		isBold="true"
carlos@0
   174
	/>
carlos@0
   175
carlos@0
   176
	<parameter name="Title" isForPrompting="false" class="java.lang.String"/>
carlos@0
   177
	<parameter name="Subtitle" isForPrompting="false" class="java.lang.String"/>
carlos@0
   178
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
carlos@0
   179
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
carlos@0
   180
	<queryString><![CDATA[SELECT IDENTIFIER, DATEACCT, VALUE, NAME, ID, AD_TABLE_ID, DOCBASETYPE, '' AS TOTAL, '' AS DESCRIPTION,
carlos@0
   181
(CASE AMTACCTDR WHEN 0 THEN NULL ELSE AMTACCTDR END) AS AMTACCTDR, (CASE AMTACCTCR WHEN 0 THEN NULL ELSE AMTACCTCR END) AS AMTACCTCR
carlos@0
   182
FROM 
carlos@0
   183
(SELECT F.FACT_ACCT_GROUP_ID AS IDENTIFIER, F.DATEACCT,
carlos@0
   184
F.ACCTVALUE AS VALUE, F.ACCTDESCRIPTION AS NAME,F.RECORD_ID AS ID, F.AD_TABLE_ID, F.DOCBASETYPE,
carlos@0
   185
sum(F.AMTACCTDR) AS AMTACCTDR, sum(F.AMTACCTCR) AS AMTACCTCR
carlos@0
   186
FROM FACT_ACCT F 
carlos@0
   187
WHERE F.AD_CLIENT_ID IN (1000000)
carlos@0
   188
  AND F.AD_ORG_ID IN(0,1000000,1000001)
carlos@0
   189
  AND 1=1
carlos@0
   190
  AND f.dateacct >= TO_DATE('01/01/2007', 'DD/MM/YYYY')
carlos@0
   191
  AND f.dateacct < TO_DATE('01/01/2008', 'DD/MM/YYYY')
carlos@0
   192
GROUP BY F.AD_TABLE_ID, F.DATEACCT, F.ACCTDESCRIPTION, F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID, 
carlos@0
   193
  F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID,
carlos@0
   194
  (CASE F.AMTACCTDR WHEN 0 THEN (CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1 ELSE 2 END) ELSE (CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END)) AA
carlos@0
   195
ORDER BY DATEACCT, IDENTIFIER]]></queryString>
carlos@0
   196
carlos@0
   197
	<field name="IDENTIFIER" class="java.math.BigDecimal"/>
carlos@0
   198
	<field name="DATEACCT" class="java.util.Date"/>
carlos@0
   199
	<field name="VALUE" class="java.lang.String"/>
carlos@0
   200
	<field name="NAME" class="java.lang.String"/>
carlos@0
   201
	<field name="ID" class="java.math.BigDecimal"/>
carlos@0
   202
	<field name="AD_TABLE_ID" class="java.math.BigDecimal"/>
carlos@0
   203
	<field name="DOCBASETYPE" class="java.lang.String"/>
carlos@0
   204
	<field name="TOTAL" class="java.lang.String"/>
carlos@0
   205
	<field name="DESCRIPTION" class="java.lang.String"/>
carlos@0
   206
	<field name="AMTACCTDR" class="java.math.BigDecimal"/>
carlos@0
   207
	<field name="AMTACCTCR" class="java.math.BigDecimal"/>
carlos@0
   208
carlos@0
   209
	<variable name="entry" class="java.math.BigDecimal" resetType="Report" calculation="DistinctCount">
carlos@0
   210
		<variableExpression><![CDATA[$F{IDENTIFIER}]]></variableExpression>
carlos@0
   211
		<initialValueExpression><![CDATA[new BigDecimal(0)]]></initialValueExpression>
carlos@0
   212
	</variable>
carlos@0
   213
carlos@0
   214
		<group  name="JournalEntry" >
carlos@0
   215
			<groupExpression><![CDATA[$F{IDENTIFIER}]]></groupExpression>
carlos@0
   216
			<groupHeader>
carlos@0
   217
			<band height="45"  isSplitAllowed="true" >
carlos@0
   218
				<staticText>
carlos@0
   219
					<reportElement
carlos@0
   220
						style="GroupHeader_Gray"
carlos@0
   221
						x="0"
carlos@0
   222
						y="27"
carlos@0
   223
						width="100"
carlos@0
   224
						height="18"
carlos@0
   225
						key="staticText-3"/>
carlos@0
   226
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   227
					<textElement verticalAlignment="Middle">
carlos@0
   228
						<font/>
carlos@0
   229
					</textElement>
carlos@0
   230
				<text><![CDATA[Account No]]></text>
carlos@0
   231
				</staticText>
carlos@0
   232
				<staticText>
carlos@0
   233
					<reportElement
carlos@0
   234
						style="GroupHeader_Gray"
carlos@0
   235
						x="100"
carlos@0
   236
						y="27"
carlos@0
   237
						width="235"
carlos@0
   238
						height="18"
carlos@0
   239
						key="staticText-4"/>
carlos@0
   240
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   241
					<textElement verticalAlignment="Middle">
carlos@0
   242
						<font/>
carlos@0
   243
					</textElement>
carlos@0
   244
				<text><![CDATA[NAME]]></text>
carlos@0
   245
				</staticText>
carlos@0
   246
				<staticText>
carlos@0
   247
					<reportElement
carlos@0
   248
						style="GroupHeader_Gray"
carlos@0
   249
						x="335"
carlos@0
   250
						y="27"
carlos@0
   251
						width="100"
carlos@0
   252
						height="18"
carlos@0
   253
						key="staticText-6"/>
carlos@0
   254
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   255
					<textElement verticalAlignment="Middle">
carlos@0
   256
						<font/>
carlos@0
   257
					</textElement>
carlos@0
   258
				<text><![CDATA[DEBIT]]></text>
carlos@0
   259
				</staticText>
carlos@0
   260
				<staticText>
carlos@0
   261
					<reportElement
carlos@0
   262
						style="GroupHeader_Gray"
carlos@0
   263
						x="435"
carlos@0
   264
						y="27"
carlos@0
   265
						width="100"
carlos@0
   266
						height="18"
carlos@0
   267
						key="staticText-7"/>
carlos@0
   268
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   269
					<textElement verticalAlignment="Middle">
carlos@0
   270
						<font/>
carlos@0
   271
					</textElement>
carlos@0
   272
				<text><![CDATA[CREDIT]]></text>
carlos@0
   273
				</staticText>
carlos@0
   274
				<frame>					<reportElement
carlos@0
   275
						style="GroupHeader_DarkGray"
carlos@0
   276
						x="0"
carlos@0
   277
						y="5"
carlos@0
   278
						width="535"
carlos@0
   279
						height="22"
carlos@0
   280
						key="frame-1"/>
carlos@0
   281
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   282
				<staticText>
carlos@0
   283
					<reportElement
carlos@0
   284
						style="GroupHeader_DarkGray"
carlos@0
   285
						x="0"
carlos@0
   286
						y="0"
carlos@0
   287
						width="100"
carlos@0
   288
						height="22"
carlos@0
   289
						key="staticText-9"/>
carlos@0
   290
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   291
					<textElement>
carlos@0
   292
						<font/>
carlos@0
   293
					</textElement>
carlos@0
   294
				<text><![CDATA[Entry:]]></text>
carlos@0
   295
				</staticText>
carlos@0
   296
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   297
					<reportElement
carlos@0
   298
						style="GroupHeader_DarkGray"
carlos@0
   299
						mode="Opaque"
carlos@0
   300
						x="100"
carlos@0
   301
						y="0"
carlos@0
   302
						width="100"
carlos@0
   303
						height="22"
carlos@0
   304
						key="textField-1"/>
carlos@0
   305
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   306
					<textElement>
carlos@0
   307
						<font/>
carlos@0
   308
					</textElement>
carlos@0
   309
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[($V{entry}.add(new BigDecimal(1))!=null)?$V{entry}.add(new BigDecimal(1)): new BigDecimal("0")]]></textFieldExpression>
carlos@0
   310
				</textField>
carlos@0
   311
				<staticText>
carlos@0
   312
					<reportElement
carlos@0
   313
						style="GroupHeader_DarkGray"
carlos@0
   314
						x="271"
carlos@0
   315
						y="0"
carlos@0
   316
						width="63"
carlos@0
   317
						height="22"
carlos@0
   318
						key="staticText-10"/>
carlos@0
   319
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   320
					<textElement>
carlos@0
   321
						<font/>
carlos@0
   322
					</textElement>
carlos@0
   323
				<text><![CDATA[Date:]]></text>
carlos@0
   324
				</staticText>
carlos@0
   325
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   326
					<reportElement
carlos@0
   327
						style="GroupHeader_DarkGray"
carlos@0
   328
						mode="Opaque"
carlos@0
   329
						x="334"
carlos@0
   330
						y="0"
carlos@0
   331
						width="193"
carlos@0
   332
						height="22"
carlos@0
   333
						key="textField-2"/>
carlos@0
   334
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   335
					<textElement textAlignment="Left">
carlos@0
   336
						<font pdfFontName="Helvetica-Bold"/>
carlos@0
   337
					</textElement>
carlos@0
   338
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{DATEACCT}]]></textFieldExpression>
carlos@0
   339
				</textField>
carlos@0
   340
				</frame>			</band>
carlos@0
   341
			</groupHeader>
carlos@0
   342
			<groupFooter>
carlos@0
   343
			<band height="0"  isSplitAllowed="true" >
carlos@0
   344
			</band>
carlos@0
   345
			</groupFooter>
carlos@0
   346
		</group>
carlos@0
   347
		<background>
carlos@0
   348
			<band height="0"  isSplitAllowed="true" >
carlos@0
   349
			</band>
carlos@0
   350
		</background>
carlos@0
   351
		<title>
carlos@0
   352
			<band height="48"  isSplitAllowed="true" >
carlos@0
   353
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   354
					<reportElement
carlos@0
   355
						style="Report_Title"
carlos@0
   356
						mode="Transparent"
carlos@0
   357
						x="0"
carlos@0
   358
						y="8"
carlos@0
   359
						width="535"
carlos@0
   360
						height="20"
carlos@0
   361
						key="textField-3"/>
carlos@0
   362
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   363
					<textElement>
carlos@0
   364
						<font/>
carlos@0
   365
					</textElement>
carlos@0
   366
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{Title}]]></textFieldExpression>
carlos@0
   367
				</textField>
carlos@0
   368
				<line direction="TopDown">
carlos@0
   369
					<reportElement
carlos@0
   370
						x="0"
carlos@0
   371
						y="28"
carlos@0
   372
						width="535"
carlos@0
   373
						height="0"
carlos@0
   374
						key="line-1"/>
carlos@0
   375
					<graphicElement stretchType="NoStretch" pen="2Point"/>
carlos@0
   376
				</line>
carlos@0
   377
				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   378
					<reportElement
carlos@0
   379
						style="Report_Subtitle"
carlos@0
   380
						x="0"
carlos@0
   381
						y="28"
carlos@0
   382
						width="535"
carlos@0
   383
						height="20"
carlos@0
   384
						key="textField-4"/>
carlos@0
   385
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
carlos@0
   386
					<textElement textAlignment="Left">
carlos@0
   387
						<font size="14"/>
carlos@0
   388
					</textElement>
carlos@0
   389
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{Subtitle}]]></textFieldExpression>
carlos@0
   390
				</textField>
carlos@0
   391
			</band>
carlos@0
   392
		</title>
carlos@0
   393
		<pageHeader>
carlos@0
   394
			<band height="16"  isSplitAllowed="true" >
carlos@0
   395
			</band>
carlos@0
   396
		</pageHeader>
carlos@0
   397
		<columnHeader>
carlos@0
   398
			<band height="0"  isSplitAllowed="true" >
carlos@0
   399
			</band>
carlos@0
   400
		</columnHeader>
carlos@0
   401
		<detail>
carlos@0
   402
			<band height="16"  isSplitAllowed="true" >
carlos@0
   403
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   404
					<reportElement
carlos@0
   405
						x="100"
carlos@0
   406
						y="0"
carlos@0
   407
						width="235"
carlos@0
   408
						height="16"
carlos@0
   409
						key="textField"/>
carlos@0
   410
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   411
					<textElement>
carlos@0
   412
						<font/>
carlos@0
   413
					</textElement>
carlos@0
   414
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression>
carlos@0
   415
				</textField>
carlos@0
   416
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   417
					<reportElement
carlos@0
   418
						x="335"
carlos@0
   419
						y="0"
carlos@0
   420
						width="100"
carlos@0
   421
						height="16"
carlos@0
   422
						key="textField"/>
carlos@0
   423
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   424
					<textElement textAlignment="Right">
carlos@0
   425
						<font/>
carlos@0
   426
					</textElement>
carlos@0
   427
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{AMTACCTDR}!=null)?$P{NUMBERFORMAT}.format($F{AMTACCTDR}):new String(" ")]]></textFieldExpression>
carlos@0
   428
				</textField>
carlos@0
   429
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   430
					<reportElement
carlos@0
   431
						x="435"
carlos@0
   432
						y="0"
carlos@0
   433
						width="100"
carlos@0
   434
						height="16"
carlos@0
   435
						key="textField"/>
carlos@0
   436
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   437
					<textElement textAlignment="Right">
carlos@0
   438
						<font/>
carlos@0
   439
					</textElement>
carlos@0
   440
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{AMTACCTCR}!=null)?$P{NUMBERFORMAT}.format($F{AMTACCTCR}):new String(" ")]]></textFieldExpression>
carlos@0
   441
				</textField>
carlos@0
   442
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   443
					<reportElement
carlos@0
   444
						x="0"
carlos@0
   445
						y="0"
carlos@0
   446
						width="100"
carlos@0
   447
						height="16"
carlos@0
   448
						key="textField"/>
carlos@0
   449
					<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000"/>
carlos@0
   450
					<textElement textAlignment="Right">
carlos@0
   451
						<font/>
carlos@0
   452
					</textElement>
carlos@0
   453
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{VALUE}]]></textFieldExpression>
carlos@0
   454
				</textField>
carlos@0
   455
			</band>
carlos@0
   456
		</detail>
carlos@0
   457
		<columnFooter>
carlos@0
   458
			<band height="0"  isSplitAllowed="true" >
carlos@0
   459
			</band>
carlos@0
   460
		</columnFooter>
carlos@0
   461
		<pageFooter>
carlos@0
   462
			<band height="0"  isSplitAllowed="true" >
carlos@0
   463
			</band>
carlos@0
   464
		</pageFooter>
carlos@0
   465
		<summary>
carlos@0
   466
			<band height="0"  isSplitAllowed="true" >
carlos@0
   467
			</band>
carlos@0
   468
		</summary>
carlos@0
   469
</jasperReport>