← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/sale_by_month1.1.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/sale_by_month1.1.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="sale_by_month1.1" language="groovy" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
 
3
        <property name="ireport.zoom" value="2.0"/>
 
4
        <property name="ireport.x" value="453"/>
 
5
        <property name="ireport.y" value="27"/>
 
6
        <queryString language="xPath">
 
7
                <![CDATA[/data/record]]>
 
8
        </queryString>
 
9
        <field name="id-id" class="java.lang.Integer">
 
10
                <fieldDescription><![CDATA[id-id]]></fieldDescription>
 
11
        </field>
 
12
        <field name="Month-name" class="java.lang.String">
 
13
                <fieldDescription><![CDATA[Month-name]]></fieldDescription>
 
14
        </field>
 
15
        <field name="Total_Sale-total_sale" class="java.lang.Double">
 
16
                <fieldDescription><![CDATA[Total_Sale-total_sale]]></fieldDescription>
 
17
        </field>
 
18
        <variable name="Cero" class="java.lang.Double">
 
19
                <variableExpression><![CDATA[0.0]]></variableExpression>
 
20
                <initialValueExpression><![CDATA[0.0]]></initialValueExpression>
 
21
        </variable>
 
22
        <variable name="Total_Sale-total_sale_1" class="java.lang.Double" resetType="Column" calculation="Sum">
 
23
                <variableExpression><![CDATA[$F{Total_Sale-total_sale}]]></variableExpression>
 
24
        </variable>
 
25
        <background>
 
26
                <band splitType="Stretch"/>
 
27
        </background>
 
28
        <title>
 
29
                <band height="25">
 
30
                        <frame>
 
31
                                <reportElement mode="Opaque" x="-20" y="-20" width="612" height="45" backcolor="#006699"/>
 
32
                                <staticText>
 
33
                                        <reportElement x="20" y="10" width="148" height="35" forecolor="#FFFFFF"/>
 
34
                                        <textElement textAlignment="Center">
 
35
                                                <font size="10" isBold="true"/>
 
36
                                        </textElement>
 
37
                                        <text><![CDATA[Minerales y Carbones
 
38
de México]]></text>
 
39
                                </staticText>
 
40
                                <staticText>
 
41
                                        <reportElement x="380" y="10" width="212" height="35" forecolor="#FFFFFF"/>
 
42
                                        <textElement textAlignment="Center">
 
43
                                                <font size="10" isBold="false"/>
 
44
                                        </textElement>
 
45
                                        <text><![CDATA[Reporte de ventas mensuales
 
46
por cliente]]></text>
 
47
                                </staticText>
 
48
                        </frame>
 
49
                </band>
 
50
        </title>
 
51
        <pageHeader>
 
52
                <band height="10" splitType="Stretch"/>
 
53
        </pageHeader>
 
54
        <columnHeader>
 
55
                <band height="12" splitType="Stretch">
 
56
                        <staticText>
 
57
                                <reportElement mode="Opaque" x="138" y="0" width="150" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
58
                                <box>
 
59
                                        <pen lineWidth="0.25" lineStyle="Dotted"/>
 
60
                                        <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
61
                                        <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
62
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted"/>
 
63
                                        <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
64
                                </box>
 
65
                                <textElement>
 
66
                                        <font isBold="true"/>
 
67
                                </textElement>
 
68
                                <text><![CDATA[Mes]]></text>
 
69
                        </staticText>
 
70
                        <staticText>
 
71
                                <reportElement mode="Opaque" x="288" y="0" width="100" height="12" forecolor="#006699" backcolor="#E6E6E6"/>
 
72
                                <box>
 
73
                                        <pen lineWidth="0.25" lineStyle="Dotted"/>
 
74
                                        <topPen lineWidth="0.25" lineStyle="Dotted"/>
 
75
                                        <leftPen lineWidth="0.25" lineStyle="Dotted"/>
 
76
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted"/>
 
77
                                        <rightPen lineWidth="0.25" lineStyle="Dotted"/>
 
78
                                </box>
 
79
                                <textElement>
 
80
                                        <font isBold="true"/>
 
