src/org/openbravo/erpCommon/ad_reports/ReportRegisterByVatJR.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="ReportRegisterByVatJR"
juanpablo@727
     6
		 columnCount="1"
juanpablo@727
     7
		 printOrder="Vertical"
juanpablo@727
     8
		 orientation="Portrait"
juanpablo@727
     9
		 pageWidth="842"
juanpablo@727
    10
		 pageHeight="1190"
juanpablo@727
    11
		 columnWidth="782"
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>
eduardo@723
    34
	<queryString><![CDATA[select taxreg.name, (tax.name||'-'||tax.rate || '%' ) as Aliquota,
eduardo@723
    35
 coalesce(taxregline.taxbaseamt,0) as Imponibile, coalesce(taxregline.novatamt,0) as NonImponibile, coalesce(taxregline.exemptamt,0) as Esente , 
eduardo@723
    36
 coalesce(taxregline.taxundamt,0) as IvaIndeducibile, coalesce(taxregline.taxamt,0) as Iva, coalesce(taxregline.totalamt,0) as Totale,
eduardo@723
    37
 coalesce(taxreg.lastregaccumamt,0) as TotalePrecedente,
eduardo@723
    38
case 
eduardo@723
    39
 when taxregtyp.issotrx ='S' then 'Vendite'
eduardo@723
    40
 else 'Acquisti'
eduardo@723
    41
 end 
eduardo@723
    42
 as IsSale
eduardo@723
    43
 from c_taxregister taxreg, c_taxregisterline taxregline , c_taxregister_type taxregtyp, c_tax tax
eduardo@723
    44
 where
eduardo@723
    45
     taxreg.c_taxregister_id = taxregline.c_taxregister_id
eduardo@723
    46
 and taxreg.c_taxregister_type_id = taxregtyp.c_taxregister_type_id 
eduardo@723
    47
 and taxregline.c_tax_id = tax.c_tax_id
eduardo@723
    48
 and 1=1
eduardo@723
    49
 and ( taxregline.invoicedate >= to_date($P{invoicedateDA},'DD/MM/YYYY')  ) 
eduardo@723
    50
 and ( taxregline.invoicedate <= to_date($P{invoicedateA},'DD/MM/YYYY')  ) 
juanpablo@727
    51
 order by  taxreg.name,(tax.name||'-'||tax.rate || '%' )]]></queryString>
juanpablo@727
    52
juanpablo@727
    53
	<field name="NAME" class="java.lang.String"/>
juanpablo@727
    54
	<field name="ALIQUOTA" class="java.lang.String"/>
juanpablo@727
    55
	<field name="IMPONIBILE" class="java.math.BigDecimal"/>
juanpablo@727
    56
	<field name="NONIMPONIBILE" class="java.math.BigDecimal"/>
juanpablo@727
    57
	<field name="ESENTE" class="java.math.BigDecimal"/>
juanpablo@727
    58
	<field name="IVAINDEDUCIBILE" class="java.math.BigDecimal"/>
juanpablo@727
    59
	<field name="IVA" class="java.math.BigDecimal"/>
juanpablo@727
    60
	<field name="TOTALE" class="java.math.BigDecimal"/>
juanpablo@727
    61
	<field name="TOTALEPRECEDENTE" class="java.math.BigDecimal"/>
juanpablo@727
    62
	<field name="ISSALE" class="java.lang.String"/>
juanpablo@727
    63
juanpablo@727
    64
	<variable name="SumImponibile" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
juanpablo@727
    65
		<variableExpression><![CDATA[$F{IMPONIBILE}]]></variableExpression>
juanpablo@727
    66
	</variable>
juanpablo@727
    67
	<variable name="SumNonImponibile" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
juanpablo@727
    68
		<variableExpression><![CDATA[$F{NONIMPONIBILE}]]></variableExpression>
juanpablo@727
    69
	</variable>
juanpablo@727
    70
	<variable name="SumEsente" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
juanpablo@727
    71
		<variableExpression><![CDATA[$F{ESENTE}]]></variableExpression>
juanpablo@727
    72
	</variable>
juanpablo@727
    73
	<variable name="SumIvaIndeducibile" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
juanpablo@727
    74
		<variableExpression><![CDATA[$F{IVAINDEDUCIBILE}]]></variableExpression>
juanpablo@727
    75
	</variable>
juanpablo@727
    76
	<variable name="SumIva" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
juanpablo@727
    77
		<variableExpression><![CDATA[$F{IVA}]]></variableExpression>
juanpablo@727
    78
	</variable>
juanpablo@727
    79
	<variable name="SumTotale" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
juanpablo@727
    80
		<variableExpression><![CDATA[$F{TOTALE}]]></variableExpression>
juanpablo@727
    81
	</variable>
juanpablo@727
    82
	<variable name="SumTotalePrec" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="First">
juanpablo@727
    83
		<variableExpression><![CDATA[$F{TOTALEPRECEDENTE}]]></variableExpression>
juanpablo@727
    84
	</variable>
juanpablo@727
    85
	<variable name="TotIva" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
juanpablo@727
    86
		<variableExpression><![CDATA[( $F{ISSALE}.equals( "Acquisti" )  ? $F{IVA}.negate() : $F{IVA} )]]></variableExpression>
juanpablo@727
    87
	</variable>
juanpablo@727
    88
	<variable name="TotCredPrec" class="java.math.BigDecimal" resetType="Report" incrementType="Group" incrementGroup="NAME" calculation="Sum">
