src/org/openbravo/erpCommon/ad_reports/ReportRegisterLineJR.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 727 23af88f55124
permissions -rw-r--r--
Removed old frame parameter of windowTableId
juanpablo@727
     1
<?xml version="1.0" encoding="UTF-8"  ?>
juanpablo@727
     2
<!-- Created with iReport - A designer for JasperReports -->
juanpablo@727
     3
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
juanpablo@727
     4
<jasperReport
juanpablo@727
     5
		 name="ReportRegisterLineJR"
juanpablo@727
     6
		 columnCount="1"
juanpablo@727
     7
		 printOrder="Vertical"
juanpablo@727
     8
		 orientation="Landscape"
juanpablo@727
     9
		 pageWidth="992"
juanpablo@727
    10
		 pageHeight="595"
juanpablo@727
    11
		 columnWidth="932"
juanpablo@727
    12
		 columnSpacing="0"
juanpablo@727
    13
		 leftMargin="30"
juanpablo@727
    14
		 rightMargin="30"
juanpablo@727
    15
		 topMargin="20"
juanpablo@727
    16
		 bottomMargin="20"
juanpablo@727
    17
		 whenNoDataType="NoPages"
juanpablo@727
    18
		 isTitleNewPage="false"
juanpablo@727
    19
		 isSummaryNewPage="false">
juanpablo@727
    20
	<property name="ireport.scriptlethandling" value="0" />
juanpablo@727
    21
	<property name="ireport.encoding" value="UTF-8" />
juanpablo@727
    22
	<import value="java.util.*" />
juanpablo@727
    23
	<import value="net.sf.jasperreports.engine.*" />
juanpablo@727
    24
	<import value="net.sf.jasperreports.engine.data.*" />
juanpablo@727
    25
juanpablo@727
    26
	<parameter name="invoicedateDA" isForPrompting="true" class="java.lang.String">
juanpablo@727
    27
		<parameterDescription><![CDATA[Invoice Date From :]]></parameterDescription>
juanpablo@727
    28
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    29
	</parameter>
juanpablo@727
    30
	<parameter name="invoicedateA" isForPrompting="true" class="java.lang.String">
juanpablo@727
    31
		<parameterDescription><![CDATA[Invoice Date To :]]></parameterDescription>
juanpablo@727
    32
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    33
	</parameter>
juanpablo@727
    34
	<parameter name="StartPageNo" isForPrompting="false" class="java.lang.Integer">
juanpablo@727
    35
		<parameterDescription><![CDATA[Start Page No]]></parameterDescription>
juanpablo@727
    36
		<defaultValueExpression ><![CDATA[new Integer(0)]]></defaultValueExpression>
juanpablo@727
    37
	</parameter>
eduardo@723
    38
	<queryString><![CDATA[select taxreg.name,taxregline.documentno as DocNum,taxregline.created as RegDate , inv.documentno as DocInv, bp.name as RagSoc,
eduardo@723
    39
 coalesce(taxregline.totalamt,0) as TotAmt, coalesce(taxregline.taxbaseamt,0) as TaxBaseAmt, coalesce(taxregline.exemptamt,0) as ExemptAmt , coalesce(taxregline.taxundamt,0) as TaxUndAmt,
eduardo@723
    40
 coalesce(taxregline.taxamt,0) as TaxAmt , (tax.name||'-'||tax.rate || '%') as aliquota
eduardo@723
    41
 from c_taxregister taxreg , c_taxregisterline taxregline , c_invoicetax invtax, c_invoice inv ,c_bpartner bp, c_tax tax
eduardo@723
    42
 where taxreg.c_taxregister_id = taxregline.c_taxregister_id 
eduardo@723
    43
 and taxregline.c_invoicetax_id = invtax.c_invoicetax_id
eduardo@723
    44
 and inv.c_invoice_id = invtax.c_invoice_id
eduardo@723
    45
 and inv.c_bpartner_id = bp.c_bpartner_id
eduardo@723
    46
 and taxregline.c_tax_id = tax.c_tax_id
eduardo@723
    47
 and 1=1
eduardo@723
    48
 and ( taxregline.invoicedate >= to_date($P{invoicedateDA},'DD/MM/YYYY')  ) 
eduardo@723
    49
 and ( taxregline.invoicedate <= to_date($P{invoicedateA},'DD/MM/YYYY')  )
juanpablo@727
    50
 order by taxreg.name]]></queryString>
