src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 727 23af88f55124
child 1365 82ac545d75cf
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="ReportAnnualCertification"
juanpablo@727
     6
		 columnCount="1"
juanpablo@727
     7
		 printOrder="Vertical"
juanpablo@727
     8
		 orientation="Portrait"
juanpablo@727
     9
		 pageWidth="595"
juanpablo@727
    10
		 pageHeight="842"
juanpablo@727
    11
		 columnWidth="535"
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="Mittente" isForPrompting="false" class="java.lang.String">
juanpablo@727
    27
		<parameterDescription><![CDATA[Mittente]]></parameterDescription>
juanpablo@727
    28
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    29
	</parameter>
juanpablo@727
    30
	<parameter name="Erogante" isForPrompting="false" class="java.lang.String">
juanpablo@727
    31
		<parameterDescription><![CDATA[Erogante]]></parameterDescription>
juanpablo@727
    32
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    33
	</parameter>
juanpablo@727
    34
	<parameter name="DateFrom" isForPrompting="false" class="java.lang.String">
juanpablo@727
    35
		<parameterDescription><![CDATA[Date From]]></parameterDescription>
juanpablo@727
    36
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    37
	</parameter>
juanpablo@727
    38
	<parameter name="DateTo" isForPrompting="false" class="java.lang.String">
juanpablo@727
    39
		<parameterDescription><![CDATA[Date To]]></parameterDescription>
juanpablo@727
    40
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    41
	</parameter>
juanpablo@727
    42
	<parameter name="AddressOrganization" isForPrompting="false" class="java.lang.String">
juanpablo@727
    43
		<parameterDescription><![CDATA[Address Organization]]></parameterDescription>
juanpablo@727
    44
		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
juanpablo@727
    45
	</parameter>
eduardo@723
    46
	<queryString><![CDATA[SELECT buspar.name as BusinessPartner,buspar.taxid,buspar.fiscalcode,Loc.ADDRESS1,Loc.POSTAL,City.NAME as City,City.LOCODE,
eduardo@723
    47
 debpaycancel.DATEPLANNED,bank.Name,bank.Codebank,bank.Codebranch,bank.Digitcontrol as DigitcontrolBank,bankaccount.Digitcontrol as DigitcontrolBankAccount,bankaccount.Codeaccount,
eduardo@723
    48
 coalesce ( sum(invoic.TOTALLINES),0) as SummedLineAmount,
eduardo@723
    49
 coalesce ( sum(invoic.GRANDTOTAL),0) as GrandTotalAmount,
eduardo@723
    50
 coalesce ( sum(invoic.WITHHOLDINGAMOUNT),0) as WithHoldingAmount
eduardo@723
    51
 --(TO_CHAR(bank.Name)  || ' - ' || TO_CHAR(bank.Codebank)  || ' - ' || TO_CHAR(bank.Codebranch)  || ' - ' || TO_CHAR(bank.Digitcontrol)  || ' - ' || TO_CHAR(bankaccount.Digitcontrol)  || ' - ' || TO_CHAR(bankaccount.Codeaccount) ) AS C_BankAccount_IDR
eduardo@723
    52
 FROM 
eduardo@723
    53
 (select * from C_INVOICE where ISACTIVE='Y' 
eduardo@723
    54
 /* and AD_Client_ID IN ('1')
eduardo@723
    55
 and AD_ORG_ID IN ('1')
eduardo@723
    56
 */
eduardo@723
    57
 ) invoic 
eduardo@723
    58
 join (select * from C_DEBT_PAYMENT where ISACTIVE='Y' 
eduardo@723
    59
 AND 1=1 
eduardo@723
    60
 ) debpaycancel on invoic.C_INVOICE_ID=debpaycancel.C_INVOICE_ID 
eduardo@723
    61
  join (select * from C_SETTLEMENT where ISACTIVE='Y' 
eduardo@723
    62
 and PROCESSED='Y' 
eduardo@723
    63
 ) settlm on settlm.C_SETTLEMENT_ID=debpaycancel.C_SETTLEMENT_CANCEL_ID
eduardo@723
    64
 join (select * from C_DEBT_PAYMENT where ISACTIVE='Y' 
eduardo@723
    65
 ) debpaygenerate on settlm.C_SETTLEMENT_ID=debpaygenerate.C_SETTLEMENT_GENERATE_ID
eduardo@723
    66
 join (select * from C_BPARTNER where ISACTIVE='Y' 
eduardo@723
    67
 AND 2=2 ) buspar on buspar.C_BPARTNER_ID=invoic.C_BPARTNER_ID 
eduardo@723
    68
 left join (select C_BPARTNER_ID,C_LOCATION_ID from C_BPARTNER_LOCATION where ISACTIVE='Y' and ISBILLTO='Y') BprLoc  on buspar.C_BPARTNER_ID=BprLoc.C_BPARTNER_ID
eduardo@723
    69
 left join (select C_LOCATION_ID,C_CITY_ID,ADDRESS1,POSTAL from C_LOCATION where ISACTIVE='Y' ) Loc on  BprLoc.C_LOCATION_ID = Loc.C_LOCATION_ID 
eduardo@723
    70
 left join (select C_CITY_ID,NAME,LOCODE from C_CITY where ISACTIVE='Y' ) City  on Loc.C_CITY_ID=City.C_CITY_ID 
eduardo@723
    71
 left join (select C_BankAccount_ID, C_Bank_ID, Digitcontrol, Codeaccount from C_BankAccount) bankaccount on (debpaygenerate.C_BankAccount_ID = bankaccount.C_BankAccount_ID) 
eduardo@723
    72
 left join (select C_Bank_ID, Name, Codebank, Codebranch, Digitcontrol from C_Bank) bank on (bank.C_Bank_ID = bankaccount.C_Bank_ID) 
eduardo@723
    73
 group by buspar.name,buspar.taxid,buspar.fiscalcode,Loc.ADDRESS1,Loc.POSTAL,City.NAME,City.LOCODE ,debpaycancel.DATEPLANNED,bank.Name,bank.Codebank,bank.Codebranch,bank.Digitcontrol,bankaccount.Digitcontrol,bankaccount.Codeaccount
juanpablo@727
    74
 order by buspar.name asc]]></queryString>
