← Back to branch summary

~eduardo-bayardo-bias/openobject-addons/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/ventas_mensuales_importe_producto.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/ventas_mensuales_importe_producto.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="Ventas_Mensuales_Cliente" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true">
 
3
        <property name="ireport.zoom" value="1.0"/>
 
4
        <property name="ireport.x" value="0"/>
 
5
        <property name="ireport.y" value="0"/>
 
6
        <style name="title" mode="Opaque" forecolor="#006699" backcolor="#E6E6E6" fontSize="10" isBold="true">
 
7
                <pen lineStyle="Dotted"/>
 
8
                <box topPadding="0" leftPadding="0">
 
9
                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
10
                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
11
                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
12
                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
13
                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
14
                </box>
 
15
        </style>
 
16
        <style name="cuerpo" fontSize="8">
 
17
                <pen lineStyle="Dotted"/>
 
18
                <box>
 
19
                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
20
                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
21
                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
22
                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
23
                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
24
                </box>
 
25
        </style>
 
26
        <style name="Row">
 
27
                <conditionalStyle>
 
28
                        <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
 
29
                        <style mode="Opaque" backcolor="#F0F8FF"/>
 
30
                </conditionalStyle>
 
31
        </style>
 
32
        <subDataset name="New Dataset 1"/>
 
33
        <queryString language="xPath">
 
34
                <![CDATA[/data/record]]>
 
35
        </queryString>
 
36
        <field name="Abril-abril" class="java.lang.Float">
 
37
                <fieldDescription><![CDATA[/data/record/Abril-abril]]></fieldDescription>
 
38
        </field>
 
39
        <field name="Agosto-agosto" class="java.lang.Float">
 
40
                <fieldDescription><![CDATA[/data/record/Agosto-agosto]]></fieldDescription>
 
41
        </field>
 
42
        <field name="Diciembre-diciembre" class="java.lang.Float">
 
43
                <fieldDescription><![CDATA[/data/record/Diciembre-diciembre]]></fieldDescription>
 
44
        </field>
 
45
        <field name="Enero-enero" class="java.lang.Float">
 
46
                <fieldDescription><![CDATA[/data/record/Enero-enero]]></fieldDescription>
 
47
        </field>
 
48
        <field name="Febrero-febrero" class="java.lang.Float">
 
49
                <fieldDescription><![CDATA[/data/record/Febrero-febrero]]></fieldDescription>
 
50
        </field>
 
51
        <field name="id-id" class="java.lang.Double">
 
52
                <fieldDescription><![CDATA[/data/record/id-id]]></fieldDescription>
 
53
        </field>
 
54
        <field name="Julio-julio" class="java.lang.Float">
 
55
                <fieldDescription><![CDATA[/data/record/Julio-julio]]></fieldDescription>
 
56
        </field>
 
57
        <field name="Junio-junio" class="java.lang.Float">
 
58
                <fieldDescription><![CDATA[/data/record/Junio-junio]]></fieldDescription>
 
59
        </field>
 
60
        <field name="Marzo-marzo" class="java.lang.Float">
 
61
                <fieldDescription><![CDATA[/data/record/Marzo-marzo]]></fieldDescription>
 
62
        </field>
 
63
        <field name="Mayo-mayo" class="java.lang.Float">
 
64
                <fieldDescription><![CDATA[/data/record/Mayo-mayo]]></fieldDescription>
 
65
        </field>
 
66
        <field name="Noviembre-noviembre" class="java.lang.Float">
 
67
                <fieldDescription><![CDATA[/data/record/Noviembre-noviembre]]></fieldDescription>
 
68
        </field>
 
69
        <field name="Octubre-octubre" class="java.lang.Float">
 
70
                <fieldDescription><![CDATA[/data/record/Octubre-octubre]]></fieldDescription>
 
71
        </field>
 
72
        <field name="Septiembre-septiembre" class="java.lang.Float">
 
73
                <fieldDescription><![CDATA[/data/record/Septiembre-septiembre]]></fieldDescription>
 
74
        </field>
 
75
        <field name="Total-total" class="java.lang.Double">
 
76
                <fieldDescription><![CDATA[Total-total]]></fieldDescription>
 
77
        </field>
 
78
        <field name="Nombre-name" class="java.lang.String">
 
79
                <fieldDescription><![CDATA[User-User/Nombre-name]]></fieldDescription>
 
80
        </field>
 
81
        <field name="Producto-producto" class="java.lang.String">
 
82
                <fieldDescription><![CDATA[Producto-producto]]></fieldDescription>
 
83
        </field>
 
84
        <field name="Cliente-cliente" class="java.lang.String">
 
