PrimaRekonDailyRekap.jrxml 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522
  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="PrimaRekonDailyRekap" language="groovy" pageWidth="595" pageHeight="1080" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
  3. <property name="ireport.zoom" value="1.0"/>
  4. <property name="ireport.x" value="0"/>
  5. <property name="ireport.y" value="0"/>
  6. <parameter name="START_DATE" class="java.util.Date">
  7. <defaultValueExpression><![CDATA[]]></defaultValueExpression>
  8. </parameter>
  9. <parameter name="END_DATE" class="java.util.Date">
  10. <defaultValueExpression><![CDATA[]]></defaultValueExpression>
  11. </parameter>
  12. <queryString>
  13. <![CDATA[]]>
  14. </queryString>
  15. <field name="approveInCoreAndApproveInPrimaFrek" class="java.lang.Integer">
  16. <fieldDescription><![CDATA[approveInCoreAndApproveInPrimaFrek]]></fieldDescription>
  17. </field>
  18. <field name="approveInCoreAndApproveInPrimaTotal" class="java.math.BigDecimal">
  19. <fieldDescription><![CDATA[approveInCoreAndApproveInPrimaTotal]]></fieldDescription>
  20. </field>
  21. <field name="approveInCoreAndFailedInPrimaFrek" class="java.lang.Integer">
  22. <fieldDescription><![CDATA[approveInCoreAndFailedInPrimaFrek]]></fieldDescription>
  23. </field>
  24. <field name="approveInCoreAndFailedInPrimaTotal" class="java.math.BigDecimal">
  25. <fieldDescription><![CDATA[approveInCoreAndFailedInPrimaTotal]]></fieldDescription>
  26. </field>
  27. <field name="approveInCoreAndNotApproveInPrimaFrek" class="java.lang.Integer">
  28. <fieldDescription><![CDATA[approveInCoreAndNotApproveInPrimaFrek]]></fieldDescription>
  29. </field>
  30. <field name="approveInCoreAndNotApproveInPrimaTotal" class="java.math.BigDecimal">
  31. <fieldDescription><![CDATA[approveInCoreAndNotApproveInPrimaTotal]]></fieldDescription>
  32. </field>
  33. <field name="approveInPrimaAndNotApproveInCoreFrek" class="java.lang.Integer">
  34. <fieldDescription><![CDATA[approveInPrimaAndNotApproveInCoreFrek]]></fieldDescription>
  35. </field>
  36. <field name="approveInPrimaAndNotApproveInCoreTotal" class="java.math.BigDecimal">
  37. <fieldDescription><![CDATA[approveInPrimaAndNotApproveInCoreTotal]]></fieldDescription>
  38. </field>
  39. <field name="btnFrek" class="java.lang.Integer">
  40. <fieldDescription><![CDATA[btnFrek]]></fieldDescription>
  41. </field>
  42. <field name="btnTotal" class="java.math.BigDecimal">
  43. <fieldDescription><![CDATA[btnTotal]]></fieldDescription>
  44. </field>
  45. <field name="class" class="java.lang.Class">
  46. <fieldDescription><![CDATA[class]]></fieldDescription>
  47. </field>
  48. <field name="primaFrek" class="java.lang.Integer">
  49. <fieldDescription><![CDATA[primaFrek]]></fieldDescription>
  50. </field>
  51. <field name="primaTotal" class="java.math.BigDecimal">
  52. <fieldDescription><![CDATA[primaTotal]]></fieldDescription>
  53. </field>
  54. <field name="title" class="java.lang.String">
  55. <fieldDescription><![CDATA[title]]></fieldDescription>
  56. </field>
  57. <variable name="TOTAL" class="java.lang.Integer"/>
  58. <variable name="TOTAL_NOMINAL" class="java.math.BigDecimal"/>
  59. <background>
  60. <band splitType="Stretch"/>
  61. </background>
  62. <pageHeader>
  63. <band height="20">
  64. <textField pattern="dd-MM-yyyy">
  65. <reportElement x="178" y="0" width="377" height="20"/>
  66. <box leftPadding="3">
  67. <rightPen lineWidth="0.0"/>
  68. </box>
  69. <textElement/>
  70. <textFieldExpression class="java.util.Date"><![CDATA[$P{END_DATE}]]></textFieldExpression>
  71. </textField>
  72. <staticText>
  73. <reportElement x="1" y="0" width="90" height="20"/>
  74. <box leftPadding="3">
  75. <topPen lineWidth="0.0" lineStyle="Solid"/>
  76. <leftPen lineWidth="0.0" lineStyle="Solid"/>
  77. <bottomPen lineWidth="0.0" lineStyle="Solid"/>
  78. </box>
  79. <textElement/>
  80. <text><![CDATA[Periode :]]></text>
  81. </staticText>
  82. <staticText>
  83. <reportElement x="164" y="0" width="14" height="20"/>
  84. <box leftPadding="3"/>
  85. <textElement/>
  86. <text><![CDATA[to]]></text>
  87. </staticText>
  88. <textField pattern="dd-MM-yyyy">
  89. <reportElement x="91" y="0" width="73" height="20"/>
  90. <box leftPadding="3" rightPadding="3"/>
  91. <textElement/>
  92. <textFieldExpression class="java.util.Date"><![CDATA[$P{START_DATE}]]></textFieldExpression>
  93. </textField>
  94. </band>
  95. </pageHeader>
  96. <detail>
  97. <band height="203">
  98. <staticText>
  99. <reportElement x="0" y="20" width="221" height="40"/>
  100. <box>
  101. <topPen lineWidth="1.0" lineStyle="Solid"/>
  102. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  103. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  104. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  105. </box>
  106. <textElement>
  107. <font isBold="false"/>
  108. </textElement>
  109. <text><![CDATA[]]></text>
  110. </staticText>
  111. <staticText>
  112. <reportElement x="388" y="20" width="167" height="20"/>
  113. <box>
  114. <topPen lineWidth="1.0" lineStyle="Solid"/>
  115. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  116. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  117. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  118. </box>
  119. <textElement textAlignment="Center"/>
  120. <text><![CDATA[PRIMA]]></text>
  121. </staticText>
  122. <staticText>
  123. <reportElement x="221" y="20" width="167" height="20"/>
  124. <box>
  125. <topPen lineWidth="1.0" lineStyle="Solid"/>
  126. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  127. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  128. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  129. </box>
  130. <textElement textAlignment="Center"/>
  131. <text><![CDATA[BTN]]></text>
  132. </staticText>
  133. <staticText>
  134. <reportElement x="221" y="40" width="59" height="20"/>
  135. <box>
  136. <topPen lineWidth="1.0" lineStyle="Solid"/>
  137. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  138. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  139. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  140. </box>
  141. <textElement textAlignment="Center"/>
  142. <text><![CDATA[FREK]]></text>
  143. </staticText>
  144. <staticText>
  145. <reportElement x="280" y="40" width="108" height="20"/>
  146. <box>
  147. <topPen lineWidth="1.0" lineStyle="Solid"/>
  148. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  149. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  150. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  151. </box>
  152. <textElement textAlignment="Center"/>
  153. <text><![CDATA[NOMINAL]]></text>
  154. </staticText>
  155. <staticText>
  156. <reportElement x="447" y="40" width="108" height="20"/>
  157. <box>
  158. <topPen lineWidth="1.0" lineStyle="Solid"/>
  159. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  160. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  161. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  162. </box>
  163. <textElement textAlignment="Center"/>
  164. <text><![CDATA[NOMINAL]]></text>
  165. </staticText>
  166. <staticText>
  167. <reportElement x="388" y="40" width="59" height="20"/>
  168. <box>
  169. <topPen lineWidth="1.0" lineStyle="Solid"/>
  170. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  171. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  172. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  173. </box>
  174. <textElement textAlignment="Center"/>
  175. <text><![CDATA[FREK]]></text>
  176. </staticText>
  177. <staticText>
  178. <reportElement x="0" y="60" width="221" height="20"/>
  179. <box>
  180. <topPen lineWidth="1.0" lineStyle="Solid"/>
  181. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  182. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  183. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  184. </box>
  185. <textElement>
  186. <font size="9"/>
  187. </textElement>
  188. <text><![CDATA[Initial Data (A)]]></text>
  189. </staticText>
  190. <staticText>
  191. <reportElement x="0" y="80" width="221" height="20"/>
  192. <box>
  193. <topPen lineWidth="1.0" lineStyle="Solid"/>
  194. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  195. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  196. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  197. </box>
  198. <textElement>
  199. <font size="9"/>
  200. </textElement>
  201. <text><![CDATA[Approve In Prima And Not Approve In Core (B)]]></text>
  202. </staticText>
  203. <staticText>
  204. <reportElement x="0" y="100" width="221" height="20"/>
  205. <box>
  206. <topPen lineWidth="1.0" lineStyle="Solid"/>
  207. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  208. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  209. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  210. </box>
  211. <textElement>
  212. <font size="9"/>
  213. </textElement>
  214. <text><![CDATA[Approve In Core And Not Approve In Prima (C)]]></text>
  215. </staticText>
  216. <staticText>
  217. <reportElement x="0" y="120" width="221" height="20"/>
  218. <box>
  219. <topPen lineWidth="1.0" lineStyle="Solid"/>
  220. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  221. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  222. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  223. </box>
  224. <textElement>
  225. <font size="9"/>
  226. </textElement>
  227. <text><![CDATA[Total(A+B-C)]]></text>
  228. </staticText>
  229. <staticText>
  230. <reportElement x="0" y="140" width="221" height="20"/>
  231. <box>
  232. <topPen lineWidth="1.0" lineStyle="Solid"/>
  233. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  234. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  235. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  236. </box>
  237. <textElement>
  238. <font size="9"/>
  239. </textElement>
  240. <text><![CDATA[Approve In Core And Prima (Match)]]></text>
  241. </staticText>
  242. <staticText>
  243. <reportElement x="0" y="160" width="221" height="20"/>
  244. <box>
  245. <topPen lineWidth="1.0" lineStyle="Solid"/>
  246. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  247. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  248. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  249. </box>
  250. <textElement>
  251. <font size="9"/>
  252. </textElement>
  253. <text><![CDATA[Approve In Core Failed On Prima (Failed)]]></text>
  254. </staticText>
  255. <textField>
  256. <reportElement x="1" y="0" width="329" height="20"/>
  257. <box topPadding="2" leftPadding="2"/>
  258. <textElement/>
  259. <textFieldExpression class="java.lang.String"><![CDATA[$F{title}]]></textFieldExpression>
  260. </textField>
  261. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  262. <reportElement x="221" y="60" width="59" height="20"/>
  263. <box topPadding="2" leftPadding="2">
  264. <topPen lineWidth="1.0" lineStyle="Solid"/>
  265. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  266. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  267. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  268. </box>
  269. <textElement/>
  270. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{btnFrek}]]></textFieldExpression>
  271. </textField>
  272. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  273. <reportElement x="280" y="60" width="108" height="20"/>
  274. <box topPadding="2" rightPadding="2">
  275. <topPen lineWidth="1.0" lineStyle="Solid"/>
  276. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  277. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  278. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  279. </box>
  280. <textElement textAlignment="Right"/>
  281. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{btnTotal}]]></textFieldExpression>
  282. </textField>
  283. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  284. <reportElement x="221" y="80" width="59" height="20"/>
  285. <box topPadding="2" leftPadding="2">
  286. <topPen lineWidth="1.0" lineStyle="Solid"/>
  287. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  288. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  289. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  290. </box>
  291. <textElement/>
  292. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{approveInPrimaAndNotApproveInCoreFrek}]]></textFieldExpression>
  293. </textField>
  294. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  295. <reportElement x="280" y="80" width="108" height="20"/>
  296. <box topPadding="2" rightPadding="2">
  297. <topPen lineWidth="1.0" lineStyle="Solid"/>
  298. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  299. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  300. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  301. </box>
  302. <textElement textAlignment="Right"/>
  303. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{approveInPrimaAndNotApproveInCoreTotal}]]></textFieldExpression>
  304. </textField>
  305. <staticText>
  306. <reportElement x="388" y="80" width="59" height="20"/>
  307. <box>
  308. <topPen lineWidth="1.0" lineStyle="Solid"/>
  309. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  310. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  311. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  312. </box>
  313. <textElement/>
  314. <text><![CDATA[]]></text>
  315. </staticText>
  316. <staticText>
  317. <reportElement x="447" y="80" width="108" height="20"/>
  318. <box>
  319. <topPen lineWidth="1.0" lineStyle="Solid"/>
  320. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  321. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  322. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  323. </box>
  324. <textElement/>
  325. <text><![CDATA[]]></text>
  326. </staticText>
  327. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  328. <reportElement x="221" y="100" width="59" height="20"/>
  329. <box topPadding="2" leftPadding="2">
  330. <topPen lineWidth="1.0" lineStyle="Solid"/>
  331. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  332. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  333. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  334. </box>
  335. <textElement/>
  336. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{approveInCoreAndNotApproveInPrimaFrek}]]></textFieldExpression>
  337. </textField>
  338. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  339. <reportElement x="280" y="100" width="108" height="20"/>
  340. <box topPadding="2" rightPadding="2">
  341. <topPen lineWidth="1.0" lineStyle="Solid"/>
  342. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  343. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  344. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  345. </box>
  346. <textElement textAlignment="Right"/>
  347. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{approveInCoreAndNotApproveInPrimaTotal}]]></textFieldExpression>
  348. </textField>
  349. <staticText>
  350. <reportElement x="388" y="100" width="59" height="20"/>
  351. <box>
  352. <topPen lineWidth="1.0" lineStyle="Solid"/>
  353. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  354. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  355. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  356. </box>
  357. <textElement/>
  358. <text><![CDATA[]]></text>
  359. </staticText>
  360. <staticText>
  361. <reportElement x="447" y="100" width="108" height="20"/>
  362. <box>
  363. <topPen lineWidth="1.0" lineStyle="Solid"/>
  364. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  365. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  366. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  367. </box>
  368. <textElement/>
  369. <text><![CDATA[]]></text>
  370. </staticText>
  371. <staticText>
  372. <reportElement x="221" y="120" width="59" height="20"/>
  373. <box>
  374. <topPen lineWidth="1.0" lineStyle="Solid"/>
  375. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  376. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  377. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  378. </box>
  379. <textElement/>
  380. <text><![CDATA[]]></text>
  381. </staticText>
  382. <staticText>
  383. <reportElement x="280" y="120" width="108" height="20"/>
  384. <box>
  385. <topPen lineWidth="1.0" lineStyle="Solid"/>
  386. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  387. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  388. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  389. </box>
  390. <textElement/>
  391. <text><![CDATA[]]></text>
  392. </staticText>
  393. <staticText>
  394. <reportElement x="221" y="140" width="59" height="20"/>
  395. <box>
  396. <topPen lineWidth="1.0" lineStyle="Solid"/>
  397. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  398. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  399. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  400. </box>
  401. <textElement/>
  402. <text><![CDATA[]]></text>
  403. </staticText>
  404. <staticText>
  405. <reportElement x="280" y="140" width="108" height="20"/>
  406. <box>
  407. <topPen lineWidth="1.0" lineStyle="Solid"/>
  408. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  409. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  410. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  411. </box>
  412. <textElement/>
  413. <text><![CDATA[]]></text>
  414. </staticText>
  415. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  416. <reportElement x="221" y="160" width="59" height="20"/>
  417. <box topPadding="2" leftPadding="2">
  418. <topPen lineWidth="1.0" lineStyle="Solid"/>
  419. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  420. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  421. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  422. </box>
  423. <textElement/>
  424. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{approveInCoreAndFailedInPrimaFrek}]]></textFieldExpression>
  425. </textField>
  426. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  427. <reportElement x="280" y="160" width="108" height="20"/>
  428. <box topPadding="2" rightPadding="2">
  429. <topPen lineWidth="1.0" lineStyle="Solid"/>
  430. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  431. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  432. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  433. </box>
  434. <textElement textAlignment="Right"/>
  435. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{approveInCoreAndFailedInPrimaTotal}]]></textFieldExpression>
  436. </textField>
  437. <textField>
  438. <reportElement x="388" y="140" width="59" height="20"/>
  439. <box topPadding="2" leftPadding="2">
  440. <topPen lineWidth="1.0" lineStyle="Solid"/>
  441. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  442. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  443. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  444. </box>
  445. <textElement/>
  446. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{approveInCoreAndApproveInPrimaFrek}]]></textFieldExpression>
  447. </textField>
  448. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  449. <reportElement x="447" y="140" width="108" height="20"/>
  450. <box topPadding="2" rightPadding="2">
  451. <topPen lineWidth="1.0" lineStyle="Solid"/>
  452. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  453. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  454. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  455. </box>
  456. <textElement textAlignment="Right"/>
  457. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{approveInCoreAndApproveInPrimaTotal}]]></textFieldExpression>
  458. </textField>
  459. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  460. <reportElement x="388" y="160" width="59" height="20"/>
  461. <box topPadding="2" leftPadding="2">
  462. <topPen lineWidth="1.0" lineStyle="Solid"/>
  463. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  464. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  465. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  466. </box>
  467. <textElement/>
  468. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{approveInCoreAndFailedInPrimaFrek}]]></textFieldExpression>
  469. </textField>
  470. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  471. <reportElement x="447" y="160" width="108" height="20"/>
  472. <box topPadding="2" rightPadding="2">
  473. <topPen lineWidth="1.0" lineStyle="Solid"/>
  474. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  475. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  476. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  477. </box>
  478. <textElement textAlignment="Right"/>
  479. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{approveInCoreAndFailedInPrimaTotal}]]></textFieldExpression>
  480. </textField>
  481. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  482. <reportElement x="388" y="120" width="59" height="20"/>
  483. <box topPadding="2" leftPadding="2">
  484. <topPen lineWidth="1.0" lineStyle="Solid"/>
  485. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  486. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  487. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  488. </box>
  489. <textElement/>
  490. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{btnFrek}+$F{approveInPrimaAndNotApproveInCoreFrek}-$F{approveInCoreAndNotApproveInPrimaFrek}]]></textFieldExpression>
  491. </textField>
  492. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  493. <reportElement x="447" y="120" width="108" height="20"/>
  494. <box topPadding="2" rightPadding="2">
  495. <topPen lineWidth="1.0" lineStyle="Solid"/>
  496. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  497. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  498. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  499. </box>
  500. <textElement textAlignment="Right"/>
  501. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{btnTotal}.add($F{approveInPrimaAndNotApproveInCoreTotal}).subtract($F{approveInCoreAndNotApproveInPrimaTotal})]]></textFieldExpression>
  502. </textField>
  503. <textField>
  504. <reportElement x="388" y="60" width="59" height="20"/>
  505. <box topPadding="2" leftPadding="2"/>
  506. <textElement/>
  507. <textFieldExpression class="java.lang.Integer"><![CDATA[$F{approveInCoreAndApproveInPrimaFrek}+$F{approveInPrimaAndNotApproveInCoreFrek}]]></textFieldExpression>
  508. </textField>
  509. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  510. <reportElement x="447" y="60" width="108" height="20"/>
  511. <box topPadding="2" rightPadding="2">
  512. <topPen lineWidth="1.0" lineStyle="Solid"/>
  513. <leftPen lineWidth="1.0" lineStyle="Solid"/>
  514. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  515. <rightPen lineWidth="1.0" lineStyle="Solid"/>
  516. </box>
  517. <textElement textAlignment="Right"/>
  518. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{approveInCoreAndApproveInPrimaTotal}.add($F{approveInPrimaAndNotApproveInCoreTotal})]]></textFieldExpression>
  519. </textField>
  520. </band>
  521. </detail>
  522. </jasperReport>