repDestinatari.jrxml 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 6.4.3 -->
  3. <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="repDestinatari" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="8af919e3-9bd1-4d81-87f2-a492b280f937">
  4. <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
  5. <queryString>
  6. <![CDATA[]]>
  7. </queryString>
  8. <field name="cab" class="java.lang.String">
  9. <fieldDescription><![CDATA[cab]]></fieldDescription>
  10. </field>
  11. <field name="coordinateIban" class="java.lang.String">
  12. <fieldDescription><![CDATA[coordinateIban]]></fieldDescription>
  13. </field>
  14. <field name="indirizzo" class="java.lang.String">
  15. <fieldDescription><![CDATA[indirizzo]]></fieldDescription>
  16. </field>
  17. <field name="abi" class="java.lang.String">
  18. <fieldDescription><![CDATA[abi]]></fieldDescription>
  19. </field>
  20. <field name="cin" class="java.lang.String">
  21. <fieldDescription><![CDATA[cin]]></fieldDescription>
  22. </field>
  23. <field name="sia" class="java.lang.String">
  24. <fieldDescription><![CDATA[sia]]></fieldDescription>
  25. </field>
  26. <field name="tipoCodiceDestinatario" class="java.lang.String">
  27. <fieldDescription><![CDATA[tipoCodiceDestinatario]]></fieldDescription>
  28. </field>
  29. <field name="provincia" class="java.lang.String">
  30. <fieldDescription><![CDATA[provincia]]></fieldDescription>
  31. </field>
  32. <field name="codiceFiscale" class="java.lang.String">
  33. <fieldDescription><![CDATA[codiceFiscale]]></fieldDescription>
  34. </field>
  35. <field name="codiceDestinatario" class="java.lang.String">
  36. <fieldDescription><![CDATA[codiceDestinatario]]></fieldDescription>
  37. </field>
  38. <field name="destinatario" class="java.lang.String">
  39. <fieldDescription><![CDATA[destinatario]]></fieldDescription>
  40. </field>
  41. <field name="iddestinatario" class="java.lang.Integer"/>
  42. <field name="descrizioneBanca" class="java.lang.String">
  43. <fieldDescription><![CDATA[descrizioneBanca]]></fieldDescription>
  44. </field>
  45. <field name="cap" class="java.lang.String">
  46. <fieldDescription><![CDATA[cap]]></fieldDescription>
  47. </field>
  48. <field name="coordinateIbanordinante" class="java.lang.String">
  49. <fieldDescription><![CDATA[coordinateIbanordinante]]></fieldDescription>
  50. </field>
  51. <field name="conto" class="java.lang.String">
  52. <fieldDescription><![CDATA[conto]]></fieldDescription>
  53. </field>
  54. <field name="class" class="java.lang.Class">
  55. <fieldDescription><![CDATA[class]]></fieldDescription>
  56. </field>
  57. <field name="codiceBic" class="java.lang.String">
  58. <fieldDescription><![CDATA[codiceBic]]></fieldDescription>
  59. </field>
  60. <field name="citta" class="java.lang.String">
  61. <fieldDescription><![CDATA[citta]]></fieldDescription>
  62. </field>
  63. <variable name="cnt" class="java.lang.Integer" incrementType="Column" calculation="Sum">
  64. <variableExpression><![CDATA[1]]></variableExpression>
  65. <initialValueExpression><![CDATA[0]]></initialValueExpression>
  66. </variable>
  67. <group name="GDestinatario">
  68. <groupExpression><![CDATA[$F{iddestinatario}]]></groupExpression>
  69. <groupHeader>
  70. <band height="70">
  71. <textField isBlankWhenNull="true">
  72. <reportElement x="20" y="3" width="245" height="16" uuid="90dee75d-884e-4677-839c-049d2aca6e45">
  73. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  74. </reportElement>
  75. <textElement verticalAlignment="Middle"/>
  76. <textFieldExpression><![CDATA[$F{destinatario}]]></textFieldExpression>
  77. </textField>
  78. <textField isBlankWhenNull="true">
  79. <reportElement x="20" y="21" width="245" height="16" uuid="d007bc7c-da37-4a1b-a1f0-67c22cf3ac17">
  80. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  81. </reportElement>
  82. <textElement verticalAlignment="Middle"/>
  83. <textFieldExpression><![CDATA[$F{indirizzo}]]></textFieldExpression>
  84. </textField>
  85. <textField isBlankWhenNull="true">
  86. <reportElement x="275" y="3" width="84" height="16" uuid="f5a8dff9-f680-48b9-b877-7937c2a28060">
  87. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  88. </reportElement>
  89. <textElement verticalAlignment="Middle"/>
  90. <textFieldExpression><![CDATA[$F{codiceFiscale}]]></textFieldExpression>
  91. </textField>
  92. <textField isBlankWhenNull="true">
  93. <reportElement x="275" y="21" width="54" height="16" uuid="5c07bde2-350c-4924-b13a-5c32747a5641">
  94. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  95. </reportElement>
  96. <textElement verticalAlignment="Middle"/>
  97. <textFieldExpression><![CDATA[$F{cap}]]></textFieldExpression>
  98. </textField>
  99. <textField isBlankWhenNull="true">
  100. <reportElement x="344" y="2" width="126" height="16" uuid="79f07f98-5743-4022-9386-20f8cb81c556">
  101. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  102. </reportElement>
  103. <textElement verticalAlignment="Middle"/>
  104. <textFieldExpression><![CDATA[$F{codiceDestinatario}]]></textFieldExpression>
  105. </textField>
  106. <textField isBlankWhenNull="true">
  107. <reportElement x="343" y="21" width="126" height="16" uuid="ae1d8764-e3e6-4a69-8c76-a0fa733c2669">
  108. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  109. </reportElement>
  110. <textElement verticalAlignment="Middle"/>
  111. <textFieldExpression><![CDATA[$F{citta}]]></textFieldExpression>
  112. </textField>
  113. <textField isBlankWhenNull="true">
  114. <reportElement x="470" y="2" width="80" height="16" uuid="1d5b7f49-dafd-4047-8ad0-0e44354234a0">
  115. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  116. </reportElement>
  117. <textElement verticalAlignment="Middle"/>
  118. <textFieldExpression><![CDATA[$F{tipoCodiceDestinatario}]]></textFieldExpression>
  119. </textField>
  120. <textField isBlankWhenNull="true">
  121. <reportElement x="471" y="21" width="80" height="16" uuid="45e21b1e-24cf-4c22-850e-9c7e192c7f37">
  122. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  123. </reportElement>
  124. <textElement verticalAlignment="Middle"/>
  125. <textFieldExpression><![CDATA[$F{provincia}]]></textFieldExpression>
  126. </textField>
  127. <staticText>
  128. <reportElement x="2" y="46" width="48" height="20" uuid="9c34f38c-a470-4bc1-9ba3-5c7b5c53d105"/>
  129. <textElement textAlignment="Left" verticalAlignment="Middle">
  130. <font fontName="SansSerif" isBold="true"/>
  131. </textElement>
  132. <text><![CDATA[ABI]]></text>
  133. </staticText>
  134. <staticText>
  135. <reportElement x="50" y="46" width="51" height="20" uuid="e03afa66-2b94-4a41-b316-8a888f838a1c"/>
  136. <textElement textAlignment="Left" verticalAlignment="Middle">
  137. <font fontName="SansSerif" isBold="true"/>
  138. </textElement>
  139. <text><![CDATA[CAB]]></text>
  140. </staticText>
  141. <staticText>
  142. <reportElement x="102" y="46" width="78" height="20" uuid="db810098-ea5d-4e64-916c-0e1b2e78ee97"/>
  143. <textElement textAlignment="Left" verticalAlignment="Middle">
  144. <font fontName="SansSerif" isBold="true"/>
  145. </textElement>
  146. <text><![CDATA[Conto]]></text>
  147. </staticText>
  148. <staticText>
  149. <reportElement x="180" y="46" width="30" height="20" uuid="39b4304e-d311-4b6f-8994-dc95043090e9"/>
  150. <textElement textAlignment="Center" verticalAlignment="Middle">
  151. <font fontName="SansSerif" isBold="true"/>
  152. </textElement>
  153. <text><![CDATA[CIN]]></text>
  154. </staticText>
  155. <staticText>
  156. <reportElement x="210" y="46" width="150" height="20" uuid="1404aa95-3203-4339-9eba-781f7b65b146"/>
  157. <textElement textAlignment="Left" verticalAlignment="Middle">
  158. <font fontName="SansSerif" size="10" isBold="true" isItalic="false"/>
  159. </textElement>
  160. <text><![CDATA[Descrizione banca]]></text>
  161. </staticText>
  162. <staticText>
  163. <reportElement x="370" y="46" width="180" height="20" uuid="41116669-c8d6-4d97-b3af-d98897221583"/>
  164. <textElement textAlignment="Left" verticalAlignment="Middle">
  165. <font fontName="SansSerif" isBold="true"/>
  166. </textElement>
  167. <text><![CDATA[Coordinate IBAN]]></text>
  168. </staticText>
  169. <line>
  170. <reportElement x="2" y="39" width="550" height="1" uuid="755656c6-b02c-435c-a56f-722b88def942">
  171. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  172. </reportElement>
  173. </line>
  174. <line>
  175. <reportElement x="2" y="0" width="550" height="1" uuid="c7666832-2360-4071-8774-c0bd4d2f3b4f">
  176. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  177. </reportElement>
  178. </line>
  179. </band>
  180. </groupHeader>
  181. <groupFooter>
  182. <band height="34">
  183. <line>
  184. <reportElement x="2" y="10" width="550" height="1" uuid="046033ee-bdd3-4268-be38-2a4238304e20">
  185. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  186. </reportElement>
  187. </line>
  188. <line>
  189. <reportElement x="2" y="13" width="550" height="1" uuid="366b6243-2746-47c8-bc66-1ab07666167e">
  190. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  191. </reportElement>
  192. </line>
  193. </band>
  194. </groupFooter>
  195. </group>
  196. <background>
  197. <band splitType="Stretch"/>
  198. </background>
  199. <title>
  200. <band height="72" splitType="Stretch">
  201. <rectangle radius="4">
  202. <reportElement stretchType="ContainerHeight" x="-1" y="-2" width="552" height="74" uuid="30610c36-1ada-4ed2-9d63-8d3b10f3f367"/>
  203. </rectangle>
  204. <textField pattern="dd/MM/yyyy HH:mm">
  205. <reportElement x="357" y="3" width="190" height="20" uuid="d9143f98-367d-4946-a9bf-6ff17b8eb7dc"/>
  206. <textElement textAlignment="Right" verticalAlignment="Middle"/>
  207. <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
  208. </textField>
  209. <staticText>
  210. <reportElement x="357" y="23" width="191" height="21" uuid="0bc31c92-5733-41f2-9566-8e30ab75ebc5"/>
  211. <textElement textAlignment="Right" verticalAlignment="Middle">
  212. <font fontName="SansSerif"/>
  213. </textElement>
  214. <text><![CDATA[SICURA - Pagamenti e Incassi Telematici]]></text>
  215. </staticText>
  216. <staticText>
  217. <reportElement x="2" y="3" width="338" height="41" uuid="bd94485f-3d89-434d-b89d-1b227e4cf4ab"/>
  218. <textElement verticalAlignment="Middle">
  219. <font fontName="SansSerif" size="18" isBold="true" isItalic="true"/>
  220. </textElement>
  221. <text><![CDATA[Stampa anagrafica destinatari]]></text>
  222. </staticText>
  223. </band>
  224. </title>
  225. <pageHeader>
  226. <band height="35" splitType="Stretch"/>
  227. </pageHeader>
  228. <columnHeader>
  229. <band height="61" splitType="Stretch">
  230. <rectangle>
  231. <reportElement x="2" y="0" width="551" height="49" backcolor="#E0E0E0" uuid="4a389d19-f522-41e9-90b2-2ed2be11601b"/>
  232. </rectangle>
  233. <staticText>
  234. <reportElement x="470" y="4" width="80" height="20" uuid="232a1c16-7477-4a17-9b05-893356c76ccd"/>
  235. <textElement textAlignment="Left" verticalAlignment="Middle">
  236. <font fontName="SansSerif" isBold="true"/>
  237. </textElement>
  238. <text><![CDATA[Tipo cod. dest.]]></text>
  239. </staticText>
  240. <staticText>
  241. <reportElement x="5" y="4" width="95" height="20" uuid="8cae434e-6d72-4796-b694-6c9bc2af173e"/>
  242. <textElement textAlignment="Left" verticalAlignment="Middle">
  243. <font fontName="SansSerif" isBold="true"/>
  244. </textElement>
  245. <text><![CDATA[Destinatario]]></text>
  246. </staticText>
  247. <staticText>
  248. <reportElement x="5" y="24" width="95" height="20" uuid="877ae89b-401e-4225-88e1-ccad2a775cd0"/>
  249. <textElement textAlignment="Left" verticalAlignment="Middle">
  250. <font fontName="SansSerif" isBold="true"/>
  251. </textElement>
  252. <text><![CDATA[Indirizzo]]></text>
  253. </staticText>
  254. <staticText>
  255. <reportElement x="260" y="4" width="84" height="20" uuid="657b89ba-0336-4632-92e7-050a69419a86"/>
  256. <textElement textAlignment="Left" verticalAlignment="Middle">
  257. <font fontName="SansSerif" isBold="true"/>
  258. </textElement>
  259. <text><![CDATA[Cod. fiscale]]></text>
  260. </staticText>
  261. <staticText>
  262. <reportElement x="344" y="4" width="125" height="20" uuid="91847b61-7342-410c-9aad-da75591dd054"/>
  263. <textElement textAlignment="Left" verticalAlignment="Middle">
  264. <font fontName="SansSerif" isBold="true"/>
  265. </textElement>
  266. <text><![CDATA[Cod. destinatario]]></text>
  267. </staticText>
  268. <staticText>
  269. <reportElement x="343" y="24" width="126" height="20" uuid="caa6911e-7559-4881-aa17-f1d8d5ed62d9"/>
  270. <textElement textAlignment="Left" verticalAlignment="Middle">
  271. <font fontName="SansSerif" isBold="true"/>
  272. </textElement>
  273. <text><![CDATA[Comune]]></text>
  274. </staticText>
  275. <staticText>
  276. <reportElement x="470" y="24" width="80" height="20" uuid="40be5f74-ea9c-46cf-817b-b3826fc4b6d9"/>
  277. <textElement textAlignment="Left" verticalAlignment="Middle">
  278. <font fontName="SansSerif" isBold="true"/>
  279. </textElement>
  280. <text><![CDATA[Provincia]]></text>
  281. </staticText>
  282. <staticText>
  283. <reportElement x="260" y="24" width="54" height="20" uuid="4be23a91-458d-4a8c-b467-23cec6d35102"/>
  284. <textElement textAlignment="Left" verticalAlignment="Middle">
  285. <font fontName="SansSerif" isBold="true"/>
  286. </textElement>
  287. <text><![CDATA[CAP]]></text>
  288. </staticText>
  289. </band>
  290. </columnHeader>
  291. <detail>
  292. <band height="16" splitType="Stretch">
  293. <textField isBlankWhenNull="true">
  294. <reportElement x="4" y="0" width="45" height="16" uuid="e5e7bfb2-c2b2-4dae-a21d-1aaefe3a638b">
  295. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  296. </reportElement>
  297. <textElement verticalAlignment="Middle"/>
  298. <textFieldExpression><![CDATA[$F{abi}]]></textFieldExpression>
  299. </textField>
  300. <textField isBlankWhenNull="true">
  301. <reportElement x="50" y="0" width="50" height="16" uuid="41687b53-78ae-4c36-8cd0-857e8dc98791">
  302. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  303. </reportElement>
  304. <textElement verticalAlignment="Middle"/>
  305. <textFieldExpression><![CDATA[$F{cab}]]></textFieldExpression>
  306. </textField>
  307. <textField isBlankWhenNull="true">
  308. <reportElement x="100" y="0" width="80" height="16" uuid="8aa7adc1-fce5-4eb7-8a94-7445b9003847">
  309. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  310. </reportElement>
  311. <textElement verticalAlignment="Middle"/>
  312. <textFieldExpression><![CDATA[$F{conto}]]></textFieldExpression>
  313. </textField>
  314. <textField isBlankWhenNull="true">
  315. <reportElement x="180" y="0" width="30" height="16" uuid="cfc641ba-a585-4fe6-b29c-7c7f4ee547d0">
  316. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  317. </reportElement>
  318. <textElement textAlignment="Center" verticalAlignment="Middle"/>
  319. <textFieldExpression><![CDATA[$F{cin}]]></textFieldExpression>
  320. </textField>
  321. <textField isBlankWhenNull="true">
  322. <reportElement x="210" y="0" width="150" height="16" uuid="f3ead9c9-5571-4e7b-860b-6481570a13aa">
  323. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  324. </reportElement>
  325. <textElement verticalAlignment="Middle"/>
  326. <textFieldExpression><![CDATA[$F{descrizioneBanca}]]></textFieldExpression>
  327. </textField>
  328. <textField isBlankWhenNull="true">
  329. <reportElement x="370" y="0" width="180" height="16" uuid="e9f7a87e-8d38-4ee8-9abc-eb45d9447e40">
  330. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  331. </reportElement>
  332. <textElement verticalAlignment="Middle"/>
  333. <textFieldExpression><![CDATA[$F{coordinateIban}]]></textFieldExpression>
  334. </textField>
  335. </band>
  336. </detail>
  337. <columnFooter>
  338. <band height="21" splitType="Stretch"/>
  339. </columnFooter>
  340. <pageFooter>
  341. <band height="54" splitType="Stretch">
  342. <textField>
  343. <reportElement x="160" y="12" width="100" height="30" uuid="3c763381-cb16-4629-a657-ca18b9650f46"/>
  344. <textElement textAlignment="Right">
  345. <font fontName="SansSerif"/>
  346. </textElement>
  347. <textFieldExpression><![CDATA["Pagina " + $V{PAGE_NUMBER}]]></textFieldExpression>
  348. </textField>
  349. <textField evaluationTime="Report">
  350. <reportElement x="260" y="12" width="100" height="30" uuid="0d2646ba-79f1-4acb-8982-4d1eb3cd8f69"/>
  351. <textElement textAlignment="Left">
  352. <font fontName="SansSerif"/>
  353. </textElement>
  354. <textFieldExpression><![CDATA[" di " + $V{PAGE_NUMBER}]]></textFieldExpression>
  355. </textField>
  356. </band>
  357. </pageFooter>
  358. <summary>
  359. <band height="42" splitType="Stretch"/>
  360. </summary>
  361. </jasperReport>