← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/xls_sheet1.jrxml

  • Committer: root
  • Date: 2012-02-17 17:29:00 UTC
  • mfrom: (564.1.1 addons_mx)
  • Revision ID: root@minerales-20120217172900-o0tqaj0bnt95lk3w
 cambios en jasper

Show diffs side-by-side

added added

removed removed

Lines of Context:
jasper_reports/custom_reports/xls_sheet1.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="Reporte_produccion_produccion" language="groovy" pageWidth="1008" pageHeight="1008" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="968" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isTitleNewPage="true" isSummaryNewPage="true" isSummaryWithPageHeaderAndFooter="true" isFloatColumnFooter="true" isIgnorePagination="true">
 
3
    <property name="ireport.zoom" value="1.3310000000000035"/>
 
4
    <property name="ireport.x" value="0"/>
 
5
    <property name="ireport.y" value="0"/>
 
6
    <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="Boolean.False"/>
 
7
    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="Boolean.False"/>
 
8
    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="Boolean.False"/>
 
9
    <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="Boolean.False"/>
 
10
    <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="Boolean.False"/>
 
11
    <property name="net.sf.jasperreports.export.xls.sheet.names.sheet1" value="Produccion"/>
 
12
    <style name="celdas_titulo" mode="Opaque" forecolor="#FFFFFF" backcolor="#0B5595" fontSize="8">
 
13
        <pen lineWidth="0.0" lineStyle="Dotted" lineColor="#FEFEFE"/>
 
14
        <box>
 
15
            <pen lineWidth="0.25" lineStyle="Solid" lineColor="#010101"/>
 
16
            <topPen lineWidth="0.25" lineStyle="Solid" lineColor="#010101"/>
 
17
            <leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#010101"/>
 
18
            <bottomPen lineWidth="0.25" lineStyle="Solid" lineColor="#010101"/>
 
19
            <rightPen lineWidth="0.25" lineStyle="Solid" lineColor="#010101"/>
 
20
        </box>
 
21
    </style>
 
22
    <style name="celda_titulo1" style="celdas_titulo" forecolor="#FFFFFF" backcolor="#1D6894">
 
23
        <pen lineWidth="0.25" lineColor="#FEFEFE"/>
 
24
    </style>
 
25
    <style name="celda_contenido_1" style="celdas_titulo" forecolor="#240A0A" backcolor="#CDBDBD">
 
26
        <conditionalStyle>
 
27
            <conditionExpression><![CDATA[$V{REPORT_COUNT}%3 == 0]]></conditionExpression>
 
28
            <style mode="Opaque" forecolor="#000000">
 
29
                <box bottomPadding="0">
 
30
                    <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
31
                    <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
32
                    <bottomPen lineWidth="0.5"/>
 
33
                    <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
34
                </box>
 
35
            </style>
 
36
        </conditionalStyle>
 
37
    </style>
 
38
    <style name="celda_contenido" mode="Opaque" forecolor="#020F20" backcolor="#FFFFFF">
 
39
        <box>
 
40
            <pen lineWidth="0.25" lineStyle="Dotted"/>
 
41
            <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
42
            <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
43
            <bottomPen lineWidth="0.25" lineStyle="Dotted"/>
 
44
            <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
45
        </box>
 
46
        <conditionalStyle>
 
47
            <conditionExpression><![CDATA[$V{REPORT_COUNT}%3 == 0]]></conditionExpression>
 
48
            <style mode="Opaque" forecolor="#000000" backcolor="#FFFFFF" fill="Solid" pattern="">
 
49
                <pen lineWidth="0.75" lineStyle="Dotted"/>
 
50
                <box bottomPadding="0">
 
51
                    <pen lineWidth="0.5"/>
 
52
                    <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
53
                    <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
54
                    <bottomPen lineWidth="0.5"/>
 
55
                    <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
56
                </box>
 
57
            </style>
 
