← 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/trial_balance.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/trial_balance.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" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
 
3
        <property name="ireport.zoom" value="3.4522712143931042"/>
 
4
        <property name="ireport.x" value="559"/>
 
5
        <property name="ireport.y" value="303"/>
 
6
        <subDataset name="dataset1"/>
 
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="code" class="java.lang.String">
 
15
                <fieldDescription><![CDATA[code]]></fieldDescription>
 
16
        </field>
 
17
        <field name="name" class="java.lang.String">
 
18
                <fieldDescription><![CDATA[name]]></fieldDescription>
 
19
        </field>
 
20
        <field name="period_credit" class="java.math.BigDecimal">
 
21
                <fieldDescription><![CDATA[period_credit]]></fieldDescription>
 
22
        </field>
 
23
        <field name="period_debit" class="java.math.BigDecimal">
 
24
                <fieldDescription><![CDATA[period_debit]]></fieldDescription>
 
25
        </field>
 
26
        <field name="period_balance" class="java.math.BigDecimal">
 
27
                <fieldDescription><![CDATA[period_balance]]></fieldDescription>
 
28
        </field>
 
29
        <field name="credit" class="java.math.BigDecimal">
 
30
                <fieldDescription><![CDATA[credit]]></fieldDescription>
 
31
        </field>
 
32
        <field name="debit" class="java.math.BigDecimal">
 
33
                <fieldDescription><![CDATA[debit]]></fieldDescription>
 
34
        </field>
 
35
        <field name="balance" class="java.math.BigDecimal">
 
36
                <fieldDescription><![CDATA[balance]]></fieldDescription>
 
37
        </field>
 
38
        <variable name="total_debit" class="java.math.BigDecimal" calculation="Sum">
 
39
                <variableExpression><![CDATA[$F{debit}]]></variableExpression>
 
40
        </variable>
 
41
        <variable name="total_credit" class="java.math.BigDecimal" calculation="Sum">
 
42
                <variableExpression><![CDATA[$F{credit}]]></variableExpression>
 
43
        </variable>
 
44
        <variable name="total_balance" class="java.math.BigDecimal" calculation="Sum">
 
45
                <variableExpression><![CDATA[$F{balance}]]></variableExpression>
 
46
        </variable>
 
47
        <variable name="total_period_debit" class="java.math.BigDecimal" calculation="Sum">
 
48
                <variableExpression><![CDATA[$F{period_debit}]]></variableExpression>
 
49
        </variable>
 
50
        <variable name="total_period_credit" class="java.math.BigDecimal" calculation="Sum">
 
51
                <variableExpression><![CDATA[$F{period_credit}]]></variableExpression>
 
52
        </variable>
 
53
        <variable name="total_period_balance" class="java.math.BigDecimal" calculation="Sum">
 
54
                <variableExpression><![CDATA[$F{period_balance}]]></variableExpression>
 
55
        </variable>
 
56
        <variable name="L" class="java.util.Locale">
 
57
                <variableExpression><![CDATA[$P{REPORT_LOCALE}]]></variableExpression>
 
58
                <initialValueExpression><![CDATA[$P{REPORT_LOCALE}]]></initialValueExpression>
 
59
        </variable>
 
60
        <background>
 
61
                <band/>
 
62
        </background>
 
63
        <title>
 
64
                <band height="59">
 
65
                        <subreport>
 
66
                                <reportElement x="0" y="0" width="555" height="59"/>
 
67
                                <subreportParameter name="SUBTITLE">
 
68
                                        <subreportParameterExpression><![CDATA[$P{SUBTITLE}]]></subreportParameterExpression>
 
69
                                </subreportParameter>
 
70
                                <subreportParameter name="DOCUMENT">
 
71
                                        <subreportParameterExpression><![CDATA[tr($V{L},"Trial Balance")]]></subreportParameterExpression>
 
72
                                </subreportParameter>
 
73
                                <subreportParameter name="LANG">
 
74
                                        <subreportParameterExpression><![CDATA[$V{L}.toString()]]></subreportParameterExpression>
 