juanpablo@727
    51
juanpablo@727
    52
	<field name="NAME" class="java.lang.String"/>
juanpablo@727
    53
	<field name="DOCNUM" class="java.math.BigDecimal"/>
juanpablo@727
    54
	<field name="REGDATE" class="java.util.Date"/>
juanpablo@727
    55
	<field name="DOCINV" class="java.lang.String"/>
juanpablo@727
    56
	<field name="RAGSOC" class="java.lang.String"/>
juanpablo@727
    57
	<field name="TOTAMT" class="java.math.BigDecimal"/>
juanpablo@727
    58
	<field name="TAXBASEAMT" class="java.math.BigDecimal"/>
juanpablo@727
    59
	<field name="EXEMPTAMT" class="java.math.BigDecimal"/>
juanpablo@727
    60
	<field name="TAXUNDAMT" class="java.math.BigDecimal"/>
juanpablo@727
    61
	<field name="TAXAMT" class="java.math.BigDecimal"/>
juanpablo@727
    62
	<field name="ALIQUOTA" class="java.lang.String"/>
juanpablo@727
    63
juanpablo@727
    64
juanpablo@727
    65
		<group  name="RegName" >
juanpablo@727
    66
			<groupExpression><![CDATA[$F{NAME}]]></groupExpression>
juanpablo@727
    67
			<groupHeader>
juanpablo@727
    68
			<band height="19"  isSplitAllowed="true" >
juanpablo@727
    69
			</band>
juanpablo@727
    70
			</groupHeader>
juanpablo@727
    71
			<groupFooter>
juanpablo@727
    72
			<band height="24"  isSplitAllowed="true" >
juanpablo@727
    73
			</band>
juanpablo@727
    74
			</groupFooter>
juanpablo@727
    75
		</group>
juanpablo@727
    76
		<background>
juanpablo@727
    77
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
    78
			</band>
juanpablo@727
    79
		</background>
juanpablo@727
    80
		<title>
juanpablo@727
    81
			<band height="50"  isSplitAllowed="true" >
juanpablo@727
    82
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
    83
					<reportElement
eduardo@723
    84
						x="0"
eduardo@723
    85
						y="3"
eduardo@723
    86
						width="365"
eduardo@723
    87
						height="45"
juanpablo@727
    88
						key="textField"/>
juanpablo@727
    89
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
    90
					<textElement verticalAlignment="Middle">
juanpablo@727
    91
						<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
juanpablo@727
    92
					</textElement>
juanpablo@727
    93
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression>
juanpablo@727
    94
				</textField>
juanpablo@727
    95
				<line direction="TopDown">
eduardo@723
    96
					<reportElement
eduardo@723
    97
						x="0"
eduardo@723
    98
						y="48"
eduardo@723
    99
						width="932"
eduardo@723
   100
						height="0"
eduardo@723
   101
						forecolor="#000000"
eduardo@723
   102
						backcolor="#FFFFFF"
juanpablo@727
   103
						key="line"/>
juanpablo@727
   104
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   105
				</line>
juanpablo@727
   106
				<line direction="TopDown">
eduardo@723
   107
					<reportElement
eduardo@723
   108
						x="0"
eduardo@723
   109
						y="3"
eduardo@723
   110
						width="932"
eduardo@723
   111
						height="0"
eduardo@723
   112
						forecolor="#000000"
eduardo@723
   113
						backcolor="#FFFFFF"
juanpablo@727
   114
						key="line"/>
juanpablo@727
   115
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   116
				</line>
juanpablo@727
   117
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   118
					<reportElement
eduardo@723
   119
						x="365"
eduardo@723
   120
						y="0"
eduardo@723
   121
						width="567"
eduardo@723
   122
						height="50"
juanpablo@727
   123
						key="textField-1"/>
juanpablo@727
   124
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   125
					<textElement verticalAlignment="Middle">