58
        </conditionalStyle>
 
59
    </style>
 
60
    <style name="encabezado_1" mode="Opaque" forecolor="#FFFFFF" backcolor="#0B5595" fill="Solid" pattern="" fontSize="7">
 
61
        <pen lineStyle="Dotted"/>
 
62
        <box>
 
63
            <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
64
            <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
65
            <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
66
        </box>
 
67
    </style>
 
68
    <style name="encabezado_2" mode="Opaque" forecolor="#0B5595" backcolor="#FFFFFF" fill="Solid" fontSize="7">
 
69
        <box>
 
70
            <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
71
            <bottomPen lineWidth="0.25" lineStyle="Dotted"/>
 
72
            <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
73
        </box>
 
74
    </style>
 
75
    <style name="contenido" mode="Opaque" forecolor="#010101" backcolor="#FFFFFF" fill="Solid" pattern="" fontSize="7">
 
76
        <pen lineStyle="Dotted" lineColor="#0B5595"/>
 
77
        <box>
 
78
            <pen lineWidth="0.25" lineStyle="Dotted"/>
 
79
            <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
80
            <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
81
            <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
82
            <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#0B5595"/>
 
83
        </box>
 
84
        <conditionalStyle>
 
85
            <conditionExpression><![CDATA[$V{REPORT_COUNT}%3 == 0]]></conditionExpression>
 
86
            <style mode="Opaque" fill="Solid">
 
87
                <pen lineWidth="0.25" lineColor="#958282"/>
 
88
                <box>
 
89
                    <pen lineWidth="0.25"/>
 
90
                    <topPen lineWidth="0.5" lineStyle="Dotted"/>
 
91
                    <leftPen lineWidth="0.25"/>
 
92
                    <bottomPen lineWidth="0.75" lineStyle="Solid" lineColor="#A03636"/>
 
93
                    <rightPen lineWidth="0.25"/>
 
94
                </box>
 
95
            </style>
 
96
        </conditionalStyle>
 
97
    </style>
 
98
    <style name="total" mode="Opaque" forecolor="#FFFFFF" backcolor="#1D6894" fill="Solid" pattern="#,##0.00" fontSize="8">
 
99
        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#2B2828"/>
 
100
    </style>
 
101
    <parameter name="pqty_1" class="java.lang.String">
 
102
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
103
    </parameter>
 
104
    <parameter name="pqty_2" class="java.lang.String">
 
105
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
106
    </parameter>
 
107
    <parameter name="pqty_3" class="java.lang.String">
 
108
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
109
    </parameter>
 
110
    <parameter name="pqty_4" class="java.lang.String">
 
111
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
112
    </parameter>
 
113
    <parameter name="pqty_5" class="java.lang.String">
 
114
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
115
    </parameter>
 
116
    <parameter name="pqty_6" class="java.lang.String">
 
117
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
118
    </parameter>
 
119
    <parameter name="pqty_7" class="java.lang.String">
 
120
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
121
    </parameter>
 
122
    <parameter name="pqty_8" class="java.lang.String">
 
123
        <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
124
    </parameter>
 
125
    <parameter name="production_id" class="java.lang.Integer"/>
 
126
    <parameter name="location_id" class="java.lang.Integer"/>
 
127
    <parameter name="fiscalyear_id" class="java.lang.Integer"/>
 
128
    <parameter name="user_name" class="java.lang.String"/>
 
129
    <parameter name="report_name" class="java.lang.String"/>
 
130
    <parameter name="company_name" class="java.lang.String"/>
 
131
    <parameter name="report_subname" class="java.lang.String"/>
 
132
    <queryString>
 
