← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/production_statistical_control.jrxml

  • Committer: root
  • Date: 2012-02-16 23:12:06 UTC
  • Revision ID: root@minerales-20120216231206-xgfkdzoz7ukblpuy
se agregao los jaspers a ignore list

Show diffs side-by-side

added added

removed removed

Lines of Context:
jasper_reports/custom_reports/production_statistical_control.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="capture" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
 
3
        <property name="ireport.zoom" value="1.331000000000016"/>
 
4
        <property name="ireport.x" value="0"/>
 
5
        <property name="ireport.y" value="0"/>
 
6
        <style name="encabezado" mode="Opaque" forecolor="#FEFEFE" backcolor="#010101" fill="Solid">
 
7
                <pen lineWidth="0.25" lineColor="#F3D0D0"/>
 
8
                <box>
 
9
                        <pen lineWidth="0.25"/>
 
10
                        <topPen lineWidth="0.25" lineColor="#FDBEBE"/>
 
11
                        <leftPen lineWidth="0.25" lineColor="#FDBEBE"/>
 
12
                        <bottomPen lineWidth="0.25" lineColor="#FDBEBE"/>
 
13
                        <rightPen lineWidth="0.25" lineColor="#FDBEBE"/>
 
14
                </box>
 
15
        </style>
 
16
        <parameter name="plant_id" class="java.lang.Integer"/>
 
17
        <parameter name="date_capture" class="java.lang.String"/>
 
18
        <parameter name="plant_name" class="java.lang.String"/>
 
19
        <queryString>
 
20
                <![CDATA[SELECT *
 
21
FROM get_production_statistical_capture($P{plant_id}, $P{date_capture}) AS
 
22
    (
 
23
    state_id integer,
 
24
    state_date date,
 
25
    turn_id integer,
 
26
    plant_name varchar,
 
27
    supervisor_name varchar,
 
28
    abertura numeric,
 
29
    cono numeric,
 
30
    date_capture date,
 
31
    time_capture time,
 
32
    humedad numeric,
 
33
    mallas numeric,
 
34
    mt numeric,
 
35
    tn numeric,
 
36
    tn_turno numeric);]]>
 
37
        </queryString>
 
38
        <field name="state_id" class="java.lang.Integer"/>
 
39
        <field name="state_date" class="java.sql.Date"/>
 
40
        <field name="turn_id" class="java.lang.Integer"/>
 
41
        <field name="plant_name" class="java.lang.String"/>
 
42
        <field name="supervisor_name" class="java.lang.String"/>
 
43
        <field name="abertura" class="java.math.BigDecimal"/>
 
44
        <field name="cono" class="java.math.BigDecimal"/>
 
45
        <field name="date_capture" class="java.sql.Date"/>
 
46
        <field name="time_capture" class="java.sql.Time"/>
 
47
        <field name="humedad" class="java.math.BigDecimal"/>
 
48
        <field name="mallas" class="java.math.BigDecimal"/>
 
49
        <field name="mt" class="java.math.BigDecimal"/>
 
50
        <field name="tn" class="java.math.BigDecimal"/>
 
51
        <field name="tn_turno" class="java.math.BigDecimal"/>
 
52
        <variable name="state_id" class="java.math.BigDecimal">
 
53
                <variableExpression><![CDATA[$F{state_id}]]></variableExpression>
 
54
        </variable>
 
55
        <variable name="tn_1" class="java.math.BigDecimal" resetType="Group" resetGroup="turn_id" calculation="Sum">
 
56
                <variableExpression><![CDATA[$F{tn}]]></variableExpression>
 
57
        </variable>
 
58
        <variable name="time_capture_1" class="java.lang.Integer" resetType="Group" resetGroup="turn_id" calculation="Count">
 
59
                <variableExpression><![CDATA[$F{time_capture}]]></variableExpression>
 
60
        </variable>
 
61
        <variable name="tn_hr" class="java.math.BigDecimal">
 
62
                <variableExpression><![CDATA[$V{tn_1}.doubleValue() / $V{time_capture_1}.doubleValue()]]></variableExpression>
 
