← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/certificado_lines_2.jrxml

  • Committer: root
  • Date: 2012-02-16 23:07:06 UTC
  • Revision ID: root@minerales-20120216230706-12theuc0i4uxeics
se quito el jasper repots de la distro

Show diffs side-by-side

added added

removed removed

Lines of Context:
jasper_reports/custom_reports/certificado_lines_2.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="Calidad" language="groovy" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
3
 
        <property name="ireport.zoom" value="1.2100000000000033"/>
4
 
        <property name="ireport.x" value="0"/>
5
 
        <property name="ireport.y" value="242"/>
6
 
        <property name="OPENERP_RELATIONS" value="[&apos;certificate_line_id&apos;]"/>
7
 
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
8
 
                <defaultValueExpression><![CDATA["/home/miguelmiguel/Escritorio/jasper_xml/jrxml/"]]></defaultValueExpression>
9
 
        </parameter>
10
 
        <parameter name="ID" class="java.lang.String">
11
 
                <parameterDescription><![CDATA[]]></parameterDescription>
12
 
                <defaultValueExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}.get("IDS").toString()[1]]]></defaultValueExpression>
13
 
        </parameter>
14
 
        <queryString language="xPath">
15
 
                <![CDATA[/data/record]]>
16
 
        </queryString>
17
 
        <field name="Referencia-name" class="java.lang.String">
18
 
                <fieldDescription><![CDATA[/data/record/Referencia-name]]></fieldDescription>
19
 
        </field>
20
 
        <field name="Fecha-date" class="java.lang.String">
21
 
                <fieldDescription><![CDATA[Fecha-date]]></fieldDescription>
22
 
        </field>
23
 
        <field name="Cliente" class="java.lang.String">
24
 
                <fieldDescription><![CDATA[Cliente-partner_id/Nombre-name]]></fieldDescription>
25
 
        </field>
26
 
        <field name="producto" class="java.lang.String">
27
 
                <fieldDescription><![CDATA[Producto-product_id/Plantilla_de_producto-product_tmpl_id/Nombre-name]]></fieldDescription>
28
 
        </field>
29
 
        <field name="cantidad" class="java.lang.String">
30
 
                <fieldDescription><![CDATA[Peso_Estimado-product_qty]]></fieldDescription>
31
 
        </field>
32
 
        <field name="udem" class="java.lang.String">
33
 
                <fieldDescription><![CDATA[/data/record/ID_de_Movimiento-stock_move_id/UdM_del_producto-product_uom/Nombre-name]]></fieldDescription>
34
 
        </field>
35
 
        <field name="Transportista" class="java.lang.String">
36
 
                <fieldDescription><![CDATA[Fletero-carrier_id/Transportista-name]]></fieldDescription>
37
 
        </field>
38
 
        <field name="lote" class="java.lang.String">
39
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/ID_de_Certificado-certificate_id/No_de_Lote-product_lot_num]]></fieldDescription>
40
 
        </field>
41
 
        <field name="move" class="java.lang.String">
42
 
                <fieldDescription><![CDATA[ID_de_Movimiento-stock_move_id/Albaran-picking_id/Referencia-name]]></fieldDescription>
43
 
        </field>
44
 
        <field name="Fecah_de_Impresion-print_date" class="java.lang.String">
45
 
                <fieldDescription><![CDATA[/data/record/Fecah_de_Impresion-print_date]]></fieldDescription>
46
 
        </field>
47
 
        <field name="user" class="java.lang.String">
48
 
                <fieldDescription><![CDATA[User-User/Nombre-name]]></fieldDescription>
49
 
        </field>
50
 
        <field name="Data-datas" class="java.lang.String">
51
 
                <fieldDescription><![CDATA[Attachments-Attachments/Data-datas]]></fieldDescription>
52
 
        </field>
53
 
        <field name="lineas" class="java.lang.String">
54
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/Nombre-name]]></fieldDescription>
55
 
        </field>
56
 
        <field name="id-certificado" class="java.lang.String">