juanpablo@727
    89
		<variableExpression><![CDATA[( $F{ISSALE}.equals( "Acquisti" )  ? $F{TOTALEPRECEDENTE} : $F{TOTALEPRECEDENTE}.negate() )]]></variableExpression>
juanpablo@727
    90
		<initialValueExpression><![CDATA[new BigDecimal(0)]]></initialValueExpression>
juanpablo@727
    91
	</variable>
juanpablo@727
    92
	<variable name="TotIvaDaPagare" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
juanpablo@727
    93
		<variableExpression><![CDATA[$V{TotIva}.add(  ( $V{TotCredPrec}.doubleValue()<0 ? new BigDecimal(0) :  $V{TotCredPrec}.negate() ))]]></variableExpression>
juanpablo@727
    94
	</variable>
juanpablo@727
    95
juanpablo@727
    96
		<group  name="NAME" >
juanpablo@727
    97
			<groupExpression><![CDATA[$F{NAME}]]></groupExpression>
juanpablo@727
    98
			<groupHeader>
juanpablo@727
    99
			<band height="25"  isSplitAllowed="true" >
juanpablo@727
   100
				<rectangle radius="0" >
eduardo@723
   101
					<reportElement
eduardo@723
   102
						x="0"
eduardo@723
   103
						y="0"
eduardo@723
   104
						width="782"
eduardo@723
   105
						height="25"
eduardo@723
   106
						forecolor="#8080FF"
eduardo@723
   107
						backcolor="#00CCFF"
juanpablo@727
   108
						key="rectangle"/>
juanpablo@727
   109
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   110
				</rectangle>
juanpablo@727
   111
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   112
					<reportElement
eduardo@723
   113
						x="0"
eduardo@723
   114
						y="2"
eduardo@723
   115
						width="329"
eduardo@723
   116
						height="23"
eduardo@723
   117
						forecolor="#000000"
juanpablo@727
   118
						key="textField"/>
juanpablo@727
   119
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   120
					<textElement>
juanpablo@727
   121
						<font size="18"/>
juanpablo@727
   122
					</textElement>
juanpablo@727
   123
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression>
juanpablo@727
   124
				</textField>
juanpablo@727
   125
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   126
					<reportElement
eduardo@723
   127
						x="538"
eduardo@723
   128
						y="0"
eduardo@723
   129
						width="86"
eduardo@723
   130
						height="25"
eduardo@723
   131
						forecolor="#000000"
juanpablo@727
   132
						key="textField"/>
juanpablo@727
   133
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   134
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@727
   135
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   136
					</textElement>
juanpablo@727
   137
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{ISSALE}]]></textFieldExpression>
juanpablo@727
   138
				</textField>
juanpablo@727
   139
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   140
					<reportElement
eduardo@723
   141
						x="329"
eduardo@723
   142
						y="0"
eduardo@723
   143
						width="86"
eduardo@723
   144
						height="25"
juanpablo@727
   145
						key="textField">
juanpablo@727
   146
							<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>
juanpablo@727
   147
						</reportElement>
juanpablo@727
   148
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   149
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@727
   150
						<font size="12"/>
juanpablo@727
   151
					</textElement>
juanpablo@727
   152
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{TOTALEPRECEDENTE}]]></textFieldExpression>
juanpablo@727
   153
				</textField>
juanpablo@727
   154
			</band>
juanpablo@727
   155
			</groupHeader>
juanpablo@727
   156
			<groupFooter>
juanpablo@727
   157
			<band height="30"  isSplitAllowed="true" >
juanpablo@727
   158
				<line direction="BottomUp">
eduardo@723
   159
					<reportElement
eduardo@723
   160
						x="1"
eduardo@723
   161
						y="0"
eduardo@723
   162
						width="781"
eduardo@723
   163
						height="0"
eduardo@723
   164
						forecolor="#000000"
eduardo@723
   165
						backcolor="#FFFFFF"
juanpablo@727
   166
						key="line"/>
juanpablo@727
   167
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   168
				</line>
juanpablo@727
   169
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   170
					<reportElement
eduardo@723
   171
						x="86"
eduardo@723
   172
						y="0"
eduardo@723
   173
						width="86"
eduardo@723
   174
						height="18"
juanpablo@727
   175
						key="textField"/>
juanpablo@727
   176
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   177
					<textElement textAlignment="Right">
juanpablo@727
   178
						<font/>
juanpablo@727
   179
					</textElement>
juanpablo@727
   180
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{SumImponibile}]]></textFieldExpression>
juanpablo@727
   181
				</textField>
juanpablo@727
   182
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   183
					<reportElement
eduardo@723
   184
						x="172"
eduardo@723
   185
						y="0"
eduardo@723
   186
						width="86"
eduardo@723
   187
						height="18"
juanpablo@727
   188
						key="textField"/>
juanpablo@727
   189
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   190
					<textElement textAlignment="Right">
juanpablo@727
   191
						<font/>
juanpablo@727
   192
					</textElement>
juanpablo@727
   193
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{SumNonImponibile}]]></textFieldExpression>
juanpablo@727
   194
				</textField>
juanpablo@727
   195
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   196
					<reportElement
eduardo@723
   197
						x="258"
eduardo@723
   198
						y="0"
eduardo@723
   199
						width="86"
eduardo@723
   200
						height="18"
juanpablo@727
   201
						key="textField-1"/>
juanpablo@727
   202
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   203
					<textElement textAlignment="Right">