85
                <fieldDescription><![CDATA[Cliente-cliente]]></fieldDescription>
 
86
        </field>
 
87
        <variable name="Enero-enero_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
88
                <variableExpression><![CDATA[$F{Enero-enero}]]></variableExpression>
 
89
        </variable>
 
90
        <variable name="Febrero-febrero_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
91
                <variableExpression><![CDATA[$F{Febrero-febrero}]]></variableExpression>
 
92
        </variable>
 
93
        <variable name="Marzo-marzo_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
94
                <variableExpression><![CDATA[$F{Marzo-marzo}]]></variableExpression>
 
95
        </variable>
 
96
        <variable name="Abril-abril_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
97
                <variableExpression><![CDATA[$F{Abril-abril}]]></variableExpression>
 
98
        </variable>
 
99
        <variable name="Mayo-mayo_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
100
                <variableExpression><![CDATA[$F{Mayo-mayo}]]></variableExpression>
 
101
        </variable>
 
102
        <variable name="Junio-junio_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
103
                <variableExpression><![CDATA[$F{Junio-junio}]]></variableExpression>
 
104
        </variable>
 
105
        <variable name="Julio-julio_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
106
                <variableExpression><![CDATA[$F{Julio-julio}]]></variableExpression>
 
107
        </variable>
 
108
        <variable name="Agosto-agosto_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
109
                <variableExpression><![CDATA[$F{Agosto-agosto}]]></variableExpression>
 
110
        </variable>
 
111
        <variable name="Septiembre-septiembre_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
112
                <variableExpression><![CDATA[$F{Septiembre-septiembre}]]></variableExpression>
 
113
        </variable>
 
114
        <variable name="Octubre-octubre_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
115
                <variableExpression><![CDATA[$F{Octubre-octubre}]]></variableExpression>
 
116
        </variable>
 
117
        <variable name="Noviembre-noviembre_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
118
                <variableExpression><![CDATA[$F{Noviembre-noviembre}]]></variableExpression>
 
119
        </variable>
 
120
        <variable name="Diciembre-diciembre_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
121
                <variableExpression><![CDATA[$F{Diciembre-diciembre}]]></variableExpression>
 
122
                <initialValueExpression><![CDATA[0.0]]></initialValueExpression>
 
123
        </variable>
 
124
        <variable name="Cero" class="java.lang.Double">
 
125
                <variableExpression><![CDATA[0.0]]></variableExpression>
 
126
                <initialValueExpression><![CDATA[0.0]]></initialValueExpression>
 
127
        </variable>
 
128
        <variable name="Total-total_1" class="java.lang.Integer" resetType="Column" calculation="Count">
 
129
                <variableExpression><![CDATA[$F{Total-total}]]></variableExpression>
 
130
        </variable>
 
131
        <variable name="Total-total_2" class="java.lang.Double" resetType="Column" calculation="Sum">
 
132
                <variableExpression><![CDATA[$F{Total-total}]]></variableExpression>
 
133
        </variable>
 
134
        <background>
 
135
                <band/>
 
136
        </background>
 
137
        <title>
 
138
                <band height="35">
 
139
                        <frame>
 
140
                                <reportElement mode="Opaque" x="-20" y="-20" width="791" height="45" backcolor="#006699"/>
 
141
                                <staticText>
 
142
                                        <reportElement x="78" y="10" width="139" height="25" forecolor="#FFFFFF"/>
 
143
                                        <textElement textAlignment="Center">
 
144
                                                <font size="10" isBold="true"/>
 
145
                                        </textElement>
 
146
                                        <text><![CDATA[Minerales y Carbones de
 
147
México, S.A de C.V]]></text>
 
148
                                </staticText>
 
149
                                <textField>
 
150
                                        <reportElement x="538" y="10" width="93" height="10" forecolor="#FFFFFF"/>
 
151
                                        <textElement>
 
152
                                                <font size="8"/>
 
153
                                        </textElement>
 
154
                                        <textFieldExpression class="java.lang.String"><![CDATA["Fecha de Impresión: "]]></textFieldExpression>
 
155
                                </textField>
 
156
                                <textField pattern="dd/MM/yyyy">
 
157
                                        <reportElement x="631" y="10" width="54" height="10" forecolor="#FFFFFF"/>
 
158
                                        <textElement>
 
159
                                                <font size="8"/>
 
160
                                        </textElement>
 
161
                                        <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
162
                                </textField>
 
163
                                <textField pattern="h.mm.ss a">
 
164
                                        <reportElement x="685" y="10" width="62" height="10" forecolor="#FFFFFF"/>
 
165
                                        <textElement>
 
166
                                                <font size="8"/>
 
167
                                        </textElement>
 
