API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.03 KB | None | 0 0
raw download clone embed print report
  1. Error filling print... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : RateReinsurance
  2. net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : RateReinsurance
  3. at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:787)
  4. (Remaining details removed due to character limit)
  5.  
  6. Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : RateReinsurance
  7. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)
  8. (Remaining details removed due to character limit)
  9.  
  10. Caused by: java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
  11. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  12. (Remaining details removed due to character limit)
  13.  
  14. <jasperReport>
  15. <parameter>
  16. (Removed due to character limit)
  17. </parameter>
  18. <queryString>
  19. (Removed due to character limit, but this query does return result without any error)
  20. </queryString>
  21. <field name="BINDING_ID" class="java.lang.String"/>
  22. <field name="BINDING_REVISED" class="java.lang.String"/>
  23. <field name="LOB_ID" class="java.lang.String"/>
  24. <field name="DEPT_ID" class="java.lang.String"/>
  25. <field name="BRANCH_ID" class="java.lang.String"/>
  26. <field name="BINDING_MONTH" class="java.lang.String"/>
  27. <field name="BINDING_YEAR" class="java.lang.String"/>
  28. <field name="REN_END" class="java.lang.String"/>
  29. <field name="REINSURANCE_ID" class="java.lang.String"/>
  30. <field name="REINSSQ" class="java.lang.String"/>
  31. <field name="SHARES" class="java.math.BigDecimal"/>
  32. <field name="RATE" class="java.math.BigDecimal"/>
  33. <field name="SHARE_COMM" class="java.math.BigDecimal"/>
  34. <field name="CURR_ID" class="java.lang.String"/>
  35. <field name="DETAIL_SQ" class="java.lang.String"/>
  36. <field name="TOTAL_SI_VALUE" class="java.math.BigDecimal"/>
  37. <field name="LOB_DESC" class="java.lang.String"/>
  38. <field name="RATECOUNT" class="java.math.BigDecimal"/>
  39. <field name="PREMI" class="java.math.BigDecimal"/>
  40. <field name="COMM" class="java.math.BigDecimal"/>
  41. <field name="SHARE_DISC" class="java.math.BigDecimal"/>
  42. <field name="DISCOUNT" class="java.math.BigDecimal"/>
  43. <variable name="variable1" class="java.math.BigDecimal">
  44. <variableExpression><![CDATA[$F{PREMI}.add($F{COMM}).add($F{DISCOUNT})]]></variableExpression>
  45. </variable>
  46. <group name="curr">
  47. <groupExpression><![CDATA[$F{CURR_ID}]]></groupExpression>
  48. </group>
  49. <group name="DETAIL_SQ">
  50. <groupExpression><![CDATA[$F{DETAIL_SQ}]]></groupExpression>
  51. <groupHeader>
  52. <band height="15">
  53. <textField isStretchWithOverflow="true">
  54. <reportElement uuid="3fcf4367-96eb-4510-bdfe-b6264acab241" positionType="Float" isPrintRepeatedValues="false" x="0" y="0" width="555" height="15" isRemoveLineWhenBlank="true"/>
  55. <textElement>
  56. <font isBold="true" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  57. </textElement>
  58. <textFieldExpression><![CDATA["Detail Premium Calculation for "+$F{LOB_DESC}]]></textFieldExpression>
  59. </textField>
  60. </band>
  61. </groupHeader>
  62. </group>
  63. <detail>
  64. <band height="139" splitType="Stretch">
  65. <textField>
  66. <reportElement uuid="d08fe1a3-8650-43b1-86da-7473b3bda3ba" positionType="Float" isPrintRepeatedValues="false" x="19" y="1" width="100" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  67. <textElement markup="none">
  68. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  69. </textElement>
  70. <textFieldExpression><![CDATA[$P{DEPT}!='M' ? "Total SI" : null]]></textFieldExpression>
  71. </textField>
  72. <textField>
  73. <reportElement uuid="114a77b8-316c-4845-a898-e947bdc6cea2" positionType="Float" isPrintRepeatedValues="false" x="102" y="1" width="18" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  74. <textElement textAlignment="Center" markup="none">
  75. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  76. </textElement>
  77. <textFieldExpression><![CDATA[$P{DEPT}!='M' ? ":" : null]]></textFieldExpression>
  78. </textField>
  79. <textField>
  80. <reportElement uuid="85870c4f-23c2-4fd9-8db9-37ebdfbc24bb" positionType="Float" isPrintRepeatedValues="false" x="122" y="1" width="136" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  81. <textElement markup="none">
  82. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  83. </textElement>
  84. <textFieldExpression><![CDATA[$P{DEPT}!='M' ? $F{CURR_ID}+". "+new java.text.DecimalFormat("#,##0.00").format($F{TOTAL_SI_VALUE}) : null]]></textFieldExpression>
  85. </textField>
  86. <textField isBlankWhenNull="true">
  87. <reportElement uuid="825f3cc5-770b-46db-a51a-3bc03993270c" positionType="Float" isPrintRepeatedValues="false" x="19" y="16" width="100" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  88. <textElement markup="none">
  89. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  90. </textElement>
  91. <textFieldExpression><![CDATA[$F{SHARES} != 0 ?"Your Share":null]]></textFieldExpression>
  92. </textField>
  93. <textField isBlankWhenNull="true">
  94. <reportElement uuid="4dac225b-de01-49b7-8e10-b9bbd7bb542d" positionType="Float" isPrintRepeatedValues="false" x="102" y="16" width="18" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  95. <textElement textAlignment="Center" markup="none">
  96. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  97. </textElement>
  98. <textFieldExpression><![CDATA[$F{SHARES} != 0 ?":":null]]></textFieldExpression>
  99. </textField>
  100. <textField pattern="###0.00### &apos;%&apos;" isBlankWhenNull="true">
  101. <reportElement uuid="8aa3a080-658e-4ec2-b413-28d6702fbed9" positionType="Float" isPrintRepeatedValues="false" x="122" y="16" width="136" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  102. <textElement>
  103. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  104. </textElement>
  105. <textFieldExpression><![CDATA[$F{SHARES} != 0 ?$F{SHARES}:null]]></textFieldExpression>
  106. </textField>
  107. <textField isBlankWhenNull="true">
  108. <reportElement uuid="ecbe01b2-93c3-479a-a2fc-762b7b365fdc" positionType="Float" x="19" y="31" width="100" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  109. <textElement markup="none">
  110. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  111. </textElement>
  112. <textFieldExpression><![CDATA[$F{RATE}==0?
  113. "Original Gross Rate"
  114. :($F{COMM}!=0?
  115. "Original Gross Rate"
  116. :"Absolute Net Rate")]]></textFieldExpression>
  117. </textField>
  118. <textField isBlankWhenNull="true">
  119. <reportElement uuid="41250bf0-00f8-4de3-9a1b-850b9ec23743" positionType="Float" x="102" y="31" width="18" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  120. <textElement textAlignment="Center" markup="none">
  121. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  122. </textElement>
  123. <textFieldExpression><![CDATA[$F{RATECOUNT}==0?":":":"]]></textFieldExpression>
  124. </textField>
  125. <textField isBlankWhenNull="true">
  126. <reportElement uuid="ec64998f-6a18-4cbb-a423-5f59bae2386e" positionType="Float" x="122" y="31" width="136" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  127. <textElement markup="none">
  128. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  129. </textElement>
  130. <textFieldExpression><![CDATA[$F{RATECOUNT}!=1?$F{RATE}==0?"As per List Attached":null:($F{RATE}==0?null:(new DecimalFormat("#0.0######## '%'").format($F{RATE})))]]></textFieldExpression>
  131. </textField>
  132. <textField isBlankWhenNull="true">
  133. <reportElement uuid="8b1f5ebd-4b45-4872-83e1-57ad602544bb" positionType="Float" isPrintRepeatedValues="false" x="19" y="61" width="100" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  134. <textElement markup="none">
  135. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  136. </textElement>
  137. <textFieldExpression><![CDATA[$F{COMM}!=null?($F{COMM}!=0?"R/I Commission":null):null]]></textFieldExpression>
  138. </textField>
  139. <textField isBlankWhenNull="true">
  140. <reportElement uuid="7d14ea25-a182-4081-80f4-ede5b60df70e" positionType="Float" isPrintRepeatedValues="false" x="102" y="61" width="18" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  141. <textElement textAlignment="Center" markup="none">
  142. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  143. </textElement>
  144. <textFieldExpression><![CDATA[$F{COMM}!=null?($F{COMM}!=0?":":null):null]]></textFieldExpression>
  145. </textField>
  146. <textField pattern="###0.00### &apos;%&apos;" isBlankWhenNull="true">
  147. <reportElement uuid="52eb6fd7-48c9-4bbb-b208-5162814011ad" positionType="Float" isPrintRepeatedValues="false" mode="Transparent" x="122" y="61" width="136" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  148. <textElement>
  149. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  150. </textElement>
  151. <textFieldExpression><![CDATA[$F{COMM}!=null?($F{SHARE_COMM}==0?null:$F{SHARE_COMM}):null]]></textFieldExpression>
  152. </textField>
  153. <subreport>
  154. <reportElement uuid="36eadc82-9b6c-4b9c-9e87-7cc9055f64ae" positionType="Float" x="0" y="77" width="554" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  155. <printWhenExpression><![CDATA[new Boolean($P{DEPT}!='M') && $F{PREMI}!=-0.01]]></printWhenExpression>
  156. </reportElement>
  157. <subreportParameter name="SUBREPORT_DIR">
  158. <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
  159. </subreportParameter>
  160. <subreportParameter name="LOB">
  161. <subreportParameterExpression><![CDATA[$P{LOB}]]></subreportParameterExpression>
  162. </subreportParameter>
  163. <subreportParameter name="CURR_ID">
  164. <subreportParameterExpression><![CDATA[$F{CURR_ID}]]></subreportParameterExpression>
  165. </subreportParameter>
  166. <subreportParameter name="PLACING_REVISED">
  167. <subreportParameterExpression><![CDATA[$P{PLACING_REVISED}]]></subreportParameterExpression>
  168. </subreportParameter>
  169. <subreportParameter name="RENEND">
  170. <subreportParameterExpression><![CDATA[$P{RENEND}]]></subreportParameterExpression>
  171. </subreportParameter>
  172. <subreportParameter name="YEAR">
  173. <subreportParameterExpression><![CDATA[$P{YEAR}]]></subreportParameterExpression>
  174. </subreportParameter>
  175. <subreportParameter name="PLACING_ID">
  176. <subreportParameterExpression><![CDATA[$P{PLACING_ID}]]></subreportParameterExpression>
  177. </subreportParameter>
  178. <subreportParameter name="MONTH">
  179. <subreportParameterExpression><![CDATA[$P{MONTH}]]></subreportParameterExpression>
  180. </subreportParameter>
  181. <subreportParameter name="DETAIL_SQ">
  182. <subreportParameterExpression><![CDATA[$F{DETAIL_SQ}]]></subreportParameterExpression>
  183. </subreportParameter>
  184. <subreportParameter name="REINSSQ">
  185. <subreportParameterExpression><![CDATA[$P{REINSSQ}]]></subreportParameterExpression>
  186. </subreportParameter>
  187. <subreportParameter name="BRANCH">
  188. <subreportParameterExpression><![CDATA[$P{BRANCH}]]></subreportParameterExpression>
  189. </subreportParameter>
  190. <subreportParameter name="DEPT">
  191. <subreportParameterExpression><![CDATA[$P{DEPT}]]></subreportParameterExpression>
  192. </subreportParameter>
  193. <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
  194. <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "RateReinsuranceNoStock.jasper"]]></subreportExpression>
  195. </subreport>
  196. <subreport>
  197. <reportElement uuid="14e693e2-8e40-4abf-8fd8-3be56ab83515" positionType="Float" x="1" y="77" width="554" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  198. <printWhenExpression><![CDATA[new Boolean($P{DEPT}=='M') && $F{PREMI}!=0.01]]></printWhenExpression>
  199. </reportElement>
  200. <subreportParameter name="CURRID">
  201. <subreportParameterExpression><![CDATA[$F{CURR_ID}]]></subreportParameterExpression>
  202. </subreportParameter>
  203. <subreportParameter name="LOB">
  204. <subreportParameterExpression><![CDATA[$P{LOB}]]></subreportParameterExpression>
  205. </subreportParameter>
  206. <subreportParameter name="PLACING_REVISED">
  207. <subreportParameterExpression><![CDATA[$P{PLACING_REVISED}]]></subreportParameterExpression>
  208. </subreportParameter>
  209. <subreportParameter name="RENEND">
  210. <subreportParameterExpression><![CDATA[$P{RENEND}]]></subreportParameterExpression>
  211. </subreportParameter>
  212. <subreportParameter name="YEAR">
  213. <subreportParameterExpression><![CDATA[$P{YEAR}]]></subreportParameterExpression>
  214. </subreportParameter>
  215. <subreportParameter name="PLACING_ID">
  216. <subreportParameterExpression><![CDATA[$P{PLACING_ID}]]></subreportParameterExpression>
  217. </subreportParameter>
  218. <subreportParameter name="MONTH">
  219. <subreportParameterExpression><![CDATA[$P{MONTH}]]></subreportParameterExpression>
  220. </subreportParameter>
  221. <subreportParameter name="REINSSQ">
  222. <subreportParameterExpression><![CDATA[$F{REINSURANCE_ID}]]></subreportParameterExpression>
  223. </subreportParameter>
  224. <subreportParameter name="DETAIL_SQ">
  225. <subreportParameterExpression><![CDATA[$F{DETAIL_SQ}]]></subreportParameterExpression>
  226. </subreportParameter>
  227. <subreportParameter name="BRANCH">
  228. <subreportParameterExpression><![CDATA[$P{BRANCH}]]></subreportParameterExpression>
  229. </subreportParameter>
  230. <subreportParameter name="DEPT">
  231. <subreportParameterExpression><![CDATA[$P{DEPT}]]></subreportParameterExpression>
  232. </subreportParameter>
  233. <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
  234. <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "RateReinsuranceMotor.jasper"]]></subreportExpression>
  235. </subreport>
  236. <textField isBlankWhenNull="true">
  237. <reportElement uuid="d171aaa9-4af7-4b25-9e12-d9642418593e" positionType="Float" mode="Transparent" x="124" y="108" width="184" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  238. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  239. </reportElement>
  240. <textElement verticalAlignment="Middle">
  241. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  242. </textElement>
  243. <textFieldExpression><![CDATA[$F{COMM}!=0?
  244. $F{SHARE_COMM}==0?
  245. "Less R/I Commision"
  246. : "Less "+$F{SHARE_COMM}+"% R/I Commision"
  247. : null]]></textFieldExpression>
  248. </textField>
  249. <textField isBlankWhenNull="true">
  250. <reportElement uuid="42f2e57f-a64f-4b46-b919-482f60add18a" positionType="Float" x="396" y="108" width="10" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  251. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  252. </reportElement>
  253. <textElement verticalAlignment="Middle" markup="none">
  254. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  255. </textElement>
  256. <textFieldExpression><![CDATA[$F{COMM}!=0?"=":null]]></textFieldExpression>
  257. </textField>
  258. <textField isBlankWhenNull="true">
  259. <reportElement uuid="876d3f65-7c4a-4d0c-82b8-0c0b3c75ea7a" positionType="Float" x="406" y="108" width="32" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  260. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  261. </reportElement>
  262. <textElement verticalAlignment="Middle">
  263. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  264. </textElement>
  265. <textFieldExpression><![CDATA[$F{COMM}!=0?$F{CURR_ID}+" ":null]]></textFieldExpression>
  266. </textField>
  267. <textField pattern="#,##0.00" isBlankWhenNull="true">
  268. <reportElement uuid="e3ce7328-b9cd-4c8f-b268-9922b1d54b55" positionType="Float" x="439" y="108" width="105" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  269. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  270. </reportElement>
  271. <textElement textAlignment="Right" verticalAlignment="Middle">
  272. <font pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  273. </textElement>
  274. <textFieldExpression><![CDATA[$F{COMM}!=0?Math.abs($F{COMM}):null]]></textFieldExpression>
  275. </textField>
  276. <line>
  277. <reportElement uuid="d2f4d87d-8fe8-40ff-ac0a-9e301d16a789" positionType="Float" x="395" y="123" width="152" height="1" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  278. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  279. </reportElement>
  280. </line>
  281. <textField>
  282. <reportElement uuid="9234b427-02e4-4eb3-ae55-27ab96b98110" positionType="Float" x="124" y="123" width="245" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  283. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  284. </reportElement>
  285. <textElement verticalAlignment="Middle" markup="none">
  286. <font isBold="true" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  287. </textElement>
  288. <textFieldExpression><![CDATA[$V{variable1}.compareTo(0) < 0?"Net Premium Due to You":"Net Premium Due to Us"]]></textFieldExpression>
  289. </textField>
  290. <textField>
  291. <reportElement uuid="651afc4c-4592-4a71-bd08-807513b647dc" positionType="Float" x="396" y="123" width="10" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  292. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  293. </reportElement>
  294. <textElement verticalAlignment="Middle" markup="none">
  295. <font isBold="true" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  296. </textElement>
  297. <textFieldExpression><![CDATA["="]]></textFieldExpression>
  298. </textField>
  299. <textField>
  300. <reportElement uuid="0708e406-c586-4deb-aae4-83852a3aa591" positionType="Float" x="406" y="123" width="32" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  301. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  302. </reportElement>
  303. <textElement verticalAlignment="Middle" markup="none">
  304. <font fontName="SansSerif" size="10" isBold="true" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  305. </textElement>
  306. <textFieldExpression><![CDATA[$F{CURR_ID}+" "]]></textFieldExpression>
  307. </textField>
  308. <textField pattern=" #,##0.00">
  309. <reportElement uuid="e3e53e63-e36f-44c9-9c47-37770ba39970" positionType="Float" x="439" y="123" width="105" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  310. <printWhenExpression><![CDATA[$F{PREMI}!=-0.01]]></printWhenExpression>
  311. </reportElement>
  312. <textElement textAlignment="Right" verticalAlignment="Middle">
  313. <font isBold="true" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  314. </textElement>
  315. <textFieldExpression><![CDATA[Math.abs($V{variable1})]]></textFieldExpression>
  316. </textField>
  317. <textField isBlankWhenNull="true">
  318. <reportElement uuid="42a75eea-eda5-474f-8919-bbf2939efde1" positionType="Float" x="396" y="93" width="10" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  319. <printWhenExpression><![CDATA[new Boolean($F{DISCOUNT}!=0) || $F{PREMI}!=-0.01]]></printWhenExpression>
  320. </reportElement>
  321. <textElement verticalAlignment="Middle" markup="none">
  322. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  323. </textElement>
  324. <textFieldExpression><![CDATA[$F{DISCOUNT}!=0?"=":null]]></textFieldExpression>
  325. </textField>
  326. <textField isBlankWhenNull="true">
  327. <reportElement uuid="b9f347b8-6b17-4bf6-97ff-68ff6eefaa90" positionType="Float" x="406" y="93" width="32" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  328. <printWhenExpression><![CDATA[new Boolean($F{DISCOUNT}!=0)|| $F{PREMI}!=-0.01]]></printWhenExpression>
  329. </reportElement>
  330. <textElement verticalAlignment="Middle">
  331. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  332. </textElement>
  333. <textFieldExpression><![CDATA[$F{DISCOUNT}!=0?$F{CURR_ID}+" ":null]]></textFieldExpression>
  334. </textField>
  335. <textField isBlankWhenNull="true">
  336. <reportElement uuid="d8c52a0b-2306-4ea8-b08e-eb55499afb44" positionType="Float" x="124" y="93" width="184" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  337. <printWhenExpression><![CDATA[new Boolean($F{DISCOUNT}!=0) || $F{PREMI}!=-0.01]]></printWhenExpression>
  338. </reportElement>
  339. <textElement markup="none">
  340. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  341. </textElement>
  342. <textFieldExpression><![CDATA[$F{DISCOUNT}!=0?
  343. $F{SHARE_DISC}==0?
  344. "Less Discount"
  345. : "Less "+$F{SHARE_DISC}+"% Discount"
  346. : null]]></textFieldExpression>
  347. </textField>
  348. <textField pattern="#,##0.00" isBlankWhenNull="true">
  349. <reportElement uuid="5b8765ad-d5cf-4724-874c-30e98dc7c7bb" positionType="Float" isPrintRepeatedValues="false" x="439" y="93" width="105" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr">
  350. <printWhenExpression><![CDATA[new Boolean($F{DISCOUNT}!=0)|| $F{PREMI}!=-0.01]]></printWhenExpression>
  351. </reportElement>
  352. <textElement textAlignment="Right">
  353. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  354. </textElement>
  355. <textFieldExpression><![CDATA[$F{DISCOUNT}!=0?Math.abs($F{DISCOUNT}):null]]></textFieldExpression>
  356. </textField>
  357. <textField isBlankWhenNull="true">
  358. <reportElement uuid="4779e511-19e7-47a4-b8ee-26927b4259d3" positionType="Float" x="19" y="46" width="100" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  359. <textElement markup="none">
  360. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  361. </textElement>
  362. <textFieldExpression><![CDATA[$F{SHARE_DISC}!=0?"Discount":null]]></textFieldExpression>
  363. </textField>
  364. <textField pattern="#,##0.00" isBlankWhenNull="true">
  365. <reportElement uuid="263b9852-8aac-4452-824a-64c02ad8d852" positionType="Float" x="122" y="46" width="136" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  366. <textElement>
  367. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  368. </textElement>
  369. <textFieldExpression><![CDATA[$F{SHARE_DISC}!=0?$F{SHARE_DISC}+" %":null]]></textFieldExpression>
  370. </textField>
  371. <textField isBlankWhenNull="true">
  372. <reportElement uuid="bb91f137-9262-4731-a8df-59f15d649c38" positionType="Float" x="102" y="46" width="18" height="15" isRemoveLineWhenBlank="true" printWhenGroupChanges="curr"/>
  373. <textElement textAlignment="Center" markup="none">
  374. <font fontName="SansSerif" size="10" pdfFontName="Times-Roman" isPdfEmbedded="true"/>
  375. </textElement>
  376. <textFieldExpression><![CDATA[$F{SHARE_DISC}!=0?($F{SHARE_DISC}!=null?":":null):null]]></textFieldExpression>
  377. </textField>
  378. <subreport>
  379. <reportElement uuid="09c3a14b-6f3c-447c-8f0d-38179de57fd8" x="1" y="77" width="554" height="15">
  380. <printWhenExpression><![CDATA[$F{LOB_ID}=="FCOF" && $F{PREMI}==-0.01]]></printWhenExpression>
  381. </reportElement>
  382. <subreportParameter name="SUBREPORT_DIR">
  383. <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
  384. </subreportParameter>
  385. <subreportParameter name="LOB">
  386. <subreportParameterExpression><![CDATA[$P{LOB}]]></subreportParameterExpression>
  387. </subreportParameter>
  388. <subreportParameter name="CURR_ID">
  389. <subreportParameterExpression><![CDATA[$F{CURR_ID}]]></subreportParameterExpression>
  390. </subreportParameter>
  391. <subreportParameter name="PLACING_REVISED">
  392. <subreportParameterExpression><![CDATA[$P{PLACING_REVISED}]]></subreportParameterExpression>
  393. </subreportParameter>
  394. <subreportParameter name="RENEND">
  395. <subreportParameterExpression><![CDATA[$P{RENEND}]]></subreportParameterExpression>
  396. </subreportParameter>
  397. <subreportParameter name="YEAR">
  398. <subreportParameterExpression><![CDATA[$P{YEAR}]]></subreportParameterExpression>
  399. </subreportParameter>
  400. <subreportParameter name="PLACING_ID">
  401. <subreportParameterExpression><![CDATA[$P{PLACING_ID}]]></subreportParameterExpression>
  402. </subreportParameter>
  403. <subreportParameter name="MONTH">
  404. <subreportParameterExpression><![CDATA[$P{MONTH}]]></subreportParameterExpression>
  405. </subreportParameter>
  406. <subreportParameter name="DETAIL_SQ">
  407. <subreportParameterExpression><![CDATA[$F{DETAIL_SQ}]]></subreportParameterExpression>
  408. </subreportParameter>
  409. <subreportParameter name="REINSSQ">
  410. <subreportParameterExpression><![CDATA[$P{REINSSQ}]]></subreportParameterExpression>
  411. </subreportParameter>
  412. <subreportParameter name="BRANCH">
  413. <subreportParameterExpression><![CDATA[$P{BRANCH}]]></subreportParameterExpression>
  414. </subreportParameter>
  415. <subreportParameter name="DEPT">
  416. <subreportParameterExpression><![CDATA[$P{DEPT}]]></subreportParameterExpression>
  417. </subreportParameter>
  418. <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
  419. <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "RateReinsuranceNoStockSpecialLob.jasper"]]></subreportExpression>
  420. </subreport>
  421. </band>
  422. </detail>
  423. </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!