Context Navigation

← Previous Revision
Latest Revision
Next Revision →
Blame
Revision Log

equipmentRegisterFinancial.jrxml @ 897

Last change on this file since 897 was 696, checked in by gav, 14 years ago
New report "Equipment Register (Financial)".
File size: 21.3 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="824" leftMargin="9" rightMargin="9" topMargin="9" bottomMargin="9" isSummaryNewPage="true" isSummaryWithPageHeaderAndFooter="true" isIgnorePagination="true">
3	<property name="ireport.scriptlethandling" value="0"/>
4	<property name="ireport.encoding" value="UTF-8"/>
5	<property name="ireport.zoom" value="1.5"/>
6	<property name="ireport.x" value="0"/>
7	<property name="ireport.y" value="644"/>
8	<import value="net.sf.jasperreports.engine.*"/>
9	<import value="java.util.*"/>
10	<import value="net.sf.jasperreports.engine.data.*"/>
11	<style name="table" isDefault="false">
12	<pen lineWidth="0.5"/>
13	<box>
14	<pen lineWidth="1.0" lineColor="#000000"/>
15	<topPen lineWidth="1.0"/>
16	<leftPen lineWidth="1.0"/>
17	<bottomPen lineWidth="1.0"/>
18	<rightPen lineWidth="1.0"/>
19	</box>
20	</style>
21	<style name="table_TH" isDefault="false" mode="Opaque" backcolor="#F0F8FF">
22	<box>
23	<pen lineWidth="0.5" lineColor="#000000"/>
24	</box>
25	</style>
26	<style name="table_CH" isDefault="false" mode="Opaque" backcolor="#BFE1FF">
27	<box>
28	<pen lineWidth="0.5" lineColor="#000000"/>
29	</box>
30	</style>
31	<style name="table_TD" isDefault="false" mode="Opaque" backcolor="#FFFFFF" pattern="">
32	<box>
33	<pen lineWidth="0.5" lineColor="#000000"/>
34	</box>
35	</style>
36	<style name="table_GH" isDefault="false" mode="Opaque" backcolor="#D2EFF7"/>
37	<subDataset name="dataset1">
38	<queryString language="SQL">
39	<![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{dataList})]]>
40	</queryString>
41	<field name="name" class="java.lang.String"/>
42	<field name="description" class="java.lang.String"/>
43	<field name="comment" class="java.lang.String"/>
44	<field name="Serial Number" class="java.lang.String"/>
45	<field name="Model Number" class="java.lang.String"/>
46	<field name="Manufacturer" class="java.lang.String"/>
47	<field name="ecr" class="java.lang.String"/>
48	<field name="Risk Level" class="java.lang.String"/>
49	<field name="Safe Work Procedure" class="java.lang.String"/>
50	<field name="Regulatory Requirement" class="java.lang.String"/>
51	<field name="Maintenance % Completion" class="java.lang.String"/>
52	<field name="Registration Required" class="java.lang.String"/>
53	<field name="Registration Expiry Date" class="java.lang.String"/>
54	<field name="assetName" class="java.lang.String"/>
55	<field name="Asset Number" class="java.lang.String"/>
56	<field name="Location Description" class="java.lang.String"/>
57	<field name="Asset Condition" class="java.lang.String"/>
58	<group name="assetName">
59	<groupExpression><![CDATA[$F{assetName}]]></groupExpression>
60	</group>
61	</subDataset>
62	<parameter name="reportTitle" class="java.lang.String"/>
63	<parameter name="currentUser" class="java.lang.String"/>
64	<parameter name="logoUrl" class="java.lang.String"/>
65	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
66	<defaultValueExpression><![CDATA["C:\\Documents and Settings\\kromhoutg\\My Documents\\reports\\"]]></defaultValueExpression>
67	</parameter>
68	<queryString language="SQL">
69	<![CDATA[]]>
70	</queryString>
71	<field name="dataList" class="java.util.List"/>
72	<field name="attribTypes" class="java.lang.String"/>
73	<field name="assetsWithoutEquipment" class="java.lang.String"/>
74	<field name="site" class="java.lang.Object"/>
75	<field name="section" class="java.lang.Object"/>
76	<background>
77	<band splitType="Stretch"/>
78	</background>
79	<pageHeader>
80	<band height="57" splitType="Stretch">
81	<printWhenExpression><![CDATA[false]]></printWhenExpression>
82	<textField>
83	<reportElement key="staticText-1" x="398" y="14" width="340" height="20"/>
84	<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
85	<font fontName="Serif" size="14"/>
86	</textElement>
87	<textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression>
88	</textField>
89	<image>
90	<reportElement x="0" y="0" width="340" height="57"/>
91	<imageExpression class="java.net.URL"><![CDATA[new URL($P{logoUrl})]]></imageExpression>
92	</image>
93	<textField>
94	<reportElement x="398" y="34" width="340" height="15" isPrintWhenDetailOverflows="true"/>
95	<textElement textAlignment="Center">
96	<font fontName="Serif" size="10"/>
97	</textElement>
98	<textFieldExpression class="java.lang.String"><![CDATA["Site: "+$F{site}.name+", "+"Section: "+$F{section}.name]]></textFieldExpression>
99	</textField>
100	</band>
101	</pageHeader>
102	<columnHeader>
103	<band splitType="Stretch"/>
104	</columnHeader>
105	<detail>
106	<band height="492" splitType="Immediate">
107	<componentElement>
108	<reportElement key="table" style="table" x="0" y="0" width="824" height="492"/>
109	<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
110	<datasetRun subDataset="dataset1">
111	<dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{dataList})]]></dataSourceExpression>
112	</datasetRun>
113	<jr:column width="45">
114	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
115	<staticText>
116	<reportElement x="0" y="0" width="45" height="32"/>
117	<textElement textAlignment="Center" verticalAlignment="Middle">
118	<font fontName="Serif" size="10"/>
119	</textElement>
120	<text><![CDATA[#]]></text>
121	</staticText>
122	</jr:columnHeader>
123	<jr:columnFooter height="2" rowSpan="1">
124	<staticText>
125	<reportElement x="0" y="0" width="45" height="2"/>
126	<textElement/>
127	<text><![CDATA[]]></text>
128	</staticText>
129	</jr:columnFooter>
130	<jr:detailCell style="table_TD" height="36" rowSpan="1">
131	<textField>
132	<reportElement x="0" y="0" width="45" height="36"/>
133	<textElement textAlignment="Center" verticalAlignment="Middle">
134	<font fontName="Serif" size="8"/>
135	</textElement>
136	<textFieldExpression class="java.lang.String"><![CDATA[$F{Asset Number}]]></textFieldExpression>
137	</textField>
138	</jr:detailCell>
139	</jr:column>
140	<jr:column width="100">
141	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
142	<staticText>
143	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="32" isPrintWhenDetailOverflows="true"/>
144	<textElement textAlignment="Center" verticalAlignment="Middle">
145	<font fontName="Serif" isBold="false"/>
146	</textElement>
147	<text><![CDATA[Asset]]></text>
148	</staticText>
149	</jr:columnHeader>
150	<jr:detailCell style="table_TD" height="36" rowSpan="1">
151	<textField isStretchWithOverflow="true">
152	<reportElement positionType="Float" mode="Transparent" x="0" y="0" width="100" height="36" isPrintWhenDetailOverflows="true" backcolor="#D2EFF7"/>
153	<textElement textAlignment="Center" verticalAlignment="Middle">
154	<font fontName="Serif" isBold="false"/>
155	</textElement>
156	<textFieldExpression class="java.lang.String"><![CDATA[$F{assetName}]]></textFieldExpression>
157	</textField>
158	</jr:detailCell>
159	</jr:column>
160	<jr:column width="90">
161	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
162	<staticText>
163	<reportElement x="0" y="0" width="90" height="32"/>
164	<textElement textAlignment="Center" verticalAlignment="Middle">
165	<font fontName="Serif" size="8"/>
166	</textElement>
167	<text><![CDATA[Description]]></text>
168	</staticText>
169	</jr:columnHeader>
170	<jr:detailCell style="table_TD" height="36" rowSpan="1">
171	<textField>
172	<reportElement x="0" y="0" width="90" height="36">
173	<printWhenExpression><![CDATA[$F{name}.equals(' Asset Details')]]></printWhenExpression>
174	</reportElement>
175	<textElement textAlignment="Center" verticalAlignment="Middle">
176	<font fontName="Serif" size="8"/>
177	</textElement>
178	<textFieldExpression class="java.lang.String"><![CDATA[$F{description}]]></textFieldExpression>
179	</textField>
180	</jr:detailCell>
181	</jr:column>
182	<jr:column width="100">
183	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
184	<staticText>
185	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="32" isPrintWhenDetailOverflows="true"/>
186	<textElement textAlignment="Center" verticalAlignment="Middle">
187	<font fontName="Serif" size="8"/>
188	</textElement>
189	<text><![CDATA[Sub Asset]]></text>
190	</staticText>
191	</jr:columnHeader>
192	<jr:detailCell style="table_TD" height="36" rowSpan="1">
193	<textField isStretchWithOverflow="true">
194	<reportElement positionType="Float" mode="Transparent" x="0" y="0" width="100" height="36" isPrintWhenDetailOverflows="true" backcolor="#D2EFF7">
195	<printWhenExpression><![CDATA[!$F{name}.equals(' Asset Details')]]></printWhenExpression>
196	</reportElement>
197	<textElement textAlignment="Center" verticalAlignment="Middle">
198	<font fontName="Serif" size="8" isBold="false"/>
199	</textElement>
200	<textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression>
201	</textField>
202	</jr:detailCell>
203	</jr:column>
204	<jr:column width="70">
205	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
206	<staticText>
207	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" height="32" isPrintWhenDetailOverflows="true"/>
208	<textElement textAlignment="Center" verticalAlignment="Middle">
209	<font fontName="Serif" size="8" isBold="false"/>
210	</textElement>
211	<text><![CDATA[Serial Number]]></text>
212	</staticText>
213	</jr:columnHeader>
214	<jr:detailCell style="table_TD" height="36" rowSpan="1">
215	<textField isStretchWithOverflow="true">
216	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" height="36" isPrintWhenDetailOverflows="true"/>
217	<textElement textAlignment="Center" verticalAlignment="Middle">
218	<font fontName="Serif" size="8"/>
219	</textElement>
220	<textFieldExpression class="java.lang.String"><![CDATA[$F{Serial Number}]]></textFieldExpression>
221	</textField>
222	</jr:detailCell>
223	</jr:column>
224	<jr:column width="60">
225	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
226	<staticText>
227	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="60" height="32" isPrintWhenDetailOverflows="true"/>
228	<textElement textAlignment="Center" verticalAlignment="Middle">
229	<font fontName="Serif" size="8" isBold="false"/>
230	</textElement>
231	<text><![CDATA[Model Number]]></text>
232	</staticText>
233	</jr:columnHeader>
234	<jr:detailCell style="table_TD" height="36" rowSpan="1">
235	<textField isStretchWithOverflow="true">
236	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="60" height="36" isPrintWhenDetailOverflows="true"/>
237	<textElement textAlignment="Center" verticalAlignment="Middle">
238	<font fontName="Serif" size="8"/>
239	</textElement>
240	<textFieldExpression class="java.lang.String"><![CDATA[$F{Model Number}]]></textFieldExpression>
241	</textField>
242	</jr:detailCell>
243	</jr:column>
244	<jr:column width="75">
245	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
246	<staticText>
247	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="75" height="32" isPrintWhenDetailOverflows="true"/>
248	<textElement textAlignment="Center" verticalAlignment="Middle">
249	<font fontName="Serif" size="8" isBold="false"/>
250	</textElement>
251	<text><![CDATA[Manufacturer]]></text>
252	</staticText>
253	</jr:columnHeader>
254	<jr:detailCell style="table_TD" height="36" rowSpan="1">
255	<textField isStretchWithOverflow="true">
256	<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="75" height="36" isPrintWhenDetailOverflows="true"/>
257	<textElement textAlignment="Center" verticalAlignment="Middle">
258	<font fontName="Serif" size="8"/>
259	</textElement>
260	<textFieldExpression class="java.lang.String"><![CDATA[$F{Manufacturer}]]></textFieldExpression>
261	</textField>
262	</jr:detailCell>
263	</jr:column>
264	<jr:column width="63">
265	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
266	<staticText>
267	<reportElement x="0" y="0" width="63" height="32"/>
268	<textElement textAlignment="Center" verticalAlignment="Middle">
269	<font fontName="Serif" size="8"/>
270	</textElement>
271	<text><![CDATA[Location]]></text>
272	</staticText>
273	</jr:columnHeader>
274	<jr:detailCell style="table_TD" height="36" rowSpan="1">
275	<textField>
276	<reportElement x="0" y="0" width="63" height="36"/>
277	<textElement textAlignment="Center" verticalAlignment="Middle">
278	<font fontName="Serif" size="8"/>
279	</textElement>
280	<textFieldExpression class="java.lang.String"><![CDATA[$F{Location Description}]]></textFieldExpression>
281	</textField>
282	</jr:detailCell>
283	</jr:column>
284	<jr:column width="70">
285	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
286	<staticText>
287	<reportElement x="0" y="0" width="70" height="32"/>
288	<textElement textAlignment="Center" verticalAlignment="Middle">
289	<font fontName="Serif" size="8"/>
290	</textElement>
291	<text><![CDATA[Equipment Criticality]]></text>
292	</staticText>
293	</jr:columnHeader>
294	<jr:detailCell style="table_TD" height="36" rowSpan="1">
295	<textField>
296	<reportElement x="0" y="0" width="70" height="36"/>
297	<textElement textAlignment="Center" verticalAlignment="Middle">
298	<font fontName="Serif" size="8"/>
299	</textElement>
300	<textFieldExpression class="java.lang.String"><![CDATA[$F{ecr}]]></textFieldExpression>
301	</textField>
302	</jr:detailCell>
303	</jr:column>
304	<jr:column width="60">
305	<jr:columnHeader style="table_CH" height="32" rowSpan="1">
306	<staticText>
307	<reportElement x="0" y="0" width="60" height="32"/>
308	<textElement textAlignment="Center" verticalAlignment="Middle">
309	<font fontName="Serif" size="8"/>
310	</textElement>
311	<text><![CDATA[Condition]]></text>
312	</staticText>
313	</jr:columnHeader>
314	<jr:detailCell style="table_TD" height="36" rowSpan="1">
315	<textField>
316	<reportElement x="0" y="0" width="60" height="36"/>
317	<textElement textAlignment="Center" verticalAlignment="Middle">
318	<font fontName="Serif" size="8"/>
319	</textElement>
320	<textFieldExpression class="java.lang.String"><![CDATA[$F{Asset Condition}]]></textFieldExpression>
321	</textField>
322	</jr:detailCell>
323	</jr:column>
324	</jr:table>
325	</componentElement>
326	</band>
327	</detail>
328	<columnFooter>
329	<band splitType="Stretch"/>
330	</columnFooter>
331	<pageFooter>
332	<band height="28" splitType="Prevent">
333	<printWhenExpression><![CDATA[false]]></printWhenExpression>
334	<textField pattern="dd-MMM-yyyy">
335	<reportElement x="50" y="2" width="200" height="12"/>
336	<textElement>
337	<font fontName="Serif" size="8"/>
338	</textElement>
339	<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
340	</textField>
341	<textField>
342	<reportElement x="704" y="14" width="80" height="12"/>
343	<textElement textAlignment="Right">
344	<font fontName="Serif" size="8"/>
345	</textElement>
346	<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
347	</textField>
348	<textField evaluationTime="Report">
349	<reportElement x="784" y="14" width="40" height="12"/>
350	<textElement>
351	<font fontName="Serif" size="8"/>
352	</textElement>
353	<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
354	</textField>
355	<textField>
356	<reportElement x="0" y="2" width="50" height="12"/>
357	<textElement markup="none">
358	<font fontName="Serif" size="8"/>
359	</textElement>
360	<textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression>
361	</textField>
362	<textField>
363	<reportElement x="50" y="14" width="200" height="12"/>
364	<textElement markup="none">
365	<font fontName="Serif" size="8"/>
366	</textElement>
367	<textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression>
368	</textField>
369	<textField>
370	<reportElement x="0" y="14" width="50" height="12"/>
371	<textElement markup="none">
372	<font fontName="Serif" size="8"/>
373	</textElement>
374	<textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression>
375	</textField>
376	</band>
377	</pageFooter>
378	<lastPageFooter>
379	<band height="28">
380	<printWhenExpression><![CDATA[false]]></printWhenExpression>
381	<textField evaluationTime="Report">
382	<reportElement x="784" y="14" width="40" height="12"/>
383	<textElement>
384	<font fontName="Serif" size="8"/>
385	</textElement>
386	<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
387	</textField>
388	<textField pattern="dd-MMM-yyyy">
389	<reportElement x="50" y="2" width="200" height="12"/>
390	<textElement>
391	<font fontName="Serif" size="8"/>
392	</textElement>
393	<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
394	</textField>
395	<textField>
396	<reportElement x="0" y="2" width="50" height="12"/>
397	<textElement markup="none">
398	<font fontName="Serif" size="8"/>
399	</textElement>
400	<textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression>
401	</textField>
402	<textField>
403	<reportElement x="0" y="14" width="50" height="12"/>
404	<textElement markup="none">
405	<font fontName="Serif" size="8"/>
406	</textElement>
407	<textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression>
408	</textField>
409	<textField>
410	<reportElement x="50" y="14" width="200" height="12"/>
411	<textElement markup="none">
412	<font fontName="Serif" size="8"/>
413	</textElement>
414	<textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression>
415	</textField>
416	<textField>
417	<reportElement x="704" y="14" width="80" height="12"/>
418	<textElement textAlignment="Right">
419	<font fontName="Serif" size="8"/>
420	</textElement>
421	<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
422	</textField>
423	</band>
424	</lastPageFooter>
425	<summary>
426	<band height="369">
427	<printWhenExpression><![CDATA[false]]></printWhenExpression>
428	<textField isStretchWithOverflow="true">
429	<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="13" y="36" width="824" height="36" isPrintWhenDetailOverflows="true"/>
430	<textElement>
431	<font fontName="Serif"/>
432	</textElement>
433	<textFieldExpression class="java.lang.String"><![CDATA["AssetSubItem Extended Attributes: \n"+$F{attribTypes}]]></textFieldExpression>
434	</textField>
435	<textField>
436	<reportElement key="staticText-1" x="242" y="0" width="340" height="30"/>
437	<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
438	<font size="20"/>
439	</textElement>
440	<textFieldExpression class="java.lang.String"><![CDATA["Summary"]]></textFieldExpression>
441	</textField>
442	<textField isStretchWithOverflow="true">
443	<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="13" y="100" width="824" height="26" isPrintWhenDetailOverflows="true"/>
444	<textElement>
445	<font fontName="Serif"/>
446	</textElement>
447	<textFieldExpression class="java.lang.String"><![CDATA[$F{assetsWithoutEquipment}]]></textFieldExpression>
448	</textField>
449	<textField isStretchWithOverflow="true">
450	<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="13" y="81" width="824" height="19" isPrintWhenDetailOverflows="true" forecolor="#000000">
451	<printWhenExpression><![CDATA[$F{assetsWithoutEquipment}]]></printWhenExpression>
452	</reportElement>
453	<textElement>
454	<font fontName="Serif"/>
455	</textElement>
456	<textFieldExpression class="java.lang.String"><![CDATA["The following assets have no sub assets (equipment):"]]></textFieldExpression>
457	</textField>
458	</band>
459	</summary>
460	<noData>
461	<band height="85" splitType="Stretch">
462	<textField>
463	<reportElement x="0" y="35" width="824" height="50"/>
464	<textElement textAlignment="Center" markup="none">
465	<font fontName="Serif" size="12" isBold="true"/>
466	</textElement>
467	<textFieldExpression class="java.lang.String"><![CDATA["No data to display. \n"+
468	"Please run report again."]]></textFieldExpression>
469	</textField>
470	<textField>
471	<reportElement key="staticText-1" x="0" y="0" width="824" height="35"/>
472	<textElement textAlignment="Center" markup="none">
473	<font fontName="Serif" size="18"/>
474	</textElement>
475	<textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression>
476	</textField>
477	</band>
478	</noData>
479	</jasperReport>

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

Download in other formats:

Original Format