168
                                        <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
169
                                </textField>
 
170
                                <textField>
 
171
                                        <reportElement x="538" y="20" width="209" height="10" forecolor="#FFFFFF"/>
 
172
                                        <textElement>
 
173
                                                <font size="8"/>
 
174
                                        </textElement>
 
175
                                        <textFieldExpression class="java.lang.String"><![CDATA["Por :  " + $F{Nombre-name}]]></textFieldExpression>
 
176
                                </textField>
 
177
                                <staticText>
 
178
                                        <reportElement x="286" y="15" width="189" height="15" forecolor="#FFFFFF"/>
 
179
                                        <textElement textAlignment="Center">
 
180
                                                <font size="9" isPdfEmbedded="false"/>
 
181
                                        </textElement>
 
182
                                        <text><![CDATA[Ventas Mensuales Importe Producto]]></text>
 
183
                                </staticText>
 
184
                                <image scaleImage="FillFrame">
 
185
                                        <reportElement stretchType="RelativeToTallestObject" x="20" y="5" width="38" height="35"/>
 
186
                                        <imageExpression class="java.lang.String"><![CDATA["logo_mcm.gif"]]></imageExpression>
 
187
                                </image>
 
188
                        </frame>
 
189
                </band>
 
190
        </title>
 
191
        <pageHeader>
 
192
                <band height="20">
 
193
                        <textField>
 
194
                                <reportElement x="279" y="0" width="209" height="13"/>
 
195
                                <textElement>
 
196
                                        <font isBold="true"/>
 
197
                                </textElement>
 
198
                                <textFieldExpression class="java.lang.String"><![CDATA["Cliente: " + $F{Cliente-cliente}]]></textFieldExpression>
 
199
                        </textField>
 
200
                </band>
 
201
        </pageHeader>
 
202
        <columnHeader>
 
203
                <band height="12">
 
204
                        <staticText>
 
205
                                <reportElement mode="Opaque" x="0" y="0" width="99" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
206
                                <box bottomPadding="0">
 
207
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
208
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
209
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
210
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
211
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
212
                                </box>
 
213
                                <textElement>
 
214
                                        <font isBold="true"/>
 
215
                                </textElement>
 
216
                                <text><![CDATA[Producto]]></text>
 
217
                        </staticText>
 
218
                        <staticText>
 
219
                                <reportElement mode="Opaque" x="99" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
220
                                <box>
 
221
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
222
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
223
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
224
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
225
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
226
                                </box>
 
227
                                <textElement>
 
228
                                        <font isBold="true"/>
 
229
                                </textElement>
 
230
                                <text><![CDATA[Ene]]></text>
 
231
                        </staticText>
 
232
                        <staticText>
 
233
                                <reportElement mode="Opaque" x="148" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
234
                                <box>
 
235
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
236
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
237
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
238
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
239
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
240
                                </box>
 
241
                                <textElement>
 
242
                                        <font isBold="true"/>
 
243
                                </textElement>
 
244
                                <text><![CDATA[Feb]]></text>
 
245
                        </staticText>
 
246
                        <staticText>
 
247
                                <reportElement mode="Opaque" x="197" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
248
                                <box>
 
249
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
250
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
251
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
252
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
253
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
254
                                </box>
 
255
                                <textElement>
 
256
                                        <font isBold="true"/>
 
257
                                </textElement>
 
258
                                <text><![CDATA[Mar]]></text>
 
259
                        </staticText>
 
260
                        <staticText>
 
261
                                <reportElement mode="Opaque" x="246" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
262
                                <box>
 
263
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
264
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
265
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
266
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
267
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
268
                                </box>
 
269
                                <textElement>
 
270
                                        <font isBold="true"/>
 
271
                                </textElement>
 
272
                                <text><![CDATA[Abr]]></text>
 
273
                        </staticText>
 
274
                        <staticText>
 
275
                                <reportElement mode="Opaque" x="295" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
276
                                <box>
 
277
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
278
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
279
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
280
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
281
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
282
                                </box>
 
283
                                <textElement>
 
284
                                        <font isBold="true"/>
 
285
                                </textElement>
 
286
                                <text><![CDATA[May]]></text>
 
287
                        </staticText>
 
288
                        <staticText>
 
289
                                <reportElement mode="Opaque" x="344" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
290
                                <box>
 
291
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
292
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
293
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
294
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
295
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
296
                                </box>
 
297
                                <textElement>
 
298
                                        <font isBold="true"/>
 
299
                                </textElement>
 
300
                                <text><![CDATA[Jun]]></text>
 
301
                        </staticText>
 
302
                        <staticText>
 
303
                                <reportElement mode="Opaque" x="393" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
