← Back to branch summary

~openerp-commiter/openobject-addons/extra-6.0

« back to all changes in this revision

Viewing changes to account_jasper_report/report/taxes_by_invoice.jrxml

  • Committer: Albert Cervera i Areny
  • Date: 2011-07-08 00:25:21 UTC
  • Revision ID: albert@nan-tic.com-20110708002521-lbq7213zodri4fnn
[ADD] account_jasper_report: Module with jasper-based accounting reports: Intends to replace the ones in standard 'account' module and 'account_financial_report'.

Show diffs side-by-side

added added

removed removed

Lines of Context:
account_jasper_report/report/taxes_by_invoice.jrxml
 
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="report name" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
 
3
        <property name="OPENERP_RELATIONS" value="[&apos;tax_line&apos;]"/>
 
4
        <property name="ireport.zoom" value="2.8531167061100033"/>
 
5
        <property name="ireport.x" value="853"/>
 
6
        <property name="ireport.y" value="171"/>
 
7
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"/>
 
8
        <parameter name="STANDARD_DIR" class="java.lang.String"/>
 
9
        <parameter name="SUBTITLE" class="java.lang.String"/>
 
10
        <parameter name="HEADER_DS" class="java.lang.Object"/>
 
11
        <queryString language="xPath">
 
12
                <![CDATA[/data/record]]>
 
13
        </queryString>
 
14
        <field name="amount_total" class="java.math.BigDecimal">
 
15
                <fieldDescription><![CDATA[amount_total]]></fieldDescription>
 
16
        </field>
 
17
        <field name="number" class="java.lang.String">
 
18
                <fieldDescription><![CDATA[number]]></fieldDescription>
 
19
        </field>
 
20
        <field name="date_invoice" class="java.util.Date">
 
21
                <fieldDescription><![CDATA[date_invoice]]></fieldDescription>
 
22
        </field>
 
23
        <field name="tax_name" class="java.lang.String">
 
24
                <fieldDescription><![CDATA[tax_line/name]]></fieldDescription>
 
25
        </field>
 
26
        <field name="tax_amount" class="java.math.BigDecimal">
 
27
                <fieldDescription><![CDATA[tax_line/tax_amount]]></fieldDescription>
 
28
        </field>
 
29
        <field name="base_amount" class="java.math.BigDecimal">
 
30
                <fieldDescription><![CDATA[tax_line/base_amount]]></fieldDescription>
 
31
        </field>
 
32
        <field name="type" class="java.lang.String">
 
33
                <fieldDescription><![CDATA[type]]></fieldDescription>
 
34
        </field>
 
35
        <field name="account_code" class="java.lang.String">
 
36
                <fieldDescription><![CDATA[account_id/code]]></fieldDescription>
 
37
        </field>
 
38
        <field name="account_name" class="java.lang.String">
 
39
                <fieldDescription><![CDATA[account_id/name]]></fieldDescription>
 
40
        </field>
 
41
        <field name="partner_vat" class="java.lang.String">
 
42
                <fieldDescription><![CDATA[partner_id/vat]]></fieldDescription>
 
43
        </field>
 
44
        <field name="period" class="java.lang.String">
 
45
                <fieldDescription><![CDATA[move_id/period_id/name]]></fieldDescription>
 
46
        </field>
 
47
        <sortField name="period"/>
 
48
        <sortField name="number"/>
 
49
        <variable name="total_base" class="java.math.BigDecimal" calculation="Sum">
 
50
                <variableExpression><![CDATA[$F{base_amount}]]></variableExpression>
 
51
        </variable>
 
52
        <variable name="total_tax" class="java.math.BigDecimal" calculation="Sum">
 
53
                <variableExpression><![CDATA[$F{tax_amount}]]></variableExpression>
 
54
        </variable>
 
55
        <variable name="total" class="java.math.BigDecimal" calculation="Sum">
 
56
                <variableExpression><![CDATA[$F{amount_total}]]></variableExpression>
 