63
        </variable>
 
64
        <group name="turn_id" isStartNewPage="true">
 
65
                <groupExpression><![CDATA[$F{turn_id}]]></groupExpression>
 
66
                <groupHeader>
 
67
                        <band height="62">
 
68
                                <frame>
 
69
                                        <reportElement x="0" y="37" width="752" height="25"/>
 
70
                                        <staticText>
 
71
                                                <reportElement style="encabezado" x="164" y="0" width="200" height="12"/>
 
72
                                                <box>
 
73
                                                        <pen lineWidth="0.25"/>
 
74
                                                        <topPen lineWidth="0.25"/>
 
75
                                                        <leftPen lineWidth="0.25"/>
 
76
                                                        <bottomPen lineWidth="0.25"/>
 
77
                                                        <rightPen lineWidth="0.25"/>
 
78
                                                </box>
 
79
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
80
                                                        <font size="8"/>
 
81
                                                </textElement>
 
82
                                                <text><![CDATA[Avance]]></text>
 
83
                                        </staticText>
 
84
                                        <staticText>
 
85
                                                <reportElement style="encabezado" x="132" y="0" width="32" height="25"/>
 
86
                                                <box>
 
87
                                                        <pen lineWidth="0.25"/>
 
88
                                                        <topPen lineWidth="0.25"/>
 
89
                                                        <leftPen lineWidth="0.25"/>
 
90
                                                        <bottomPen lineWidth="0.25"/>
 
91
                                                        <rightPen lineWidth="0.25"/>
 
92
                                                </box>
 
93
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
94
                                                        <font size="8"/>
 
95
                                                </textElement>
 
96
                                                <text><![CDATA[Cono]]></text>
 
97
                                        </staticText>
 
98
                                        <staticText>
 
99
                                                <reportElement style="encabezado" x="164" y="12" width="100" height="13"/>
 
100
                                                <box>
 
101
                                                        <pen lineWidth="0.25"/>
 
102
                                                        <topPen lineWidth="0.25"/>
 
103
                                                        <leftPen lineWidth="0.25"/>
 
104
                                                        <bottomPen lineWidth="0.25"/>
 
105
                                                        <rightPen lineWidth="0.25"/>
 
106
                                                </box>
 
107
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
108
                                                        <font size="8"/>
 
109
                                                </textElement>
 
110
                                                <text><![CDATA[MT]]></text>
 
111
                                        </staticText>
 
112
                                        <staticText>
 
113
                                                <reportElement style="encabezado" x="264" y="12" width="100" height="13"/>
 
114
                                                <box>
 
115
                                                        <pen lineWidth="0.25"/>
 
116
                                                        <topPen lineWidth="0.25"/>
 
117
                                                        <leftPen lineWidth="0.25"/>
 
118
                                                        <bottomPen lineWidth="0.25"/>
 
119
                                                        <rightPen lineWidth="0.25"/>
 
120
                                                </box>
 
121
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
122
                                                        <font size="8"/>
 
123
                                                </textElement>
 
124
                                                <text><![CDATA[TN]]></text>
 
125
                                        </staticText>
 
126
                                        <staticText>
 
127
                                                <reportElement style="encabezado" x="364" y="0" width="100" height="25"/>
 
128
                                                <box>
 
129
                                                        <pen lineWidth="0.25"/>
 
130
                                                        <topPen lineWidth="0.25"/>
 
131
                                                        <leftPen lineWidth="0.25"/>
 
132
                                                        <bottomPen lineWidth="0.25"/>
 
133
                                                        <rightPen lineWidth="0.25"/>
 
134
                                                </box>
 
135
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
136
                                                        <font size="8"/>
 
137
                                                </textElement>
 
138
                                                <text><![CDATA[Alimentación pulgadas]]></text>
 
139
                                        </staticText>
 
140
                                        <staticText>
 
141
                                                <reportElement style="encabezado" x="0" y="0" width="132" height="25"/>
 
142
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
143
                                                        <font size="8"/>
 
144
                                                </textElement>
 
