← 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_acumulado.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_acumulado.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_importe_acumulado" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
 
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">
 
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
        <queryString language="xPath">
 
27
                <![CDATA[/data/record]]>
 
28
        </queryString>
 
29
        <field name="id-id" class="java.lang.Integer">
 
30
                <fieldDescription><![CDATA[id-id]]></fieldDescription>
 
31
        </field>
 
32
        <field name="Month-name" class="java.lang.String">
 
33
                <fieldDescription><![CDATA[Month-name]]></fieldDescription>
 
34
        </field>
 
35
        <field name="Total_Sale-total_sale" class="java.lang.Double">
 
36
                <fieldDescription><![CDATA[Total_Sale-total_sale]]></fieldDescription>
 
37
        </field>
 
38
        <field name="Nombre-name" class="java.lang.String">
 
39
                <fieldDescription><![CDATA[User-User/Nombre-name]]></fieldDescription>
 
40
        </field>
 
41
        <variable name="Cero" class="java.lang.Double">
 
42
                <variableExpression><![CDATA[0.0]]></variableExpression>
 
43
                <initialValueExpression><![CDATA[0.0]]></initialValueExpression>
 
44
        </variable>
 
45
        <variable name="Total_Sale-total_sale_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
46
                <variableExpression><![CDATA[$F{Total_Sale-total_sale}]]></variableExpression>
 
47
        </variable>
 
48
        <variable name="Total_Sale-total_sale_2" class="java.lang.Double" resetType="Column" calculation="Sum">
 
49
                <variableExpression><![CDATA[$F{Total_Sale-total_sale}]]></variableExpression>
 
50
        </variable>
 
51
        <variable name="Total_Sale-total_sale_3" class="java.lang.Double" resetType="Column" calculation="Sum">
 
52
                <variableExpression><![CDATA[$F{Total_Sale-total_sale}]]></variableExpression>
 
53
        </variable>
 
54
        <background>
 
55
                <band splitType="Stretch"/>
 
56
        </background>
 
57
        <title>
 
58
                <band height="35">
 
59
                        <frame>
 
60
                                <reportElement mode="Opaque" x="-20" y="-20" width="791" height="45" backcolor="#006699"/>
 
61
                                <staticText>
 
62
                                        <reportElement x="78" y="10" width="139" height="25" forecolor="#FFFFFF"/>
 
63
                                        <textElement textAlignment="Center">
 
64
                                                <font size="10" isBold="true"/>
 
65
                                        </textElement>
 
66
                                        <text><![CDATA[Minerales y Carbones de
 
67
México, S.A de C.V]]></text>
 
68
                                </staticText>
 
69
                                <textField>
 
70
                                        <reportElement x="538" y="10" width="93" height="10" forecolor="#FFFFFF"/>
 
71
                                        <textElement>
 
72
                                                <font size="8"/>
 
73
                                        </textElement>
 
74
                                        <textFieldExpression class="java.lang.String"><![CDATA["Fecha de Impresión: "]]></textFieldExpression>
 
75
                                </textField>
 
76
                                <textField pattern="dd/MM/yyyy">
 
77
                                        <reportElement x="631" y="10" width="54" height="10" forecolor="#FFFFFF"/>
 
78
                                        <textElement>
 
79
                                                <font size="8"/>
 
80
                                        </textElement>
 
81
                                        <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
82
                                </textField>
 
83
                                <textField pattern="h.mm.ss a">
 
84
                                        <reportElement x="685" y="10" width="62" height="10" forecolor="#FFFFFF"/>
 
85
                                        <textElement>
 
86
                                                <font size="8"/>
 
87
                                        </textElement>
 
88
                                        <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
89
                                </textField>
 
90
                                <textField>
 
91
                                        <reportElement x="538" y="20" width="209" height="10" forecolor="#FFFFFF"/>
 
92
                                        <textElement>
 
93
                                                <font size="8"/>
 
94
                                        </textElement>
 
95
                                        <textFieldExpression class="java.lang.String"><![CDATA["Por :  " + $F{Nombre-name}]]></textFieldExpression>
 
96
                                </textField>
 
97
                                <staticText>
 
98
                                        <reportElement x="286" y="15" width="189" height="15" forecolor="#FFFFFF"/>
 
99
                                        <textElement textAlignment="Center">
 
100
                                                <font size="9" isPdfEmbedded="false"/>
 
101
                                        </textElement>
 
102
                                        <text><![CDATA[Ventas Mensuales Importe]]></text>
 
103
                                </staticText>
 
104
                                <image scaleImage="FillFrame">
 
105
                                        <reportElement stretchType="RelativeToTallestObject" x="20" y="5" width="38" height="35"/>
 
106
                                        <imageExpression class="java.lang.String"><![CDATA["logo_mcm.gif"]]></imageExpression>
 
107
                                </image>
 
108
                        </frame>
 
109
                </band>
 
110
        </title>
 
111
        <pageHeader>
 
112
                <band height="10"/>
 
113
        </pageHeader>
 
114
        <columnHeader>
 
115
                <band height="12" splitType="Stretch">
 
116
                        <staticText>
 
117
                                <reportElement mode="Opaque" x="225" y="0" width="100" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
118
                                <box>
 
119
                                        <pen lineWidth="0.25" lineStyle="Dotted"/>
 
120
                                        <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
121
                                        <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
122
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted"/>
 
123
                                        <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
124
                                </box>
 
125
                                <textElement textAlignment="Center">
 
126
                                        <font isBold="true"/>
 
127
                                </textElement>
 
