← 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_mensuales1.5.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_mensuales1.5.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_mensuales1.5" 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.5"/>
 
4
        <property name="ireport.x" value="0"/>
 
5
        <property name="ireport.y" value="115"/>
 
6
        <queryString language="SQL">
 
7
                <![CDATA[SELECT * from  getInvoiceMonth()]]>
 
8
        </queryString>
 
9
        <field name="anio" class="java.lang.Integer"/>
 
10
        <field name="mes" class="java.lang.String"/>
 
11
        <field name="subtotal" class="java.lang.Double"/>
 
12
        <background>
 
13
                <band splitType="Stretch"/>
 
14
        </background>
 
15
        <title>
 
16
                <band height="41" splitType="Stretch">
 
17
                        <staticText>
 
18
                                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="752" height="41" forecolor="#FFFFFF" backcolor="#C0C0C0"/>
 
19
                                <textElement textAlignment="Center" verticalAlignment="Middle"/>
 
20
                                <text><![CDATA[Reporte de Ventas Mensuales
 
21
 
 
22
Minerales y Carbones de México S.A de C.V]]></text>
 
23
                        </staticText>
 
24
                </band>
 
25
        </title>
 
26
        <pageHeader>
 
27
                <band height="14" splitType="Stretch"/>
 
28
        </pageHeader>
 
29
        <columnHeader>
 
30
                <band height="12" splitType="Stretch">
 
31
                        <staticText>
 
32
                                <reportElement mode="Opaque" x="0" y="0" width="144" height="12" forecolor="#FFFFFF" backcolor="#404040"/>
 
33
                                <textElement/>
 
34
                                <text><![CDATA[mes]]></text>
 
35
                        </staticText>
 
36
                        <staticText>
 
37
                                <reportElement mode="Opaque" x="144" y="0" width="159" height="12" forecolor="#FFFFFF" backcolor="#404040"/>
 
38
                                <textElement/>
 
39
                                <text><![CDATA[subtotal]]></text>
 
40
                        </staticText>
 
41
                </band>
 
42
        </columnHeader>
 
43
        <detail>
 
44
                <band height="12" splitType="Stretch">
 
45
                        <elementGroup>
 
46
                                <textField pattern="#,##0.00">
 
47
                                        <reportElement x="144" y="0" width="159" height="12"/>
 
48
                                        <box>
 
49
                                                <pen lineWidth="0.25"/>
 
50
                                                <topPen lineWidth="0.25"/>
 
51
                                                <leftPen lineWidth="0.25"/>
 
52
                                                <bottomPen lineWidth="0.25"/>
 
53
                                                <rightPen lineWidth="0.25"/>
 
54
                                        </box>
 
55
                                        <textElement/>
 
56
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{subtotal}]]></textFieldExpression>
 
57
                                </textField>
 
58
                                <textField>
 
59
                                        <reportElement x="0" y="0" width="144" height="12"/>
 
60
                                        <box>
 
61
                                                <pen lineWidth="0.25"/>
 
62
                                                <topPen lineWidth="0.25"/>
 
63
                                                <leftPen lineWidth="0.25"/>
 
64
                                                <bottomPen lineWidth="0.25"/>
 
65
                                                <rightPen lineWidth="0.25"/>
 
66
                                        </box>
 
67
                                        <textElement/>
 
68
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{mes}]]></textFieldExpression>
 
69
                                </textField>
 
70
                        </elementGroup>
 
71
                </band>
 
72
        </detail>
 
73
        <columnFooter>
 
74
                <band splitType="Stretch"/>
 
75
        </columnFooter>
 
76
        <pageFooter>
 
77
                <band height="12" splitType="Stretch"/>
 
78
        </pageFooter>
 
79
        <lastPageFooter>
 
80
                <band height="12"/>
 
81
        </lastPageFooter>
 
82
        <summary>
 
83
                <band height="164" splitType="Stretch">
 
84
                        <bar3DChart>
 
85
                                <chart>
 
86
                                        <reportElement x="0" y="0" width="752" height="164"/>
 
87
                                        <chartTitle/>
 
88
                                        <chartSubtitle/>
 
89
                                        <chartLegend/>
 
90
                                </chart>
 
91
                                <categoryDataset>
 
92
                                        <categorySeries>
 
93
                                                <seriesExpression><![CDATA["Ventas Mensuales"]]></seriesExpression>
 
94
                                                <categoryExpression><![CDATA[$F{mes}]]></categoryExpression>
 
95
                                                <valueExpression><![CDATA[$F{subtotal}]]></valueExpression>
 
96
                                        </categorySeries>
 
97
                                </categoryDataset>
 
98
                                <bar3DPlot>
 
99
                                        <plot/>
 
100
                                        <itemLabel color="#000000" backgroundColor="#FFFFFF"/>
 
101
                                        <categoryAxisFormat>
 
102
                                                <axisFormat>
 
103
                                                        <labelFont/>
 
104
                                                        <tickLabelFont/>
 
105
                                                </axisFormat>
 
106
                                        </categoryAxisFormat>
 
107
                                        <valueAxisFormat>
 
108
                                                <axisFormat>
 
109
                                                        <labelFont/>
 
110
                                                        <tickLabelFont/>
 
111
                                                </axisFormat>
 
112
                                        </valueAxisFormat>
 
113
                                </bar3DPlot>
 
114
                        </bar3DChart>
 
115
                </band>
 
116
        </summary>
 
117
</jasperReport>