57
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/ID_de_Certificado-certificate_id/id]]></fieldDescription>
58
 
        </field>
59
 
        <field name="param_cantidad" class="java.lang.String">
60
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/Cant._Parametro-parameter_qty]]></fieldDescription>
61
 
        </field>
62
 
        <field name="Cant._Parametro-parameter_qty" class="java.lang.String">
63
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/ID_de_Certificado-certificate_id/Lineas_de_Certificado-certificate_line_id/Cant._Parametro-parameter_qty]]></fieldDescription>
64
 
        </field>
65
 
        <field name="ID_de_Certificado-certificate_id" class="java.lang.String">
66
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/ID_de_Certificado-certificate_id/Lineas_de_Certificado-certificate_line_id/ID_de_Certificado-certificate_id]]></fieldDescription>
67
 
        </field>
68
 
        <field name="Cant._Parametro-parameter_qty2" class="java.lang.String">
69
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/ID_de_Certificado-certificate_id/Lineas_de_Certificado-certificate_line_id/Cant._Parametro-parameter_qty]]></fieldDescription>
70
 
        </field>
71
 
        <field name="Cant._Parametro-parameter_qty3" class="java.lang.String">
72
 
                <fieldDescription><![CDATA[Lineas_de_Certificado-certificate_line_id/Cant._Parametro-parameter_qty]]></fieldDescription>
73
 
        </field>
74
 
        <variable name="param_cantidad_1" class="java.lang.Integer" calculation="Count">
75
 
                <variableExpression><![CDATA[$F{param_cantidad}]]></variableExpression>
76
 
        </variable>
77
 
        <variable name="Cant._Parametro-parameter_qty_1" class="java.lang.Integer" calculation="Count">
78
 
                <variableExpression><![CDATA[$F{Cant._Parametro-parameter_qty}]]></variableExpression>
79
 
        </variable>
80
 
        <background>
81
 
                <band splitType="Stretch"/>
82
 
        </background>
83
 
        <title>
84
 
                <band height="90" splitType="Stretch">
85
 
                        <staticText>
86
 
                                <reportElement x="536" y="50" width="36" height="20"/>
87
 
                                <box>
88
 
                                        <topPen lineWidth="0.25"/>
89
 
                                        <leftPen lineWidth="0.25"/>
90
 
                                        <rightPen lineWidth="0.25"/>
91
 
                                </box>
92
 
                                <textElement textAlignment="Center" verticalAlignment="Middle"/>
93
 
                                <text><![CDATA[Folio:]]></text>
94
 
                        </staticText>
95
 
                        <textField>
96
 
                                <reportElement x="536" y="70" width="36" height="20"/>
97
 
                                <box>
98
 
                                        <pen lineWidth="0.25"/>
99
 
                                        <topPen lineWidth="0.25"/>
100
 
                                        <leftPen lineWidth="0.25"/>
101
 
                                        <bottomPen lineWidth="0.25"/>
102
 
                                        <rightPen lineWidth="0.25"/>
103
 
                                </box>
104
 
                                <textElement textAlignment="Center" verticalAlignment="Middle"/>
105
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Referencia-name}]]></textFieldExpression>
106
 
                        </textField>
107
 
                        <image scaleImage="FillFrame">
108
 
                                <reportElement x="0" y="0" width="223" height="50"/>
109
 
                                <imageExpression class="java.lang.String"><![CDATA["logo_mcm1.gif"]]></imageExpression>
110
 
                        </image>
111
 
                </band>
112
 
        </title>
113
 
        <pageHeader>
114
 
                <band height="99" splitType="Stretch">
115
 
                        <staticText>
116
 
                                <reportElement x="0" y="14" width="100" height="12"/>
117
 
                                <textElement/>
118
 
                                <text><![CDATA[FECHA]]></text>
119
 
                        </staticText>
120
 
                        <staticText>
121
 
                                <reportElement x="0" y="27" width="100" height="12"/>
122
 
                                <textElement/>
123
 
                                <text><![CDATA[CLIENTE]]></text>