75
                                </subreportParameter>
 
76
                                <dataSourceExpression><![CDATA[$P{HEADER_DS}]]></dataSourceExpression>
 
77
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "portrait_header.jasper"]]></subreportExpression>
 
78
                        </subreport>
 
79
                </band>
 
80
        </title>
 
81
        <pageHeader>
 
82
                <band/>
 
83
        </pageHeader>
 
84
        <columnHeader>
 
85
                <band height="47">
 
86
                        <textField isBlankWhenNull="true">
 
87
                                <reportElement x="2" y="27" width="60" height="20"/>
 
88
                                <textElement verticalAlignment="Middle">
 
89
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
90
                                </textElement>
 
91
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Account")]]></textFieldExpression>
 
92
                        </textField>
 
93
                        <textField isBlankWhenNull="true">
 
94
                                <reportElement x="62" y="27" width="150" height="20"/>
 
95
                                <textElement verticalAlignment="Middle">
 
96
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
97
                                </textElement>
 
98
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Account Name")]]></textFieldExpression>
 
99
                        </textField>
 
100
                        <textField isBlankWhenNull="true">
 
101
                                <reportElement x="212" y="27" width="56" height="20"/>
 
102
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
103
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
104
                                </textElement>
 
105
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Debit")]]></textFieldExpression>
 
106
                        </textField>
 
107
                        <textField isBlankWhenNull="true">
 
108
                                <reportElement x="268" y="27" width="56" height="20"/>
 
109
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
110
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
111
                                </textElement>
 
112
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Credit")]]></textFieldExpression>
 
113
                        </textField>
 
114
                        <textField isBlankWhenNull="true">
 
115
                                <reportElement x="324" y="27" width="56" height="20"/>
 
116
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
117
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
118
                                </textElement>
 
119
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Balance")]]></textFieldExpression>
 
120
                        </textField>
 
121
                        <textField isBlankWhenNull="true">
 
122
                                <reportElement x="381" y="27" width="57" height="20"/>
 
123
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
124
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
125
                                </textElement>
 
126
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Debit")]]></textFieldExpression>
 
127
                        </textField>
 
128
                        <textField isBlankWhenNull="true">
 
129
                                <reportElement x="439" y="27" width="57" height="20"/>
 
130
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
131
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
132
                                </textElement>
 
133
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Credit")]]></textFieldExpression>
 
134
                        </textField>
 
135
                        <textField isBlankWhenNull="true">
 
136
                                <reportElement x="496" y="27" width="57" height="20"/>
 
137
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
138
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
139
                                </textElement>
 
140
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Balance")]]></textFieldExpression>
 
141
                        </textField>
 
142
                        <textField isBlankWhenNull="true">
 
143
                                <reportElement x="212" y="7" width="168" height="20"/>
 
144
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
145
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
146
                                </textElement>
 
147
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Accumulated Period")]]></textFieldExpression>
 
148
                        </textField>
 
149
                        <textField isBlankWhenNull="true">
 
150
                                <reportElement x="381" y="7" width="172" height="20"/>
 
151
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
152
                                        <font isBold="true" pdfFontName="Helvetica"/>
 
153
                                </textElement>
 
154
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Accumulated Year")]]></textFieldExpression>
 
155
                        </textField>
 
156
                </band>
 
157
        </columnHeader>
 
158
        <detail>
 
159
                <band height="18">
 
160
                        <textField isBlankWhenNull="true">
 
161
                                <reportElement x="2" y="3" width="60" height="12"/>
 
162
                                <textElement verticalAlignment="Middle">
 
163
                                        <font size="8"/>
 
164
                                </textElement>
 
165
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{code}]]></textFieldExpression>
 
166
                        </textField>
 
167
                        <textField isBlankWhenNull="true">
 
168
                                <reportElement x="62" y="3" width="150" height="12"/>
 
169
                                <textElement verticalAlignment="Middle">
 
170
                                        <font size="8"/>
 
171
                                </textElement>
 