304
                                <box>
 
305
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
306
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
307
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
308
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
309
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
310
                                </box>
 
311
                                <textElement>
 
312
                                        <font isBold="true"/>
 
313
                                </textElement>
 
314
                                <text><![CDATA[Jul]]></text>
 
315
                        </staticText>
 
316
                        <staticText>
 
317
                                <reportElement mode="Opaque" x="442" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
318
                                <box>
 
319
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
320
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
321
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
322
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
323
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
324
                                </box>
 
325
                                <textElement>
 
326
                                        <font isBold="true"/>
 
327
                                </textElement>
 
328
                                <text><![CDATA[Agost]]></text>
 
329
                        </staticText>
 
330
                        <staticText>
 
331
                                <reportElement mode="Opaque" x="491" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
332
                                <box>
 
333
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
334
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
335
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
336
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
337
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
338
                                </box>
 
339
                                <textElement>
 
340
                                        <font isBold="true"/>
 
341
                                </textElement>
 
342
                                <text><![CDATA[Sept]]></text>
 
343
                        </staticText>
 
344
                        <staticText>
 
345
                                <reportElement mode="Opaque" x="540" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
346
                                <box>
 
347
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
348
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
349
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
350
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
351
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
352
                                </box>
 
353
                                <textElement>
 
354
                                        <font isBold="true"/>
 
355
                                </textElement>
 
356
                                <text><![CDATA[Oct]]></text>
 
357
                        </staticText>
 
358
                        <staticText>
 
359
                                <reportElement mode="Opaque" x="589" y="0" width="49" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
360
                                <box>
 
361
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
362
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
363
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
364
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
365
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
366
                                </box>
 
367
                                <textElement>
 
368
                                        <font isBold="true"/>
 
369
                                </textElement>
 
370
                                <text><![CDATA[Nov]]></text>
 
371
                        </staticText>
 
372
                        <staticText>
 
373
                                <reportElement mode="Opaque" x="638" y="0" width="50" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
374
                                <box>
 
375
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
376
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
377
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
378
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
379
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
380
                                </box>
 
381
                                <textElement>
 
382
                                        <font isBold="true"/>
 
383
                                </textElement>
 
384
                                <text><![CDATA[Dic]]></text>
 
385
                        </staticText>
 
386
                        <staticText>
 
387
                                <reportElement mode="Opaque" x="688" y="0" width="64" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
388
                                <box>
 
389
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
390
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
391
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
392
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
393
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
394
                                </box>
 
395
                                <textElement>
 
396
                                        <font isBold="true"/>
 
397
                                </textElement>
 
398
                                <text><![CDATA[Total]]></text>
 
399
                        </staticText>
 
400
                </band>
 
401
        </columnHeader>
 
402
        <detail>
 
403
                <band height="13">
 
404
                        <textField>
 
405
                                <reportElement style="Row" x="0" y="0" width="99" height="13"/>
 
406
                                <box>
 
407
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
408
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
409
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
410
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
411
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
412
                                </box>
 
413
                                <textElement>
 
414
                                        <font size="8"/>
 
415
                                </textElement>
 
416
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Producto-producto}]]></textFieldExpression>
 
417
                        </textField>
 
418
                        <elementGroup>
 
419
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="false">
 
420
                                        <reportElement style="Row" x="99" y="0" width="49" height="13"/>
 
421
                                        <box>
 
422
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
423
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
424
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
425
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
426
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
427
                                        </box>
 
428
                                        <textElement textAlignment="Right">
 
429
                                                <font size="8"/>
 
430
                                        </textElement>
 
431
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Enero-enero} != null ? $F{Enero-enero} : $V{Cero}]]></textFieldExpression>
 
432
                                </textField>
 
433
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
434
                                        <reportElement style="Row" x="148" y="0" width="49" height="13"/>
 
435
                                        <box>
 
436
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
437
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
438
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
439
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
440
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
441
                                        </box>
 
442
                                        <textElement textAlignment="Right">
 
443
                                                <font size="8" isBold="false"/>
 
444
                                        </textElement>
 
445
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Febrero-febrero} != null ? $F{Febrero-febrero} : $V{Cero}]]></textFieldExpression>
 
446
                                </textField>
 
447
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
448
                                        <reportElement style="Row" x="197" y="0" width="49" height="13"/>
 
449
                                        <box>
 
450
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
451
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
452
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
453
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
454
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
455
                                        </box>
 
456
                                        <textElement textAlignment="Right">
 
457
                                                <font size="8"/>
 
458
                                        </textElement>
 
459
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Marzo-marzo} != null ? $F{Marzo-marzo} : $V{Cero}]]></textFieldExpression>
 