juanpablo@727
    75
juanpablo@727
    76
	<field name="BUSINESSPARTNER" class="java.lang.String"/>
juanpablo@727
    77
	<field name="TAXID" class="java.lang.String"/>
juanpablo@727
    78
	<field name="FISCALCODE" class="java.lang.String"/>
juanpablo@727
    79
	<field name="ADDRESS1" class="java.lang.String"/>
juanpablo@727
    80
	<field name="POSTAL" class="java.lang.String"/>
juanpablo@727
    81
	<field name="CITY" class="java.lang.String"/>
juanpablo@727
    82
	<field name="LOCODE" class="java.lang.String"/>
juanpablo@727
    83
	<field name="DATEPLANNED" class="java.util.Date"/>
juanpablo@727
    84
	<field name="NAME" class="java.lang.String"/>
juanpablo@727
    85
	<field name="CODEBANK" class="java.lang.String"/>
juanpablo@727
    86
	<field name="CODEBRANCH" class="java.lang.String"/>
juanpablo@727
    87
	<field name="DIGITCONTROLBANK" class="java.lang.String"/>
juanpablo@727
    88
	<field name="DIGITCONTROLBANKACCOUNT" class="java.lang.String"/>
juanpablo@727
    89
	<field name="CODEACCOUNT" class="java.lang.String"/>
juanpablo@727
    90
	<field name="SUMMEDLINEAMOUNT" class="java.math.BigDecimal"/>
juanpablo@727
    91
	<field name="GRANDTOTALAMOUNT" class="java.math.BigDecimal"/>
juanpablo@727
    92
	<field name="WITHHOLDINGAMOUNT" class="java.math.BigDecimal"/>
juanpablo@727
    93
juanpablo@727
    94
		<background>
juanpablo@727
    95
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
    96
			</band>
