← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/xls_book.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_book.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="xls_book" language="groovy" pageWidth="1044" pageHeight="1008" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="1004" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isTitleNewPage="true" isFloatColumnFooter="true" isIgnorePagination="true">
 
3
        <property name="ireport.zoom" value="0.6830134553650715"/>
 
4
        <property name="ireport.x" value="0"/>
 
5
        <property name="ireport.y" value="463"/>
 
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="Gas"/>
 
12
        <property name="net.sf.jasperreports.export.xls.sheet.names.sheet2" value="Producion"/>
 
13
        <property name="net.sf.jasperreports.export.xls.sheet.names.sheet3" value="Entradas"/>
 
14
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
 
15
                <defaultValueExpression><![CDATA["/home/miguelmiguel/Escritorio/jasper_xml/jrxml/jrxml/produccion/"]]></defaultValueExpression>
 
16
        </parameter>
 
17
        <parameter name="pqty_1" class="java.lang.String">
 
18
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
19
        </parameter>
 
20
        <parameter name="pqty_2" class="java.lang.String">
 
21
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
22
        </parameter>
 
23
        <parameter name="pqty_3" class="java.lang.String">
 
24
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
25
        </parameter>
 
26
        <parameter name="pqty_4" class="java.lang.String">
 
27
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
28
        </parameter>
 
29
        <parameter name="pqty_5" class="java.lang.String">
 
30
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
31
        </parameter>
 
32
        <parameter name="pqty_6" class="java.lang.String">
 
33
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
34
        </parameter>
 
35
        <parameter name="pqty_7" class="java.lang.String">
 
36
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
37
        </parameter>
 
38
        <parameter name="pqty_8" class="java.lang.String">
 
39
                <defaultValueExpression><![CDATA["vacio"]]></defaultValueExpression>
 
40
        </parameter>
 
41
        <parameter name="production_id" class="java.lang.Integer">
 
42
                <defaultValueExpression><![CDATA[12]]></defaultValueExpression>
 
43
        </parameter>
 
44
        <parameter name="location_id" class="java.lang.Integer">
 
45
                <defaultValueExpression><![CDATA[1]]></defaultValueExpression>
 
46
        </parameter>
 
47
        <parameter name="fiscalyear_id" class="java.lang.Integer">
 
48
                <defaultValueExpression><![CDATA[3]]></defaultValueExpression>
 
49
        </parameter>
 
50
        <parameter name="user_name" class="java.lang.String">
 
51
                <defaultValueExpression><![CDATA["Miguel Miguel"]]></defaultValueExpression>
 
52
        </parameter>
 
53
        <parameter name="report_name" class="java.lang.String">
 
54
                <defaultValueExpression><![CDATA["Excel"]]></defaultValueExpression>
 
55
        </parameter>
 
56
        <parameter name="company_name" class="java.lang.String">
 
57
                <defaultValueExpression><![CDATA["Minerales y Carbones de Mexico"]]></defaultValueExpression>
 
58
        </parameter>
 
59
        <parameter name="report_subname" class="java.lang.String"/>
 
60
        <parameter name="fiscalyear_name" class="java.lang.String"/>
 
61
        <queryString>
 
62
                <![CDATA[SELECT * FROM get_production_sheet('{''G'',''P'',''E'',''S'',''I''}')
 
63
AS ("sheet" character varying);]]>
 
64
        </queryString>
 
65
        <field name="sheet" class="java.lang.String"/>
 
66
        <group name="sheet" isStartNewPage="true" isResetPageNumber="true" minHeightToStartNewPage="1700">
 
67
                <groupExpression><![CDATA[$F{sheet}]]></groupExpression>
 
68
        </group>
 
69
        <background>
 
70
                <band splitType="Stretch"/>
 
71
        </background>
 
72
        <title>
 
73
                <band height="568">
 
74
                        <frame>
 
75
                                <reportElement mode="Opaque" x="-1" y="0" width="225" height="80" backcolor="#3D8EC5"/>
 
76
                        </frame>
 
77
                        <textField>
 
78
                                <reportElement x="62" y="0" width="162" height="80" forecolor="#FFFFFF"/>
 
79
                                <box>
 
80
                                        <leftPen lineWidth="0.25"/>
 
81
                                </box>
 
82
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
83
                                        <font size="25" isBold="true"/>
 
84
                                </textElement>
 
85
                                <textFieldExpression class="java.lang.String"><![CDATA["[" + $P{fiscalyear_name} + "]"]]></textFieldExpression>
 
86
                        </textField>
 
87
                        <textField>
 
88
                                <reportElement x="62" y="80" width="162" height="26"/>
 
89
                                <box>
 
90
                                        <leftPen lineWidth="0.25"/>
 
91
                                </box>
 