juanpablo@727
   126
						<font isBold="true"/>
juanpablo@727
   127
					</textElement>
juanpablo@727
   128
				<textFieldExpression   class="java.lang.String"><![CDATA["Periodo da :    " + $P{invoicedateDA}+"   a    "+$P{invoicedateA}]]></textFieldExpression>
juanpablo@727
   129
				</textField>
juanpablo@727
   130
			</band>
juanpablo@727
   131
		</title>
juanpablo@727
   132
		<pageHeader>
juanpablo@727
   133
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   134
			</band>
juanpablo@727
   135
		</pageHeader>
juanpablo@727
   136
		<columnHeader>
juanpablo@727
   137
			<band height="23"  isSplitAllowed="true" >
juanpablo@727
   138
				<rectangle>
eduardo@723
   139
					<reportElement
eduardo@723
   140
						mode="Opaque"
eduardo@723
   141
						x="0"
eduardo@723
   142
						y="0"
eduardo@723
   143
						width="782"
eduardo@723
   144
						height="23"
eduardo@723
   145
						forecolor="#000000"
juanpablo@727
   146
						key="rectangle"/>
juanpablo@727
   147
					<graphicElement stretchType="NoStretch" pen="None"/>
juanpablo@727
   148
				</rectangle>
juanpablo@727
   149
				<staticText>
eduardo@723
   150
					<reportElement
eduardo@723
   151
						mode="Transparent"
eduardo@723
   152
						x="0"
eduardo@723
   153
						y="0"
eduardo@723
   154
						width="86"
eduardo@723
   155
						height="23"
eduardo@723
   156
						forecolor="#000000"
juanpablo@727
   157
						key="staticText"/>
juanpablo@727
   158
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   159
					<textElement>
juanpablo@727
   160
						<font size="12" isBold="true"/>
juanpablo@727
   161
					</textElement>
juanpablo@727
   162
				<text><![CDATA[Doc No]]></text>
juanpablo@727
   163
				</staticText>
juanpablo@727
   164
				<staticText>
eduardo@723
   165
					<reportElement
eduardo@723
   166
						x="86"
eduardo@723
   167
						y="0"
eduardo@723
   168
						width="86"
eduardo@723
   169
						height="23"
eduardo@723
   170
						forecolor="#000000"
juanpablo@727
   171
						key="staticText"/>
juanpablo@727
   172
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   173
					<textElement>
juanpablo@727
   174
						<font size="12" isBold="true"/>
juanpablo@727
   175
					</textElement>
juanpablo@727
   176
				<text><![CDATA[Register Date]]></text>
juanpablo@727
   177
				</staticText>
juanpablo@727
   178
				<staticText>
eduardo@723
   179
					<reportElement
eduardo@723
   180
						x="172"
eduardo@723
   181
						y="0"
eduardo@723
   182
						width="86"
eduardo@723
   183
						height="23"
eduardo@723
   184
						forecolor="#000000"
juanpablo@727
   185
						key="staticText"/>
juanpablo@727
   186
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   187
					<textElement>
juanpablo@727
   188
						<font size="12" isBold="true"/>
juanpablo@727
   189
					</textElement>
juanpablo@727
   190
				<text><![CDATA[Invoice Doc No]]></text>
juanpablo@727
   191
				</staticText>
juanpablo@727
   192
				<staticText>
eduardo@723
   193
					<reportElement
eduardo@723
   194
						x="258"
eduardo@723
   195
						y="0"
eduardo@723
   196
						width="86"
eduardo@723
   197
						height="23"
eduardo@723
   198
						forecolor="#000000"
juanpablo@727
   199
						key="staticText"/>
juanpablo@727
   200
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   201
					<textElement>
juanpablo@727
   202
						<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
juanpablo@727
   203
					</textElement>
juanpablo@727
   204
				<text><![CDATA[B. Partner]]></text>
juanpablo@727
   205
				</staticText>
juanpablo@727
   206
				<staticText>
eduardo@723
   207
					<reportElement
eduardo@723
   208
						x="344"
eduardo@723
   209
						y="0"
eduardo@723
   210
						width="86"
eduardo@723
   211
						height="23"