juanpablo@727
    97
		</background>
juanpablo@727
    98
		<title>
juanpablo@727
    99
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   100
				<line direction="TopDown">
eduardo@723
   101
					<reportElement
eduardo@723
   102
						x="0"
eduardo@723
   103
						y="-2"
eduardo@723
   104
						width="534"
eduardo@723
   105
						height="0"
juanpablo@727
   106
						key="line"/>
juanpablo@727
   107
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   108
				</line>
juanpablo@727
   109
				<line direction="TopDown">
eduardo@723
   110
					<reportElement
eduardo@723
   111
						x="0"
eduardo@723
   112
						y="-47"
eduardo@723
   113
						width="534"
eduardo@723
   114
						height="0"
juanpablo@727
   115
						key="line"/>
juanpablo@727
   116
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   117
				</line>
juanpablo@727
   118
			</band>
juanpablo@727
   119
		</title>
juanpablo@727
   120
		<pageHeader>
juanpablo@727
   121
			<band height="10"  isSplitAllowed="true" >
juanpablo@727
   122
				<line direction="BottomUp">
eduardo@723
   123
					<reportElement
eduardo@723
   124
						x="0"
eduardo@723
   125
						y="9"
eduardo@723
   126
						width="535"
eduardo@723
   127
						height="0"
juanpablo@727
   128
						key="line"/>
juanpablo@727
   129
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   130
				</line>
juanpablo@727
   131
			</band>
juanpablo@727
   132
		</pageHeader>
juanpablo@727
   133
		<columnHeader>
juanpablo@727
   134
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   135
			</band>
juanpablo@727
   136
		</columnHeader>
juanpablo@727
   137
		<detail>
juanpablo@727
   138
			<band height="600"  isSplitAllowed="true" >
juanpablo@727
   139
				<textField isStretchWithOverflow="false" pattern="dd/MM/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   140
					<reportElement
eduardo@723
   141
						x="0"
eduardo@723
   142
						y="545"
eduardo@723
   143
						width="404"
eduardo@723
   144
						height="30"
eduardo@723
   145
						forecolor="#000000"
eduardo@723
   146
						backcolor="#FFFFFF"
juanpablo@727
   147
						key="textField"/>
juanpablo@727
   148
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   149
					<textElement>
juanpablo@727
   150
						<font fontName="Courier New" size="10"/>
juanpablo@727
   151
					</textElement>
juanpablo@727
   152
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{AddressOrganization}+"\nIl "+ new SimpleDateFormat ("dd/mm/yyyy").format(new Date()).toString()]]></textFieldExpression>
juanpablo@727
   153
				</textField>
juanpablo@727
   154
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   155
					<reportElement
eduardo@723
   156
						x="220"
eduardo@723
   157
						y="32"
eduardo@723
   158
						width="315"
eduardo@723
   159
						height="17"
eduardo@723
   160
						forecolor="#000000"
eduardo@723
   161
						backcolor="#FFFFFF"
juanpablo@727
   162
						key="textField"/>
juanpablo@727
   163
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   164
					<textElement verticalAlignment="Middle">
juanpablo@727
   165
						<font fontName="Courier New" size="10"/>
juanpablo@727
   166
					</textElement>
juanpablo@727
   167
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{BUSINESSPARTNER}]]></textFieldExpression>
juanpablo@727
   168
				</textField>
juanpablo@727
   169
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   170
					<reportElement
eduardo@723
   171
						x="76"
eduardo@723
   172
						y="170"
eduardo@723
   173
						width="196"
eduardo@723
   174
						height="17"
eduardo@723
   175
						forecolor="#000000"
eduardo@723
   176
						backcolor="#FFFFFF"
juanpablo@727
   177
						key="textField"/>
juanpablo@727
   178
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   179
					<textElement verticalAlignment="Middle">
juanpablo@727
   180
						<font fontName="Courier New" size="10"/>
juanpablo@727
   181
					</textElement>
juanpablo@727
   182
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{FISCALCODE}]]></textFieldExpression>
juanpablo@727
   183
				</textField>