133
        <![CDATA[SELECT * FROM get_production_plant_data($P{production_id}, $P{location_id}, $P{fiscalyear_id}, 'vacio') AS
 
134
("date_production" date,
 
135
    "turn" integer,
 
136
    "pqty_1" numeric,
 
137
    "pqty_2" numeric,
 
138
    "pqty_3" numeric,
 
139
    "pqty_4" numeric,
 
140
    "pqty_5" numeric,
 
141
    "pqty_6" numeric,
 
142
    "pqty_7" numeric,
 
143
    "pqty_8" numeric,
 
144
    "total_produccion" numeric,
 
145
    "total_sacos" numeric,
 
146
    "nota" text
 
147
) ORDER BY date_production, turn;]]>
 
148
    </queryString>
 
149
    <field name="date_production" class="java.sql.Date"/>
 
150
    <field name="turn" class="java.lang.Integer"/>
 
151
    <field name="pqty_1" class="java.math.BigDecimal"/>
 
152
    <field name="pqty_2" class="java.math.BigDecimal"/>
 
153
    <field name="pqty_3" class="java.math.BigDecimal"/>
 
154
    <field name="pqty_4" class="java.math.BigDecimal"/>
 
155
    <field name="pqty_5" class="java.math.BigDecimal"/>
 
156
    <field name="pqty_6" class="java.math.BigDecimal"/>
 
157
    <field name="pqty_7" class="java.math.BigDecimal"/>
 
158
    <field name="pqty_8" class="java.math.BigDecimal"/>
 
159
    <field name="total_produccion" class="java.math.BigDecimal"/>
 
160
    <field name="total_sacos" class="java.math.BigDecimal"/>
 
161
    <field name="nota" class="java.lang.Object"/>
 
162
    <variable name="var1" class="java.lang.String">
 
163
        <variableExpression><![CDATA[]]></variableExpression>
 
164
        <initialValueExpression><![CDATA[' ']]></initialValueExpression>
 
165
    </variable>
 
166
    <variable name="pqty_1_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
167
        <variableExpression><![CDATA[$F{pqty_1}]]></variableExpression>
 
168
    </variable>
 
169
    <variable name="pqty_2_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
170
        <variableExpression><![CDATA[$F{pqty_2}]]></variableExpression>
 
171
    </variable>
 
172
    <variable name="pqty_3_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
173
        <variableExpression><![CDATA[$F{pqty_3}]]></variableExpression>
 
174
    </variable>
 
175
    <variable name="pqty_4_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
176
        <variableExpression><![CDATA[$F{pqty_4}]]></variableExpression>
 
177
    </variable>
 
178
    <variable name="pqty_5_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
179
        <variableExpression><![CDATA[$F{pqty_5}]]></variableExpression>
 
180
    </variable>
 
181
    <variable name="pqty_6_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
182
        <variableExpression><![CDATA[$F{pqty_6}]]></variableExpression>
 
183
    </variable>
 
184
    <variable name="pqty_7_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
185
        <variableExpression><![CDATA[$F{pqty_7}]]></variableExpression>
 
186
    </variable>
 
187
    <variable name="pqty_8_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
188
        <variableExpression><![CDATA[$F{pqty_8}]]></variableExpression>
 
189
    </variable>
 
190
    <variable name="total_produccion_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
191
        <variableExpression><![CDATA[$F{total_produccion}]]></variableExpression>
 
192
    </variable>
 
193
    <variable name="total_sacos_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
 
194
        <variableExpression><![CDATA[$F{total_sacos}]]></variableExpression>
 
195
    </variable>
 
196
    <background>
 
197
        <band splitType="Stretch"/>
 
198
    </background>
 
199
    <title>
 
200
        <band splitType="Stretch"/>
 
201
    </title>
 
202
    <pageHeader>
 
203
        <band splitType="Stretch"/>
 
204
    </pageHeader>
 
205
    <columnHeader>
 
206
        <band height="60" splitType="Stretch">
 
207
            <frame>
 
208
                <reportElement mode="Opaque" x="0" y="0" width="968" height="20" forecolor="#FFFFFF" backcolor="#1D6894"/>
 