81
                                </textElement>
 
82
                                <text><![CDATA[Venta]]></text>
 
83
                        </staticText>
 
84
                </band>
 
85
        </columnHeader>
 
86
        <detail>
 
87
                <band height="13" splitType="Stretch">
 
88
                        <textField>
 
89
                                <reportElement x="138" y="0" width="150" height="13"/>
 
90
                                <box>
 
91
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
92
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
93
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
94
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
95
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
96
                                </box>
 
97
                                <textElement>
 
98
                                        <font size="10"/>
 
99
                                </textElement>
 
100
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{Month-name}]]></textFieldExpression>
 
101
                        </textField>
 
102
                        <textField pattern="#,##0">
 
103
                                <reportElement x="288" y="0" width="100" height="13"/>
 
104
                                <box>
 
105
                                        <pen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
106
                                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
107
                                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
108
                                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
109
                                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#5E93F2"/>
 
110
                                </box>
 
111
                                <textElement textAlignment="Right">
 
112
                                        <font isBold="false"/>
 
113
                                </textElement>
 
114
                                <textFieldExpression class="java.lang.Double"><![CDATA[$F{Total_Sale-total_sale} != null ? $F{Total_Sale-total_sale} : $V{Cero}]]></textFieldExpression>
 
115
                        </textField>
 
116
                </band>
 
117
        </detail>
 
118
        <columnFooter>
 
119
                <band height="12" splitType="Stretch">
 
120
                        <textField>
 
121
                                <reportElement x="289" y="0" width="100" height="12"/>
 
122
                                <box>
 
123
                                        <pen lineWidth="0.25" lineColor="#5E93F2"/>
 
124
                                        <topPen lineWidth="0.25" lineColor="#5E93F2"/>
 
125
                                        <leftPen lineWidth="0.25" lineColor="#5E93F2"/>
 
126
                                        <bottomPen lineWidth="0.25" lineColor="#5E93F2"/>
 
127
                                        <rightPen lineWidth="0.25" lineColor="#5E93F2"/>
 
128
                                </box>
 
129
                                <textElement textAlignment="Right"/>
 
130
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{Total_Sale-total_sale_1} != null ? $V{Total_Sale-total_sale_1} : $V{Cero}]]></textFieldExpression>
 
131
                        </textField>
 
132
                </band>
 
133
        </columnFooter>
 
134
        <pageFooter>
 
135
                <band height="5" splitType="Stretch"/>
 
136
        </pageFooter>
 
137
        <summary>
 
138
                <band height="250" splitType="Stretch">
 
139
                        <bar3DChart>
 
140
                                <chart>
 
141
                                        <reportElement x="0" y="0" width="572" height="250"/>
 
142
                                        <chartTitle/>
 
143
                                        <chartSubtitle/>
 
144
                                        <chartLegend/>
 
145
                                </chart>
 
146
                                <categoryDataset>
 
147
                                        <categorySeries>
 
148
                                                <seriesExpression><![CDATA["Ventas"]]></seriesExpression>
 
149
                                                <categoryExpression><![CDATA[$F{Month-name}]]></categoryExpression>
 
150
                                                <valueExpression><![CDATA[$F{Total_Sale-total_sale}]]></valueExpression>
 
151
                                        </categorySeries>
 
152
                                </categoryDataset>
 
153
                                <bar3DPlot>
 
154
                                        <plot/>
 
155
                                        <itemLabel color="#000000" backgroundColor="#FFFFFF"/>
 
156
                                        <categoryAxisFormat>
 
157
                                                <axisFormat>
 
158
                                                        <labelFont/>
 
159
                                                        <tickLabelFont/>
 
160
                                                </axisFormat>
 
161
                                        </categoryAxisFormat>
 
162
                                        <valueAxisFormat>
 
163
                                                <axisFormat>
 
164
                                                        <labelFont/>
 
165
                                                        <tickLabelFont/>
 
166
                                                </axisFormat>
 
167
                                        </valueAxisFormat>
 
168
                                </bar3DPlot>
 
169
                        </bar3DChart>
 
170
                </band>
 
171
        </summary>
 
172
</jasperReport>