juanpablo@727
   204
						<font/>
juanpablo@727
   205
					</textElement>
juanpablo@727
   206
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{SumEsente}]]></textFieldExpression>
juanpablo@727
   207
				</textField>
juanpablo@727
   208
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   209
					<reportElement
eduardo@723
   210
						x="344"
eduardo@723
   211
						y="0"
eduardo@723
   212
						width="86"
eduardo@723
   213
						height="18"
juanpablo@727
   214
						key="textField-2"/>
juanpablo@727
   215
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   216
					<textElement textAlignment="Right">
juanpablo@727
   217
						<font/>
juanpablo@727
   218
					</textElement>
juanpablo@727
   219
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{SumIvaIndeducibile}]]></textFieldExpression>
juanpablo@727
   220
				</textField>
juanpablo@727
   221
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   222
					<reportElement
eduardo@723
   223
						x="430"
eduardo@723
   224
						y="0"
eduardo@723
   225
						width="86"
eduardo@723
   226
						height="18"
juanpablo@727
   227
						key="textField-3"/>
juanpablo@727
   228
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   229
					<textElement textAlignment="Right">
juanpablo@727
   230
						<font/>
juanpablo@727
   231
					</textElement>
juanpablo@727
   232
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{SumIva}]]></textFieldExpression>
juanpablo@727
   233
				</textField>
juanpablo@727
   234
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   235
					<reportElement
eduardo@723
   236
						x="516"
eduardo@723
   237
						y="0"
eduardo@723
   238
						width="86"
eduardo@723
   239
						height="18"
juanpablo@727
   240
						key="textField-4"/>
juanpablo@727
   241
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   242
					<textElement textAlignment="Right">
juanpablo@727
   243
						<font/>
juanpablo@727
   244
					</textElement>
juanpablo@727
   245
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{SumTotale}]]></textFieldExpression>
juanpablo@727
   246
				</textField>
juanpablo@727
   247
				<staticText>
eduardo@723
   248
					<reportElement
eduardo@723
   249
						x="0"
eduardo@723
   250
						y="0"
eduardo@723
   251
						width="86"
eduardo@723
   252
						height="18"
juanpablo@727
   253
						key="staticText-1"/>
juanpablo@727
   254
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   255
					<textElement>
juanpablo@727
   256
						<font pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   257
					</textElement>
juanpablo@727
   258
				<text><![CDATA[Totali :]]></text>
juanpablo@727
   259
				</staticText>
juanpablo@727
   260
				<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   261
					<reportElement
eduardo@723
   262
						x="649"
eduardo@723
   263
						y="0"
eduardo@723
   264
						width="100"
eduardo@723
   265
						height="18"
juanpablo@727
   266
						key="textField">
juanpablo@727
   267
							<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>
juanpablo@727
   268
						</reportElement>
juanpablo@727
   269
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   270
					<textElement>
juanpablo@727
   271
						<font/>
juanpablo@727
   272
					</textElement>
juanpablo@727
   273
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{TotCredPrec}]]></textFieldExpression>
juanpablo@727
   274
				</textField>
juanpablo@727
   275
			</band>
juanpablo@727
   276
			</groupFooter>
juanpablo@727
   277
		</group>
juanpablo@727
   278
		<background>
juanpablo@727
   279
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   280
			</band>
juanpablo@727
   281
		</background>
juanpablo@727
   282
		<title>
juanpablo@727
   283
			<band height="50"  isSplitAllowed="true" >
juanpablo@727
   284
				<staticText>
eduardo@723
   285
					<reportElement
eduardo@723
   286
						x="158"
eduardo@723
   287
						y="5"
eduardo@723
   288
						width="242"
eduardo@723
   289
						height="40"
juanpablo@727
   290
						key="staticText"/>
juanpablo@727
   291
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   292
					<textElement>
juanpablo@727
   293
						<font size="30"/>
juanpablo@727
   294
					</textElement>
juanpablo@727
   295
				<text><![CDATA[Liquidazione Iva]]></text>
juanpablo@727
   296
				</staticText>
juanpablo@727
   297
				<line direction="TopDown">
eduardo@723
   298
					<reportElement
eduardo@723
   299
						x="0"
eduardo@723
   300
						y="48"
eduardo@723
   301
						width="781"
eduardo@723
   302
						height="0"
eduardo@723
   303
						forecolor="#000000"
eduardo@723
   304
						backcolor="#FFFFFF"
juanpablo@727
   305
						key="line"/>
juanpablo@727
   306
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   307
				</line>
juanpablo@727
   308
				<line direction="TopDown">
eduardo@723
   309
					<reportElement
eduardo@723
   310
						x="0"
eduardo@723
   311
						y="3"
eduardo@723
   312
						width="781"
eduardo@723
   313
						height="0"
eduardo@723
   314
						forecolor="#000000"
eduardo@723
   315
						backcolor="#FFFFFF"
juanpablo@727
   316
						key="line"/>
juanpablo@727
   317
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   318
				</line>
juanpablo@727
   319
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   320
					<reportElement
eduardo@723
   321
						x="400"
eduardo@723
   322
						y="0"
eduardo@723
   323
						width="382"
eduardo@723
   324
						height="50"
juanpablo@727
   325
						key="textField-6"/>
juanpablo@727
   326
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   327
					<textElement verticalAlignment="Middle">
juanpablo@727
   328
						<font isBold="true"/>
juanpablo@727
   329
					</textElement>