juanpablo@727
   184
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   185
					<reportElement
eduardo@723
   186
						x="76"
eduardo@723
   187
						y="153"
eduardo@723
   188
						width="196"
eduardo@723
   189
						height="17"
eduardo@723
   190
						forecolor="#000000"
eduardo@723
   191
						backcolor="#FFFFFF"
juanpablo@727
   192
						key="textField"/>
juanpablo@727
   193
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   194
					<textElement verticalAlignment="Middle">
juanpablo@727
   195
						<font fontName="Courier New" size="10"/>
juanpablo@727
   196
					</textElement>
juanpablo@727
   197
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{ADDRESS1}]]></textFieldExpression>
juanpablo@727
   198
				</textField>
juanpablo@727
   199
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   200
					<reportElement
eduardo@723
   201
						x="387"
eduardo@723
   202
						y="153"
eduardo@723
   203
						width="74"
eduardo@723
   204
						height="17"
eduardo@723
   205
						forecolor="#000000"
eduardo@723
   206
						backcolor="#FFFFFF"
juanpablo@727
   207
						key="textField"/>
juanpablo@727
   208
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   209
					<textElement verticalAlignment="Middle">
juanpablo@727
   210
						<font fontName="Courier New" size="10"/>
juanpablo@727
   211
					</textElement>
juanpablo@727
   212
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{POSTAL}]]></textFieldExpression>
juanpablo@727
   213
				</textField>
juanpablo@727
   214
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   215
					<reportElement
eduardo@723
   216
						x="277"
eduardo@723
   217
						y="153"
eduardo@723
   218
						width="107"
eduardo@723
   219
						height="17"
eduardo@723
   220
						forecolor="#000000"
eduardo@723
   221
						backcolor="#FFFFFF"
juanpablo@727
   222
						key="textField"/>
juanpablo@727
   223
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   224
					<textElement verticalAlignment="Middle">
juanpablo@727
   225
						<font fontName="Courier New" size="10"/>
juanpablo@727
   226
					</textElement>
juanpablo@727
   227
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{CITY}]]></textFieldExpression>
juanpablo@727
   228
				</textField>
juanpablo@727
   229
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   230
					<reportElement
eduardo@723
   231
						x="467"
eduardo@723
   232
						y="153"
eduardo@723
   233
						width="67"
eduardo@723
   234
						height="17"
eduardo@723
   235
						forecolor="#000000"
eduardo@723
   236
						backcolor="#FFFFFF"
juanpablo@727
   237
						key="textField"/>
juanpablo@727
   238
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   239
					<textElement verticalAlignment="Middle">
juanpablo@727
   240
						<font fontName="Courier New" size="10"/>
juanpablo@727
   241
					</textElement>
juanpablo@727
   242
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{LOCODE}]]></textFieldExpression>
juanpablo@727
   243
				</textField>
juanpablo@727
   244
				<staticText>
eduardo@723
   245
					<reportElement
eduardo@723
   246
						x="182"
eduardo@723
   247
						y="32"
eduardo@723
   248
						width="38"
eduardo@723
   249
						height="17"
juanpablo@727
   250
						key="staticText-1"/>
juanpablo@727
   251
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   252
					<textElement verticalAlignment="Middle">
juanpablo@727
   253
						<font fontName="Courier New"/>
juanpablo@727
   254
					</textElement>
juanpablo@727
   255
				<text><![CDATA[Spett.]]></text>
juanpablo@727
   256
				</staticText>
juanpablo@727
   257
				<staticText>
eduardo@723
   258
					<reportElement
eduardo@723
   259
						x="0"
eduardo@723
   260
						y="68"
eduardo@723
   261
						width="535"
eduardo@723
   262
						height="33"
juanpablo@727
   263
						key="staticText-2"/>
juanpablo@727
   264
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   265
					<textElement>
juanpablo@727
   266
						<font fontName="Courier New" pdfFontName="Helvetica-Bold" isBold="true"/>
juanpablo@727
   267
					</textElement>