57
        </variable>
 
58
        <variable name="tax_amount_1" class="java.math.BigDecimal" resetType="Group" resetGroup="quarter" calculation="Sum">
 
59
                <variableExpression><![CDATA[$F{tax_amount}]]></variableExpression>
 
60
        </variable>
 
61
        <variable name="base_amount_1" class="java.math.BigDecimal" resetType="Group" resetGroup="quarter" calculation="Sum">
 
62
                <variableExpression><![CDATA[$F{base_amount}]]></variableExpression>
 
63
        </variable>
 
64
        <variable name="amount_total_1" class="java.math.BigDecimal" resetType="Group" resetGroup="quarter" calculation="Sum">
 
65
                <variableExpression><![CDATA[$F{amount_total}]]></variableExpression>
 
66
        </variable>
 
67
        <variable name="L" class="java.util.Locale">
 
68
                <variableExpression><![CDATA[$P{REPORT_LOCALE}]]></variableExpression>
 
69
                <initialValueExpression><![CDATA[$P{REPORT_LOCALE}]]></initialValueExpression>
 
70
        </variable>
 
71
        <filterExpression><![CDATA[$F{tax_name}.indexOf("IRPF")]]></filterExpression>
 
72
        <group name="quarter" isStartNewPage="true">
 
73
                <groupExpression><![CDATA[$F{period}]]></groupExpression>
 
74
                <groupHeader>
 
75
                        <band height="16">
 
76
                                <textField>
 
77
                                        <reportElement x="83" y="0" width="134" height="16"/>
 
78
                                        <textElement verticalAlignment="Middle">
 
79
                                                <font size="8" isBold="true"/>
 
80
                                        </textElement>
 
81
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{period}]]></textFieldExpression>
 
82
                                </textField>
 
83
                        </band>
 
84
                </groupHeader>
 
85
                <groupFooter>
 
86
                        <band height="19">
 
87
                                <textField pattern="#,##0.00;-#,##0.00">
 
88
                                        <reportElement x="498" y="3" width="61" height="15"/>
 
89
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
90
                                                <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
91
                                        </textElement>
 
92
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{base_amount_1}]]></textFieldExpression>
 
93
                                </textField>
 
94
                                <textField>
 
95
                                        <reportElement x="409" y="3" width="74" height="16"/>
 
96
                                        <textElement verticalAlignment="Middle">
 
97
                                                <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
98
                                        </textElement>
 
99
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Period Total")]]></textFieldExpression>
 
100
                                </textField>
 
101
                                <textField pattern="#,##0.00;-#,##0.00">
 
102
                                        <reportElement x="624" y="2" width="76" height="16"/>
 
103
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
104
                                                <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
105
                                        </textElement>
 
106
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tax_amount_1}]]></textFieldExpression>
 
107
                                </textField>
 
108
                                <textField pattern="#,##0.00;-#,##0.00">
 
109
                                        <reportElement x="708" y="2" width="76" height="16"/>
 
110
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
111
                                                <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
112
                                        </textElement>
 
113
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{amount_total_1}]]></textFieldExpression>
 
114
                                </textField>
 
115
                        </band>
 
116
                </groupFooter>
 
117
        </group>
 
118
        <group name="number">
 
119
                <groupExpression><![CDATA[$F{number}]]></groupExpression>
 
120
                <groupHeader>
 
121
                        <band/>
 
122
                </groupHeader>
 
123
                <groupFooter>
 
124
                        <band/>
 
125
                </groupFooter>
 
126
        </group>
 
127
        <background>
 
128
                <band/>
 
129
        </background>
 
130
        <title>
 
131
                <band height="63">
 
132
                        <subreport>
 
133
                                <reportElement x="0" y="0" width="802" height="63"/>
 
134
                                <subreportParameter name="SUBTITLE">
 
135
                                        <subreportParameterExpression><![CDATA[$P{SUBTITLE}]]></subreportParameterExpression>
 
136
                                </subreportParameter>
 