juanpablo@727
   330
				<textFieldExpression   class="java.lang.String"><![CDATA["Periodo da:   " +" "+ $P{invoicedateDA}+" "+"   a   "+" "+$P{invoicedateA}]]></textFieldExpression>
juanpablo@727
   331
				</textField>
juanpablo@727
   332
			</band>
juanpablo@727
   333
		</title>
juanpablo@727
   334
		<pageHeader>
juanpablo@727
   335
			<band height="9"  isSplitAllowed="true" >
juanpablo@727
   336
			</band>
juanpablo@727
   337
		</pageHeader>
juanpablo@727
   338
		<columnHeader>
juanpablo@727
   339
			<band height="18"  isSplitAllowed="true" >
juanpablo@727
   340
				<rectangle>
eduardo@723
   341
					<reportElement
eduardo@723
   342
						mode="Opaque"
eduardo@723
   343
						x="0"
eduardo@723
   344
						y="0"
eduardo@723
   345
						width="782"
eduardo@723
   346
						height="17"
eduardo@723
   347
						forecolor="#000000"
eduardo@723
   348
						backcolor="#999999"
juanpablo@727
   349
						key="rectangle"/>
juanpablo@727
   350
					<graphicElement stretchType="NoStretch" pen="None"/>
juanpablo@727
   351
				</rectangle>
juanpablo@727
   352
				<line direction="BottomUp">
eduardo@723
   353
					<reportElement
eduardo@723
   354
						x="0"
eduardo@723
   355
						y="0"
eduardo@723
   356
						width="782"
eduardo@723
   357
						height="0"
eduardo@723
   358
						forecolor="#000000"
eduardo@723
   359
						backcolor="#999999"
juanpablo@727
   360
						key="line"/>
juanpablo@727
   361
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   362
				</line>
juanpablo@727
   363
				<line direction="BottomUp">
eduardo@723
   364
					<reportElement
eduardo@723
   365
						x="0"
eduardo@723
   366
						y="15"
eduardo@723
   367
						width="782"
eduardo@723
   368
						height="0"
eduardo@723
   369
						forecolor="#000000"
eduardo@723
   370
						backcolor="#FFFFFF"
juanpablo@727
   371
						key="line"/>
juanpablo@727
   372
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   373
				</line>
juanpablo@727
   374
				<staticText>
eduardo@723
   375
					<reportElement
eduardo@723
   376
						x="0"
eduardo@723
   377
						y="0"
eduardo@723
   378
						width="86"
eduardo@723
   379
						height="17"
eduardo@723
   380
						forecolor="#000000"
eduardo@723
   381
						backcolor="#999999"
juanpablo@727
   382
						key="staticText"/>
juanpablo@727
   383
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   384
					<textElement>
juanpablo@727
   385
						<font size="12"/>
juanpablo@727
   386
					</textElement>
juanpablo@727
   387
				<text><![CDATA[Aliquota]]></text>
juanpablo@727
   388
				</staticText>
juanpablo@727
   389
				<staticText>
eduardo@723
   390
					<reportElement
eduardo@723
   391
						x="86"
eduardo@723
   392
						y="0"
eduardo@723
   393
						width="86"
eduardo@723
   394
						height="17"
eduardo@723
   395
						forecolor="#000000"
juanpablo@727
   396
						key="staticText"/>
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="Right">
juanpablo@727
   399
						<font size="12"/>
juanpablo@727
   400
					</textElement>
juanpablo@727
   401
				<text><![CDATA[Imponibile]]></text>
juanpablo@727
   402
				</staticText>
juanpablo@727
   403
				<staticText>
eduardo@723
   404
					<reportElement
eduardo@723
   405
						x="172"
eduardo@723
   406
						y="0"
eduardo@723
   407
						width="86"
eduardo@723
   408
						height="17"
eduardo@723
   409
						forecolor="#000000"
juanpablo@727
   410
						key="staticText"/>
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="Right">
juanpablo@727
   413
						<font size="12"/>
juanpablo@727
   414
					</textElement>
juanpablo@727
   415
				<text><![CDATA[Non Imp.]]></text>
juanpablo@727
   416
				</staticText>
juanpablo@727
   417
				<staticText>
eduardo@723
   418
					<reportElement
eduardo@723
   419
						x="258"
eduardo@723
   420
						y="0"
eduardo@723
   421
						width="86"
eduardo@723
   422
						height="17"
eduardo@723
   423
						forecolor="#000000"
juanpablo@727
   424
						key="staticText"/>
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="Right">
juanpablo@727
   427
						<font size="12"/>
juanpablo@727
   428
					</textElement>
juanpablo@727
   429
				<text><![CDATA[Esente]]></text>
juanpablo@727
   430
				</staticText>
juanpablo@727
   431
				<staticText>
eduardo@723
   432
					<reportElement
eduardo@723
   433
						x="344"
eduardo@723
   434
						y="0"
eduardo@723
   435
						width="86"
eduardo@723
   436
						height="17"
eduardo@723
   437
						forecolor="#000000"
juanpablo@727
   438
						key="staticText"/>
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="Right">
juanpablo@727
   441
						<font size="12"/>
juanpablo@727
   442
					</textElement>
juanpablo@727
   443
				<text><![CDATA[Iva Inded.]]></text>
juanpablo@727
   444
				</staticText>
juanpablo@727
   445
				<staticText>
eduardo@723
   446
					<reportElement
eduardo@723
   447
						x="430"
eduardo@723
   448
						y="0"