145
                                                <text><![CDATA[Tiempo]]></text>
 
146
                                        </staticText>
 
147
                                </frame>
 
148
                                <frame>
 
149
                                        <reportElement x="0" y="0" width="752" height="37"/>
 
150
                                        <staticText>
 
151
                                                <reportElement x="508" y="0" width="100" height="12"/>
 
152
                                                <box>
 
153
                                                        <topPen lineWidth="0.25"/>
 
154
                                                        <leftPen lineWidth="0.25"/>
 
155
                                                        <bottomPen lineWidth="0.25"/>
 
156
                                                        <rightPen lineWidth="0.25"/>
 
157
                                                </box>
 
158
                                                <textElement verticalAlignment="Middle">
 
159
                                                        <font size="8"/>
 
160
                                                </textElement>
 
161
                                                <text><![CDATA[   Supervisor]]></text>
 
162
                                        </staticText>
 
163
                                        <staticText>
 
164
                                                <reportElement x="508" y="12" width="100" height="12"/>
 
165
                                                <box>
 
166
                                                        <topPen lineWidth="0.25"/>
 
167
                                                        <leftPen lineWidth="0.25"/>
 
168
                                                        <bottomPen lineWidth="0.25"/>
 
169
                                                        <rightPen lineWidth="0.25"/>
 
170
                                                </box>
 
171
                                                <textElement verticalAlignment="Middle">
 
172
                                                        <font size="8"/>
 
173
                                                </textElement>
 
174
                                                <text><![CDATA[   Turno]]></text>
 
175
                                        </staticText>
 
176
                                        <staticText>
 
177
                                                <reportElement x="508" y="24" width="100" height="13"/>
 
178
                                                <box>
 
179
                                                        <topPen lineWidth="0.25"/>
 
180
                                                        <leftPen lineWidth="0.25"/>
 
181
                                                        <bottomPen lineWidth="0.25"/>
 
182
                                                        <rightPen lineWidth="0.25"/>
 
183
                                                </box>
 
184
                                                <textElement verticalAlignment="Middle">
 
185
                                                        <font size="8"/>
 
186
                                                </textElement>
 
187
                                                <text><![CDATA[   Fecha]]></text>
 
188
                                        </staticText>
 
189
                                        <textField>
 
190
                                                <reportElement x="608" y="0" width="144" height="12"/>
 
191
                                                <box>
 
192
                                                        <pen lineWidth="0.25"/>
 
193
                                                        <topPen lineWidth="0.25"/>
 
194
                                                        <leftPen lineWidth="0.25"/>
 
195
                                                        <bottomPen lineWidth="0.25"/>
 
196
                                                        <rightPen lineWidth="0.25"/>
 
197
                                                </box>
 
198
                                                <textElement verticalAlignment="Middle">
 
199
                                                        <font size="8"/>
 
200
                                                </textElement>
 
201
                                                <textFieldExpression class="java.lang.String"><![CDATA[$F{supervisor_name}]]></textFieldExpression>
 
202
                                        </textField>
 
203
                                        <textField>
 
204
                                                <reportElement x="608" y="12" width="144" height="12"/>
 
205
                                                <box>
 
206
                                                        <pen lineWidth="0.25"/>
 
207
                                                        <topPen lineWidth="0.25"/>
 
208
                                                        <leftPen lineWidth="0.25"/>
 
209
                                                        <bottomPen lineWidth="0.25"/>
 
210
                                                        <rightPen lineWidth="0.25"/>
 
211
                                                </box>
 
212
                                                <textElement verticalAlignment="Middle">
 
213
                                                        <font size="8"/>
 
214
                                                </textElement>
 
215
                                                <textFieldExpression class="java.lang.Integer"><![CDATA[$F{turn_id}]]></textFieldExpression>
 
216
                                        </textField>
 
217
                                        <textField pattern="dd/MM/yyyy">
 
218
                                                <reportElement x="608" y="24" width="144" height="13"/>
 
219
                                                <box>
 
220
                                                        <pen lineWidth="0.25"/>
 