137
                                <subreportParameter name="DOCUMENT">
 
138
                                        <subreportParameterExpression><![CDATA[tr($V{L},"Taxes by Invoice")]]></subreportParameterExpression>
 
139
                                </subreportParameter>
 
140
                                <subreportParameter name="LANG">
 
141
                                        <subreportParameterExpression><![CDATA[$V{L}.toString()]]></subreportParameterExpression>
 
142
                                </subreportParameter>
 
143
                                <dataSourceExpression><![CDATA[$P{HEADER_DS}]]></dataSourceExpression>
 
144
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "portrait_header.jasper"]]></subreportExpression>
 
145
                        </subreport>
 
146
                </band>
 
147
        </title>
 
148
        <pageHeader>
 
149
                <band height="26">
 
150
                        <textField>
 
151
                                <reportElement x="437" y="13" width="49" height="12"/>
 
152
                                <textElement verticalAlignment="Middle">
 
153
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
154
                                </textElement>
 
155
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Date")]]></textFieldExpression>
 
156
                        </textField>
 
157
                        <textField>
 
158
                                <reportElement x="623" y="13" width="77" height="12"/>
 
159
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
160
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
161
                                </textElement>
 
162
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Tax")]]></textFieldExpression>
 
163
                        </textField>
 
164
                        <textField>
 
165
                                <reportElement x="708" y="13" width="76" height="12"/>
 
166
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
167
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
168
                                </textElement>
 
169
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Invoice Total")]]></textFieldExpression>
 
170
                        </textField>
 
171
                        <textField>
 
172
                                <reportElement x="498" y="13" width="61" height="12"/>
 
173
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
174
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
175
                                </textElement>
 
176
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Base")]]></textFieldExpression>
 
177
                        </textField>
 
178
                        <textField>
 
179
                                <reportElement x="384" y="13" width="53" height="12"/>
 
180
                                <textElement verticalAlignment="Middle">
 
181
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
182
                                </textElement>
 
183
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Invoice")]]></textFieldExpression>
 
184
                        </textField>
 
185
                        <textField>
 
186
                                <reportElement x="83" y="13" width="144" height="12"/>
 
187
                                <textElement verticalAlignment="Middle">
 
188
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
189
                                </textElement>
 
190
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Account")]]></textFieldExpression>
 
191
                        </textField>
 
192
                        <textField>
 
193
                                <reportElement x="310" y="13" width="53" height="12"/>
 
194
                                <textElement verticalAlignment="Middle">
 
195
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
196
                                </textElement>
 
197
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"VAT")]]></textFieldExpression>
 
198
                        </textField>
 
199
                </band>
 
200
        </pageHeader>
 
201
        <columnHeader>
 
202
                <band/>
 
203
        </columnHeader>
 
204
        <detail>
 
205
                <band height="15">
 
206
                        <textField isBlankWhenNull="true">
 
207
                                <reportElement x="62" y="1" width="56" height="12">
 
208
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
209
                                </reportElement>
 
210
                                <textElement verticalAlignment="Middle">
 
211
                                        <font size="8"/>
 
212
                                </textElement>
 
213
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{account_code}]]></textFieldExpression>
 
214
                        </textField>
 
215
                        <textField isBlankWhenNull="true">
 
216
                                <reportElement x="119" y="1" width="175" height="12">
 
217
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
218
                                </reportElement>
 
219
                                <textElement verticalAlignment="Middle">
 
220
                                        <font size="8"/>
 
221
                                </textElement>
 
222
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{account_name}]]></textFieldExpression>
 
223
                        </textField>
 
224
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
225
                                <reportElement x="498" y="2" width="61" height="12"/>
 
226
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
227
                                        <font size="8"/>
 
228
                                </textElement>
 
229
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{base_amount}]]></textFieldExpression>
 
230
                        </textField>
 
231
                        <textField isBlankWhenNull="true">
 
232
                                <reportElement x="579" y="1" width="44" height="12"/>
 