eduardo@723
   449
						width="86"
eduardo@723
   450
						height="17"
eduardo@723
   451
						forecolor="#000000"
juanpablo@727
   452
						key="staticText"/>
juanpablo@727
   453
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   454
					<textElement textAlignment="Right">
juanpablo@727
   455
						<font size="12"/>
juanpablo@727
   456
					</textElement>
juanpablo@727
   457
				<text><![CDATA[Iva]]></text>
juanpablo@727
   458
				</staticText>
juanpablo@727
   459
				<staticText>
eduardo@723
   460
					<reportElement
eduardo@723
   461
						x="516"
eduardo@723
   462
						y="0"
eduardo@723
   463
						width="86"
eduardo@723
   464
						height="17"
eduardo@723
   465
						forecolor="#000000"
juanpablo@727
   466
						key="staticText"/>
juanpablo@727
   467
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   468
					<textElement textAlignment="Right">
juanpablo@727
   469
						<font size="12"/>
juanpablo@727
   470
					</textElement>
juanpablo@727
   471
				<text><![CDATA[Totale]]></text>
juanpablo@727
   472
				</staticText>
juanpablo@727
   473
			</band>
juanpablo@727
   474
		</columnHeader>
juanpablo@727
   475
		<detail>
juanpablo@727
   476
			<band height="17"  isSplitAllowed="true" >
juanpablo@727
   477
				<line direction="TopDown">
eduardo@723
   478
					<reportElement
eduardo@723
   479
						x="0"
eduardo@723
   480
						y="16"
eduardo@723
   481
						width="782"
eduardo@723
   482
						height="0"
eduardo@723
   483
						forecolor="#808080"
eduardo@723
   484
						backcolor="#FFFFFF"
juanpablo@727
   485
						key="line"/>
juanpablo@727
   486
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   487
				</line>
juanpablo@727
   488
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   489
					<reportElement
eduardo@723
   490
						x="0"
eduardo@723
   491
						y="0"
eduardo@723
   492
						width="86"
eduardo@723
   493
						height="17"
eduardo@723
   494
						forecolor="#000000"
juanpablo@727
   495
						key="textField"/>
juanpablo@727
   496
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   497
					<textElement>
juanpablo@727
   498
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   499
					</textElement>
juanpablo@727
   500
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{ALIQUOTA}]]></textFieldExpression>
juanpablo@727
   501
				</textField>
juanpablo@727
   502
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   503
					<reportElement
eduardo@723
   504
						x="86"
eduardo@723
   505
						y="0"
eduardo@723
   506
						width="86"
eduardo@723
   507
						height="17"
eduardo@723
   508
						forecolor="#000000"
juanpablo@727
   509
						key="textField"/>
juanpablo@727
   510
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   511
					<textElement textAlignment="Right">
juanpablo@727
   512
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   513
					</textElement>
juanpablo@727
   514
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{IMPONIBILE}]]></textFieldExpression>
juanpablo@727
   515
				</textField>
juanpablo@727
   516
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   517
					<reportElement
eduardo@723
   518
						x="172"
eduardo@723
   519
						y="0"
eduardo@723
   520
						width="86"
eduardo@723
   521
						height="17"
eduardo@723
   522
						forecolor="#000000"
juanpablo@727
   523
						key="textField"/>
juanpablo@727
   524
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   525
					<textElement textAlignment="Right">
juanpablo@727
   526
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   527
					</textElement>
juanpablo@727
   528
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{NONIMPONIBILE}]]></textFieldExpression>
juanpablo@727
   529
				</textField>
juanpablo@727
   530
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   531
					<reportElement
eduardo@723
   532
						x="258"
eduardo@723
   533
						y="0"
eduardo@723
   534
						width="86"
eduardo@723
   535
						height="17"
eduardo@723
   536
						forecolor="#000000"
juanpablo@727
   537
						key="textField"/>
juanpablo@727
   538
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   539
					<textElement textAlignment="Right">
juanpablo@727
   540
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   541
					</textElement>
juanpablo@727
   542
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{ESENTE}]]></textFieldExpression>
juanpablo@727
   543
				</textField>
juanpablo@727
   544
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   545
					<reportElement
eduardo@723
   546
						x="344"
eduardo@723
   547
						y="0"
eduardo@723
   548
						width="86"
eduardo@723
   549
						height="17"
eduardo@723
   550
						forecolor="#000000"
juanpablo@727
   551
						key="textField"/>
juanpablo@727
   552
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   553
					<textElement textAlignment="Right">
juanpablo@727
   554
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   555
					</textElement>
juanpablo@727
   556
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{IVAINDEDUCIBILE}]]></textFieldExpression>
juanpablo@727
   557
				</textField>
juanpablo@727
   558
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   559
					<reportElement
eduardo@723
   560
						x="430"
eduardo@723
   561
						y="0"
eduardo@723
   562
						width="86"
eduardo@723
   563
						height="17"
eduardo@723
   564
						forecolor="#000000"
juanpablo@727
   565
						key="textField"/>
juanpablo@727
   566
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   567
					<textElement textAlignment="Right">
juanpablo@727
   568
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   569
					</textElement>
juanpablo@727
   570
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{IVA}]]></textFieldExpression>
juanpablo@727
   571
				</textField>
juanpablo@727
   572
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   573
					<reportElement
eduardo@723
   574
						x="516"
eduardo@723
   575
						y="0"
eduardo@723
   576
						width="86"