124
 
                        </staticText>
125
 
                        <staticText>
126
 
                                <reportElement x="372" y="14" width="100" height="12"/>
127
 
                                <textElement/>
128
 
                                <text><![CDATA[REMISION]]></text>
129
 
                        </staticText>
130
 
                        <staticText>
131
 
                                <reportElement x="0" y="40" width="100" height="12"/>
132
 
                                <textElement/>
133
 
                                <text><![CDATA[PRODUCTO]]></text>
134
 
                        </staticText>
135
 
                        <staticText>
136
 
                                <reportElement x="372" y="40" width="100" height="12"/>
137
 
                                <textElement/>
138
 
                                <text><![CDATA[NO.LOTE]]></text>
139
 
                        </staticText>
140
 
                        <staticText>
141
 
                                <reportElement x="0" y="53" width="100" height="12"/>
142
 
                                <textElement/>
143
 
                                <text><![CDATA[U. DE MEDIDA]]></text>
144
 
                        </staticText>
145
 
                        <staticText>
146
 
                                <reportElement x="372" y="53" width="100" height="12"/>
147
 
                                <textElement/>
148
 
                                <text><![CDATA[CANT. ESTIMADA]]></text>
149
 
                        </staticText>
150
 
                        <staticText>
151
 
                                <reportElement x="0" y="66" width="100" height="12"/>
152
 
                                <textElement/>
153
 
                                <text><![CDATA[TRANSPORTISTA]]></text>
154
 
                        </staticText>
155
 
                        <textField>
156
 
                                <reportElement x="100" y="14" width="272" height="12"/>
157
 
                                <box>
158
 
                                        <bottomPen lineWidth="0.25"/>
159
 
                                </box>
160
 
                                <textElement verticalAlignment="Middle"/>
161
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Fecha-date}]]></textFieldExpression>
162
 
                        </textField>
163
 
                        <textField>
164
 
                                <reportElement x="100" y="27" width="472" height="12"/>
165
 
                                <box>
166
 
                                        <bottomPen lineWidth="0.25"/>
167
 
                                </box>
168
 
                                <textElement verticalAlignment="Middle"/>
169
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Cliente}]]></textFieldExpression>
170
 
                        </textField>
171
 
                        <textField>
172
 
                                <reportElement x="100" y="40" width="272" height="12"/>
173
 
                                <box>
174
 
                                        <bottomPen lineWidth="0.25"/>
175
 
                                </box>
176
 
                                <textElement verticalAlignment="Middle"/>
177
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{producto}]]></textFieldExpression>
178
 
                        </textField>
179
 
                        <textField>
180
 
                                <reportElement x="472" y="53" width="100" height="12"/>
181
 
                                <box>
182
 
                                        <bottomPen lineWidth="0.25"/>
183
 
                                </box>
184
 
                                <textElement verticalAlignment="Middle"/>
185
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{cantidad}]]></textFieldExpression>
186
 
                        </textField>
187
 
                        <textField>
188
 
                                <reportElement x="100" y="53" width="272" height="12"/>
189
 
                                <box>
190
 
                                        <bottomPen lineWidth="0.25"/>
191
 
                                </box>
192
 
                                <textElement verticalAlignment="Middle"/>
193
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{udem}]]></textFieldExpression>
194
 
                        </textField>
195
 
                        <textField>
196
 
                                <reportElement x="100" y="66" width="472" height="12"/>
197
 
                                <box>
198
 
                                        <bottomPen lineWidth="0.25"/>
199
 
                                </box>
200
 
                                <textElement verticalAlignment="Middle"/>
201
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Transportista}]]></textFieldExpression>
202
 
                        </textField>
203
 
                        <textField>
204
 
                                <reportElement x="472" y="14" width="100" height="12"/>
205
 
                                <box>
206
 
                                        <bottomPen lineWidth="0.25"/>
207
 
                                </box>
208
 
                                <textElement verticalAlignment="Middle"/>
209
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{move}]]></textFieldExpression>
210
 
                        </textField>