92
                                <textElement verticalAlignment="Middle"/>
 
93
                                <textFieldExpression class="java.lang.String"><![CDATA[$P{company_name}]]></textFieldExpression>
 
94
                        </textField>
 
95
                        <textField>
 
96
                                <reportElement x="62" y="106" width="162" height="29"/>
 
97
                                <box>
 
98
                                        <leftPen lineWidth="0.25"/>
 
99
                                </box>
 
100
                                <textElement verticalAlignment="Middle"/>
 
101
                                <textFieldExpression class="java.lang.String"><![CDATA[$P{user_name}]]></textFieldExpression>
 
102
                        </textField>
 
103
                        <frame>
 
104
                                <reportElement x="0" y="437" width="968" height="78"/>
 
105
                                <textField>
 
106
                                        <reportElement x="0" y="0" width="968" height="52"/>
 
107
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
108
                                                <font size="30" isBold="true"/>
 
109
                                        </textElement>
 
110
                                        <textFieldExpression class="java.lang.String"><![CDATA["[" + $P{report_name} + "]"]]></textFieldExpression>
 
111
                                </textField>
 
112
                                <textField bookmarkLevel="1">
 
113
                                        <reportElement x="0" y="52" width="968" height="26"/>
 
114
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
115
                                                <font isBold="true"/>
 
116
                                        </textElement>
 
117
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{report_subname}]]></textFieldExpression>
 
118
                                        <anchorNameExpression><![CDATA["Portada"]]></anchorNameExpression>
 
119
                                </textField>
 
120
                        </frame>
 
121
                </band>
 
122
        </title>
 
123
        <pageHeader>
 
124
                <band splitType="Stretch"/>
 
125
        </pageHeader>
 
126
        <columnHeader>
 
127
                <band splitType="Stretch"/>
 
128
        </columnHeader>
 
129
        <detail>
 
130
                <band height="169">
 
131
                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('G')]]></printWhenExpression>
 
132
                        <textField bookmarkLevel="1">
 
133
                                <reportElement x="0" y="0" width="968" height="20"/>
 
134
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
135
                                        <font isBold="true"/>
 
136
                                </textElement>
 
137
                                <textFieldExpression class="java.lang.String"><![CDATA["Consumo de GAS"]]></textFieldExpression>
 
138
                                <anchorNameExpression><![CDATA["Consumo de GAS"]]></anchorNameExpression>
 
139
                        </textField>
 
140
                        <subreport isUsingCache="true">
 
141
                                <reportElement x="0" y="20" width="968" height="148" printWhenGroupChanges="sheet">
 
142
                                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('G')]]></printWhenExpression>
 
143
                                </reportElement>
 
144
                                <subreportParameter name="fiscalyear_id">
 
145
                                        <subreportParameterExpression><![CDATA[$P{fiscalyear_id}]]></subreportParameterExpression>
 
146
                                </subreportParameter>
 
147
                                <subreportParameter name="report_subname">
 
148
                                        <subreportParameterExpression><![CDATA[$P{report_subname}]]></subreportParameterExpression>
 
149
                                </subreportParameter>
 
150
                                <subreportParameter name="report_name">
 
151
                                        <subreportParameterExpression><![CDATA[$P{report_name}]]></subreportParameterExpression>
 
152
                                </subreportParameter>
 
153
                                <subreportParameter name="production_id">
 
154
                                        <subreportParameterExpression><![CDATA[$P{production_id}]]></subreportParameterExpression>
 
155
                                </subreportParameter>
 
156
                                <subreportParameter name="location_id">
 
157
                                        <subreportParameterExpression><![CDATA[$P{location_id}]]></subreportParameterExpression>
 
158
                                </subreportParameter>
 
159
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 
160
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "xls_sheet2.jasper"]]></subreportExpression>
 
161
                        </subreport>
 
162
                </band>
 
163
                <band height="175">
 
164
                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('P')]]></printWhenExpression>
 
165
                        <textField bookmarkLevel="1">
 
166
                                <reportElement x="0" y="0" width="968" height="20"/>
 
167
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
168
                                        <font isBold="true"/>
 
169
                                </textElement>
 
170
                                <textFieldExpression class="java.lang.String"><![CDATA["Produccion"]]></textFieldExpression>
 
171
                                <anchorNameExpression><![CDATA["Produccion"]]></anchorNameExpression>
 
172
                        </textField>
 
173
                        <subreport>
 
174
                                <reportElement x="0" y="20" width="968" height="155" printWhenGroupChanges="sheet">
 
175
                                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('P')]]></printWhenExpression>
 
176
                                </reportElement>
 
177
                                <subreportParameter name="fiscalyear_id">
 