221
                                                        <topPen lineWidth="0.25"/>
 
222
                                                        <leftPen lineWidth="0.25"/>
 
223
                                                        <bottomPen lineWidth="0.25"/>
 
224
                                                        <rightPen lineWidth="0.25"/>
 
225
                                                </box>
 
226
                                                <textElement verticalAlignment="Middle">
 
227
                                                        <font size="8"/>
 
228
                                                </textElement>
 
229
                                                <textFieldExpression class="java.util.Date"><![CDATA[$F{state_date}]]></textFieldExpression>
 
230
                                        </textField>
 
231
                                        <staticText>
 
232
                                                <reportElement x="0" y="24" width="508" height="13"/>
 
233
                                                <textElement/>
 
234
                                                <text><![CDATA[ ]]></text>
 
235
                                        </staticText>
 
236
                                        <textField>
 
237
                                                <reportElement x="0" y="0" width="508" height="24"/>
 
238
                                                <textElement verticalAlignment="Middle">
 
239
                                                        <font isBold="true"/>
 
240
                                                </textElement>
 
241
                                                <textFieldExpression class="java.lang.String"><![CDATA["          " + $P{plant_name}]]></textFieldExpression>
 
242
                                        </textField>
 
243
                                </frame>
 
244
                        </band>
 
245
                </groupHeader>
 
246
                <groupFooter>
 
247
                        <band height="288">
 
248
                                <frame>
 
249
                                        <reportElement x="0" y="0" width="752" height="288"/>
 
250
                                        <lineChart>
 
251
                                                <chart evaluationTime="Group" evaluationGroup="turn_id" theme="default">
 
252
                                                        <reportElement x="0" y="45" width="752" height="243" printWhenGroupChanges="turn_id"/>
 
253
                                                        <chartTitle>
 
254
                                                                <font size="8"/>
 
255
                                                        </chartTitle>
 
256
                                                        <chartSubtitle>
 
257
                                                                <font size="8"/>
 
258
                                                        </chartSubtitle>
 
259
                                                        <chartLegend>
 
260
                                                                <font size="10"/>
 
261
                                                        </chartLegend>
 
262
                                                </chart>
 
263
                                                <categoryDataset>
 
264
                                                        <dataset resetType="Group" resetGroup="turn_id"/>
 
265
                                                        <categorySeries>
 
266
                                                                <seriesExpression><![CDATA["Cono"]]></seriesExpression>
 
267
                                                                <categoryExpression><![CDATA[$F{time_capture}.toString()]]></categoryExpression>
 
268
                                                                <valueExpression><![CDATA[$F{mt}]]></valueExpression>
 
269
                                                                <labelExpression><![CDATA["cono"]]></labelExpression>
 
270
                                                        </categorySeries>
 
271
                                                        <categorySeries>
 
272
                                                                <seriesExpression><![CDATA["tn"]]></seriesExpression>
 
273
                                                                <categoryExpression><![CDATA[$F{time_capture}.toString()]]></categoryExpression>
 
274
                                                                <valueExpression><![CDATA[$F{tn}]]></valueExpression>
 
275
                                                                <labelExpression><![CDATA["tn"]]></labelExpression>
 
276
                                                        </categorySeries>
 
277
                                                </categoryDataset>
 
278
                                                <linePlot>
 
279
                                                        <plot/>
 
280
                                                        <categoryAxisFormat>
 
281
                                                                <axisFormat>
 
282
                                                                        <labelFont/>
 
283
                                                                        <tickLabelFont/>
 
284
                                                                </axisFormat>
 
285
                                                        </categoryAxisFormat>
 
286
                                                        <valueAxisFormat>
 
287
                                                                <axisFormat>
 
288
                                                                        <labelFont/>
 
289
                                                                        <tickLabelFont/>
 
290
                                                                </axisFormat>
 
291
                                                        </valueAxisFormat>
 
292
                                                </linePlot>
 
293
                                        </lineChart>
 
294
                                        <frame>
 
295
                                                <reportElement x="0" y="0" width="752" height="45"/>
 
296
                                                <staticText>
 
