← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/report_entradas_mensuales2.jrxml

  • Committer: root
  • Date: 2012-02-17 17:29:00 UTC
  • mfrom: (564.1.1 addons_mx)
  • Revision ID: root@minerales-20120217172900-o0tqaj0bnt95lk3w
 cambios en jasper

Show diffs side-by-side

added added

removed removed

Lines of Context:
jasper_reports/custom_reports/report_entradas_mensuales2.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="report_entradas_mensuales" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="0" isFloatColumnFooter="true" isIgnorePagination="true">
3
 
        <property name="ireport.zoom" value="1.7715610000000017"/>
4
 
        <property name="ireport.x" value="0"/>
5
 
        <property name="ireport.y" value="46"/>
6
 
        <style name="Title" fontName="SansSerif" fontSize="21" isBold="true" pdfFontName="Helvetica-Bold"/>
7
 
        <style name="SubTitle" forecolor="#666666" fontName="SansSerif" fontSize="13"/>
8
 
        <style name="Column header" forecolor="#FFFFFF" fill="Solid" fontName="SansSerif" fontSize="10" isBold="true">
9
 
                <pen lineWidth="0.25" lineStyle="Dotted"/>
10
 
                <box>
11
 
                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#C15E5E"/>
12
 
                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#C15E5E"/>
13
 
                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#C15E5E"/>
14
 
                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#C15E5E"/>
15
 
                </box>
16
 
        </style>
17
 
        <style name="Detail" fill="Solid" fontName="SansSerif" fontSize="11">
18
 
                <box>
19
 
                        <topPen lineWidth="0.25" lineStyle="Dotted" lineColor="#D63A3A"/>
20
 
                        <leftPen lineWidth="0.25" lineStyle="Dotted" lineColor="#D63A3A"/>
21
 
                        <bottomPen lineWidth="0.25" lineStyle="Dotted" lineColor="#D63A3A"/>
22
 
                        <rightPen lineWidth="0.25" lineStyle="Dotted" lineColor="#D63A3A"/>
23
 
                </box>
24
 
        </style>
25
 
        <parameter name="company_name" class="java.lang.String"/>
26
 
        <parameter name="report_name" class="java.lang.String"/>
27
 
        <parameter name="user_name" class="java.lang.String"/>
28
 
        <queryString>
29
 
                <![CDATA[SELECT name_ubicacion, product, SUM(product_qty) AS product_qty,  SUM(costs) AS costs, sum(cump) AS cump FROM report_monthly_purchases GROUP BY name_ubicacion, product ORDER BY name_ubicacion;]]>
30
 
        </queryString>
31
 
        <field name="name_ubicacion" class="java.lang.String"/>
32
 
        <field name="product" class="java.lang.String"/>
33
 
        <field name="product_qty" class="java.lang.Double"/>
34
 
        <field name="costs" class="java.lang.Double"/>
35
 
        <field name="cump" class="java.lang.Double"/>
36
 
        <background>
37
 
                <band splitType="Stretch"/>
38
 
        </background>
39
 
        <title>
40
 
                <band height="104" splitType="Stretch">
41
 
                        <textField>
42
 
                                <reportElement style="Title" x="118" y="0" width="684" height="58"/>
43
 
                                <textElement textAlignment="Right" verticalAlignment="Middle">
44
 
                                        <font size="20" isBold="false"/>
45
 
                                </textElement>
46
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$P{company_name}]]></textFieldExpression>
47
 
                        </textField>
48
 
                        <textField>
49
 
                                <reportElement style="SubTitle" x="118" y="58" width="684" height="23"/>
50
 
                                <textElement textAlignment="Right" verticalAlignment="Middle">
51
 
                                        <font size="12"/>
52
 
                                </textElement>
53
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$P{report_name}]]></textFieldExpression>
54
 
                        </textField>
55
 
                        <image scaleImage="FillFrame">
56
 
                                <reportElement x="0" y="4" width="118" height="77"/>
57
 
                                <imageExpression class="java.lang.String"><![CDATA["logo_mcm.gif"]]></imageExpression>
58
 
                        </image>
59
 
                        <textField>
60
 
                                <reportElement x="0" y="81" width="802" height="23"/>
61
 
                                <textElement textAlignment="Right" verticalAlignment="Middle"/>
62
 
                                <textFieldExpression class="java.lang.String"><![CDATA["Impreso por:  " + $P{user_name}]]></textFieldExpression>
63
 
                        </textField>
64
 
                </band>
65
 
        </title>
66
 
        <pageHeader>
67
 
                <band splitType="Stretch"/>
68
 
        </pageHeader>
69
 
        <columnHeader>
70
 
                <band height="15" splitType="Stretch">
71
 
                        <frame>
72
 
                                <reportElement mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#666666"/>
73
 
                                <staticText>
74
 
                                        <reportElement style="Column header" x="0" y="0" width="323" height="15"/>