eduardo@723
   212
						forecolor="#000000"
juanpablo@727
   213
						key="staticText"/>
juanpablo@727
   214
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   215
					<textElement>
juanpablo@727
   216
						<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
juanpablo@727
   217
					</textElement>
juanpablo@727
   218
				<text><![CDATA[Tot. Amount]]></text>
juanpablo@727
   219
				</staticText>
juanpablo@727
   220
				<staticText>
eduardo@723
   221
					<reportElement
eduardo@723
   222
						x="430"
eduardo@723
   223
						y="0"
eduardo@723
   224
						width="86"
eduardo@723
   225
						height="23"
eduardo@723
   226
						forecolor="#000000"
juanpablo@727
   227
						key="staticText"/>
juanpablo@727
   228
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   229
					<textElement>
juanpablo@727
   230
						<font size="12" isBold="true"/>
juanpablo@727
   231
					</textElement>
juanpablo@727
   232
				<text><![CDATA[Base Amount]]></text>
juanpablo@727
   233
				</staticText>
juanpablo@727
   234
				<staticText>
eduardo@723
   235
					<reportElement
eduardo@723
   236
						x="516"
eduardo@723
   237
						y="0"
eduardo@723
   238
						width="86"
eduardo@723
   239
						height="23"
eduardo@723
   240
						forecolor="#000000"
juanpablo@727
   241
						key="staticText"/>
juanpablo@727
   242
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   243
					<textElement>
juanpablo@727
   244
						<font size="12" isBold="true"/>
juanpablo@727
   245
					</textElement>
juanpablo@727
   246
				<text><![CDATA[Exempt Amount]]></text>
juanpablo@727
   247
				</staticText>
juanpablo@727
   248
				<staticText>
eduardo@723
   249
					<reportElement
eduardo@723
   250
						x="602"
eduardo@723
   251
						y="0"
eduardo@723
   252
						width="86"
eduardo@723
   253
						height="23"
eduardo@723
   254
						forecolor="#000000"
juanpablo@727
   255
						key="staticText"/>
juanpablo@727
   256
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   257
					<textElement>
juanpablo@727
   258
						<font size="12" isBold="true"/>
juanpablo@727
   259
					</textElement>
juanpablo@727
   260
				<text><![CDATA[Tax Und. Amount]]></text>
juanpablo@727
   261
				</staticText>
juanpablo@727
   262
				<staticText>
eduardo@723
   263
					<reportElement
eduardo@723
   264
						x="688"
eduardo@723
   265
						y="0"
eduardo@723
   266
						width="86"
eduardo@723
   267
						height="23"
eduardo@723
   268
						forecolor="#000000"
juanpablo@727
   269
						key="staticText"/>
juanpablo@727
   270
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   271
					<textElement>
juanpablo@727
   272
						<font size="12" isBold="true"/>
juanpablo@727
   273
					</textElement>
juanpablo@727
   274
				<text><![CDATA[Tax Amount]]></text>
juanpablo@727
   275
				</staticText>
juanpablo@727
   276
				<staticText>
eduardo@723
   277
					<reportElement
eduardo@723
   278
						x="774"
eduardo@723
   279
						y="0"
eduardo@723
   280
						width="158"
eduardo@723
   281
						height="23"
eduardo@723
   282
						forecolor="#000000"
juanpablo@727
   283
						key="staticText-1"/>
juanpablo@727
   284
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   285
					<textElement textAlignment="Center">
juanpablo@727
   286
						<font size="12" isBold="true"/>
juanpablo@727
   287
					</textElement>
juanpablo@727
   288
				<text><![CDATA[Tax Name]]></text>
juanpablo@727
   289
				</staticText>
juanpablo@727
   290
			</band>
juanpablo@727
   291
		</columnHeader>
juanpablo@727
   292
		<detail>
juanpablo@727
   293
			<band height="17"  isSplitAllowed="true" >
juanpablo@727
   294
				<line direction="TopDown">
eduardo@723
   295
					<reportElement
eduardo@723
   296
						x="0"
eduardo@723
   297
						y="16"
eduardo@723
   298
						width="932"
eduardo@723
   299
						height="0"