297
                                                        <reportElement x="60" y="0" width="404" height="20"/>
 
298
                                                        <box>
 
299
                                                                <topPen lineWidth="0.25"/>
 
300
                                                        </box>
 
301
                                                        <textElement verticalAlignment="Middle">
 
302
                                                                <font size="8"/>
 
303
                                                        </textElement>
 
304
                                                        <text><![CDATA[Hr. de operación.]]></text>
 
305
                                                </staticText>
 
306
                                                <staticText>
 
307
                                                        <reportElement x="464" y="0" width="288" height="20"/>
 
308
                                                        <textElement/>
 
309
                                                        <text><![CDATA[ ]]></text>
 
310
                                                </staticText>
 
311
                                                <staticText>
 
312
                                                        <reportElement x="0" y="20" width="164" height="25"/>
 
313
                                                        <textElement/>
 
314
                                                        <text><![CDATA[ ]]></text>
 
315
                                                </staticText>
 
316
                                                <staticText>
 
317
                                                        <reportElement x="164" y="20" width="100" height="25"/>
 
318
                                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
319
                                                                <font size="8"/>
 
320
                                                        </textElement>
 
321
                                                        <text><![CDATA[tn / Turno]]></text>
 
322
                                                </staticText>
 
323
                                                <staticText>
 
324
                                                        <reportElement x="364" y="20" width="100" height="25"/>
 
325
                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
326
                                                                <font size="8"/>
 
327
                                                        </textElement>
 
328
                                                        <text><![CDATA[Tn / Hr.]]></text>
 
329
                                                </staticText>
 
330
                                                <textField>
 
331
                                                        <reportElement x="264" y="20" width="100" height="25"/>
 
332
                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
333
                                                                <font size="8"/>
 
334
                                                        </textElement>
 
335
                                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tn_1}]]></textFieldExpression>
 
336
                                                </textField>
 
337
                                                <textField>
 
338
                                                        <reportElement x="0" y="0" width="60" height="20"/>
 
339
                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
340
                                                                <font size="8"/>
 
341
                                                        </textElement>
 
342
                                                        <textFieldExpression class="java.lang.Integer"><![CDATA[$V{time_capture_1}]]></textFieldExpression>
 
343
                                                </textField>
 
344
                                                <textField pattern="#,##0.00">
 
345
                                                        <reportElement x="464" y="20" width="288" height="25"/>
 
346
                                                        <textElement verticalAlignment="Middle">
 
347
                                                                <font size="8"/>
 
348
                                                        </textElement>
 
349
                                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tn_hr}]]></textFieldExpression>
 
350
                                                </textField>
 
351
                                        </frame>
 
352
                                </frame>
 
353
                        </band>
 
354
                </groupFooter>
 
355
        </group>
 
356
        <background>
 
357
                <band splitType="Stretch"/>
 
358
        </background>
 
359
        <title>
 
360
                <band splitType="Stretch"/>
 
361
        </title>
 
362
        <pageHeader>
 
363
                <band splitType="Stretch"/>
 
364
        </pageHeader>
 
365
        <columnHeader>
 
366
                <band height="33" splitType="Stretch">
 
367
                        <frame>
 
368
                                <reportElement x="0" y="0" width="752" height="33"/>
 
369
                                <staticText>
 
370
                                        <reportElement key="staticText-5" x="0" y="0" width="752" height="33"/>
 
371
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
372
                                                <font fontName="SansSerif" size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
 
373
                                        </textElement>
 
374
                                        <text><![CDATA[Gráfico de seguimiento de producción y avance de silo]]></text>
 
375
                                </staticText>
 
376
                        </frame>
 
377
                </band>
 
378
        </columnHeader>
 
379
        <detail>
 
380
                <band height="12" splitType="Stretch">
 
381
                        <frame>
 
382
                                <reportElement x="0" y="0" width="752" height="12"/>
 
383
                                <textField pattern="h.mm.ss a">
 
384
                                        <reportElement x="60" y="0" width="72" height="12"/>
 
385
                                        <box>
 