209
                <textField>
 
210
                    <reportElement x="0" y="0" width="968" height="20" forecolor="#FFFFFF"/>
 
211
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
212
                        <font size="9" isBold="true"/>
 
213
                    </textElement>
 
214
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{report_name} + " Producción " + $P{report_subname}]]></textFieldExpression>
 
215
                </textField>
 
216
            </frame>
 
217
            <frame>
 
218
                <reportElement x="0" y="20" width="968" height="35"/>
 
219
                <staticText>
 
220
                    <reportElement style="encabezado_1" x="0" y="0" width="59" height="18"/>
 
221
                    <box>
 
222
                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
223
                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
224
                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
225
                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
226
                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
227
                    </box>
 
228
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
229
                        <font size="8"/>
 
230
                    </textElement>
 
231
                    <text><![CDATA[ ]]></text>
 
232
                </staticText>
 
233
                <staticText>
 
234
                    <reportElement style="encabezado_1" mode="Opaque" x="59" y="0" width="30" height="18"/>
 
235
                    <box>
 
236
                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
237
                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
238
                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
239
                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
240
                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#786A6A"/>
 
241
                    </box>
 
242
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
243
                        <font size="8"/>
 
244
                    </textElement>
 
245
                    <text><![CDATA[ ]]></text>
 
246
                </staticText>
 
247
                <staticText>
 
248
                    <reportElement style="encabezado_2" x="505" y="0" width="56" height="18" backcolor="#71A8DD"/>
 
249
                    <box>
 
250
                        <topPen lineWidth="0.5"/>
 
251
                        <leftPen lineWidth="0.5"/>
 
252
                        <bottomPen lineWidth="0.0"/>
 
253
                        <rightPen lineWidth="0.5"/>
 
254
                    </box>
 
255
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
256
                        <font size="8" isBold="true"/>
 
257
                    </textElement>
 
258
                    <text><![CDATA[Total 1]]></text>
 
259
                </staticText>
 
260
                <staticText>
 
261
                    <reportElement style="encabezado_2" x="561" y="0" width="50" height="18" forecolor="#0B5595" backcolor="#71A8DD"/>
 
262
                    <box>
 
263
                        <topPen lineWidth="0.5"/>
 
264
                        <leftPen lineWidth="0.5"/>
 
265
                        <bottomPen lineWidth="0.0"/>
 
266
                        <rightPen lineWidth="0.5"/>
 
267
                    </box>
 
268
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
269
                        <font size="8" isBold="true"/>
 
270
                    </textElement>
 
271
                    <text><![CDATA[Total]]></text>
 
272
                </staticText>
 
273
                <staticText>
 
274
                    <reportElement style="encabezado_1" x="611" y="0" width="357" height="18"/>
 
275
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
276
                        <font size="8"/>
 
277
                    </textElement>
 
278
                    <text><![CDATA[ ]]></text>
 
279
                </staticText>
 
280
                <staticText>
 
281
                    <reportElement style="encabezado_2" x="561" y="18" width="50" height="17" forecolor="#0B5595" backcolor="#71A8DD"/>
 
282
                    <box>
 
283
                        <topPen lineWidth="0.0"/>
 
284
                    </box>
 
285
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
286
                        <font size="8" isBold="true"/>
 
287
                    </textElement>
 
288
                    <text><![CDATA[Sacos]]></text>
 
289
                </staticText>
 
290
                <staticText>
 
291
                    <reportElement style="encabezado_2" x="505" y="18" width="56" height="17" forecolor="#0B5595" backcolor="#71A8DD"/>
 
292
                    <box>
 
293
                        <topPen lineWidth="0.0"/>
 
294
                        <leftPen lineWidth="0.5"/>
 
295
                        <bottomPen lineWidth="0.5"/>
 
296
                        <rightPen lineWidth="0.5"/>
 
297
                    </box>
 
298
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
299
                        <font size="8" isBold="true"/>
 