460
                                </textField>
 
461
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
462
                                        <reportElement style="Row" x="246" y="0" width="49" height="13"/>
 
463
                                        <box>
 
464
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
465
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
466
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
467
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
468
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
469
                                        </box>
 
470
                                        <textElement textAlignment="Right">
 
471
                                                <font size="8"/>
 
472
                                        </textElement>
 
473
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Abril-abril} != null ? $F{Abril-abril} : $V{Cero}]]></textFieldExpression>
 
474
                                </textField>
 
475
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
476
                                        <reportElement style="Row" x="295" y="0" width="49" height="13"/>
 
477
                                        <box>
 
478
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
479
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
480
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
481
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
482
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
483
                                        </box>
 
484
                                        <textElement textAlignment="Right">
 
485
                                                <font size="8"/>
 
486
                                        </textElement>
 
487
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Mayo-mayo} != null ? $F{Mayo-mayo} : $V{Cero}]]></textFieldExpression>
 
488
                                </textField>
 
489
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
490
                                        <reportElement style="Row" x="344" y="0" width="49" height="13"/>
 
491
                                        <box>
 
492
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
493
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
494
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
495
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
496
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
497
                                        </box>
 
498
                                        <textElement textAlignment="Right">
 
499
                                                <font size="8"/>
 
500
                                        </textElement>
 
501
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Junio-junio} != null ? $F{Junio-junio} : $V{Cero}]]></textFieldExpression>
 
502
                                </textField>
 
503
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
504
                                        <reportElement style="Row" x="393" y="0" width="49" height="13"/>
 
505
                                        <box>
 
506
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
507
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
508
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
509
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
510
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
511
                                        </box>
 
512
                                        <textElement textAlignment="Right">
 
513
                                                <font size="8"/>
 
514
                                        </textElement>
 
515
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Julio-julio} != null ? $F{Julio-julio} : $V{Cero}]]></textFieldExpression>
 
516
                                </textField>
 
517
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
518
                                        <reportElement style="Row" x="442" y="0" width="49" height="13"/>
 
519
                                        <box>
 
520
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
521
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
522
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
523
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
524
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
525
                                        </box>
 
526
                                        <textElement textAlignment="Right">
 
527
                                                <font size="8"/>
 
528
                                        </textElement>
 
529
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Agosto-agosto} != null ? $F{Agosto-agosto} : $V{Cero}]]></textFieldExpression>
 
530
                                </textField>
 
531
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
532
                                        <reportElement style="Row" x="491" y="0" width="49" height="13"/>
 
533
                                        <box>
 
534
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
535
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
536
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
537
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
538
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
539
                                        </box>
 
540
                                        <textElement textAlignment="Right">
 
541
                                                <font size="8"/>
 
542
                                        </textElement>
 
543
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Septiembre-septiembre} != null ? $F{Septiembre-septiembre} : $V{Cero}]]></textFieldExpression>
 
544
                                </textField>
 
545
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
546
                                        <reportElement style="Row" x="540" y="0" width="49" height="13"/>
 
547
                                        <box>
 
548
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
549
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
550
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
551
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
552
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
553
                                        </box>
 
554
                                        <textElement textAlignment="Right">
 
555
                                                <font size="8"/>
 
556
                                        </textElement>
 
557
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Octubre-octubre} != null ? $F{Octubre-octubre} : $V{Cero}]]></textFieldExpression>
 
558
                                </textField>
 
559
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
560
                                        <reportElement style="Row" x="589" y="0" width="49" height="13"/>
 
561
                                        <box>
 
562
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
563
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
564
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
565
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
566
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
567
                                        </box>
 
568
                                        <textElement textAlignment="Right">
 
569
                                                <font size="8"/>
 
570
                                        </textElement>
 
571
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Noviembre-noviembre} != null ? $F{Noviembre-noviembre} : $V{Cero}]]></textFieldExpression>
 
572
                                </textField>
 
573
                                <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
574
                                        <reportElement style="Row" x="638" y="0" width="50" height="13"/>
 
575
                                        <box>
 
576
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
577
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
578
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
579
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
580
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
581
                                        </box>
 
582
                                        <textElement textAlignment="Right">
 
583
                                                <font size="8"/>
 
584
                                        </textElement>
 
585
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Diciembre-diciembre} != null ? $F{Diciembre-diciembre} : $V{Cero}]]></textFieldExpression>
 
586
                                </textField>
 
587
                        </elementGroup>
 
588
                        <textField pattern="#,##0">
 
589
                                <reportElement style="Row" x="688" y="0" width="64" height="13"/>
 
590
                                <box>
 