178
                                        <subreportParameterExpression><![CDATA[$P{fiscalyear_id}]]></subreportParameterExpression>
 
179
                                </subreportParameter>
 
180
                                <subreportParameter name="location_id">
 
181
                                        <subreportParameterExpression><![CDATA[$P{location_id}]]></subreportParameterExpression>
 
182
                                </subreportParameter>
 
183
                                <subreportParameter name="user_name">
 
184
                                        <subreportParameterExpression><![CDATA[$P{user_name}]]></subreportParameterExpression>
 
185
                                </subreportParameter>
 
186
                                <subreportParameter name="company_name">
 
187
                                        <subreportParameterExpression><![CDATA[$P{company_name}]]></subreportParameterExpression>
 
188
                                </subreportParameter>
 
189
                                <subreportParameter name="report_subname">
 
190
                                        <subreportParameterExpression><![CDATA[$P{report_subname}]]></subreportParameterExpression>
 
191
                                </subreportParameter>
 
192
                                <subreportParameter name="report_name">
 
193
                                        <subreportParameterExpression><![CDATA[$P{report_name}]]></subreportParameterExpression>
 
194
                                </subreportParameter>
 
195
                                <subreportParameter name="pqty_2">
 
196
                                        <subreportParameterExpression><![CDATA[$P{pqty_2}]]></subreportParameterExpression>
 
197
                                </subreportParameter>
 
198
                                <subreportParameter name="pqty_1">
 
199
                                        <subreportParameterExpression><![CDATA[$P{pqty_1}]]></subreportParameterExpression>
 
200
                                </subreportParameter>
 
201
                                <subreportParameter name="pqty_4">
 
202
                                        <subreportParameterExpression><![CDATA[$P{pqty_4}]]></subreportParameterExpression>
 
203
                                </subreportParameter>
 
204
                                <subreportParameter name="pqty_3">
 
205
                                        <subreportParameterExpression><![CDATA[$P{pqty_3}]]></subreportParameterExpression>
 
206
                                </subreportParameter>
 
207
                                <subreportParameter name="pqty_6">
 
208
                                        <subreportParameterExpression><![CDATA[$P{pqty_6}]]></subreportParameterExpression>
 
209
                                </subreportParameter>
 
210
                                <subreportParameter name="pqty_5">
 
211
                                        <subreportParameterExpression><![CDATA[$P{pqty_5}]]></subreportParameterExpression>
 
212
                                </subreportParameter>
 
213
                                <subreportParameter name="pqty_8">
 
214
                                        <subreportParameterExpression><![CDATA[$P{pqty_8}]]></subreportParameterExpression>
 
215
                                </subreportParameter>
 
216
                                <subreportParameter name="production_id">
 
217
                                        <subreportParameterExpression><![CDATA[$P{production_id}]]></subreportParameterExpression>
 
218
                                </subreportParameter>
 
219
                                <subreportParameter name="pqty_7">
 
220
                                        <subreportParameterExpression><![CDATA[$P{pqty_7}]]></subreportParameterExpression>
 
221
                                </subreportParameter>
 
222
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 
223
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "xls_sheet1.jasper"]]></subreportExpression>
 
224
                        </subreport>
 
225
                </band>
 
226
                <band height="149">
 
227
                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('E')]]></printWhenExpression>
 
228
                        <textField bookmarkLevel="1">
 
229
                                <reportElement x="0" y="0" width="968" height="20"/>
 
230
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
231
                                        <font isBold="true"/>
 
232
                                </textElement>
 
233
                                <textFieldExpression class="java.lang.String"><![CDATA["Entradas"]]></textFieldExpression>
 
234
                                <anchorNameExpression><![CDATA["Entradas"]]></anchorNameExpression>
 
235
                        </textField>
 
236
                        <subreport>
 
237
                                <reportElement x="-1" y="20" width="969" height="129" printWhenGroupChanges="sheet">
 
238
                                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('E')]]></printWhenExpression>
 
239
                                </reportElement>
 
240
                                <subreportParameter name="production_id">
 
241
                                        <subreportParameterExpression><![CDATA[$P{production_id}]]></subreportParameterExpression>
 
242
                                </subreportParameter>
 
243
                                <subreportParameter name="location_id">
 
244
                                        <subreportParameterExpression><![CDATA[$P{location_id}]]></subreportParameterExpression>
 
245
                                </subreportParameter>
 
246
                                <subreportParameter name="fiscalyear_id">
 
247
                                        <subreportParameterExpression><![CDATA[$P{fiscalyear_id}]]></subreportParameterExpression>
 
248
                                </subreportParameter>
 
249
                                <subreportParameter name="report_subname">
 
250
                                        <subreportParameterExpression><![CDATA[$P{report_subname}]]></subreportParameterExpression>
 
251
                                </subreportParameter>
 