eduardo@723
   268
				<text><![CDATA[Oggetto : certificazione dei compensi assoggettati a ritenuta d'acconto (art. DPR 29 Settembre 1973 n°
juanpablo@727
   269
600)]]></text>
juanpablo@727
   270
				</staticText>
juanpablo@727
   271
				<staticText>
eduardo@723
   272
					<reportElement
eduardo@723
   273
						x="1"
eduardo@723
   274
						y="117"
eduardo@723
   275
						width="75"
eduardo@723
   276
						height="18"
juanpablo@727
   277
						key="staticText-3"/>
juanpablo@727
   278
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   279
					<textElement verticalAlignment="Middle">
juanpablo@727
   280
						<font fontName="Courier New"/>
juanpablo@727
   281
					</textElement>
juanpablo@727
   282
				<text><![CDATA[Percipiente :]]></text>
juanpablo@727
   283
				</staticText>
juanpablo@727
   284
				<staticText>
eduardo@723
   285
					<reportElement
eduardo@723
   286
						x="1"
eduardo@723
   287
						y="135"
eduardo@723
   288
						width="75"
eduardo@723
   289
						height="18"
juanpablo@727
   290
						key="staticText-4"/>
juanpablo@727
   291
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   292
					<textElement verticalAlignment="Middle">
juanpablo@727
   293
						<font fontName="Courier New"/>
juanpablo@727
   294
					</textElement>
juanpablo@727
   295
				<text><![CDATA[Nato :]]></text>
juanpablo@727
   296
				</staticText>
juanpablo@727
   297
				<staticText>
eduardo@723
   298
					<reportElement
eduardo@723
   299
						x="1"
eduardo@723
   300
						y="153"
eduardo@723
   301
						width="75"
eduardo@723
   302
						height="18"
juanpablo@727
   303
						key="staticText-5"/>
juanpablo@727
   304
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   305
					<textElement verticalAlignment="Middle">
juanpablo@727
   306
						<font fontName="Courier New"/>
juanpablo@727
   307
					</textElement>
juanpablo@727
   308
				<text><![CDATA[Residente :]]></text>
juanpablo@727
   309
				</staticText>
juanpablo@727
   310
				<staticText>
eduardo@723
   311
					<reportElement
eduardo@723
   312
						x="1"
eduardo@723
   313
						y="171"
eduardo@723
   314
						width="75"
eduardo@723
   315
						height="18"
juanpablo@727
   316
						key="staticText-6"/>
juanpablo@727
   317
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   318
					<textElement verticalAlignment="Middle">
juanpablo@727
   319
						<font fontName="Courier New"/>
juanpablo@727
   320
					</textElement>
juanpablo@727
   321
				<text><![CDATA[Cod.Fiscale :]]></text>
juanpablo@727
   322
				</staticText>
juanpablo@727
   323
				<staticText>
eduardo@723
   324
					<reportElement
eduardo@723
   325
						x="0"
eduardo@723
   326
						y="199"
eduardo@723
   327
						width="75"
eduardo@723
   328
						height="18"
juanpablo@727
   329
						key="staticText-7"/>
juanpablo@727
   330
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   331
					<textElement verticalAlignment="Middle">
juanpablo@727
   332
						<font fontName="Courier New"/>
juanpablo@727
   333
					</textElement>
juanpablo@727
   334
				<text><![CDATA[Erogante :]]></text>
juanpablo@727
   335
				</staticText>
juanpablo@727
   336
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   337
					<reportElement
eduardo@723
   338
						x="0"
eduardo@723
   339
						y="217"
eduardo@723
   340
						width="535"
eduardo@723
   341
						height="62"
juanpablo@727
   342
						key="textField-1"/>
juanpablo@727
   343
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   344
					<textElement>
juanpablo@727
   345
						<font fontName="Courier New"/>
juanpablo@727
   346
					</textElement>