591
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
592
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
593
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
594
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
595
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
596
                                </box>
 
597
                                <textElement textAlignment="Right">
 
598
                                        <font size="8"/>
 
599
                                </textElement>
 
600
                                <textFieldExpression class="java.lang.Double"><![CDATA[$F{Total-total} != null ? $F{Total-total} : $V{Cero}]]></textFieldExpression>
 
601
                        </textField>
 
602
                </band>
 
603
        </detail>
 
604
        <columnFooter>
 
605
                <band height="13" splitType="Prevent">
 
606
                        <textField pattern="#,##0" isBlankWhenNull="true">
 
607
                                <reportElement x="99" y="0" width="49" height="13"/>
 
608
                                <box>
 
609
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
610
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
611
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
612
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
613
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
614
                                </box>
 
615
                                <textElement textAlignment="Right">
 
616
                                        <font size="8"/>
 
617
                                </textElement>
 
618
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Enero-enero_1} != null ? $V{Enero-enero_1} : $V{Cero}]]></textFieldExpression>
 
619
                        </textField>
 
620
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
621
                                <reportElement x="148" y="0" width="49" height="13"/>
 
622
                                <box>
 
623
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
624
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
625
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
626
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
627
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
628
                                </box>
 
629
                                <textElement textAlignment="Right">
 
630
                                        <font size="8"/>
 
631
                                </textElement>
 
632
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Febrero-febrero_1} != null ? $V{Febrero-febrero_1} : $V{Cero}]]></textFieldExpression>
 
633
                        </textField>
 
634
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
635
                                <reportElement x="197" y="0" width="49" height="13"/>
 
636
                                <box>
 
637
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
638
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
639
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
640
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
641
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
642
                                </box>
 
643
                                <textElement textAlignment="Right">
 
644
                                        <font size="8"/>
 
645
                                </textElement>
 
646
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Marzo-marzo_1} != null ? $V{Marzo-marzo_1} : $V{Cero}]]></textFieldExpression>
 
647
                        </textField>
 
648
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
649
                                <reportElement x="246" y="0" width="49" height="13"/>
 
650
                                <box>
 
651
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
652
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
653
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
654
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
655
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
656
                                </box>
 
657
                                <textElement textAlignment="Right">
 
658
                                        <font size="8"/>
 
659
                                </textElement>
 
660
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Abril-abril_1} != null ? $V{Abril-abril_1} : $V{Cero}]]></textFieldExpression>
 
661
                        </textField>
 
662
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
663
                                <reportElement x="295" y="0" width="49" height="13"/>
 
664
                                <box>
 
665
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
666
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
667
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
668
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
669
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
670
                                </box>
 
671
                                <textElement textAlignment="Right">
 
672
                                        <font size="8" isBold="false"/>
 
673
                                </textElement>
 
674
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Mayo-mayo_1} != null ? $V{Mayo-mayo_1} : $V{Cero}]]></textFieldExpression>
 
675
                        </textField>
 
676
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
677
                                <reportElement x="344" y="0" width="49" height="13"/>
 
678
                                <box>
 
679
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
680
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
681
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
682
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
683
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
684
                                </box>
 
685
                                <textElement textAlignment="Right">
 
686
                                        <font size="8"/>
 
687
                                </textElement>
 
688
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Junio-junio_1} != null ? $V{Junio-junio_1} : $V{Cero}]]></textFieldExpression>
 
689
                        </textField>
 
690
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
691
                                <reportElement x="393" y="0" width="49" height="13"/>
 
692
                                <box>
 
693
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
694
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
695
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
696
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
697
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
698
                                </box>
 
699
                                <textElement textAlignment="Right">
 
700
                                        <font size="8"/>
 
701
                                </textElement>
 
702
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Julio-julio_1} != null ? $V{Julio-julio_1} : $V{Cero}]]></textFieldExpression>
 
703
                        </textField>
 
704
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
705
                                <reportElement x="442" y="0" width="49" height="13"/>
 
706
                                <box>
 
707
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
708
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
709
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
710
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
711
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
712
                                </box>
 
713
                                <textElement textAlignment="Right">
 
714
                                        <font size="8"/>
 
715
                                </textElement>
 
716
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Agosto-agosto_1} != null ? $V{Agosto-agosto_1} : $V{Cero}]]></textFieldExpression>
 
717
                        </textField>
 
718
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
719
                                <reportElement x="491" y="0" width="49" height="13"/>
 
720
                                <box>
 
721
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
722
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
723
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
724
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
725
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
726
                                </box>
 
727
                                <textElement textAlignment="Right">
 
728
                                        <font size="8"/>
 
729
                                </textElement>
 