300
                    </textElement>
 
301
                    <text><![CDATA[Ton x Dia]]></text>
 
302
                </staticText>
 
303
                <staticText>
 
304
                    <reportElement style="encabezado_2" x="611" y="18" width="357" height="17"/>
 
305
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
306
                        <font size="8"/>
 
307
                    </textElement>
 
308
                    <text><![CDATA[Observaciones]]></text>
 
309
                </staticText>
 
310
                <staticText>
 
311
                    <reportElement style="encabezado_2" x="0" y="18" width="59" height="17"/>
 
312
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
313
                        <font size="8"/>
 
314
                    </textElement>
 
315
                    <text><![CDATA[Fecha]]></text>
 
316
                </staticText>
 
317
                <staticText>
 
318
                    <reportElement style="encabezado_2" x="59" y="18" width="30" height="17"/>
 
319
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
320
                        <font size="8"/>
 
321
                    </textElement>
 
322
                    <text><![CDATA[Turno]]></text>
 
323
                </staticText>
 
324
                <textField isBlankWhenNull="true">
 
325
                    <reportElement style="encabezado_2" x="89" y="18" width="52" height="17"/>
 
326
                    <textElement verticalAlignment="Middle">
 
327
                        <font size="7"/>
 
328
                    </textElement>
 
329
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_1} + " "]]></textFieldExpression>
 
330
                </textField>
 
331
                <textField isBlankWhenNull="true">
 
332
                    <reportElement style="encabezado_2" x="141" y="18" width="52" height="17"/>
 
333
                    <textElement verticalAlignment="Middle">
 
334
                        <font size="7"/>
 
335
                    </textElement>
 
336
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_2} + " "]]></textFieldExpression>
 
337
                </textField>
 
338
                <textField isBlankWhenNull="true">
 
339
                    <reportElement style="encabezado_2" x="193" y="18" width="52" height="17"/>
 
340
                    <textElement verticalAlignment="Middle">
 
341
                        <font size="7"/>
 
342
                    </textElement>
 
343
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_3} + " "]]></textFieldExpression>
 
344
                </textField>
 
345
                <textField isBlankWhenNull="true">
 
346
                    <reportElement style="encabezado_2" x="245" y="18" width="52" height="17"/>
 
347
                    <textElement verticalAlignment="Middle">
 
348
                        <font size="7"/>
 
349
                    </textElement>
 
350
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_4} + " "]]></textFieldExpression>
 
351
                </textField>
 
352
                <textField isBlankWhenNull="true">
 
353
                    <reportElement style="encabezado_2" x="297" y="18" width="52" height="17"/>
 
354
                    <textElement verticalAlignment="Middle">
 
355
                        <font size="7"/>
 
356
                    </textElement>
 
357
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_5} + " "]]></textFieldExpression>
 
358
                </textField>
 
359
                <textField>
 
360
                    <reportElement style="encabezado_2" x="349" y="18" width="52" height="17"/>
 
361
                    <textElement verticalAlignment="Middle">
 
362
                        <font size="7"/>
 
363
                    </textElement>
 
364
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_6} + " "]]></textFieldExpression>
 
365
                </textField>
 
366
                <textField>
 
367
                    <reportElement style="encabezado_2" x="401" y="18" width="52" height="17"/>
 
368
                    <textElement verticalAlignment="Middle">
 
369
                        <font size="7"/>
 
370
                    </textElement>
 
371
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_7} + " "]]></textFieldExpression>
 
372
                </textField>
 
373
                <textField isBlankWhenNull="true">
 
374
                    <reportElement style="encabezado_2" x="453" y="18" width="52" height="17"/>
 
375
                    <textElement verticalAlignment="Middle">
 
376
                        <font size="7"/>
 
377
                    </textElement>
 
378
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_8} + " "]]></textFieldExpression>
 
379
                </textField>
 