eduardo@723
   300
						forecolor="#808080"
eduardo@723
   301
						backcolor="#FFFFFF"
juanpablo@727
   302
						key="line"/>
juanpablo@727
   303
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   304
				</line>
juanpablo@727
   305
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   306
					<reportElement
eduardo@723
   307
						x="0"
eduardo@723
   308
						y="0"
eduardo@723
   309
						width="86"
eduardo@723
   310
						height="17"
eduardo@723
   311
						forecolor="#000000"
juanpablo@727
   312
						key="textField"/>
juanpablo@727
   313
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   314
					<textElement>
juanpablo@727
   315
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   316
					</textElement>
juanpablo@727
   317
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{DOCNUM}]]></textFieldExpression>
juanpablo@727
   318
				</textField>
juanpablo@727
   319
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   320
					<reportElement
eduardo@723
   321
						x="86"
eduardo@723
   322
						y="0"
eduardo@723
   323
						width="86"
eduardo@723
   324
						height="17"
eduardo@723
   325
						forecolor="#000000"
juanpablo@727
   326
						key="textField"/>
juanpablo@727
   327
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   328
					<textElement>
juanpablo@727
   329
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   330
					</textElement>
juanpablo@727
   331
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{REGDATE}]]></textFieldExpression>
juanpablo@727
   332
				</textField>
juanpablo@727
   333
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   334
					<reportElement
eduardo@723
   335
						x="172"
eduardo@723
   336
						y="0"
eduardo@723
   337
						width="86"
eduardo@723
   338
						height="17"
eduardo@723
   339
						forecolor="#000000"
juanpablo@727
   340
						key="textField"/>
juanpablo@727
   341
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   342
					<textElement>
juanpablo@727
   343
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   344
					</textElement>
juanpablo@727
   345
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCINV}]]></textFieldExpression>
juanpablo@727
   346
				</textField>
juanpablo@727
   347
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   348
					<reportElement
eduardo@723
   349
						x="258"
eduardo@723
   350
						y="0"
eduardo@723
   351
						width="86"
eduardo@723
   352
						height="17"
eduardo@723
   353
						forecolor="#000000"
juanpablo@727
   354
						key="textField"/>
juanpablo@727
   355
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   356
					<textElement>
juanpablo@727
   357
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   358
					</textElement>
juanpablo@727
   359
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{RAGSOC}]]></textFieldExpression>
juanpablo@727
   360
				</textField>
juanpablo@727
   361
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   362
					<reportElement
eduardo@723
   363
						x="344"
eduardo@723
   364
						y="0"
eduardo@723
   365
						width="86"
eduardo@723
   366
						height="17"
eduardo@723
   367
						forecolor="#000000"
juanpablo@727
   368
						key="textField"/>
juanpablo@727
   369
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   370
					<textElement textAlignment="Left">
juanpablo@727
   371
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   372
					</textElement>
juanpablo@727
   373
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{TOTAMT}]]></textFieldExpression>
juanpablo@727
   374
				</textField>
juanpablo@727
   375
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   376
					<reportElement
eduardo@723
   377
						x="430"
eduardo@723
   378
						y="0"
eduardo@723
   379
						width="86"
eduardo@723
   380
						height="17"
eduardo@723
   381
						forecolor="#000000"
juanpablo@727
   382
						key="textField"/>
juanpablo@727
   383
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   384
					<textElement textAlignment="Left">
juanpablo@727
   385
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   386
					</textElement>
juanpablo@727
   387
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{TAXBASEAMT}]]></textFieldExpression>
juanpablo@727
   388
				</textField>
juanpablo@727
   389
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   390
					<reportElement
eduardo@723
   391
						x="516"
eduardo@723
   392
						y="0"
eduardo@723
   393
						width="86"
eduardo@723
   394
						height="17"
eduardo@723
   395
						forecolor="#000000"
juanpablo@727
   396
						key="textField"/>
juanpablo@727
   397
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   398
					<textElement textAlignment="Left">
juanpablo@727
   399
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   400
					</textElement>
juanpablo@727
   401
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{EXEMPTAMT}]]></textFieldExpression>
juanpablo@727
   402
				</textField>
