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="595" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" 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.0"/> |
---|
6 | <property name="ireport.x" value="0"/> |
---|
7 | <property name="ireport.y" value="240"/> |
---|
8 | <import value="net.sf.jasperreports.engine.*"/> |
---|
9 | <import value="java.util.*"/> |
---|
10 | <import value="net.sf.jasperreports.engine.data.*"/> |
---|
11 | <style name="Crosstab Data Text" isDefault="false" hAlign="Center"/> |
---|
12 | <style name="table" isDefault="false" fill="Solid" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"> |
---|
13 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
14 | <pen lineWidth="0.0" lineColor="#000000"/> |
---|
15 | <topPen lineWidth="0.0"/> |
---|
16 | <leftPen lineWidth="0.0"/> |
---|
17 | <bottomPen lineWidth="0.0"/> |
---|
18 | <rightPen lineWidth="0.0"/> |
---|
19 | </box> |
---|
20 | </style> |
---|
21 | <style name="table_TH" isDefault="false" mode="Opaque" backcolor="#C7C7C7" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"> |
---|
22 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
23 | <pen lineWidth="1.0" lineColor="#000000"/> |
---|
24 | <topPen lineWidth="1.0"/> |
---|
25 | <leftPen lineWidth="0.0"/> |
---|
26 | <bottomPen lineWidth="1.0"/> |
---|
27 | <rightPen lineWidth="0.0"/> |
---|
28 | </box> |
---|
29 | </style> |
---|
30 | <style name="table_CH" isDefault="false" mode="Opaque" backcolor="#FFFFFF" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"> |
---|
31 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
32 | <pen lineWidth="1.0" lineColor="#000000"/> |
---|
33 | <topPen lineWidth="0.0"/> |
---|
34 | <leftPen lineWidth="0.0"/> |
---|
35 | <bottomPen lineWidth="1.0"/> |
---|
36 | <rightPen lineWidth="0.0"/> |
---|
37 | </box> |
---|
38 | </style> |
---|
39 | <style name="table_TD" isDefault="false" mode="Opaque" backcolor="#FFFFFF" fontSize="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"> |
---|
40 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
41 | <pen lineWidth="1.0" lineColor="#000000"/> |
---|
42 | <topPen lineWidth="1.0"/> |
---|
43 | <leftPen lineWidth="0.0"/> |
---|
44 | <bottomPen lineWidth="1.0"/> |
---|
45 | <rightPen lineWidth="0.0"/> |
---|
46 | </box> |
---|
47 | <conditionalStyle> |
---|
48 | <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> |
---|
49 | <style isDefault="false" style="table_TD" backcolor="#F7F7F7"/> |
---|
50 | </conditionalStyle> |
---|
51 | </style> |
---|
52 | <style name="table_CF" isDefault="false" mode="Opaque" backcolor="#EDEDED" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"> |
---|
53 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
54 | <pen lineWidth="1.0"/> |
---|
55 | <topPen lineWidth="1.0"/> |
---|
56 | <leftPen lineWidth="0.0"/> |
---|
57 | <bottomPen lineWidth="1.0"/> |
---|
58 | <rightPen lineWidth="0.0"/> |
---|
59 | </box> |
---|
60 | </style> |
---|
61 | <subDataset name="dataset1"> |
---|
62 | <field name="store" class="java.lang.String"/> |
---|
63 | <field name="location" class="java.lang.String"/> |
---|
64 | <group name="group1"> |
---|
65 | <groupExpression><![CDATA[$F{store}]]></groupExpression> |
---|
66 | </group> |
---|
67 | </subDataset> |
---|
68 | <parameter name="reportTitle" class="java.lang.String"/> |
---|
69 | <parameter name="currentUser" class="java.lang.String"/> |
---|
70 | <parameter name="logoUrl" class="java.lang.String"/> |
---|
71 | <parameter name="startDateString" class="java.lang.String"/> |
---|
72 | <parameter name="endDateString" class="java.lang.String"/> |
---|
73 | <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> |
---|
74 | <defaultValueExpression><![CDATA["C:\\Documents and Settings\\kromhoutg\\My Documents\\reports\\"]]></defaultValueExpression> |
---|
75 | </parameter> |
---|
76 | <queryString language="SQL"> |
---|
77 | <![CDATA[]]> |
---|
78 | </queryString> |
---|
79 | <field name="inventoryLocationList" class="java.util.List"/> |
---|
80 | <field name="summaryOfCalculationMethod" class="java.lang.String"/> |
---|
81 | <field name="inventoryLocationCount" class="java.lang.Integer"/> |
---|
82 | <background> |
---|
83 | <band splitType="Stretch"/> |
---|
84 | </background> |
---|
85 | <pageHeader> |
---|
86 | <band height="121" splitType="Stretch"> |
---|
87 | <textField> |
---|
88 | <reportElement key="staticText-1" x="0" y="57" width="340" height="30"/> |
---|
89 | <textElement textAlignment="Center" verticalAlignment="Top" markup="none"> |
---|
90 | <font fontName="Serif" size="20"/> |
---|
91 | </textElement> |
---|
92 | <textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression> |
---|
93 | </textField> |
---|
94 | <image> |
---|
95 | <reportElement x="0" y="0" width="340" height="57"/> |
---|
96 | <imageExpression class="java.net.URL"><![CDATA[new URL($P{logoUrl})]]></imageExpression> |
---|
97 | </image> |
---|
98 | <textField pattern="dd-MMM-yyyy" isBlankWhenNull="true"> |
---|
99 | <reportElement x="0" y="87" width="340" height="20"/> |
---|
100 | <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> |
---|
101 | <font fontName="Serif"/> |
---|
102 | </textElement> |
---|
103 | <textFieldExpression class="java.lang.String"><![CDATA["Total Locations: "+$F{inventoryLocationCount}]]></textFieldExpression> |
---|
104 | </textField> |
---|
105 | </band> |
---|
106 | </pageHeader> |
---|
107 | <columnHeader> |
---|
108 | <band splitType="Stretch"/> |
---|
109 | </columnHeader> |
---|
110 | <detail> |
---|
111 | <band height="641" splitType="Stretch"> |
---|
112 | <componentElement> |
---|
113 | <reportElement key="table 1" x="0" y="0" width="535" height="641"/> |
---|
114 | <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"> |
---|
115 | <datasetRun subDataset="dataset1"> |
---|
116 | <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{inventoryLocationList})]]></dataSourceExpression> |
---|
117 | </datasetRun> |
---|
118 | <jr:column width="127"> |
---|
119 | <jr:groupHeader groupName="group1"> |
---|
120 | <jr:cell height="30" rowSpan="1"> |
---|
121 | <textField> |
---|
122 | <reportElement x="0" y="0" width="127" height="30"/> |
---|
123 | <textElement verticalAlignment="Middle"> |
---|
124 | <font fontName="Serif" size="12" isBold="true"/> |
---|
125 | </textElement> |
---|
126 | <textFieldExpression class="java.lang.String"><![CDATA[$F{store}]]></textFieldExpression> |
---|
127 | </textField> |
---|
128 | </jr:cell> |
---|
129 | </jr:groupHeader> |
---|
130 | <jr:columnHeader style="table_CH" height="30" rowSpan="1"> |
---|
131 | <textField> |
---|
132 | <reportElement x="0" y="0" width="127" height="30"/> |
---|
133 | <textElement verticalAlignment="Middle"> |
---|
134 | <font fontName="Serif" size="12" isBold="true"/> |
---|
135 | </textElement> |
---|
136 | <textFieldExpression class="java.lang.String"><![CDATA["Store: "+$F{store}]]></textFieldExpression> |
---|
137 | </textField> |
---|
138 | </jr:columnHeader> |
---|
139 | <jr:detailCell style="table_TD" height="30" rowSpan="1"/> |
---|
140 | </jr:column> |
---|
141 | <jr:column width="91"> |
---|
142 | <jr:columnHeader style="table_CH" height="30" rowSpan="1"> |
---|
143 | <textField> |
---|
144 | <reportElement x="0" y="0" width="91" height="30"/> |
---|
145 | <textElement verticalAlignment="Middle"> |
---|
146 | <font fontName="Serif" size="12" isBold="true"/> |
---|
147 | </textElement> |
---|
148 | <textFieldExpression class="java.lang.String"><![CDATA["Location"]]></textFieldExpression> |
---|
149 | </textField> |
---|
150 | </jr:columnHeader> |
---|
151 | <jr:detailCell style="table_TD" height="30" rowSpan="1"> |
---|
152 | <textField> |
---|
153 | <reportElement x="0" y="0" width="91" height="30"/> |
---|
154 | <textElement verticalAlignment="Middle"> |
---|
155 | <font fontName="Serif"/> |
---|
156 | </textElement> |
---|
157 | <textFieldExpression class="java.lang.String"><![CDATA[$F{location}]]></textFieldExpression> |
---|
158 | </textField> |
---|
159 | </jr:detailCell> |
---|
160 | </jr:column> |
---|
161 | <jr:column width="104"> |
---|
162 | <jr:columnHeader style="table_CH" height="30" rowSpan="1"> |
---|
163 | <textField> |
---|
164 | <reportElement x="0" y="0" width="104" height="30"/> |
---|
165 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
166 | <font fontName="Serif" size="12" isBold="true"/> |
---|
167 | </textElement> |
---|
168 | <textFieldExpression class="java.lang.String"><![CDATA["Location Report Prepared"]]></textFieldExpression> |
---|
169 | </textField> |
---|
170 | </jr:columnHeader> |
---|
171 | <jr:detailCell style="table_TD" height="30" rowSpan="1"> |
---|
172 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
173 | <leftPen lineWidth="0.0"/> |
---|
174 | <rightPen lineWidth="0.0"/> |
---|
175 | </box> |
---|
176 | <rectangle radius="10"> |
---|
177 | <reportElement x="37" y="5" width="30" height="20"/> |
---|
178 | </rectangle> |
---|
179 | </jr:detailCell> |
---|
180 | </jr:column> |
---|
181 | <jr:column width="107"> |
---|
182 | <jr:columnHeader style="table_CH" height="30" rowSpan="1"> |
---|
183 | <textField> |
---|
184 | <reportElement x="0" y="0" width="107" height="30"/> |
---|
185 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
---|
186 | <font fontName="Serif" size="12" isBold="true"/> |
---|
187 | </textElement> |
---|
188 | <textFieldExpression class="java.lang.String"><![CDATA["Stock Take Complete"]]></textFieldExpression> |
---|
189 | </textField> |
---|
190 | </jr:columnHeader> |
---|
191 | <jr:detailCell style="table_TD" height="30" rowSpan="1"> |
---|
192 | <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> |
---|
193 | <leftPen lineWidth="0.0"/> |
---|
194 | <rightPen lineWidth="0.0"/> |
---|
195 | </box> |
---|
196 | <rectangle radius="10"> |
---|
197 | <reportElement x="38" y="5" width="30" height="20"/> |
---|
198 | </rectangle> |
---|
199 | </jr:detailCell> |
---|
200 | </jr:column> |
---|
201 | <jr:column width="107"> |
---|
202 | <jr:columnHeader style="table_CH" height="30" rowSpan="1"> |
---|
203 | <textField> |
---|
204 | <reportElement x="0" y="0" width="107" height="30"/> |
---|
205 | <textElement verticalAlignment="Middle"> |
---|
206 | <font fontName="Serif" size="12" isBold="true"/> |
---|
207 | </textElement> |
---|
208 | <textFieldExpression class="java.lang.String"><![CDATA["Notes"]]></textFieldExpression> |
---|
209 | </textField> |
---|
210 | </jr:columnHeader> |
---|
211 | <jr:detailCell style="table_TD" height="30" rowSpan="1"/> |
---|
212 | </jr:column> |
---|
213 | </jr:table> |
---|
214 | </componentElement> |
---|
215 | </band> |
---|
216 | </detail> |
---|
217 | <columnFooter> |
---|
218 | <band splitType="Stretch"/> |
---|
219 | </columnFooter> |
---|
220 | <pageFooter> |
---|
221 | <band height="40" splitType="Stretch"> |
---|
222 | <textField pattern="dd-MMM-yyyy"> |
---|
223 | <reportElement x="82" y="0" width="200" height="20"/> |
---|
224 | <textElement> |
---|
225 | <font fontName="Serif"/> |
---|
226 | </textElement> |
---|
227 | <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> |
---|
228 | </textField> |
---|
229 | <textField> |
---|
230 | <reportElement x="415" y="20" width="80" height="20"/> |
---|
231 | <textElement textAlignment="Right"> |
---|
232 | <font fontName="Serif"/> |
---|
233 | </textElement> |
---|
234 | <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> |
---|
235 | </textField> |
---|
236 | <textField evaluationTime="Report"> |
---|
237 | <reportElement x="495" y="20" width="40" height="20"/> |
---|
238 | <textElement> |
---|
239 | <font fontName="Serif"/> |
---|
240 | </textElement> |
---|
241 | <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> |
---|
242 | </textField> |
---|
243 | <textField> |
---|
244 | <reportElement x="0" y="0" width="82" height="20"/> |
---|
245 | <textElement markup="none"> |
---|
246 | <font fontName="Serif"/> |
---|
247 | </textElement> |
---|
248 | <textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression> |
---|
249 | </textField> |
---|
250 | <textField> |
---|
251 | <reportElement x="82" y="20" width="200" height="20"/> |
---|
252 | <textElement markup="none"> |
---|
253 | <font fontName="Serif"/> |
---|
254 | </textElement> |
---|
255 | <textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression> |
---|
256 | </textField> |
---|
257 | <textField> |
---|
258 | <reportElement x="0" y="20" width="82" height="20"/> |
---|
259 | <textElement markup="none"> |
---|
260 | <font fontName="Serif"/> |
---|
261 | </textElement> |
---|
262 | <textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression> |
---|
263 | </textField> |
---|
264 | </band> |
---|
265 | </pageFooter> |
---|
266 | <lastPageFooter> |
---|
267 | <band height="40"> |
---|
268 | <textField evaluationTime="Report"> |
---|
269 | <reportElement x="495" y="20" width="40" height="20"/> |
---|
270 | <textElement> |
---|
271 | <font fontName="Serif"/> |
---|
272 | </textElement> |
---|
273 | <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> |
---|
274 | </textField> |
---|
275 | <textField pattern="dd-MMM-yyyy"> |
---|
276 | <reportElement x="82" y="0" width="200" height="20"/> |
---|
277 | <textElement> |
---|
278 | <font fontName="Serif"/> |
---|
279 | </textElement> |
---|
280 | <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> |
---|
281 | </textField> |
---|
282 | <textField> |
---|
283 | <reportElement x="0" y="0" width="82" height="20"/> |
---|
284 | <textElement markup="none"> |
---|
285 | <font fontName="Serif"/> |
---|
286 | </textElement> |
---|
287 | <textFieldExpression class="java.lang.String"><![CDATA["Generated: "]]></textFieldExpression> |
---|
288 | </textField> |
---|
289 | <textField> |
---|
290 | <reportElement x="0" y="20" width="82" height="20"/> |
---|
291 | <textElement markup="none"> |
---|
292 | <font fontName="Serif"/> |
---|
293 | </textElement> |
---|
294 | <textFieldExpression class="java.lang.String"><![CDATA["By: "]]></textFieldExpression> |
---|
295 | </textField> |
---|
296 | <textField> |
---|
297 | <reportElement x="82" y="20" width="200" height="20"/> |
---|
298 | <textElement markup="none"> |
---|
299 | <font fontName="Serif"/> |
---|
300 | </textElement> |
---|
301 | <textFieldExpression class="java.lang.String"><![CDATA[$P{currentUser}]]></textFieldExpression> |
---|
302 | </textField> |
---|
303 | <textField> |
---|
304 | <reportElement x="415" y="20" width="80" height="20"/> |
---|
305 | <textElement textAlignment="Right"> |
---|
306 | <font fontName="Serif"/> |
---|
307 | </textElement> |
---|
308 | <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> |
---|
309 | </textField> |
---|
310 | </band> |
---|
311 | </lastPageFooter> |
---|
312 | <summary> |
---|
313 | <band height="369"> |
---|
314 | <textField> |
---|
315 | <reportElement key="staticText-1" x="97" y="12" width="340" height="30"/> |
---|
316 | <textElement textAlignment="Center" verticalAlignment="Top" markup="none"> |
---|
317 | <font fontName="Serif" size="20"/> |
---|
318 | </textElement> |
---|
319 | <textFieldExpression class="java.lang.String"><![CDATA["Summary"]]></textFieldExpression> |
---|
320 | </textField> |
---|
321 | <textField> |
---|
322 | <reportElement x="0" y="60" width="535" height="309"/> |
---|
323 | <textElement> |
---|
324 | <font fontName="Serif"/> |
---|
325 | </textElement> |
---|
326 | <textFieldExpression class="java.lang.String"><![CDATA[$F{summaryOfCalculationMethod}]]></textFieldExpression> |
---|
327 | </textField> |
---|
328 | </band> |
---|
329 | </summary> |
---|
330 | <noData> |
---|
331 | <band height="85" splitType="Stretch"> |
---|
332 | <textField> |
---|
333 | <reportElement x="0" y="35" width="535" height="50"/> |
---|
334 | <textElement textAlignment="Center" markup="none"> |
---|
335 | <font fontName="Serif" size="14" isBold="true"/> |
---|
336 | </textElement> |
---|
337 | <textFieldExpression class="java.lang.String"><![CDATA["No data to display. \n"+ |
---|
338 | "Please run report again."]]></textFieldExpression> |
---|
339 | </textField> |
---|
340 | <textField> |
---|
341 | <reportElement key="staticText-1" x="0" y="0" width="535" height="35"/> |
---|
342 | <textElement textAlignment="Center" markup="none"> |
---|
343 | <font fontName="Serif" size="20"/> |
---|
344 | </textElement> |
---|
345 | <textFieldExpression class="java.lang.String"><![CDATA[$P{reportTitle}]]></textFieldExpression> |
---|
346 | </textField> |
---|
347 | </band> |
---|
348 | </noData> |
---|
349 | </jasperReport> |
---|