380
                <textField isBlankWhenNull="true">
 
381
                    <reportElement style="encabezado_1" x="453" y="0" width="52" height="18"/>
 
382
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
383
                        <font size="8"/>
 
384
                    </textElement>
 
385
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
386
                </textField>
 
387
                <textField isBlankWhenNull="true">
 
388
                    <reportElement style="encabezado_1" x="401" y="0" width="52" height="18"/>
 
389
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
390
                        <font size="8"/>
 
391
                    </textElement>
 
392
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
393
                </textField>
 
394
                <textField isBlankWhenNull="true">
 
395
                    <reportElement style="encabezado_1" x="349" y="0" width="52" height="18"/>
 
396
                    <textElement verticalAlignment="Middle">
 
397
                        <font size="8"/>
 
398
                    </textElement>
 
399
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
400
                </textField>
 
401
                <textField isBlankWhenNull="true">
 
402
                    <reportElement style="encabezado_1" x="297" y="0" width="52" height="18"/>
 
403
                    <textElement verticalAlignment="Middle">
 
404
                        <font size="8"/>
 
405
                    </textElement>
 
406
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
407
                </textField>
 
408
                <textField isBlankWhenNull="true">
 
409
                    <reportElement style="encabezado_1" x="245" y="0" width="52" height="18"/>
 
410
                    <textElement verticalAlignment="Middle">
 
411
                        <font size="8"/>
 
412
                    </textElement>
 
413
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
414
                </textField>
 
415
                <textField isBlankWhenNull="true">
 
416
                    <reportElement style="encabezado_1" x="193" y="0" width="52" height="18"/>
 
417
                    <textElement verticalAlignment="Middle">
 
418
                        <font size="8"/>
 
419
                    </textElement>
 
420
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
421
                </textField>
 
422
                <textField isBlankWhenNull="true">
 
423
                    <reportElement style="encabezado_1" x="141" y="0" width="52" height="18"/>
 
424
                    <textElement verticalAlignment="Middle">
 
425
                        <font size="8"/>
 
426
                    </textElement>
 
427
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
428
                </textField>
 
429
                <textField isBlankWhenNull="true">
 
430
                    <reportElement style="encabezado_1" x="89" y="0" width="52" height="18"/>
 
431
                    <textElement verticalAlignment="Middle">
 
432
                        <font size="8"/>
 
433
                    </textElement>
 
434
                    <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
 
435
                </textField>
 
436
            </frame>
 
437
            <frame>
 
438
                <reportElement mode="Opaque" x="0" y="55" width="968" height="5" backcolor="#DBD4D4"/>
 
439
            </frame>
 
440
        </band>
 
441
    </columnHeader>
 
442
    <detail>
 
443
        <band height="15" splitType="Stretch">
 
444
            <frame>
 
445
                <reportElement x="0" y="0" width="968" height="15"/>
 
446
                <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy">
 
447
                    <reportElement style="celda_contenido_1" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="59" height="15" backcolor="#89AF6B"/>
 
448
                    <textElement verticalAlignment="Middle">
 
449
                        <font size="7"/>
 
450
                    </textElement>
 
451
                    <textFieldExpression class="java.util.Date"><![CDATA[$F{date_production}]]></textFieldExpression>
 
452
                </textField>
 
453
                <textField isStretchWithOverflow="true">
 
454
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="59" y="0" width="30" height="15"/>
 
455
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
456
                        <font size="7"/>
 
457
                    </textElement>
 
458
                    <textFieldExpression class="java.lang.Integer"><![CDATA[$F{turn}]]></textFieldExpression>
 
459
                </textField>
 
460
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
461
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="141" y="0" width="52" height="15"/>
 
462
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
463
                        <font size="7"/>
 
464
                    </textElement>
 
465
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_2}]]></textFieldExpression>
 
466
                </textField>
 
467
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
468
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="245" y="0" width="52" height="15"/>
 