128
                                <text><![CDATA[Mes]]></text>
 
129
                        </staticText>
 
130
                        <staticText>
 
131
                                <reportElement mode="Opaque" x="325" y="0" width="100" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
132
                                <box>
 
133
                                        <pen lineWidth="0.25" lineStyle="Dotted"/>
 
134
                                        <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
135
                                        <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
136
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted"/>
 
137
                                        <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
138
                                </box>
 
139
                                <textElement textAlignment="Center">
 
140
                                        <font isBold="true"/>
 
141
                                </textElement>
 
142
                                <text><![CDATA[Venta]]></text>
 
143
                        </staticText>
 
144
                        <staticText>
 
145
                                <reportElement style="title" x="425" y="0" width="100" height="12"/>
 
146
                                <textElement textAlignment="Center">
 
147
                                        <font isBold="true"/>
 
148
                                </textElement>
 
149
                                <text><![CDATA[Acumulado]]></text>
 
150
                        </staticText>
 
151
                </band>
 
152
        </columnHeader>
 
153
        <detail>
 
154
                <band height="13">
 
155
                        <elementGroup>
 
156
                                <textField>
 
157
                                        <reportElement x="225" y="0" width="100" height="13"/>
 
158
                                        <box>
 
159
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
160
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
161
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
162
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
163
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
164
                                        </box>
 
165
                                        <textElement>
 
166
                                                <font size="10"/>
 
167
                                        </textElement>
 
168
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{Month-name}]]></textFieldExpression>
 
169
                                </textField>
 
170
                                <textField pattern="#,##0">
 
171
                                        <reportElement x="325" y="0" width="100" height="13"/>
 
172
                                        <box>
 
173
                                                <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
174
                                                <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
175
                                                <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
176
                                                <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
177
                                                <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
178
                                        </box>
 
179
                                        <textElement textAlignment="Right">
 
180
                                                <font isBold="false"/>
 
181
                                        </textElement>
 
182
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{Total_Sale-total_sale} != null ? $F{Total_Sale-total_sale} : $V{Cero}]]></textFieldExpression>
 
183
                                </textField>
 
184
                        </elementGroup>
 
185
                        <textField pattern="#,##0">
 
186
                                <reportElement x="425" y="0" width="100" height="13"/>
 
187
                                <box>
 
188
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
189
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
190
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
191
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
192
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
193
                                </box>
 
194
                                <textElement textAlignment="Right">
 
195
                                        <font isBold="true"/>
 
196
                                </textElement>
 
197
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Total_Sale-total_sale_1} != null ? $V{Total_Sale-total_sale_1} : $V{Cero}]]></textFieldExpression>
 
198
                        </textField>
 
199
                </band>
 
200
        </detail>
 
201
        <columnFooter>
 
202
                <band height="13" splitType="Prevent"/>
 
203
        </columnFooter>
 
204
        <pageFooter>
 
205
                <band height="17">
 
206
                        <textField>
 
207
                                <reportElement mode="Opaque" x="0" y="4" width="712" height="13" backcolor="#E6E6E6"/>
 
208
                                <textElement textAlignment="Right">
 
209
                                        <font size="8"/>
 
210
                                </textElement>
 
211
                                <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
 
212
                        </textField>
 
213
                        <textField evaluationTime="Report">
 
214
                                <reportElement mode="Opaque" x="712" y="4" width="40" height="13" backcolor="#E6E6E6"/>
 
215
                                <textElement>
 
216
                                        <font size="8"/>
 
217
                                </textElement>
 
218
                                <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
 
219
                        </textField>
 
220
                        <textField pattern="EEEEE dd MMMMM yyyy">
 
221
                                <reportElement x="0" y="4" width="100" height="13"/>
 
222
                                <textElement>
 
223
                                        <font size="8"/>
 
224
                                </textElement>
 
225
                                <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
226
                        </textField>
 
227
                </band>
 
228
        </pageFooter>
 
229
        <summary>
 
230
                <band height="250">
 
231
                        <bar3DChart>
 
232
                                <chart>
 
233
                                        <reportElement x="0" y="0" width="752" height="250"/>
 
234
                                        <chartTitle/>
 
235
                                        <chartSubtitle/>
 
236
                                        <chartLegend/>
 
237
                                </chart>
 
238
                                <categoryDataset>
 
239
                                        <categorySeries>
 
240
                                                <seriesExpression><![CDATA["Ventas"]]></seriesExpression>
 
241
                                                <categoryExpression><![CDATA[$F{Month-name}]]></categoryExpression>
 
242
                                                <valueExpression><![CDATA[$F{Total_Sale-total_sale}]]></valueExpression>
 
243
                                        </categorySeries>
 
244
                                </categoryDataset>
 
245
                                <bar3DPlot>
 
246
                                        <plot/>
 
247
                                        <itemLabel color="#000000" backgroundColor="#FFFFFF"/>
 
248
                                        <categoryAxisFormat>
 
249
                                                <axisFormat>
 
250
                                                        <labelFont/>
 
251
                                                        <tickLabelFont/>
 
252
                                                </axisFormat>
 
253
                                        </categoryAxisFormat>
 
254
                                        <valueAxisFormat>
 
255
                                                <axisFormat>
 
256
                                                        <labelFont/>
 
257
                                                        <tickLabelFont/>
 
258
                                                </axisFormat>
 
259
                                        </valueAxisFormat>
 
260
                                </bar3DPlot>
 
261
                        </bar3DChart>
 
262
                </band>
 
263
        </summary>
 
264
</jasperReport>