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"> |
---|
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="22"/> |
---|
7 | <property name="ireport.y" value="480"/> |
---|
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="assetDescription" class="java.lang.String"/> |
---|
42 | <field name="taskDescription" class="java.lang.String"/> |
---|
43 | <field name="assetName" class="java.lang.String"/> |
---|
44 | <field name="completionFigures" class="java.lang.String"/> |
---|
45 | <field name="taskId" class="java.lang.String"/> |
---|
46 | <group name="group1"> |
---|
47 | <groupExpression><![CDATA[$F{assetName}]]></groupExpression> |
---|
48 | </group> |
---|
49 | </subDataset> |
---|
50 | <parameter name="reportTitle" class="java.lang.String"/> |
---|
51 | <parameter name="currentUser" class="java.lang.String"/> |
---|
52 | <parameter name="logoUrl" class="java.lang.String"/> |
---|
53 | <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> |
---|
54 | <defaultValueExpression><![CDATA["C:\\Documents and Settings\\kromhoutg\\My Documents\\reports\\"]]></defaultValueExpression> |
---|
55 | </parameter> |
---|
56 | <parameter name="startDateString" class="java.lang.String"/> |
---|
57 | <parameter name="endDateString" class="java.lang.String"/> |
---|
58 | <queryString language="SQL"> |
---|
59 | <![CDATA[]]> |
---|
60 | </queryString> |
---|
61 | <field name="dataList" class="java.util.List"/> |
---|
62 | <field name="site" class="java.lang.Object"/> |
---|
63 | <field name="section" class="java.lang.Object"/> |
---|
64 | <field name="summary" class="java.lang.String"/> |
---|
65 | <background> |
---|
66 | <band splitType="Stretch"/> |
---|
67 | </background> |
---|
68 | <pageHeader> |
---|
69 | <band height="57" splitType="Stretch"> |
---|
70 | <textField> |
---|
71 | <reportElement key="staticText-1" x="398" y="5" width="340" height="20"/> |
---|
72 | <textElement textAlignment="Center" verticalAlignment="Top" markup="none"> |
---|
73 | <font fontName="Serif" size="14"/> |
---|
74 | </textElement> |
---|
75 | <textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression> |
---|
76 | </textField> |
---|
77 | <image> |
---|
78 | <reportElement x="0" y="0" width="340" height="57"/> |
---|
79 | <imageExpression class="java.net.URL"><![CDATA[new URL($P{logoUrl})]]></imageExpression> |
---|
80 | </image> |
---|
81 | <textField> |
---|
82 | <reportElement x="398" y="25" width="340" height="15" isPrintWhenDetailOverflows="true"/> |
---|
83 | <textElement textAlignment="Center"> |
---|
84 | <font fontName="Serif" size="10"/> |
---|
85 | </textElement> |
---|
86 | <textFieldExpression class="java.lang.String"><![CDATA["Site: "+$F{site}.name+", "+"Section: "+$F{section}.name]]></textFieldExpression> |
---|
87 | </textField> |
---|
88 | <textField pattern="dd-MMM-yyyy" isBlankWhenNull="true"> |
---|
89 | <reportElement x="398" y="40" width="340" height="12"/> |
---|
90 | <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> |
---|
91 | <font fontName="Serif" size="8"/> |
---|
92 | </textElement> |
---|
93 | <textFieldExpression class="java.lang.String"><![CDATA[$P{startDateString}+" to "+$P{endDateString}]]></textFieldExpression> |
---|
94 | </textField> |
---|
95 | </band> |
---|
96 | </pageHeader> |
---|
97 | <columnHeader> |
---|
98 | <band splitType="Stretch"/> |
---|
99 | </columnHeader> |
---|
100 | <detail> |
---|
101 | <band height="492" splitType="Immediate"> |
---|
102 | <printWhenExpression><![CDATA[!$F{dataList}.isEmpty()]]></printWhenExpression> |
---|
103 | <componentElement> |
---|
104 | <reportElement key="table" style="table" x="2" y="2" width="820" height="488"/> |
---|
105 | <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"> |
---|
106 | <datasetRun subDataset="dataset1"> |
---|
107 | <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{dataList})]]></dataSourceExpression> |
---|
108 | </datasetRun> |
---|
109 | <jr:column width="100"> |
---|
110 | <jr:columnHeader style="table_CH" height="32" rowSpan="1"> |
---|
111 | <staticText> |
---|
112 | <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="32" isPrintWhenDetailOverflows="true"/> |
---|
113 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
114 | <font fontName="Serif" isBold="false"/> |
---|
115 | </textElement> |
---|
116 | <text><![CDATA[Asset]]></text> |
---|
117 | </staticText> |
---|
118 | </jr:columnHeader> |
---|
119 | <jr:detailCell style="table_TD" height="20" rowSpan="1"> |
---|
120 | <textField isStretchWithOverflow="true"> |
---|
121 | <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="2" y="0" width="96" height="20" isPrintWhenDetailOverflows="true"/> |
---|
122 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
123 | <font fontName="Serif"/> |
---|
124 | </textElement> |
---|
125 | <textFieldExpression class="java.lang.String"><![CDATA[$F{assetName}]]></textFieldExpression> |
---|
126 | </textField> |
---|
127 | </jr:detailCell> |
---|
128 | </jr:column> |
---|
129 | <jr:column width="100"> |
---|
130 | <jr:columnHeader style="table_CH" height="32" rowSpan="1"> |
---|
131 | <staticText> |
---|
132 | <reportElement x="0" y="0" width="100" height="32"/> |
---|
133 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
134 | <font fontName="Serif"/> |
---|
135 | </textElement> |
---|
136 | <text><![CDATA[Description]]></text> |
---|
137 | </staticText> |
---|
138 | </jr:columnHeader> |
---|
139 | <jr:detailCell style="table_TD" height="20" rowSpan="1"> |
---|
140 | <textField isStretchWithOverflow="true"> |
---|
141 | <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="2" y="0" width="96" height="20" isPrintWhenDetailOverflows="true"/> |
---|
142 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
143 | <font size="8"/> |
---|
144 | </textElement> |
---|
145 | <textFieldExpression class="java.lang.String"><![CDATA[$F{assetDescription}]]></textFieldExpression> |
---|
146 | </textField> |
---|
147 | </jr:detailCell> |
---|
148 | </jr:column> |
---|
149 | <jr:column width="441"> |
---|
150 | <jr:columnHeader style="table_CH" height="32" rowSpan="1"> |
---|
151 | <staticText> |
---|
152 | <reportElement stretchType="RelativeToTallestObject" x="2" y="0" width="435" height="32" isPrintWhenDetailOverflows="true"/> |
---|
153 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
154 | <font fontName="Serif" size="10" isBold="false"/> |
---|
155 | </textElement> |
---|
156 | <text><![CDATA[Regulatory Requirement (Recurring Task)]]></text> |
---|
157 | </staticText> |
---|
158 | </jr:columnHeader> |
---|
159 | <jr:detailCell style="table_TD" height="20" rowSpan="1"> |
---|
160 | <textField isStretchWithOverflow="true"> |
---|
161 | <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="2" y="0" width="435" height="20" isPrintWhenDetailOverflows="true"/> |
---|
162 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
163 | <font fontName="Serif" size="8"/> |
---|
164 | </textElement> |
---|
165 | <textFieldExpression class="java.lang.String"><![CDATA["Task #"+$F{taskId}+" - "+$F{taskDescription}]]></textFieldExpression> |
---|
166 | </textField> |
---|
167 | </jr:detailCell> |
---|
168 | </jr:column> |
---|
169 | <jr:column width="112"> |
---|
170 | <jr:columnHeader style="table_CH" height="32" rowSpan="1"> |
---|
171 | <staticText> |
---|
172 | <reportElement x="2" y="0" width="108" height="32"/> |
---|
173 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
174 | <font fontName="Serif"/> |
---|
175 | </textElement> |
---|
176 | <text><![CDATA[Complete (Sub Tasks)]]></text> |
---|
177 | </staticText> |
---|
178 | </jr:columnHeader> |
---|
179 | <jr:detailCell style="table_TD" height="20" rowSpan="1"> |
---|
180 | <textField isStretchWithOverflow="true"> |
---|
181 | <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="2" y="0" width="108" height="20" isPrintWhenDetailOverflows="true"/> |
---|
182 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
183 | <font fontName="Serif" size="8"/> |
---|
184 | </textElement> |
---|
185 | <textFieldExpression class="java.lang.String"><![CDATA[$F{completionFigures}]]></textFieldExpression> |
---|
186 | </textField> |
---|
187 | </jr:detailCell> |
---|
188 | </jr:column> |
---|
189 | </jr:table> |
---|
190 | </componentElement> |
---|
191 | </band> |
---|
192 | <band height="85"> |
---|
193 | <printWhenExpression><![CDATA[$F{dataList}.isEmpty()]]></printWhenExpression> |
---|
194 | <staticText> |
---|
195 | <reportElement x="0" y="35" width="824" height="50"/> |
---|
196 | <textElement textAlignment="Center" markup="none"> |
---|
197 | <font fontName="Serif" size="12" isBold="true"/> |
---|
198 | </textElement> |
---|
199 | <text><![CDATA[No regulatory requirements found for this section.]]></text> |
---|
200 | </staticText> |
---|
201 | </band> |
---|
202 | </detail> |
---|
203 | <columnFooter> |
---|
204 | <band splitType="Stretch"/> |
---|
205 | </columnFooter> |
---|
206 | <pageFooter> |
---|
207 | <band height="28" splitType="Prevent"> |
---|
208 | <textField pattern="dd-MMM-yyyy"> |
---|
209 | <reportElement x="50" y="2" width="200" height="12"/> |
---|
210 | <textElement> |
---|
211 | <font fontName="Serif" size="8"/> |
---|
212 | </textElement> |
---|
213 | <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> |
---|
214 | </textField> |
---|
215 | <textField> |
---|
216 | <reportElement x="704" y="14" width="80" height="12"/> |
---|
217 | <textElement textAlignment="Right"> |
---|
218 | <font fontName="Serif" size="8"/> |
---|
219 | </textElement> |
---|
220 | <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> |
---|
221 | </textField> |
---|
222 | <textField evaluationTime="Report"> |
---|
223 | <reportElement x="784" y="14" width="40" height="12"/> |
---|
224 | <textElement> |
---|
225 | <font fontName="Serif" size="8"/> |
---|
226 | </textElement> |
---|
227 | <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> |
---|
228 | </textField> |
---|
229 | <textField> |
---|
230 | <reportElement x="0" y="2" width="50" height="12"/> |
---|
231 | <textElement markup="none"> |
---|
232 | <font fontName="Serif" size="8"/> |
---|
233 | </textElement> |
---|
234 | <textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression> |
---|
235 | </textField> |
---|
236 | <textField> |
---|
237 | <reportElement x="50" y="14" width="200" height="12"/> |
---|
238 | <textElement markup="none"> |
---|
239 | <font fontName="Serif" size="8"/> |
---|
240 | </textElement> |
---|
241 | <textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression> |
---|
242 | </textField> |
---|
243 | <textField> |
---|
244 | <reportElement x="0" y="14" width="50" height="12"/> |
---|
245 | <textElement markup="none"> |
---|
246 | <font fontName="Serif" size="8"/> |
---|
247 | </textElement> |
---|
248 | <textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression> |
---|
249 | </textField> |
---|
250 | </band> |
---|
251 | </pageFooter> |
---|
252 | <lastPageFooter> |
---|
253 | <band height="28"> |
---|
254 | <textField evaluationTime="Report"> |
---|
255 | <reportElement x="784" y="14" width="40" height="12"/> |
---|
256 | <textElement> |
---|
257 | <font fontName="Serif" size="8"/> |
---|
258 | </textElement> |
---|
259 | <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> |
---|
260 | </textField> |
---|
261 | <textField pattern="dd-MMM-yyyy"> |
---|
262 | <reportElement x="50" y="2" width="200" height="12"/> |
---|
263 | <textElement> |
---|
264 | <font fontName="Serif" size="8"/> |
---|
265 | </textElement> |
---|
266 | <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> |
---|
267 | </textField> |
---|
268 | <textField> |
---|
269 | <reportElement x="0" y="2" width="50" height="12"/> |
---|
270 | <textElement markup="none"> |
---|
271 | <font fontName="Serif" size="8"/> |
---|
272 | </textElement> |
---|
273 | <textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression> |
---|
274 | </textField> |
---|
275 | <textField> |
---|
276 | <reportElement x="0" y="14" width="50" height="12"/> |
---|
277 | <textElement markup="none"> |
---|
278 | <font fontName="Serif" size="8"/> |
---|
279 | </textElement> |
---|
280 | <textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression> |
---|
281 | </textField> |
---|
282 | <textField> |
---|
283 | <reportElement x="50" y="14" width="200" height="12"/> |
---|
284 | <textElement markup="none"> |
---|
285 | <font fontName="Serif" size="8"/> |
---|
286 | </textElement> |
---|
287 | <textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression> |
---|
288 | </textField> |
---|
289 | <textField> |
---|
290 | <reportElement x="704" y="14" width="80" height="12"/> |
---|
291 | <textElement textAlignment="Right"> |
---|
292 | <font fontName="Serif" size="8"/> |
---|
293 | </textElement> |
---|
294 | <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> |
---|
295 | </textField> |
---|
296 | </band> |
---|
297 | </lastPageFooter> |
---|
298 | <summary> |
---|
299 | <band height="369"> |
---|
300 | <textField> |
---|
301 | <reportElement key="staticText-1" x="242" y="0" width="340" height="30"/> |
---|
302 | <textElement textAlignment="Center" verticalAlignment="Top" markup="none"> |
---|
303 | <font fontName="Serif" size="20"/> |
---|
304 | </textElement> |
---|
305 | <textFieldExpression class="java.lang.String"><![CDATA["Summary"]]></textFieldExpression> |
---|
306 | </textField> |
---|
307 | <textField> |
---|
308 | <reportElement x="2" y="63" width="555" height="48"/> |
---|
309 | <textElement> |
---|
310 | <font fontName="Serif"/> |
---|
311 | </textElement> |
---|
312 | <textFieldExpression class="java.lang.String"><![CDATA[$F{summary}]]></textFieldExpression> |
---|
313 | </textField> |
---|
314 | </band> |
---|
315 | </summary> |
---|
316 | <noData> |
---|
317 | <band height="85" splitType="Stretch"> |
---|
318 | <textField> |
---|
319 | <reportElement x="0" y="35" width="824" height="50"/> |
---|
320 | <textElement textAlignment="Center" markup="none"> |
---|
321 | <font fontName="Serif" size="12" isBold="true"/> |
---|
322 | </textElement> |
---|
323 | <textFieldExpression class="java.lang.String"><![CDATA["No data to display. \n"+ |
---|
324 | "Please run report again."]]></textFieldExpression> |
---|
325 | </textField> |
---|
326 | <textField> |
---|
327 | <reportElement key="staticText-1" x="0" y="0" width="824" height="35"/> |
---|
328 | <textElement textAlignment="Center" markup="none"> |
---|
329 | <font fontName="Serif" size="18"/> |
---|
330 | </textElement> |
---|
331 | <textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression> |
---|
332 | </textField> |
---|
333 | </band> |
---|
334 | </noData> |
---|
335 | </jasperReport> |
---|