386
                                                <topPen lineWidth="0.25"/>
 
387
                                                <bottomPen lineWidth="0.25"/>
 
388
                                                <rightPen lineWidth="0.25"/>
 
389
                                        </box>
 
390
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
391
                                                <font size="8"/>
 
392
                                        </textElement>
 
393
                                        <textFieldExpression class="java.sql.Time"><![CDATA[$F{time_capture}]]></textFieldExpression>
 
394
                                </textField>
 
395
                                <textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
 
396
                                        <reportElement x="0" y="0" width="60" height="12"/>
 
397
                                        <box>
 
398
                                                <topPen lineWidth="0.25"/>
 
399
                                                <leftPen lineWidth="0.25"/>
 
400
                                                <bottomPen lineWidth="0.25"/>
 
401
                                        </box>
 
402
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
403
                                                <font size="8"/>
 
404
                                        </textElement>
 
405
                                        <textFieldExpression class="java.util.Date"><![CDATA[$F{date_capture}]]></textFieldExpression>
 
406
                                </textField>
 
407
                                <textField>
 
408
                                        <reportElement x="132" y="0" width="32" height="12"/>
 
409
                                        <box>
 
410
                                                <pen lineWidth="0.25"/>
 
411
                                                <topPen lineWidth="0.25"/>
 
412
                                                <leftPen lineWidth="0.25"/>
 
413
                                                <bottomPen lineWidth="0.25"/>
 
414
                                                <rightPen lineWidth="0.25"/>
 
415
                                        </box>
 
416
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
417
                                                <font size="8"/>
 
418
                                        </textElement>
 
419
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{mt}]]></textFieldExpression>
 
420
                                </textField>
 
421
                                <textField>
 
422
                                        <reportElement x="364" y="0" width="100" height="12"/>
 
423
                                        <box>
 
424
                                                <pen lineWidth="0.25"/>
 
425
                                                <topPen lineWidth="0.25"/>
 
426
                                                <leftPen lineWidth="0.25"/>
 
427
                                                <bottomPen lineWidth="0.25"/>
 
428
                                                <rightPen lineWidth="0.25"/>
 
429
                                        </box>
 
430
                                        <textElement textAlignment="Center">
 
431
                                                <font size="8"/>
 
432
                                        </textElement>
 
433
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{abertura}]]></textFieldExpression>
 
434
                                </textField>
 
435
                                <textField>
 
436
                                        <reportElement x="164" y="0" width="100" height="12"/>
 
437
                                        <box>
 
438
                                                <pen lineWidth="0.25"/>
 
439
                                                <topPen lineWidth="0.25"/>
 
440
                                                <leftPen lineWidth="0.25"/>
 
441
                                                <bottomPen lineWidth="0.25"/>
 
442
                                                <rightPen lineWidth="0.25"/>
 
443
                                        </box>
 
444
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
445
                                                <font size="8"/>
 
446
                                        </textElement>
 
447
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{mt}]]></textFieldExpression>
 
448
                                </textField>
 
449
                                <textField>
 
450
                                        <reportElement x="264" y="0" width="100" height="12"/>
 
451
                                        <box>
 
452
                                                <pen lineWidth="0.25"/>
 
453
                                                <topPen lineWidth="0.25"/>
 
454
                                                <leftPen lineWidth="0.25"/>
 
455
                                                <bottomPen lineWidth="0.25"/>
 
456
                                                <rightPen lineWidth="0.25"/>
 
457
                                        </box>
 
458
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
459
                                                <font size="8"/>
 
460
                                        </textElement>
 
461
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{tn}]]></textFieldExpression>
 
462
                                </textField>
 
463
                        </frame>
 
464
                </band>
 
465
        </detail>
 
466
        <columnFooter>
 
467
                <band splitType="Stretch"/>
 
468
        </columnFooter>
 
469
        <pageFooter>
 
470
                <band splitType="Stretch"/>
 
471
        </pageFooter>
 
472
        <summary>
 
473
                <band splitType="Stretch"/>
 
474
        </summary>
 
475
</jasperReport>