730
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Septiembre-septiembre_1} != null ? $V{Septiembre-septiembre_1} : $V{Cero}]]></textFieldExpression>
 
731
                        </textField>
 
732
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
733
                                <reportElement x="540" y="0" width="49" height="13"/>
 
734
                                <box>
 
735
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
736
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
737
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
738
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
739
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
740
                                </box>
 
741
                                <textElement textAlignment="Right">
 
742
                                        <font size="8"/>
 
743
                                </textElement>
 
744
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Octubre-octubre_1} != null ? $V{Octubre-octubre_1} : $V{Cero}]]></textFieldExpression>
 
745
                        </textField>
 
746
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
747
                                <reportElement x="589" y="0" width="49" height="13"/>
 
748
                                <box>
 
749
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
750
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
751
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
752
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
753
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
754
                                </box>
 
755
                                <textElement textAlignment="Right">
 
756
                                        <font size="8"/>
 
757
                                </textElement>
 
758
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Noviembre-noviembre_1} != null ? $V{Noviembre-noviembre_1} : $V{Cero}]]></textFieldExpression>
 
759
                        </textField>
 
760
                        <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
 
761
                                <reportElement x="638" y="0" width="50" height="13"/>
 
762
                                <box>
 
763
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
764
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
765
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
766
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
767
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
768
                                </box>
 
769
                                <textElement textAlignment="Right">
 
770
                                        <font size="8"/>
 
771
                                </textElement>
 
772
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Diciembre-diciembre_1} != null ? $V{Diciembre-diciembre_1} : $V{Cero}]]></textFieldExpression>
 
773
                        </textField>
 
774
                        <textField pattern="#,##0">
 
775
                                <reportElement x="688" y="0" width="64" height="13"/>
 
776
                                <box>
 
777
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
778
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
779
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
780
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
781
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
782
                                </box>
 
783
                                <textElement textAlignment="Right">
 
784
                                        <font size="8"/>
 
785
                                </textElement>
 
786
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Total-total_2} != null ? $V{Total-total_2} : $V{Cero}]]></textFieldExpression>
 
787
                        </textField>
 
788
                </band>
 
789
        </columnFooter>
 
790
        <pageFooter>
 
791
                <band height="17">
 
792
                        <textField>
 
793
                                <reportElement mode="Opaque" x="0" y="4" width="712" height="13" backcolor="#E6E6E6"/>
 
794
                                <textElement textAlignment="Right">
 
795
                                        <font size="8"/>
 
796
                                </textElement>
 
797
                                <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
 
798
                        </textField>
 
799
                        <textField evaluationTime="Report">
 
800
                                <reportElement mode="Opaque" x="712" y="4" width="40" height="13" backcolor="#E6E6E6"/>
 
801
                                <textElement>
 
802
                                        <font size="8"/>
 
803
                                </textElement>
 
804
                                <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
 
805
                        </textField>
 
806
                        <textField pattern="EEEEE dd MMMMM yyyy">
 
807
                                <reportElement x="0" y="4" width="100" height="13"/>
 
808
                                <textElement>
 
809
                                        <font size="8"/>
 
810
                                </textElement>
 
811
                                <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
812
                        </textField>
 
813
                </band>
 
814
        </pageFooter>
 
815
        <summary>
 
816
                <band height="572">
 
817
                        <lineChart>
 
818
                                <chart>
 
819
                                        <reportElement x="0" y="0" width="752" height="572"/>
 
820
                                        <chartTitle color="#006699">
 
821
                                                <font size="8" isBold="true"/>
 
822
                                        </chartTitle>
 
823
                                        <chartSubtitle>
 
824
                                                <font size="8"/>
 
825
                                        </chartSubtitle>
 
826
                                        <chartLegend>
 
827
                                                <font size="8" isPdfEmbedded="true"/>
 
828
                                        </chartLegend>
 
829
                                </chart>
 
830
                                <categoryDataset>
 
831
                                        <categorySeries>
 
832
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
833
                                                <categoryExpression><![CDATA["Enero"]]></categoryExpression>
 
834
                                                <valueExpression><![CDATA[$F{Enero-enero} != null ? $F{Enero-enero} : $V{Cero}]]></valueExpression>
 
835
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
836
                                        </categorySeries>
 
837
                                        <categorySeries>
 
838
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
839
                                                <categoryExpression><![CDATA["Febrero"]]></categoryExpression>
 
840
                                                <valueExpression><![CDATA[$F{Febrero-febrero} != null ? $F{Febrero-febrero} : $V{Cero}]]></valueExpression>
 
841
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
842
                                        </categorySeries>
 
843
                                        <categorySeries>
 
