Context Navigation

reactiveRatio.jrxml @ 535

Last change on this file since 535 was 535, checked in by gav, 14 years ago
Improvements to Reactive Ratio Report.
File size: 17.6 KB

Line
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="reportName" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="782" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" isSummaryNewPage="true">
3	<property name="ireport.scriptlethandling" value="0"/>
4	<property name="ireport.encoding" value="UTF-8"/>
5	<property name="ireport.zoom" value="1.0"/>
6	<property name="ireport.x" value="0"/>
7	<property name="ireport.y" value="405"/>
8	<import value="java.util.*"/>
9	<import value="net.sf.jasperreports.engine.*"/>
10	<import value="net.sf.jasperreports.engine.data.*"/>
11	<style name="table" isDefault="false">
12	<box>
13	<pen lineWidth="1.0" lineColor="#000000"/>
14	</box>
15	</style>
16	<style name="table_TH" isDefault="false" mode="Opaque" backcolor="#F0F8FF">
17	<box>
18	<pen lineWidth="0.5" lineColor="#000000"/>
19	</box>
20	</style>
21	<style name="table_CH" isDefault="false" mode="Opaque" backcolor="#BFE1FF">
22	<box>
23	<pen lineWidth="0.5" lineColor="#000000"/>
24	</box>
25	</style>
26	<style name="table_TD" isDefault="false" mode="Opaque" backcolor="#FFFFFF">
27	<box>
28	<pen lineWidth="0.5" lineColor="#000000"/>
29	</box>
30	</style>
31	<style name="table 1" isDefault="false">
32	<box>
33	<pen lineWidth="1.0" lineColor="#000000"/>
34	</box>
35	</style>
36	<style name="table 1_TH" isDefault="false" mode="Opaque" backcolor="#F0F8FF">
37	<box>
38	<pen lineWidth="0.5" lineColor="#000000"/>
39	</box>
40	</style>
41	<style name="table 1_CH" isDefault="false" mode="Opaque" backcolor="#BFE1FF">
42	<box>
43	<pen lineWidth="0.5" lineColor="#000000"/>
44	</box>
45	</style>
46	<style name="table 1_TD" isDefault="false" mode="Opaque" backcolor="#FFFFFF">
47	<box>
48	<pen lineWidth="0.5" lineColor="#000000"/>
49	</box>
50	</style>
51	<style name="Crosstab Data Text" isDefault="false" hAlign="Center"/>
52	<subDataset name="dataset1"/>
53	<subDataset name="Table Dataset 1"/>
54	<subDataset name="Table Dataset 2"/>
55	<subDataset name="dataset2"/>
56	<parameter name="reportTitle" class="java.lang.String"/>
57	<parameter name="currentUser" class="java.lang.String"/>
58	<parameter name="logoUrl" class="java.lang.String"/>
59	<parameter name="startDateString" class="java.lang.String"/>
60	<parameter name="endDateString" class="java.lang.String"/>
61	<field name="immediateCalloutPercentage" class="java.math.BigDecimal"/>
62	<field name="totalPreventativePercentage" class="java.math.BigDecimal"/>
63	<field name="immediateCalloutCount" class="java.lang.Integer"/>
64	<field name="totalAssetsOnTasksCount" class="java.lang.Integer"/>
65	<field name="totalPreventativeCount" class="java.lang.Integer"/>
66	<field name="unscheduledBreakinCount" class="java.lang.Integer"/>
67	<field name="preventativeMaintenanceCount" class="java.lang.Integer"/>
68	<field name="taskQuery" class="java.lang.String"/>
69	<field name="summaryOfCalculationMethod" class="java.lang.String"/>
70	<background>
71	<band splitType="Stretch"/>
72	</background>
73	<pageHeader>
74	<band height="121" splitType="Stretch">
75	<textField>
76	<reportElement key="staticText-1" x="0" y="57" width="340" height="30"/>
77	<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
78	<font size="20"/>
79	</textElement>
80	<textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression>
81	</textField>
82	<image>
83	<reportElement x="0" y="0" width="340" height="57"/>
84	<imageExpression class="java.net.URL"><![CDATA[new URL($P{logoUrl})]]></imageExpression>
85	</image>
86	<textField pattern="dd-MMM-yyyy" isBlankWhenNull="true">
87	<reportElement x="0" y="87" width="340" height="20"/>
88	<textElement textAlignment="Center" verticalAlignment="Middle" markup="none"/>
89	<textFieldExpression class="java.lang.String"><![CDATA[$P{startDateString}+" to "+$P{endDateString}]]></textFieldExpression>
90	</textField>
91	</band>
92	</pageHeader>
93	<columnHeader>
94	<band splitType="Stretch"/>
95	</columnHeader>
96	<detail>
97	<band height="394" splitType="Stretch">
98	<textField isBlankWhenNull="true">
99	<reportElement x="0" y="40" width="157" height="20"/>
100	<textElement verticalAlignment="Middle" markup="none"/>
101	<textFieldExpression class="java.lang.String"><![CDATA["Immediate Callout: "]]></textFieldExpression>
102	</textField>
103	<textField isBlankWhenNull="true">
104	<reportElement x="0" y="60" width="157" height="20"/>
105	<textElement verticalAlignment="Middle" markup="none"/>
106	<textFieldExpression class="java.lang.String"><![CDATA["Total Preventative: "]]></textFieldExpression>
107	</textField>
108	<textField pattern="#,##0.00 %" isBlankWhenNull="true">
109	<reportElement x="157" y="40" width="79" height="20"/>
110	<textElement textAlignment="Center" verticalAlignment="Middle"/>
111	<textFieldExpression class="java.lang.String"><![CDATA[$F{immediateCalloutPercentage}.setScale(2, RoundingMode.HALF_UP)]]></textFieldExpression>
112	</textField>
113	<textField isBlankWhenNull="true">
114	<reportElement x="157" y="60" width="79" height="20"/>
115	<textElement textAlignment="Center" verticalAlignment="Middle"/>
116	<textFieldExpression class="java.lang.String"><![CDATA[$F{totalPreventativePercentage}.setScale(2, RoundingMode.HALF_UP)]]></textFieldExpression>
117	</textField>
118	<textField pattern="###0.00" isBlankWhenNull="true">
119	<reportElement x="236" y="40" width="117" height="20"/>
120	<textElement textAlignment="Center" verticalAlignment="Middle"/>
121	<textFieldExpression class="java.lang.String"><![CDATA[$F{immediateCalloutCount}]]></textFieldExpression>
122	</textField>
123	<textField isBlankWhenNull="true">
124	<reportElement x="236" y="60" width="117" height="20"/>
125	<textElement textAlignment="Center" verticalAlignment="Middle"/>
126	<textFieldExpression class="java.lang.String"><![CDATA[$F{totalPreventativeCount}]]></textFieldExpression>
127	</textField>
128	<textField pattern="###0.00" isBlankWhenNull="true">
129	<reportElement x="0" y="80" width="157" height="20"/>
130	<textElement verticalAlignment="Middle"/>
131	<textFieldExpression class="java.lang.String"><![CDATA["Total: "]]></textFieldExpression>
132	</textField>
133	<textField isBlankWhenNull="true">
134	<reportElement x="157" y="80" width="79" height="20"/>
135	<textElement textAlignment="Center" verticalAlignment="Middle"/>
136	</textField>
137	<textField isBlankWhenNull="true">
138	<reportElement x="236" y="80" width="117" height="20"/>
139	<textElement textAlignment="Center" verticalAlignment="Middle"/>
140	<textFieldExpression class="java.lang.String"><![CDATA[$F{totalAssetsOnTasksCount}]]></textFieldExpression>
141	</textField>
142	<line>
143	<reportElement x="0" y="100" width="353" height="1" forecolor="#999999"/>
144	</line>
145	<line>
146	<reportElement x="0" y="79" width="353" height="1" forecolor="#999999"/>
147	</line>
148	<line>
149	<reportElement x="0" y="60" width="353" height="1" forecolor="#999999"/>
150	</line>
151	<line>
152	<reportElement x="0" y="39" width="353" height="1" forecolor="#999999"/>
153	</line>
154	<textField isBlankWhenNull="true">
155	<reportElement x="0" y="20" width="157" height="20"/>
156	<textElement verticalAlignment="Middle" markup="none"/>
157	</textField>
158	<textField pattern="###0.00" isBlankWhenNull="true">
159	<reportElement x="236" y="20" width="117" height="20"/>
160	<textElement verticalAlignment="Middle"/>
161	</textField>
162	<textField pattern="#,##0.00 %" isBlankWhenNull="true">
163	<reportElement x="157" y="20" width="79" height="20"/>
164	<textElement verticalAlignment="Middle"/>
165	</textField>
166	<line>
167	<reportElement x="0" y="20" width="353" height="1" forecolor="#999999"/>
168	</line>
169	<pie3DChart>
170	<chart theme="default">
171	<reportElement x="426" y="0" width="356" height="197"/>
172	<chartTitle/>
173	<chartSubtitle/>
174	<chartLegend/>
175	</chart>
176	<pieDataset>
177	<pieSeries>
178	<keyExpression><![CDATA["Immediate"]]></keyExpression>
179	<valueExpression><![CDATA[$F{immediateCalloutPercentage}]]></valueExpression>
180	<labelExpression><![CDATA[$F{immediateCalloutPercentage}.setScale(0, RoundingMode.HALF_UP)]]></labelExpression>
181	</pieSeries>
182	<pieSeries>
183	<keyExpression><![CDATA["Preventative"]]></keyExpression>
184	<valueExpression><![CDATA[$F{totalPreventativePercentage}]]></valueExpression>
185	<labelExpression><![CDATA[$F{totalPreventativePercentage}.setScale(0, RoundingMode.HALF_UP)]]></labelExpression>
186	</pieSeries>
187	</pieDataset>
188	<pie3DPlot depthFactor="0.1" isCircular="false">
189	<plot>
190	<seriesColor seriesOrder="0" color="#FF0000"/>
191	<seriesColor seriesOrder="1" color="#00CC00"/>
192	<seriesColor seriesOrder="2" color="#FFFF66"/>
193	</plot>
194	<itemLabel color="#000000" backgroundColor="#FFFFFF"/>
195	</pie3DPlot>
196	</pie3DChart>
197	<textField isBlankWhenNull="true">
198	<reportElement x="236" y="257" width="117" height="20"/>
199	<textElement textAlignment="Center" verticalAlignment="Middle"/>
200	<textFieldExpression class="java.lang.String"><![CDATA[$F{preventativeMaintenanceCount}]]></textFieldExpression>
201	</textField>
202	<textField isBlankWhenNull="true">
203	<reportElement x="236" y="277" width="117" height="20"/>
204	<textElement textAlignment="Center" verticalAlignment="Middle"/>
205	<textFieldExpression><![CDATA[$F{totalPreventativeCount}]]></textFieldExpression>
206	</textField>
207	<textField isBlankWhenNull="true">
208	<reportElement x="157" y="277" width="79" height="20"/>
209	<textElement textAlignment="Center" verticalAlignment="Middle"/>
210	</textField>
211	<line>
212	<reportElement x="0" y="297" width="353" height="1" forecolor="#999999"/>
213	</line>
214	<textField isBlankWhenNull="true">
215	<reportElement x="0" y="257" width="157" height="20"/>
216	<textElement verticalAlignment="Middle" markup="none"/>
217	<textFieldExpression><![CDATA["Preventative Maintenance"]]></textFieldExpression>
218	</textField>
219	<textField pattern="#,##0.00 %" isBlankWhenNull="true">
220	<reportElement x="157" y="237" width="79" height="20"/>
221	<textElement textAlignment="Center" verticalAlignment="Middle"/>
222	</textField>
223	<textField pattern="###0.00" isBlankWhenNull="true">
224	<reportElement x="236" y="217" width="117" height="20"/>
225	<textElement verticalAlignment="Middle"/>
226	</textField>
227	<line>
228	<reportElement x="0" y="257" width="353" height="1" forecolor="#999999"/>
229	</line>
230	<textField pattern="###0.00" isBlankWhenNull="true">
231	<reportElement x="236" y="197" width="117" height="20"/>
232	<textElement verticalAlignment="Middle"/>
233	<textFieldExpression><![CDATA["Count (Assets on Tasks)"]]></textFieldExpression>
234	</textField>
235	<textField isBlankWhenNull="true">
236	<reportElement x="0" y="237" width="157" height="20"/>
237	<textElement verticalAlignment="Middle" markup="none"/>
238	<textFieldExpression class="java.lang.String"><![CDATA["Unscheduled Breaking: "]]></textFieldExpression>
239	</textField>
240	<line>
241	<reportElement x="0" y="276" width="353" height="1" forecolor="#999999"/>
242	</line>
243	<pie3DChart>
244	<chart>
245	<reportElement x="426" y="197" width="356" height="197"/>
246	<chartTitle/>
247	<chartSubtitle/>
248	<chartLegend/>
249	</chart>
250	<pieDataset>
251	<pieSeries>
252	<keyExpression><![CDATA["Immediate"]]></keyExpression>
253	<valueExpression><![CDATA[$F{immediateCalloutCount}]]></valueExpression>
254	<labelExpression><![CDATA[$F{immediateCalloutCount}]]></labelExpression>
255	</pieSeries>
256	<pieSeries>
257	<keyExpression><![CDATA["Preventative Maintenance"]]></keyExpression>
258	<valueExpression><![CDATA[$F{preventativeMaintenanceCount}]]></valueExpression>
259	<labelExpression><![CDATA[$F{preventativeMaintenanceCount}]]></labelExpression>
260	</pieSeries>
261	<pieSeries>
262	<keyExpression><![CDATA["Unscheduled Breakin"]]></keyExpression>
263	<valueExpression><![CDATA[$F{unscheduledBreakinCount}]]></valueExpression>
264	<labelExpression><![CDATA[$F{unscheduledBreakinCount}]]></labelExpression>
265	</pieSeries>
266	</pieDataset>
267	<pie3DPlot depthFactor="0.1" isCircular="false">
268	<plot>
269	<seriesColor seriesOrder="0" color="#FF0000"/>
270	<seriesColor seriesOrder="1" color="#00CC00"/>
271	<seriesColor seriesOrder="2" color="#FFFF66"/>
272	</plot>
273	<itemLabel color="#000000" backgroundColor="#FFFFFF"/>
274	</pie3DPlot>
275	</pie3DChart>
276	<textField isBlankWhenNull="true">
277	<reportElement x="0" y="217" width="157" height="20"/>
278	<textElement verticalAlignment="Middle" markup="none"/>
279	</textField>
280	<textField pattern="###0.00" isBlankWhenNull="true">
281	<reportElement x="236" y="237" width="117" height="20"/>
282	<textElement textAlignment="Center" verticalAlignment="Middle"/>
283	<textFieldExpression class="java.lang.String"><![CDATA[$F{unscheduledBreakinCount}]]></textFieldExpression>
284	</textField>
285	<line>
286	<reportElement x="0" y="217" width="353" height="1" forecolor="#999999"/>
287	</line>
288	<textField pattern="#,##0.00 %" isBlankWhenNull="true">
289	<reportElement x="157" y="217" width="79" height="20"/>
290	<textElement verticalAlignment="Middle"/>
291	</textField>
292	<line>
293	<reportElement x="0" y="236" width="353" height="1" forecolor="#999999"/>
294	</line>
295	<textField isBlankWhenNull="true">
296	<reportElement x="157" y="257" width="79" height="20"/>
297	<textElement textAlignment="Center" verticalAlignment="Middle"/>
298	</textField>
299	<textField isBlankWhenNull="true">
300	<reportElement x="0" y="197" width="157" height="20"/>
301	<textElement verticalAlignment="Middle" markup="none"/>
302	<textFieldExpression><![CDATA["Description"]]></textFieldExpression>
303	</textField>
304	<textField pattern="#,##0.00 %" isBlankWhenNull="true">
305	<reportElement x="157" y="197" width="79" height="20"/>
306	<textElement verticalAlignment="Middle"/>
307	</textField>
308	<textField pattern="###0.00" isBlankWhenNull="true">
309	<reportElement x="0" y="277" width="157" height="20"/>
310	<textElement verticalAlignment="Middle"/>
311	<textFieldExpression class="java.lang.String"><![CDATA["Total Preventative: "]]></textFieldExpression>
312	</textField>
313	<textField pattern="#,##0.00 %" isBlankWhenNull="true">
314	<reportElement x="157" y="0" width="79" height="20"/>
315	<textElement verticalAlignment="Middle"/>
316	<textFieldExpression><![CDATA["Percentage (%)"]]></textFieldExpression>
317	</textField>
318	<textField isBlankWhenNull="true">
319	<reportElement x="0" y="0" width="157" height="20"/>
320	<textElement verticalAlignment="Middle" markup="none"/>
321	<textFieldExpression><![CDATA["Description"]]></textFieldExpression>
322	</textField>
323	<textField pattern="###0.00" isBlankWhenNull="true">
324	<reportElement x="236" y="0" width="117" height="20"/>
325	<textElement verticalAlignment="Middle"/>
326	<textFieldExpression><![CDATA["Count (Assets on Tasks)"]]></textFieldExpression>
327	</textField>
328	</band>
329	</detail>
330	<columnFooter>
331	<band splitType="Stretch"/>
332	</columnFooter>
333	<pageFooter>
334	<band height="40" splitType="Stretch">
335	<textField pattern="dd-MMM-yyyy">
336	<reportElement x="82" y="0" width="200" height="20"/>
337	<textElement/>
338	<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
339	</textField>
340	<textField>
341	<reportElement x="662" y="0" width="80" height="20"/>
342	<textElement textAlignment="Right"/>
343	<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
344	</textField>
345	<textField evaluationTime="Report">
346	<reportElement x="742" y="0" width="40" height="20"/>
347	<textElement/>
348	<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
349	</textField>
350	<textField>
351	<reportElement x="0" y="0" width="82" height="20"/>
352	<textElement markup="none"/>
353	<textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression>
354	</textField>
355	<textField>
356	<reportElement x="82" y="20" width="200" height="20"/>
357	<textElement markup="none"/>
358	<textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression>
359	</textField>
360	<textField>
361	<reportElement x="0" y="20" width="82" height="20"/>
362	<textElement markup="none"/>
363	<textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression>
364	</textField>
365	</band>
366	</pageFooter>
367	<summary>
368	<band height="555">
369	<textField>
370	<reportElement key="staticText-1" x="221" y="0" width="340" height="30"/>
371	<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
372	<font size="20"/>
373	</textElement>
374	<textFieldExpression class="java.lang.String"><![CDATA["Summary of Calculation Method"]]></textFieldExpression>
375	</textField>
376	<textField>
377	<reportElement x="0" y="30" width="782" height="311"/>
378	<textElement/>
379	<textFieldExpression class="java.lang.String"><![CDATA[$F{summaryOfCalculationMethod}]]></textFieldExpression>
380	</textField>
381	</band>
382	</summary>
383	<noData>
384	<band height="85" splitType="Stretch">
385	<textField>
386	<reportElement x="0" y="35" width="782" height="50"/>
387	<textElement textAlignment="Center" markup="none">
388	<font size="14" isBold="true"/>
389	</textElement>
390	<textFieldExpression class="java.lang.String"><![CDATA["No data to display. \n"+
391	"Please run report again."]]></textFieldExpression>
392	</textField>
393	<textField>
394	<reportElement key="staticText-1" x="0" y="0" width="782" height="35"/>
395	<textElement textAlignment="Center" markup="none">
396	<font size="20"/>
397	</textElement>
398	<textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression>
399	</textField>
400	</band>
401	</noData>
402	</jasperReport>

Note: See TracBrowser for help on using the repository browser.

Download in other formats:

Original Format