469
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
470
                        <font size="7"/>
 
471
                    </textElement>
 
472
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_4}]]></textFieldExpression>
 
473
                </textField>
 
474
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
475
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="349" y="0" width="52" height="15"/>
 
476
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
477
                        <font size="7"/>
 
478
                    </textElement>
 
479
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_6}]]></textFieldExpression>
 
480
                </textField>
 
481
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
482
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="89" y="0" width="52" height="15"/>
 
483
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
484
                        <font size="7"/>
 
485
                    </textElement>
 
486
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_1}]]></textFieldExpression>
 
487
                </textField>
 
488
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
489
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="193" y="0" width="52" height="15"/>
 
490
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
491
                        <font size="7"/>
 
492
                    </textElement>
 
493
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_3}]]></textFieldExpression>
 
494
                </textField>
 
495
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
496
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="297" y="0" width="52" height="15"/>
 
497
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
498
                        <font size="7"/>
 
499
                    </textElement>
 
500
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_5}]]></textFieldExpression>
 
501
                </textField>
 
502
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
503
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="401" y="0" width="52" height="15"/>
 
504
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
505
                        <font size="7"/>
 
506
                    </textElement>
 
507
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_7}]]></textFieldExpression>
 
508
                </textField>
 
509
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
510
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Opaque" x="505" y="0" width="56" height="15" backcolor="#C4D6EA"/>
 
511
                    <box>
 
512
                        <pen lineWidth="0.5"/>
 
513
                        <topPen lineWidth="0.5"/>
 
514
                        <leftPen lineWidth="0.5"/>
 
515
                        <bottomPen lineWidth="0.5"/>
 
516
                        <rightPen lineWidth="0.5"/>
 
517
                    </box>
 
518
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
519
                        <font size="7"/>
 
520
                    </textElement>
 
521
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{total_produccion}]]></textFieldExpression>
 
522
                </textField>
 
523
                <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 
524
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" x="561" y="0" width="50" height="15" backcolor="#C4D6EA"/>
 
525
                    <box>
 
526
                        <pen lineWidth="0.5"/>
 
527
                        <topPen lineWidth="0.5"/>
 
528
                        <leftPen lineWidth="0.5"/>
 
529
                        <bottomPen lineWidth="0.5"/>
 
530
                        <rightPen lineWidth="0.5"/>
 
531
                    </box>
 
532
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
533
                        <font size="7"/>
 
534
                    </textElement>
 
535
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{total_sacos}]]></textFieldExpression>
 
536
                </textField>
 
537
                <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 
538
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" x="611" y="0" width="357" height="15" isPrintWhenDetailOverflows="true"/>
 
539
                    <textElement verticalAlignment="Middle">
 
540
                        <font fontName="Serif" size="6"/>
 
541
                    </textElement>
 
542
                    <textFieldExpression class="java.lang.String"><![CDATA[$F{nota}.equals(null) ? $V{var1} : " " + $F{nota}]]></textFieldExpression>
 
543
                </textField>
 
544
                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
 
545
                    <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="453" y="0" width="52" height="15"/>
 
546
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
547
                        <font size="7"/>
 
548
                    </textElement>
 
549
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_8}]]></textFieldExpression>
 
550
                </textField>
 
551
            </frame>
 
552
        </band>
 
553
    </detail>
 
554
    <columnFooter>
 
555
        <band height="25" splitType="Stretch">
 
556
            <frame>
 
557
                <reportElement x="0" y="5" width="968" height="20"/>
 
558
                <textField pattern="#,##0.00" isBlankWhenNull="true">
 
559
                    <reportElement style="total" x="89" y="0" width="52" height="20"/>
 
560
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
561
                        <font size="7"/>
 
562
                    </textElement>
 
563
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_1_1}]]></textFieldExpression>
 
564
                </textField>
 
565
                <textField pattern="#,##0.00" isBlankWhenNull="true">
 