844
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
845
                                                <categoryExpression><![CDATA["Marzo"]]></categoryExpression>
 
846
                                                <valueExpression><![CDATA[$F{Marzo-marzo} != null ? $F{Marzo-marzo} : $V{Cero}]]></valueExpression>
 
847
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
848
                                        </categorySeries>
 
849
                                        <categorySeries>
 
850
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
851
                                                <categoryExpression><![CDATA["Abril"]]></categoryExpression>
 
852
                                                <valueExpression><![CDATA[$F{Abril-abril} != null ? $F{Abril-abril} : $V{Cero}]]></valueExpression>
 
853
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
854
                                        </categorySeries>
 
855
                                        <categorySeries>
 
856
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
857
                                                <categoryExpression><![CDATA["Mayo"]]></categoryExpression>
 
858
                                                <valueExpression><![CDATA[$F{Mayo-mayo} != null ? $F{Mayo-mayo} : $V{Cero}]]></valueExpression>
 
859
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
860
                                        </categorySeries>
 
861
                                        <categorySeries>
 
862
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
863
                                                <categoryExpression><![CDATA["Junio"]]></categoryExpression>
 
864
                                                <valueExpression><![CDATA[$F{Junio-junio} != null ? $F{Junio-junio} : $V{Cero}]]></valueExpression>
 
865
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
866
                                        </categorySeries>
 
867
                                        <categorySeries>
 
868
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
869
                                                <categoryExpression><![CDATA["Julio"]]></categoryExpression>
 
870
                                                <valueExpression><![CDATA[$F{Julio-julio} != null ? $F{Julio-julio} : $V{Cero}]]></valueExpression>
 
871
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
872
                                        </categorySeries>
 
873
                                        <categorySeries>
 
874
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
875
                                                <categoryExpression><![CDATA["Agosto"]]></categoryExpression>
 
876
                                                <valueExpression><![CDATA[$F{Agosto-agosto} != null ? $F{Agosto-agosto} : $V{Cero}]]></valueExpression>
 
877
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
878
                                        </categorySeries>
 
879
                                        <categorySeries>
 
880
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
881
                                                <categoryExpression><![CDATA["Septiembre"]]></categoryExpression>
 
882
                                                <valueExpression><![CDATA[$F{Septiembre-septiembre} != null ? $F{Septiembre-septiembre} : $V{Cero}]]></valueExpression>
 
883
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
884
                                        </categorySeries>
 
885
                                        <categorySeries>
 
886
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
887
                                                <categoryExpression><![CDATA["Octubre"]]></categoryExpression>
 
888
                                                <valueExpression><![CDATA[$F{Octubre-octubre} != null ? $F{Octubre-octubre} : $V{Cero}]]></valueExpression>
 
889
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
890
                                        </categorySeries>
 
891
                                        <categorySeries>
 
892
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
893
                                                <categoryExpression><![CDATA["Noviembre"]]></categoryExpression>
 
894
                                                <valueExpression><![CDATA[$F{Noviembre-noviembre} != null ? $F{Noviembre-noviembre} : $V{Cero}]]></valueExpression>
 
895
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
896
                                        </categorySeries>
 
897
                                        <categorySeries>
 
898
                                                <seriesExpression><![CDATA[$F{Producto-producto}]]></seriesExpression>
 
899
                                                <categoryExpression><![CDATA["Diciembre"]]></categoryExpression>
 
900
                                                <valueExpression><![CDATA[$F{Diciembre-diciembre} != null ? $F{Diciembre-diciembre} : $V{Cero}]]></valueExpression>
 
901
                                                <labelExpression><![CDATA[$F{Producto-producto}]]></labelExpression>
 
902
                                        </categorySeries>
 
903
                                </categoryDataset>
 
904
                                <linePlot>
 
905
                                        <plot/>
 
906
                                        <categoryAxisFormat>
 
907
                                                <axisFormat>
 
908
                                                        <labelFont>
 
909
                                                                <font size="8"/>
 
910
                                                        </labelFont>
 
911
                                                        <tickLabelFont>
 
912
                                                                <font size="8"/>
 
913
                                                        </tickLabelFont>
 
914
                                                </axisFormat>
 
915
                                        </categoryAxisFormat>
 
916
                                        <valueAxisFormat>
 
917
                                                <axisFormat>
 
918
                                                        <labelFont/>
 
919
                                                        <tickLabelFont>
 
920
                                                                <font size="8"/>
 
921
                                                        </tickLabelFont>
 
922
                                                </axisFormat>
 
923
                                        </valueAxisFormat>
 
924
                                </linePlot>
 
925
                        </lineChart>
 
926
                </band>
 
927
        </summary>
 
928
</jasperReport>