eduardo@723
   347
				<textFieldExpression   class="java.lang.String"><![CDATA["Attestiamo che nel periodo dal "+$P{DateFrom}.toString()+" al "+$P{DateTo}.toString()+" sono state corrisposte al percipiente somme per un importo complessivo pari a Euro "+$F{GRANDTOTALAMOUNT}.toString()+"\n"+
juanpablo@727
   348
"e l'importo della ritenuta d'acconto operata è di Euro "+$F{WITHHOLDINGAMOUNT}.toString()+"\n"]]></textFieldExpression>
juanpablo@727
   349
				</textField>
juanpablo@727
   350
				<staticText>
eduardo@723
   351
					<reportElement
eduardo@723
   352
						x="0"
eduardo@723
   353
						y="527"
eduardo@723
   354
						width="131"
eduardo@723
   355
						height="18"
juanpablo@727
   356
						key="staticText-8"/>
juanpablo@727
   357
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   358
					<textElement>
juanpablo@727
   359
						<font fontName="Courier New"/>
juanpablo@727
   360
					</textElement>
juanpablo@727
   361
				<text><![CDATA[Distinti saluti]]></text>
juanpablo@727
   362
				</staticText>
juanpablo@727
   363
				<staticText>
eduardo@723
   364
					<reportElement
eduardo@723
   365
						x="404"
eduardo@723
   366
						y="557"
eduardo@723
   367
						width="131"
eduardo@723
   368
						height="18"
juanpablo@727
   369
						key="staticText-9"/>
juanpablo@727
   370
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   371
					<textElement textAlignment="Right">
juanpablo@727
   372
						<font fontName="Courier New" pdfFontName="Helvetica" isBold="false"/>
juanpablo@727
   373
					</textElement>
juanpablo@727
   374
				<text><![CDATA[Firma]]></text>
juanpablo@727
   375
				</staticText>
juanpablo@727
   376
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   377
					<reportElement
eduardo@723
   378
						x="0"
eduardo@723
   379
						y="9"
eduardo@723
   380
						width="109"
eduardo@723
   381
						height="12"
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>
juanpablo@727
   385
						<font fontName="Courier New"/>
juanpablo@727
   386
					</textElement>
juanpablo@727
   387
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{Mittente}]]></textFieldExpression>
juanpablo@727
   388
				</textField>
juanpablo@727
   389
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   390
					<reportElement
eduardo@723
   391
						x="76"
eduardo@723
   392
						y="199"
eduardo@723
   393
						width="458"
eduardo@723
   394
						height="18"
juanpablo@727
   395
						key="textField"/>
juanpablo@727
   396
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   397
					<textElement>
juanpablo@727
   398
						<font/>
juanpablo@727
   399
					</textElement>
juanpablo@727
   400
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{Erogante}]]></textFieldExpression>
juanpablo@727
   401
				</textField>
juanpablo@727
   402
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   403
					<reportElement
eduardo@723
   404
						x="76"
eduardo@723
   405
						y="117"
eduardo@723
   406
						width="315"
eduardo@723
   407
						height="17"
eduardo@723
   408
						forecolor="#000000"
eduardo@723
   409
						backcolor="#FFFFFF"
juanpablo@727
   410
						key="textField-2"/>
juanpablo@727
   411
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   412
					<textElement verticalAlignment="Middle">
juanpablo@727
   413
						<font fontName="Courier New" size="10"/>
juanpablo@727
   414
					</textElement>
juanpablo@727
   415
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{BUSINESSPARTNER}]]></textFieldExpression>
juanpablo@727
   416
				</textField>
juanpablo@727
   417
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   418
					<reportElement
eduardo@723
   419
						x="0"
eduardo@723
   420
						y="319"
eduardo@723
   421
						width="535"
eduardo@723
   422
						height="20"
juanpablo@727
   423
						key="textField-3"/>
juanpablo@727
   424
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   425
					<textElement>
juanpablo@727
   426
						<font fontName="Courier New"/>
juanpablo@727
   427
					</textElement>
juanpablo@727
   428
				<textFieldExpression   class="java.lang.String"><![CDATA["Versamento effettuato il "+ new SimpleDateFormat ("dd/mm/yyyy").format($F{DATEPLANNED}).toString()]]></textFieldExpression>
