565
by root
se agregao los jaspers a ignore list |
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>
|