211
 
                        <textField>
212
 
                                <reportElement x="472" y="40" width="100" height="12"/>
213
 
                                <box>
214
 
                                        <bottomPen lineWidth="0.25"/>
215
 
                                </box>
216
 
                                <textElement verticalAlignment="Middle"/>
217
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{lote}]]></textFieldExpression>
218
 
                        </textField>
219
 
                </band>
220
 
        </pageHeader>
221
 
        <columnHeader>
222
 
                <band height="10" splitType="Stretch"/>
223
 
        </columnHeader>
224
 
        <detail>
225
 
                <band height="62" splitType="Stretch">
226
 
                        <textField>
227
 
                                <reportElement x="312" y="0" width="241" height="20"/>
228
 
                                <textElement/>
229
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Cant._Parametro-parameter_qty}]]></textFieldExpression>
230
 
                        </textField>
231
 
                        <textField>
232
 
                                <reportElement x="0" y="42" width="209" height="20"/>
233
 
                                <textElement/>
234
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Cant._Parametro-parameter_qty3}]]></textFieldExpression>
235
 
                        </textField>
236
 
                </band>
237
 
        </detail>
238
 
        <columnFooter>
239
 
                <band height="93" splitType="Stretch">
240
 
                        <image>
241
 
                                <reportElement x="89" y="9" width="92" height="78"/>
242
 
                                <imageExpression class="java.lang.String"><![CDATA["firma.gif"]]></imageExpression>
243
 
                        </image>
244
 
                        <staticText>
245
 
                                <reportElement x="43" y="76" width="166" height="16"/>
246
 
                                <textElement textAlignment="Center">
247
 
                                        <font isBold="true"/>
248
 
                                </textElement>
249
 
                                <text><![CDATA[Vo Bo]]></text>
250
 
                        </staticText>
251
 
                        <textField>
252
 
                                <reportElement x="390" y="60" width="145" height="16"/>
253
 
                                <box>
254
 
                                        <bottomPen lineWidth="0.25"/>
255
 
                                </box>
256
 
                                <textElement textAlignment="Center"/>
257
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{user}]]></textFieldExpression>
258
 
                        </textField>
259
 
                        <staticText>
260
 
                                <reportElement x="390" y="76" width="145" height="16"/>
261
 
                                <textElement textAlignment="Center">
262
 
                                        <font isBold="true"/>
263
 
                                </textElement>
264
 
                                <text><![CDATA[CONTROL DE CALIDAD]]></text>
265
 
                        </staticText>
266
 
                        <staticText>
267
 
                                <reportElement x="43" y="60" width="166" height="16"/>
268
 
                                <box>
269
 
                                        <bottomPen lineWidth="0.25"/>
270
 
                                </box>
271
 
                                <textElement textAlignment="Center"/>
272
 
                                <text><![CDATA[Gabriel Estrada]]></text>
273
 
                        </staticText>
274
 
                </band>
275
 
        </columnFooter>
276
 
        <pageFooter>
277
 
                <band height="35" splitType="Stretch">
278
 
                        <staticText>
279
 
                                <reportElement x="0" y="0" width="572" height="25"/>
280
 
                                <textElement textAlignment="Center">
281
 
                                        <font size="8"/>
282
 
                                </textElement>
283
 
                                <text><![CDATA[Minerales y Carbones de Mexico, S.A. de C.V.
284
 
Tel (81) 83 76 08 40]]></text>
285
 
                        </staticText>
286
 
                        <textField>
287
 
                                <reportElement x="0" y="16" width="572" height="19"/>
288
 
                                <textElement textAlignment="Center">
289
 
                                        <font size="8"/>
290
 
                                </textElement>
291
 
                                <textFieldExpression class="java.lang.String"><![CDATA["Contact : " + $F{user}]]></textFieldExpression>
292
 
                        </textField>
293
 
                </band>
294
 
        </pageFooter>
295
 
        <summary>
296
 
                <band splitType="Stretch"/>
297
 
        </summary>
298
 
</jasperReport>