566
                    <reportElement style="total" x="141" y="0" width="52" height="20"/>
 
567
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
568
                        <font size="7"/>
 
569
                    </textElement>
 
570
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_2_1}]]></textFieldExpression>
 
571
                </textField>
 
572
                <textField pattern="#,##0.00" isBlankWhenNull="true">
 
573
                    <reportElement style="total" x="193" y="0" width="52" height="20"/>
 
574
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
575
                        <font size="7"/>
 
576
                    </textElement>
 
577
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_3_1}]]></textFieldExpression>
 
578
                </textField>
 
579
                <textField pattern="#,##0.00" isBlankWhenNull="true">
 
580
                    <reportElement style="total" x="245" y="0" width="52" height="20"/>
 
581
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
582
                        <font size="7"/>
 
583
                    </textElement>
 
584
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_4_1}]]></textFieldExpression>
 
585
                </textField>
 
586
                <textField isBlankWhenNull="true">
 
587
                    <reportElement style="total" x="297" y="0" width="52" height="20"/>
 
588
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
589
                        <font size="7"/>
 
590
                    </textElement>
 
591
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_5_1}]]></textFieldExpression>
 
592
                </textField>
 
593
                <textField isBlankWhenNull="true">
 
594
                    <reportElement style="total" x="349" y="0" width="52" height="20"/>
 
595
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
596
                        <font size="7"/>
 
597
                    </textElement>
 
598
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_6_1}]]></textFieldExpression>
 
599
                </textField>
 
600
                <textField isBlankWhenNull="true">
 
601
                    <reportElement style="total" x="401" y="0" width="52" height="20"/>
 
602
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
603
                        <font size="7"/>
 
604
                    </textElement>
 
605
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_7_1}]]></textFieldExpression>
 
606
                </textField>
 
607
                <textField isBlankWhenNull="true">
 
608
                    <reportElement style="total" x="453" y="0" width="52" height="20"/>
 
609
                    <textElement textAlignment="Right" verticalAlignment="Middle">
 
610
                        <font size="7"/>
 
611
                    </textElement>
 
612
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:$V{pqty_8_1}]]></textFieldExpression>
 
613
                </textField>
 
614
                <textField isBlankWhenNull="true">
 
615
                    <reportElement style="total" x="505" y="0" width="56" height="20"/>
 
616
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
617
                        <font size="7"/>
 
618
                    </textElement>
 
619
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_produccion_1}]]></textFieldExpression>
 
620
                </textField>
 
621
                <textField isBlankWhenNull="true">
 
622
                    <reportElement style="total" x="561" y="0" width="50" height="20"/>
 
623
                    <textElement textAlignment="Center" verticalAlignment="Middle">
 
624
                        <font size="7"/>
 
625
                    </textElement>
 
626
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_sacos_1}]]></textFieldExpression>
 
627
                </textField>
 
628
                <staticText>
 
629
                    <reportElement style="total" x="0" y="0" width="89" height="20"/>
 
630
                    <textElement verticalAlignment="Middle">
 
631
                        <font size="8"/>
 
632
                    </textElement>
 
633
                    <text><![CDATA[Total]]></text>
 
634
                </staticText>
 
635
                <staticText>
 
636
                    <reportElement style="total" x="611" y="0" width="357" height="20"/>
 
637
                    <textElement/>
 
638
                    <text><![CDATA[ ]]></text>
 
639
                </staticText>
 
640
            </frame>
 
641
            <frame>
 
642
                <reportElement mode="Opaque" x="0" y="0" width="968" height="5" backcolor="#DBD4D4"/>
 
643
            </frame>
 
644
        </band>
 
645
    </columnFooter>
 
646
    <pageFooter>
 
647
        <band/>
 
648
    </pageFooter>
 
649
    <summary>
 
650
        <band splitType="Stretch"/>
 
651
    </summary>
 
652
</jasperReport>