eduardo@723
   577
						height="17"
eduardo@723
   578
						forecolor="#000000"
juanpablo@727
   579
						key="textField"/>
juanpablo@727
   580
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   581
					<textElement textAlignment="Right">
juanpablo@727
   582
						<font size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   583
					</textElement>
juanpablo@727
   584
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{TOTALE}]]></textFieldExpression>
juanpablo@727
   585
				</textField>
juanpablo@727
   586
			</band>
juanpablo@727
   587
		</detail>
juanpablo@727
   588
		<columnFooter>
juanpablo@727
   589
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   590
			</band>
juanpablo@727
   591
		</columnFooter>
juanpablo@727
   592
		<pageFooter>
juanpablo@727
   593
			<band height="27"  isSplitAllowed="true" >
juanpablo@727
   594
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   595
					<reportElement
eduardo@723
   596
						x="573"
eduardo@723
   597
						y="4"
eduardo@723
   598
						width="170"
eduardo@723
   599
						height="19"
eduardo@723
   600
						forecolor="#000000"
juanpablo@727
   601
						key="textField"/>
juanpablo@727
   602
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   603
					<textElement textAlignment="Right">
juanpablo@727
   604
						<font/>
juanpablo@727
   605
					</textElement>
juanpablo@727
   606
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@727
   607
				</textField>
juanpablo@727
   608
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   609
					<reportElement
eduardo@723
   610
						mode="Transparent"
eduardo@723
   611
						x="746"
eduardo@723
   612
						y="4"
eduardo@723
   613
						width="36"
eduardo@723
   614
						height="19"
eduardo@723
   615
						forecolor="#000000"
eduardo@723
   616
						backcolor="#FFFFFF"
juanpablo@727
   617
						key="textField"/>
juanpablo@727
   618
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   619
					<textElement>
juanpablo@727
   620
						<font size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />
juanpablo@727
   621
					</textElement>
juanpablo@727
   622
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@727
   623
				</textField>
juanpablo@727
   624
				<line direction="TopDown">
eduardo@723
   625
					<reportElement
eduardo@723
   626
						x="0"
eduardo@723
   627
						y="3"
eduardo@723
   628
						width="782"
eduardo@723
   629
						height="0"
eduardo@723
   630
						forecolor="#000000"
eduardo@723
   631
						backcolor="#FFFFFF"
juanpablo@727
   632
						key="line"/>
juanpablo@727
   633
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   634
				</line>
juanpablo@727
   635
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   636
					<reportElement
eduardo@723
   637
						x="1"
eduardo@723
   638
						y="6"
eduardo@723
   639
						width="209"
eduardo@723
   640
						height="19"
eduardo@723
   641
						forecolor="#000000"
juanpablo@727
   642
						key="textField"/>
juanpablo@727
   643
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   644
					<textElement>
juanpablo@727
   645
						<font/>
juanpablo@727
   646
					</textElement>
juanpablo@727
   647
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
juanpablo@727
   648
				</textField>
juanpablo@727
   649
			</band>
juanpablo@727
   650
		</pageFooter>
juanpablo@727
   651
		<summary>
juanpablo@727
   652
			<band height="195"  isSplitAllowed="true" >
juanpablo@727
   653
				<crosstab >
eduardo@723
   654
					<reportElement
eduardo@723
   655
						x="0"
eduardo@723
   656
						y="4"
eduardo@723
   657
						width="321"
eduardo@723
   658
						height="55"
juanpablo@727
   659
						key="crosstab-1"/>
juanpablo@727
   660
					<crosstabHeaderCell>						<cellContents mode="Transparent">
juanpablo@727
   661
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   662
						</cellContents>
juanpablo@727
   663
					</crosstabHeaderCell>					<rowGroup name="ALIQUOTA" width="126" totalPosition="End">
juanpablo@727
   664
						<bucket>
juanpablo@727
   665
							<bucketExpression class="java.lang.String"><![CDATA[$F{ALIQUOTA}]]></bucketExpression>
juanpablo@727
   666
						</bucket>
juanpablo@727
   667
						<crosstabRowHeader>
juanpablo@727
   668
						<cellContents mode="Transparent">
juanpablo@727
   669
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   670
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   671
					<reportElement
eduardo@723
   672
						x="0"
eduardo@723
   673
						y="0"
eduardo@723
   674
						width="75"
eduardo@723
   675
						height="30"
juanpablo@727
   676
						key="textField"/>
juanpablo@727
   677
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   678
					<textElement textAlignment="Center" verticalAlignment="Middle">
juanpablo@727
   679
						<font pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   680
					</textElement>
juanpablo@727
   681
				<textFieldExpression   class="java.lang.String"><![CDATA[$V{ALIQUOTA}]]></textFieldExpression>
juanpablo@727
   682
				</textField>
juanpablo@727
   683
				<staticText>
eduardo@723
   684
					<reportElement
eduardo@723
   685
						x="76"
eduardo@723
   686
						y="15"
eduardo@723
   687
						width="50"
eduardo@723
   688
						height="15"
juanpablo@727
   689
						key="staticText-2"/>
juanpablo@727
   690
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   691
					<textElement>
juanpablo@727
   692
						<font/>
juanpablo@727
   693
					</textElement>
juanpablo@727
   694
				<text><![CDATA[Iva Inded.]]></text>
juanpablo@727
   695
				</staticText>
juanpablo@727
   696
				<staticText>
eduardo@723
   697
					<reportElement
