1
<?xml version="1.0" encoding="UTF-8"?>
2
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="jasper_riba_distinta" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
3
<property name="ireport.zoom" value="1.0"/>
4
<property name="ireport.x" value="0"/>
5
<property name="ireport.y" value="0"/>
6
<property name="OPENERP_RELATIONS" value="['line_ids']"/>
7
<queryString language="xPath">
10
<field name="Partner Nome" class="java.lang.String">
11
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Cliente-partner_id/Nome-name]]></fieldDescription>
13
<field name="Citta-city" class="java.lang.String">
14
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Cliente-partner_id/Citta-city]]></fieldDescription>
16
<field name="Numero_Fattura-numero_fattura" class="java.lang.String">
17
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Numero_Fattura-numero_fattura]]></fieldDescription>
19
<field name="Importo-importo" class="java.lang.Float">
20
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Importo-importo]]></fieldDescription>
22
<field name="Riferimento-name" class="java.lang.String">
23
<fieldDescription><![CDATA[/data/record/Riferimento-name]]></fieldDescription>
25
<field name="Data_Creazione-date_created" class="java.util.Date">
26
<fieldDescription><![CDATA[/data/record/Data_Creazione-date_created]]></fieldDescription>
28
<field name="DescrizioneBanca" class="java.lang.String">
29
<fieldDescription><![CDATA[/data/record/Modalita_Riba-config/Banca-bank_id/Descrizione-name]]></fieldDescription>
31
<field name="CittaBanca" class="java.lang.String">
32
<fieldDescription><![CDATA[/data/record/Modalita_Riba-config/Banca-bank_id/Citta-city]]></fieldDescription>
34
<field name="CAPBanca" class="java.lang.String">
35
<fieldDescription><![CDATA[/data/record/Modalita_Riba-config/Banca-bank_id/CAP-zip]]></fieldDescription>
37
<field name="IBAN-iban" class="java.lang.String">
38
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Debitor_Bank-bank_id/IBAN-iban]]></fieldDescription>
40
<field name="Data_Scadenza-data_scadenza" class="java.util.Date">
41
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Data_Scadenza-data_scadenza]]></fieldDescription>
43
<field name="Data_Fattura-data_fattura" class="java.lang.String">
44
<fieldDescription><![CDATA[/data/record/Scadenze_Riba-line_ids/Data_Fattura-data_fattura]]></fieldDescription>
46
<field name="Logo-logo" class="java.lang.String">
47
<fieldDescription><![CDATA[/data/record/Modalita_Riba-config/Company-company_id/Logo-logo]]></fieldDescription>
49
<field name="Nome_Azienda-name" class="java.lang.String">
50
<fieldDescription><![CDATA[/data/record/Modalita_Riba-config/Company-company_id/Nome_Azienda-name]]></fieldDescription>
52
<variable name="Importo-importo_1" class="java.lang.Integer" resetType="Column" calculation="Count">
53
<variableExpression><![CDATA[$F{Importo-importo}]]></variableExpression>
55
<variable name="Importo-importo_2" class="java.lang.Integer" resetType="Column" calculation="Count">
56
<variableExpression><![CDATA[$F{Importo-importo}]]></variableExpression>
58
<variable name="Importo-importo_3" class="java.lang.Float" resetType="Column" calculation="Sum">
59
<variableExpression><![CDATA[$F{Importo-importo}]]></variableExpression>
62
<band splitType="Stretch"/>
65
<band height="72" splitType="Stretch">
67
<reportElement x="239" y="0" width="316" height="25"/>
71
<text><![CDATA[DISTINTA DI PRESENTAZIONE]]></text>
73
<textField isBlankWhenNull="true">
74
<reportElement x="239" y="25" width="316" height="16"/>
76
<textFieldExpression><![CDATA[$F{Nome_Azienda-name}]]></textFieldExpression>
78
<image scaleImage="RetainShape" hAlign="Center" vAlign="Top" isUsingCache="false" isLazy="true" onErrorType="Icon">
79
<reportElement x="0" y="0" width="239" height="62"/>
80
<imageExpression><![CDATA[$F{Logo-logo}]]></imageExpression>
85
<band height="77" splitType="Stretch">
87
<reportElement x="0" y="0" width="239" height="20"/>
89
<textFieldExpression><![CDATA["Numero Distinta : " + $F{Riferimento-name}]]></textFieldExpression>
92
<reportElement x="0" y="20" width="239" height="20"/>
94
<textFieldExpression><![CDATA["Data : " + $F{Data_Creazione-date_created}.getDate() + "/" + ($F{Data_Creazione-date_created}.getMonth() + 1) + "/" + ($F{Data_Creazione-date_created}.getYear() + 1900)]]></textFieldExpression>
97
<reportElement x="0" y="40" width="555" height="26"/>
99
<textFieldExpression><![CDATA["SPETT.LE " + $F{DescrizioneBanca} + ", " + $F{CittaBanca} + " - " + $F{CAPBanca}]]></textFieldExpression>
104
<band height="24" splitType="Stretch">
106
<reportElement x="0" y="0" width="78" height="24"/>
108
<font isBold="true"/>
110
<text><![CDATA[Ragione soc.]]></text>
113
<reportElement x="78" y="0" width="48" height="24"/>
115
<font isBold="true"/>
117
<text><![CDATA[Città]]></text>
120
<reportElement x="126" y="0" width="139" height="24"/>
122
<font isBold="true"/>
124
<text><![CDATA[IBAN]]></text>
127
<reportElement x="265" y="0" width="116" height="24"/>
129
<font isBold="true"/>
131
<text><![CDATA[Numero Fattura]]></text>
134
<reportElement x="447" y="0" width="48" height="24"/>
136
<font isBold="true"/>
138
<text><![CDATA[Importo]]></text>
141
<reportElement x="381" y="0" width="66" height="24"/>
143
<font isBold="true"/>
145
<text><![CDATA[Data]]></text>
148
<reportElement x="495" y="0" width="60" height="24"/>
150
<font isBold="true"/>
152
<text><![CDATA[Scadenza]]></text>
157
<band height="20" splitType="Stretch">
158
<textField isBlankWhenNull="true">
159
<reportElement x="0" y="0" width="78" height="20"/>
163
<textFieldExpression><![CDATA[$F{Partner Nome}]]></textFieldExpression>
165
<textField isBlankWhenNull="true">
166
<reportElement x="78" y="0" width="48" height="20"/>
170
<textFieldExpression><![CDATA[$F{Citta-city}]]></textFieldExpression>
172
<textField isBlankWhenNull="true">
173
<reportElement x="265" y="0" width="116" height="20"/>
177
<textFieldExpression><![CDATA[$F{Numero_Fattura-numero_fattura}]]></textFieldExpression>
179
<textField isBlankWhenNull="true">
180
<reportElement x="447" y="0" width="48" height="20"/>
184
<textFieldExpression><![CDATA[$F{Importo-importo}]]></textFieldExpression>
186
<textField isBlankWhenNull="true">
187
<reportElement x="126" y="0" width="139" height="20"/>
191
<textFieldExpression><![CDATA[$F{IBAN-iban}]]></textFieldExpression>
193
<textField isBlankWhenNull="true">
194
<reportElement x="495" y="0" width="60" height="20"/>
198
<textFieldExpression><![CDATA[$F{Data_Scadenza-data_scadenza}.getDate() + "/" + ($F{Data_Scadenza-data_scadenza}.getMonth() + 1) + "/" + ($F{Data_Scadenza-data_scadenza}.getYear() + 1900)]]></textFieldExpression>
200
<textField pattern="" isBlankWhenNull="true">
201
<reportElement x="381" y="0" width="66" height="20"/>
205
<textFieldExpression><![CDATA[$F{Data_Fattura-data_fattura}]]></textFieldExpression>
210
<band height="22" splitType="Stretch"/>
213
<band height="21" splitType="Stretch">
215
<reportElement x="435" y="0" width="80" height="20"/>
216
<textElement textAlignment="Right"/>
217
<textFieldExpression><![CDATA["Pagina "+$V{PAGE_NUMBER}+" di"]]></textFieldExpression>
219
<textField evaluationTime="Report">
220
<reportElement x="515" y="0" width="40" height="20"/>
222
<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
227
<band height="33" splitType="Stretch">
229
<reportElement x="455" y="8" width="100" height="23"/>
231
<textFieldExpression><![CDATA[$V{Importo-importo_3}]]></textFieldExpression>
234
<reportElement x="0" y="0" width="555" height="1"/>
236
<pen lineWidth="1.0"/>
240
<reportElement x="0" y="8" width="222" height="23"/>
242
<textFieldExpression><![CDATA["Numero righe : " + $V{Importo-importo_2}]]></textFieldExpression>