75
 
                                        <box leftPadding="0" rightPadding="0"/>
76
 
                                        <textElement verticalAlignment="Middle">
77
 
                                                <font fontName="SansSerif" size="10"/>
78
 
                                        </textElement>
79
 
                                        <text><![CDATA[Ubicación]]></text>
80
 
                                </staticText>
81
 
                                <staticText>
82
 
                                        <reportElement style="Column header" x="323" y="0" width="205" height="15"/>
83
 
                                        <textElement verticalAlignment="Middle">
84
 
                                                <font fontName="SansSerif" size="10"/>
85
 
                                        </textElement>
86
 
                                        <text><![CDATA[Producto]]></text>
87
 
                                </staticText>
88
 
                                <staticText>
89
 
                                        <reportElement style="Column header" x="528" y="0" width="114" height="15"/>
90
 
                                        <textElement verticalAlignment="Middle">
91
 
                                                <font fontName="SansSerif" size="10"/>
92
 
                                        </textElement>
93
 
                                        <text><![CDATA[Cantidad]]></text>
94
 
                                </staticText>
95
 
                                <staticText>
96
 
                                        <reportElement style="Column header" x="642" y="0" width="78" height="15"/>
97
 
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
98
 
                                                <font fontName="SansSerif" size="10"/>
99
 
                                        </textElement>
100
 
                                        <text><![CDATA[Importe]]></text>
101
 
                                </staticText>
102
 
                                <staticText>
103
 
                                        <reportElement style="Column header" x="720" y="0" width="82" height="15"/>
104
 
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
105
 
                                                <font fontName="SansSerif" size="10"/>
106
 
                                        </textElement>
107
 
                                        <text><![CDATA[C. U.]]></text>
108
 
                                </staticText>
109
 
                        </frame>
110
 
                </band>
111
 
        </columnHeader>
112
 
        <detail>
113
 
                <band height="16" splitType="Stretch">
114
 
                        <frame>
115
 
                                <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="802" height="16" isPrintWhenDetailOverflows="true"/>
116
 
                                <textField>
117
 
                                        <reportElement style="Detail" x="0" y="0" width="323" height="16"/>
118
 
                                        <textElement verticalAlignment="Middle">
119
 
                                                <font size="9"/>
120
 
                                        </textElement>
121
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{name_ubicacion}]]></textFieldExpression>
122
 
                                </textField>
123
 
                                <textField>
124
 
                                        <reportElement style="Detail" x="323" y="0" width="205" height="16"/>
125
 
                                        <textElement verticalAlignment="Middle">
126
 
                                                <font size="9"/>
127
 
                                        </textElement>
128
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{product}]]></textFieldExpression>
129
 
                                </textField>
130
 
                                <textField pattern="#,##0.00">
131
 
                                        <reportElement style="Detail" x="528" y="0" width="114" height="16"/>
132
 
                                        <textElement verticalAlignment="Middle">
133
 
                                                <font size="9"/>
134
 
                                        </textElement>
135
 
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{product_qty}]]></textFieldExpression>
136
 
                                </textField>
137
 
                                <textField pattern="¤ #,##0.00">
138
 
                                        <reportElement style="Detail" x="642" y="0" width="78" height="16"/>
139
 
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
140
 
                                                <font size="9"/>
141
 
                                        </textElement>
142
 
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{costs}]]></textFieldExpression>
143
 
                                </textField>
144
 
                                <textField pattern="¤ #,##0.00">
145
 
                                        <reportElement style="Detail" x="720" y="0" width="82" height="16"/>
146
 
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
147
 
                                                <font size="9"/>
148
 
                                        </textElement>
149
 
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$F{cump}]]></textFieldExpression>
150
 
                                </textField>
151
 
                        </frame>
152
 
                </band>
153
 
        </detail>
154
 
        <columnFooter>
155
 
                <band splitType="Stretch"/>
156
 
        </columnFooter>
157
 
        <pageFooter>
158
 
                <band height="40" splitType="Stretch">
159
 
                        <textField pattern="EEEEE dd MMMMM yyyy">
160
 
                                <reportElement style="Column header" x="642" y="0" width="160" height="20" forecolor="#000000"/>
161
 
                                <textElement textAlignment="Right" verticalAlignment="Middle">
162
 
                                        <font size="9" isBold="false"/>
163
 
                                </textElement>
164
 
                                <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
165
 
                        </textField>
166
 
                        <textField>
167
 
                                <reportElement x="0" y="0" width="323" height="20"/>
168
 
                                <textElement verticalAlignment="Middle">
169
 
                                        <font size="9"/>
170
 
                                </textElement>
171
 
                                <textFieldExpression class="java.lang.String"><![CDATA[$P{report_name}]]></textFieldExpression>
172
 
                        </textField>
173
 
                </band>
174
 
        </pageFooter>
175
 
        <summary>
176
 
                <band splitType="Stretch"/>
177
 
        </summary>
178
 
</jasperReport>