eduardo@723
   698
						x="76"
eduardo@723
   699
						y="0"
eduardo@723
   700
						width="50"
eduardo@723
   701
						height="15"
juanpablo@727
   702
						key="staticText-2"/>
juanpablo@727
   703
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   704
					<textElement>
juanpablo@727
   705
						<font/>
juanpablo@727
   706
					</textElement>
juanpablo@727
   707
				<text><![CDATA[Iva]]></text>
juanpablo@727
   708
				</staticText>
juanpablo@727
   709
						</cellContents>
juanpablo@727
   710
						</crosstabRowHeader>
juanpablo@727
   711
						<crosstabTotalRowHeader>
juanpablo@727
   712
						<cellContents mode="Transparent">
juanpablo@727
   713
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   714
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   715
					<reportElement
eduardo@723
   716
						x="0"
eduardo@723
   717
						y="0"
eduardo@723
   718
						width="75"
eduardo@723
   719
						height="30"
juanpablo@727
   720
						key="textField"/>
juanpablo@727
   721
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   722
					<textElement textAlignment="Center" verticalAlignment="Middle">
juanpablo@727
   723
						<font pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   724
					</textElement>
juanpablo@727
   725
				<textFieldExpression   class="java.lang.String"><![CDATA["Totale Iva"]]></textFieldExpression>
juanpablo@727
   726
				</textField>
juanpablo@727
   727
				<staticText>
eduardo@723
   728
					<reportElement
eduardo@723
   729
						x="76"
eduardo@723
   730
						y="0"
eduardo@723
   731
						width="50"
eduardo@723
   732
						height="15"
juanpablo@727
   733
						key="staticText-2"/>
juanpablo@727
   734
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   735
					<textElement>
juanpablo@727
   736
						<font/>
juanpablo@727
   737
					</textElement>
juanpablo@727
   738
				<text><![CDATA[Iva]]></text>
juanpablo@727
   739
				</staticText>
juanpablo@727
   740
				<staticText>
eduardo@723
   741
					<reportElement
eduardo@723
   742
						x="76"
eduardo@723
   743
						y="16"
eduardo@723
   744
						width="50"
eduardo@723
   745
						height="15"
juanpablo@727
   746
						key="staticText-2"/>
juanpablo@727
   747
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   748
					<textElement>
juanpablo@727
   749
						<font/>
juanpablo@727
   750
					</textElement>
juanpablo@727
   751
				<text><![CDATA[Iva Inded.]]></text>
juanpablo@727
   752
				</staticText>
juanpablo@727
   753
						</cellContents>
juanpablo@727
   754
						</crosstabTotalRowHeader>
juanpablo@727
   755
					</rowGroup>
juanpablo@727
   756
					<columnGroup name="ISSALE" height="25" headerPosition="Center">
juanpablo@727
   757
						<bucket>
juanpablo@727
   758
							<bucketExpression class="java.lang.String"><![CDATA[$F{ISSALE}]]></bucketExpression>
juanpablo@727
   759
						</bucket>
juanpablo@727
   760
						<crosstabColumnHeader>
juanpablo@727
   761
						<cellContents mode="Transparent">
juanpablo@727
   762
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   763
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   764
					<reportElement
eduardo@723
   765
						x="0"
eduardo@723
   766
						y="0"
eduardo@723
   767
						width="50"
eduardo@723
   768
						height="25"
juanpablo@727
   769
						key="textField"/>
juanpablo@727
   770
					<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   771
					<textElement textAlignment="Center" verticalAlignment="Middle">
juanpablo@727
   772
						<font pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   773
					</textElement>
juanpablo@727
   774
				<textFieldExpression   class="java.lang.String"><![CDATA[$V{ISSALE}]]></textFieldExpression>
juanpablo@727
   775
				</textField>
juanpablo@727
   776
						</cellContents>
juanpablo@727
   777
						</crosstabColumnHeader>
juanpablo@727
   778
						<crosstabTotalColumnHeader>
juanpablo@727
   779
						<cellContents mode="Transparent">
juanpablo@727
   780
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   781
						</cellContents>
juanpablo@727
   782
						</crosstabTotalColumnHeader>
juanpablo@727
   783
					</columnGroup>
juanpablo@727
   784
juanpablo@727
   785
					<measure name="IVA_Sum" class="java.math.BigDecimal" calculation="Sum">
juanpablo@727
   786
						<measureExpression><![CDATA[$F{IVA}]]></measureExpression>
juanpablo@727
   787
					</measure>
juanpablo@727
   788
					<measure name="IvaInd_Sum" class="java.math.BigDecimal" calculation="Sum">
juanpablo@727
   789
						<measureExpression><![CDATA[$F{IVAINDEDUCIBILE}]]></measureExpression>
juanpablo@727
   790
					</measure>
juanpablo@727
   791
					<crosstabCell width="50" height="30">
juanpablo@727
   792
						<cellContents mode="Transparent">
juanpablo@727
   793
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   794
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   795
					<reportElement
eduardo@723
   796
						x="0"
eduardo@723
   797
						y="0"
eduardo@723
   798
						width="50"
eduardo@723
   799
						height="15"
juanpablo@727
   800
						key="textField"/>
juanpablo@727
   801
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   802
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@727
   803
						<font/>
juanpablo@727
   804
					</textElement>
juanpablo@727
   805
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{IVA_Sum}]]></textFieldExpression>
juanpablo@727
   806
				</textField>
juanpablo@727
   807
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   808
					<reportElement