juanpablo@727
   403
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   404
					<reportElement
eduardo@723
   405
						x="602"
eduardo@723
   406
						y="0"
eduardo@723
   407
						width="86"
eduardo@723
   408
						height="17"
eduardo@723
   409
						forecolor="#000000"
juanpablo@727
   410
						key="textField"/>
juanpablo@727
   411
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   412
					<textElement textAlignment="Left">
juanpablo@727
   413
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   414
					</textElement>
juanpablo@727
   415
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{TAXUNDAMT}]]></textFieldExpression>
juanpablo@727
   416
				</textField>
juanpablo@727
   417
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   418
					<reportElement
eduardo@723
   419
						x="688"
eduardo@723
   420
						y="0"
eduardo@723
   421
						width="86"
eduardo@723
   422
						height="17"
eduardo@723
   423
						forecolor="#000000"
juanpablo@727
   424
						key="textField"/>
juanpablo@727
   425
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   426
					<textElement textAlignment="Left">
juanpablo@727
   427
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   428
					</textElement>
juanpablo@727
   429
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{TAXAMT}]]></textFieldExpression>
juanpablo@727
   430
				</textField>
juanpablo@727
   431
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   432
					<reportElement
eduardo@723
   433
						x="774"
eduardo@723
   434
						y="0"
eduardo@723
   435
						width="158"
eduardo@723
   436
						height="17"
eduardo@723
   437
						forecolor="#000000"
juanpablo@727
   438
						key="textField-2"/>
juanpablo@727
   439
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   440
					<textElement textAlignment="Center">
juanpablo@727
   441
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   442
					</textElement>
juanpablo@727
   443
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{ALIQUOTA}]]></textFieldExpression>
juanpablo@727
   444
				</textField>
juanpablo@727
   445
			</band>
juanpablo@727
   446
		</detail>
juanpablo@727
   447
		<columnFooter>
juanpablo@727
   448
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   449
			</band>
juanpablo@727
   450
		</columnFooter>
juanpablo@727
   451
		<pageFooter>
juanpablo@727
   452
			<band height="27"  isSplitAllowed="true" >
juanpablo@727
   453
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   454
					<reportElement
eduardo@723
   455
						x="719"
eduardo@723
   456
						y="4"
eduardo@723
   457
						width="170"
eduardo@723
   458
						height="19"
eduardo@723
   459
						forecolor="#000000"
juanpablo@727
   460
						key="textField"/>
juanpablo@727
   461
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   462
					<textElement textAlignment="Right">
juanpablo@727
   463
						<font/>
juanpablo@727
   464
					</textElement>
juanpablo@727
   465
				<textFieldExpression   class="java.lang.String"><![CDATA["Page   " +(new Integer($V{PAGE_NUMBER}.intValue()+ $P{StartPageNo}.intValue()))]]></textFieldExpression>
juanpablo@727
   466
				</textField>
juanpablo@727
   467
				<line direction="TopDown">
eduardo@723
   468
					<reportElement
eduardo@723
   469
						x="0"
eduardo@723
   470
						y="3"
eduardo@723
   471
						width="932"
eduardo@723
   472
						height="0"
eduardo@723
   473
						forecolor="#000000"
eduardo@723
   474
						backcolor="#FFFFFF"
juanpablo@727
   475
						key="line"/>
juanpablo@727
   476
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   477
				</line>
juanpablo@727
   478
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   479
					<reportElement
eduardo@723
   480
						x="1"
eduardo@723
   481
						y="6"
eduardo@723
   482
						width="209"
eduardo@723
   483
						height="19"
eduardo@723
   484
						forecolor="#000000"
juanpablo@727
   485
						key="textField"/>
juanpablo@727
   486
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   487
					<textElement>
juanpablo@727
   488
						<font/>
juanpablo@727
   489
					</textElement>
juanpablo@727
   490
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@727
   491
				</textField>
juanpablo@727
   492
			</band>
juanpablo@727
   493
		</pageFooter>
juanpablo@727
   494
		<summary>
juanpablo@727
   495
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   496
			</band>
juanpablo@727
   497
		</summary>
juanpablo@727
   498
</jasperReport>