252
                                <subreportParameter name="report_name">
 
253
                                        <subreportParameterExpression><![CDATA[$P{report_name}]]></subreportParameterExpression>
 
254
                                </subreportParameter>
 
255
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 
256
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "xls_sheet3.jasper"]]></subreportExpression>
 
257
                        </subreport>
 
258
                </band>
 
259
                <band height="149">
 
260
                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('S')]]></printWhenExpression>
 
261
                        <textField bookmarkLevel="1">
 
262
                                <reportElement x="0" y="0" width="968" height="20"/>
 
263
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
264
                                        <font isBold="true"/>
 
265
                                </textElement>
 
266
                                <textFieldExpression class="java.lang.String"><![CDATA["Salidas"]]></textFieldExpression>
 
267
                                <anchorNameExpression><![CDATA["Salidas"]]></anchorNameExpression>
 
268
                        </textField>
 
269
                        <subreport>
 
270
                                <reportElement x="-1" y="20" width="969" height="129" printWhenGroupChanges="sheet">
 
271
                                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('S')]]></printWhenExpression>
 
272
                                </reportElement>
 
273
                                <subreportParameter name="production_id">
 
274
                                        <subreportParameterExpression><![CDATA[$P{production_id}]]></subreportParameterExpression>
 
275
                                </subreportParameter>
 
276
                                <subreportParameter name="location_id">
 
277
                                        <subreportParameterExpression><![CDATA[$P{location_id}]]></subreportParameterExpression>
 
278
                                </subreportParameter>
 
279
                                <subreportParameter name="fiscalyear_id">
 
280
                                        <subreportParameterExpression><![CDATA[$P{fiscalyear_id}]]></subreportParameterExpression>
 
281
                                </subreportParameter>
 
282
                                <subreportParameter name="report_subname">
 
283
                                        <subreportParameterExpression><![CDATA[$P{report_subname}]]></subreportParameterExpression>
 
284
                                </subreportParameter>
 
285
                                <subreportParameter name="report_name">
 
286
                                        <subreportParameterExpression><![CDATA[$P{report_name}]]></subreportParameterExpression>
 
287
                                </subreportParameter>
 
288
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 
289
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "xls_sheet4.jasper"]]></subreportExpression>
 
290
                        </subreport>
 
291
                </band>
 
292
                <band height="149">
 
293
                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('I')]]></printWhenExpression>
 
294
                        <textField bookmarkLevel="1">
 
295
                                <reportElement x="0" y="0" width="968" height="20"/>
 
296
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
297
                                        <font isBold="true"/>
 
298
                                </textElement>
 
299
                                <textFieldExpression class="java.lang.String"><![CDATA["Resumen Inventario"]]></textFieldExpression>
 
300
                                <anchorNameExpression><![CDATA["Resumen Inventario"]]></anchorNameExpression>
 
301
                        </textField>
 
302
                        <subreport>
 
303
                                <reportElement x="-1" y="20" width="969" height="129" printWhenGroupChanges="sheet">
 
304
                                        <printWhenExpression><![CDATA[$F{sheet}.equalsIgnoreCase('I')]]></printWhenExpression>
 
305
                                </reportElement>
 
306
                                <subreportParameter name="production_id">
 
307
                                        <subreportParameterExpression><![CDATA[$P{production_id}]]></subreportParameterExpression>
 
308
                                </subreportParameter>
 
309
                                <subreportParameter name="location_id">
 
310
                                        <subreportParameterExpression><![CDATA[$P{location_id}]]></subreportParameterExpression>
 
311
                                </subreportParameter>
 
312
                                <subreportParameter name="fiscalyear_id">
 
313
                                        <subreportParameterExpression><![CDATA[$P{fiscalyear_id}]]></subreportParameterExpression>
 
314
                                </subreportParameter>
 
315
                                <subreportParameter name="report_subname">
 
316
                                        <subreportParameterExpression><![CDATA[$P{report_subname}]]></subreportParameterExpression>
 
317
                                </subreportParameter>
 
318
                                <subreportParameter name="report_name">
 
319
                                        <subreportParameterExpression><![CDATA[$P{report_name}]]></subreportParameterExpression>
 
320
                                </subreportParameter>
 
321
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 
322
                                <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "xls_sheet5.jasper"]]></subreportExpression>
 
323
                        </subreport>
 
324
                </band>
 
325
        </detail>
 
326
        <columnFooter>
 
327
                <band splitType="Stretch"/>
 
328
        </columnFooter>
 
329
        <pageFooter>
 
330
                <band splitType="Stretch"/>
 
331
        </pageFooter>
 
332
        <summary>
 
333
                <band splitType="Stretch"/>
 
334
        </summary>
 
335
</jasperReport>