eduardo@723
   809
						x="0"
eduardo@723
   810
						y="15"
eduardo@723
   811
						width="50"
eduardo@723
   812
						height="15"
juanpablo@727
   813
						key="textField"/>
juanpablo@727
   814
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   815
					<textElement textAlignment="Right">
juanpablo@727
   816
						<font/>
juanpablo@727
   817
					</textElement>
juanpablo@727
   818
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{IvaInd_Sum}]]></textFieldExpression>
juanpablo@727
   819
				</textField>
juanpablo@727
   820
						</cellContents>
juanpablo@727
   821
					</crosstabCell>
juanpablo@727
   822
					<crosstabCell width="50" height="30" columnTotalGroup="ISSALE">
juanpablo@727
   823
						<cellContents mode="Transparent">
juanpablo@727
   824
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   825
						</cellContents>
juanpablo@727
   826
					</crosstabCell>
juanpablo@727
   827
					<crosstabCell width="50" height="31" rowTotalGroup="ALIQUOTA">
juanpablo@727
   828
						<cellContents mode="Transparent">
juanpablo@727
   829
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   830
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   831
					<reportElement
eduardo@723
   832
						x="0"
eduardo@723
   833
						y="0"
eduardo@723
   834
						width="50"
eduardo@723
   835
						height="15"
juanpablo@727
   836
						key="textField"/>
juanpablo@727
   837
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   838
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@727
   839
						<font pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   840
					</textElement>
juanpablo@727
   841
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{IVA_Sum}]]></textFieldExpression>
juanpablo@727
   842
				</textField>
juanpablo@727
   843
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   844
					<reportElement
eduardo@723
   845
						x="0"
eduardo@723
   846
						y="15"
eduardo@723
   847
						width="50"
eduardo@723
   848
						height="15"
juanpablo@727
   849
						key="textField-7"/>
juanpablo@727
   850
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   851
					<textElement textAlignment="Right">
juanpablo@727
   852
						<font pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   853
					</textElement>
juanpablo@727
   854
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{IvaInd_Sum}]]></textFieldExpression>
juanpablo@727
   855
				</textField>
juanpablo@727
   856
						</cellContents>
juanpablo@727
   857
					</crosstabCell>
juanpablo@727
   858
					<crosstabCell width="50" height="31" rowTotalGroup="ALIQUOTA" columnTotalGroup="ISSALE">
juanpablo@727
   859
						<cellContents mode="Transparent">
juanpablo@727
   860
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   861
						</cellContents>
juanpablo@727
   862
					</crosstabCell>
juanpablo@727
   863
					<whenNoDataCell>						<cellContents mode="Transparent">
juanpablo@727
   864
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
juanpablo@727
   865
						</cellContents>
juanpablo@727
   866
					</whenNoDataCell>					</crosstab>
juanpablo@727
   867
				<staticText>
eduardo@723
   868
					<reportElement
eduardo@723
   869
						x="321"
eduardo@723
   870
						y="22"
eduardo@723
   871
						width="122"
eduardo@723
   872
						height="20"
juanpablo@727
   873
						key="staticText-3"/>
juanpablo@727
   874
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   875
					<textElement verticalAlignment="Middle">
juanpablo@727
   876
						<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
juanpablo@727
   877
					</textElement>
juanpablo@727
   878
				<text><![CDATA[Totale IVA da pagare]]></text>
juanpablo@727
   879
				</staticText>
juanpablo@727
   880
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   881
					<reportElement
eduardo@723
   882
						x="443"
eduardo@723
   883
						y="22"
eduardo@723
   884
						width="100"
eduardo@723
   885
						height="20"
juanpablo@727
   886
						key="textField"/>
juanpablo@727
   887
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   888
					<textElement textAlignment="Right" verticalAlignment="Middle">
juanpablo@727
   889
						<font/>
juanpablo@727
   890
					</textElement>
juanpablo@727
   891
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{TotIvaDaPagare}]]></textFieldExpression>
juanpablo@727
   892
				</textField>
juanpablo@727
   893
				<staticText>
eduardo@723
   894
					<reportElement
eduardo@723
   895
						x="321"
eduardo@723
   896
						y="2"
eduardo@723
   897
						width="122"
eduardo@723
   898
						height="20"
juanpablo@727
   899
						key="staticText-4"/>
juanpablo@727
   900
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   901
					<textElement verticalAlignment="Middle">
juanpablo@727
   902
						<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
juanpablo@727
   903
					</textElement>
juanpablo@727
   904
				<text><![CDATA[Totale credito prec.]]></text>
juanpablo@727
   905
				</staticText>
juanpablo@727
   906
				<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   907
					<reportElement
eduardo@723
   908
						x="443"
eduardo@723
   909
						y="2"
eduardo@723
   910
						width="100"
eduardo@723
   911
						height="20"
juanpablo@727
   912
						key="textField"/>
juanpablo@727
   913
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   914
					<textElement textAlignment="Right">
juanpablo@727
   915
						<font/>
juanpablo@727
   916
					</textElement>
juanpablo@727
   917
				<textFieldExpression   class="java.math.BigDecimal"><![CDATA[( $V{TotCredPrec}.doubleValue()<0 ? new BigDecimal(0) :  $V{TotCredPrec} )]]></textFieldExpression>
juanpablo@727
   918
				</textField>
juanpablo@727
   919
			</band>
juanpablo@727
   920
		</summary>
juanpablo@727
   921
</jasperReport>