233
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
234
                                        <font size="8"/>
 
235
                                </textElement>
 
236
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{tax_name}]]></textFieldExpression>
 
237
                        </textField>
 
238
                        <textField isBlankWhenNull="true">
 
239
                                <reportElement x="384" y="1" width="53" height="12">
 
240
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
241
                                </reportElement>
 
242
                                <textElement verticalAlignment="Middle">
 
243
                                        <font size="8"/>
 
244
                                </textElement>
 
245
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{number}]]></textFieldExpression>
 
246
                        </textField>
 
247
                        <textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
 
248
                                <reportElement x="437" y="1" width="49" height="12">
 
249
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
250
                                </reportElement>
 
251
                                <textElement verticalAlignment="Middle">
 
252
                                        <font size="8"/>
 
253
                                </textElement>
 
254
                                <textFieldExpression class="java.util.Date"><![CDATA[$F{date_invoice}]]></textFieldExpression>
 
255
                        </textField>
 
256
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
257
                                <reportElement x="708" y="1" width="76" height="12">
 
258
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
259
                                </reportElement>
 
260
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
261
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
262
                                </textElement>
 
263
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{amount_total}]]></textFieldExpression>
 
264
                        </textField>
 
265
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
266
                                <reportElement x="624" y="1" width="76" height="12"/>
 
267
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
268
                                        <font size="8"/>
 
269
                                </textElement>
 
270
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{tax_amount}]]></textFieldExpression>
 
271
                        </textField>
 
272
                        <textField isBlankWhenNull="true">
 
273
                                <reportElement x="310" y="1" width="53" height="12">
 
274
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
275
                                </reportElement>
 
276
                                <textElement verticalAlignment="Middle">
 
277
                                        <font size="8"/>
 
278
                                </textElement>
 
279
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{partner_vat}]]></textFieldExpression>
 
280
                        </textField>
 
281
                </band>
 
282
        </detail>
 
283
        <columnFooter>
 
284
                <band/>
 
285
        </columnFooter>
 
286
        <pageFooter>
 
287
                <band height="12">
 
288
                        <textField>
 
289
                                <reportElement x="384" y="0" width="31" height="10"/>
 
290
                                <textElement textAlignment="Right">
 
291
                                        <font size="8"/>
 
292
                                </textElement>
 
293
                                <textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}+" /"]]></textFieldExpression>
 
294
                        </textField>
 
295
                        <textField evaluationTime="Report">
 
296
                                <reportElement x="415" y="0" width="40" height="10"/>
 
297
                                <textElement>
 
298
                                        <font size="8"/>
 
299
                                </textElement>
 
300
                                <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
 
301
                        </textField>
 
302
                </band>
 
303
        </pageFooter>
 
304
        <summary>
 
305
                <band height="21">
 
306
                        <textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
 
307
                                <reportElement x="498" y="4" width="61" height="12"/>
 
308
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
309
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
310
                                </textElement>
 
311
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_base}]]></textFieldExpression>
 
312
                        </textField>
 
313
                        <textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
 
314
                                <reportElement x="624" y="4" width="76" height="12"/>
 
315
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
316
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
317
                                </textElement>
 
318
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_tax}]]></textFieldExpression>
 
319
                        </textField>
 
320
                        <textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
 
321
                                <reportElement x="708" y="4" width="76" height="12">
 
322
                                        <printWhenExpression><![CDATA[$V{number_COUNT} == 1]]></printWhenExpression>
 
323
                                </reportElement>
 
324
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
325
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
326
                                </textElement>
 
327
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total}]]></textFieldExpression>
 
328
                        </textField>
 
329
                        <textField>
 
330
                                <reportElement x="409" y="3" width="74" height="16"/>
 
331
                                <textElement verticalAlignment="Middle">
 
332
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
333
                                </textElement>
 
334
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Year Total")]]></textFieldExpression>
 
335
                        </textField>
 
336
                </band>
 
337
        </summary>
 
338
</jasperReport>