juanpablo@727
   429
				</textField>
juanpablo@727
   430
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   431
					<reportElement
eduardo@723
   432
						x="0"
eduardo@723
   433
						y="279"
eduardo@723
   434
						width="535"
eduardo@723
   435
						height="20"
juanpablo@727
   436
						key="textField-4"/>
juanpablo@727
   437
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   438
					<textElement>
juanpablo@727
   439
						<font fontName="Courier New"/>
juanpablo@727
   440
					</textElement>
juanpablo@727
   441
				<textFieldExpression   class="java.lang.String"><![CDATA["Le ritenute d'acconto sono state versate nei termini di legge, presso : "]]></textFieldExpression>
juanpablo@727
   442
				</textField>
juanpablo@727
   443
				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   444
					<reportElement
eduardo@723
   445
						x="0"
eduardo@723
   446
						y="299"
eduardo@723
   447
						width="535"
eduardo@723
   448
						height="20"
juanpablo@727
   449
						key="textField-5"/>
juanpablo@727
   450
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   451
					<textElement>
juanpablo@727
   452
						<font fontName="Courier New"/>
juanpablo@727
   453
					</textElement>
juanpablo@727
   454
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NAME}.trim()+"-"+$F{CODEBANK}.toString()+"-"+$F{CODEBRANCH}.toString()+"-"+$F{DIGITCONTROLBANK}.toString()+"-"+$F{DIGITCONTROLBANKACCOUNT}.toString()+"-"+$F{CODEACCOUNT}.toString()]]></textFieldExpression>
juanpablo@727
   455
				</textField>
juanpablo@727
   456
			</band>
juanpablo@727
   457
		</detail>
juanpablo@727
   458
		<columnFooter>
juanpablo@727
   459
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   460
			</band>
juanpablo@727
   461
		</columnFooter>
juanpablo@727
   462
		<pageFooter>
juanpablo@727
   463
			<band height="27"  isSplitAllowed="true" >
juanpablo@727
   464
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   465
					<reportElement
eduardo@723
   466
						x="325"
eduardo@723
   467
						y="4"
eduardo@723
   468
						width="170"
eduardo@723
   469
						height="19"
eduardo@723
   470
						forecolor="#000000"
eduardo@723
   471
						backcolor="#FFFFFF"
juanpablo@727
   472
						key="textField"/>
juanpablo@727
   473
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   474
					<textElement textAlignment="Right">
juanpablo@727
   475
						<font size="10"/>
juanpablo@727
   476
					</textElement>
juanpablo@727
   477
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
juanpablo@727
   478
				</textField>
juanpablo@727
   479
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
eduardo@723
   480
					<reportElement
eduardo@723
   481
						x="499"
eduardo@723
   482
						y="4"
eduardo@723
   483
						width="36"
eduardo@723
   484
						height="19"
eduardo@723
   485
						forecolor="#000000"
eduardo@723
   486
						backcolor="#FFFFFF"
juanpablo@727
   487
						key="textField"/>
juanpablo@727
   488
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@727
   489
					<textElement>
juanpablo@727
   490
						<font size="10"/>
juanpablo@727
   491
					</textElement>
juanpablo@727
   492
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
juanpablo@727
   493
				</textField>
juanpablo@727
   494
				<line direction="TopDown">
eduardo@723
   495
					<reportElement
eduardo@723
   496
						x="0"
eduardo@723
   497
						y="3"
eduardo@723
   498
						width="535"
eduardo@723
   499
						height="0"
juanpablo@727
   500
						key="line"/>
juanpablo@727
   501
					<graphicElement stretchType="NoStretch"/>
juanpablo@727
   502
				</line>
juanpablo@727
   503
			</band>
juanpablo@727
   504
		</pageFooter>
juanpablo@727
   505
		<summary>
juanpablo@727
   506
			<band height="0"  isSplitAllowed="true" >
juanpablo@727
   507
			</band>
juanpablo@727
   508
		</summary>
juanpablo@727
   509
</jasperReport>