172
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression>
 
173
                        </textField>
 
174
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
175
                                <reportElement x="212" y="3" width="56" height="12"/>
 
176
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
177
                                        <font size="8"/>
 
178
                                </textElement>
 
179
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{period_debit}]]></textFieldExpression>
 
180
                        </textField>
 
181
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
182
                                <reportElement x="268" y="3" width="56" height="12"/>
 
183
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
184
                                        <font size="8"/>
 
185
                                </textElement>
 
186
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{period_credit}]]></textFieldExpression>
 
187
                        </textField>
 
188
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
189
                                <reportElement x="324" y="3" width="56" height="12"/>
 
190
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
191
                                        <font size="8"/>
 
192
                                </textElement>
 
193
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{period_balance}]]></textFieldExpression>
 
194
                        </textField>
 
195
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
196
                                <reportElement x="381" y="3" width="57" height="12"/>
 
197
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
198
                                        <font size="8"/>
 
199
                                </textElement>
 
200
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{debit}]]></textFieldExpression>
 
201
                        </textField>
 
202
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
203
                                <reportElement x="439" y="3" width="57" height="12"/>
 
204
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
205
                                        <font size="8"/>
 
206
                                </textElement>
 
207
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{credit}]]></textFieldExpression>
 
208
                        </textField>
 
209
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
210
                                <reportElement x="496" y="3" width="57" height="12"/>
 
211
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
212
                                        <font size="8"/>
 
213
                                </textElement>
 
214
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{balance}]]></textFieldExpression>
 
215
                        </textField>
 
216
                </band>
 
217
        </detail>
 
218
        <columnFooter>
 
219
                <band/>
 
220
        </columnFooter>
 
221
        <pageFooter>
 
222
                <band height="11">
 
223
                        <textField evaluationTime="Report">
 
224
                                <reportElement x="271" y="1" width="40" height="10"/>
 
225
                                <textElement>
 
226
                                        <font size="8"/>
 
227
                                </textElement>
 
228
                                <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
 
229
                        </textField>
 
230
                        <textField>
 
231
                                <reportElement x="240" y="1" width="31" height="10"/>
 
232
                                <textElement textAlignment="Right">
 
233
                                        <font size="8"/>
 
234
                                </textElement>
 
235
                                <textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}+" /"]]></textFieldExpression>
 
236
                        </textField>
 
237
                </band>
 
238
        </pageFooter>
 
239
        <summary>
 
240
                <band height="54">
 
241
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
242
                                <reportElement x="324" y="4" width="56" height="12"/>
 
243
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
244
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
245
                                </textElement>
 
246
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_period_balance}]]></textFieldExpression>
 
247
                        </textField>
 
248
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
249
                                <reportElement x="212" y="4" width="56" height="12"/>
 
250
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
251
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
252
                                </textElement>
 
253
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_period_debit}]]></textFieldExpression>
 
254
                        </textField>
 
255
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
256
                                <reportElement x="268" y="4" width="56" height="12"/>
 
257
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
258
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
259
                                </textElement>
 
260
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_period_credit}]]></textFieldExpression>
 
261
                        </textField>
 
262
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
263
                                <reportElement x="381" y="4" width="57" height="12"/>
 
264
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
265
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
266
                                </textElement>
 
267
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_debit}]]></textFieldExpression>
 
268
                        </textField>
 
269
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
270
                                <reportElement x="496" y="4" width="57" height="12"/>
 
271
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
272
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
273
                                </textElement>
 
274
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_balance}]]></textFieldExpression>
 
275
                        </textField>
 
276
                        <textField pattern="#,##0.00" isBlankWhenNull="true">
 
277
                                <reportElement x="439" y="4" width="57" height="12"/>
 
278
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
279
                                        <font size="8" isBold="true" pdfFontName="Helvetica"/>
 
280
                                </textElement>
 
281
                                <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_credit}]]></textFieldExpression>
 
282
                        </textField>
 
283
                </band>
 
284
        </summary>
 
285
</jasperReport>