repOrdinanti.jrxml 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!-- Created with Jaspersoft Studio version 6.4.3.final utlizzo versione della libreria JasperReports6.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="repOrdinanti" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0f766765-55c9-45f5-9b5d-efd3a05c7ef8">
  4. <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
  5. <queryString>
  6. <![CDATA[]]>
  7. </queryString>
  8. <field name="ordinante" class="java.lang.String">
  9. <fieldDescription><![CDATA[ordinante]]></fieldDescription>
  10. </field>
  11. <field name="codiceCucOrdinante" class="java.lang.String">
  12. <fieldDescription><![CDATA[codiceCucOrdinante]]></fieldDescription>
  13. </field>
  14. <field name="codiceFiscale" class="java.lang.String">
  15. <fieldDescription><![CDATA[codiceFiscale]]></fieldDescription>
  16. </field>
  17. <field name="codiceSia" class="java.lang.String">
  18. <fieldDescription><![CDATA[codiceSia]]></fieldDescription>
  19. </field>
  20. <field name="firmaEmittente" class="java.lang.String">
  21. <fieldDescription><![CDATA[firmaEmittente]]></fieldDescription>
  22. </field>
  23. <field name="cap" class="java.lang.String">
  24. <fieldDescription><![CDATA[cap]]></fieldDescription>
  25. </field>
  26. <field name="comune" class="java.lang.String">
  27. <fieldDescription><![CDATA[comune]]></fieldDescription>
  28. </field>
  29. <field name="provincia" class="java.lang.String">
  30. <fieldDescription><![CDATA[provincia]]></fieldDescription>
  31. </field>
  32. <field name="indirizzo" class="java.lang.String">
  33. <fieldDescription><![CDATA[indirizzo]]></fieldDescription>
  34. </field>
  35. <variable name="cnt" class="java.lang.Integer" calculation="Sum">
  36. <variableExpression><![CDATA[1]]></variableExpression>
  37. <initialValueExpression><![CDATA[0]]></initialValueExpression>
  38. </variable>
  39. <background>
  40. <band splitType="Stretch"/>
  41. </background>
  42. <title>
  43. <band height="72" splitType="Stretch">
  44. <rectangle radius="4">
  45. <reportElement stretchType="ContainerHeight" x="2" y="0" width="551" height="60" uuid="a865c360-d92c-4e93-bec8-8fc059382b86"/>
  46. </rectangle>
  47. <staticText>
  48. <reportElement x="357" y="23" width="191" height="21" uuid="dd42ddf8-aef3-47d3-9c3e-c110265f4484"/>
  49. <textElement textAlignment="Right" verticalAlignment="Middle">
  50. <font fontName="SansSerif"/>
  51. </textElement>
  52. <text><![CDATA[SICURA - Pagamenti e Incassi Telematici]]></text>
  53. </staticText>
  54. <textField pattern="dd/MM/yyyy HH:mm">
  55. <reportElement x="357" y="3" width="190" height="20" uuid="93ff1deb-3480-404f-873f-091c9090a505"/>
  56. <textElement textAlignment="Right" verticalAlignment="Middle"/>
  57. <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
  58. </textField>
  59. <staticText>
  60. <reportElement x="2" y="3" width="338" height="41" uuid="df0746f4-60cc-4bd7-9087-e3a9c879fa7b"/>
  61. <textElement verticalAlignment="Middle">
  62. <font fontName="SansSerif" size="18" isBold="true" isItalic="true"/>
  63. </textElement>
  64. <text><![CDATA[Stampa anagrafica società]]></text>
  65. </staticText>
  66. </band>
  67. </title>
  68. <columnHeader>
  69. <band height="50" splitType="Stretch">
  70. <rectangle>
  71. <reportElement x="2" y="0" width="551" height="49" backcolor="#E0E0E0" uuid="9df0d89b-d86d-47b3-963a-ca4da33a2344"/>
  72. </rectangle>
  73. <staticText>
  74. <reportElement x="470" y="4" width="80" height="20" uuid="b6c8c3a5-7437-4fad-9bf6-1146c327422b"/>
  75. <textElement textAlignment="Left" verticalAlignment="Middle">
  76. <font fontName="SansSerif" isBold="true"/>
  77. </textElement>
  78. <text><![CDATA[Firma emittente]]></text>
  79. </staticText>
  80. <staticText>
  81. <reportElement x="315" y="4" width="84" height="20" uuid="0ad47376-4efd-48d6-a3f3-b3d38dae36c0"/>
  82. <textElement textAlignment="Left" verticalAlignment="Middle">
  83. <font fontName="SansSerif" isBold="true"/>
  84. </textElement>
  85. <text><![CDATA[Cod. fiscale]]></text>
  86. </staticText>
  87. <staticText>
  88. <reportElement x="260" y="3" width="54" height="20" uuid="e505e820-dd25-45d2-a5b1-bb63a46e1b96"/>
  89. <textElement textAlignment="Left" verticalAlignment="Middle">
  90. <font fontName="SansSerif" isBold="true"/>
  91. </textElement>
  92. <text><![CDATA[Cod. CUC]]></text>
  93. </staticText>
  94. <staticText>
  95. <reportElement x="5" y="4" width="50" height="20" uuid="01d9fcb7-cf54-4ede-8c5f-d920e9772150"/>
  96. <textElement textAlignment="Left" verticalAlignment="Middle">
  97. <font fontName="SansSerif" isBold="true"/>
  98. </textElement>
  99. <text><![CDATA[Ordinante]]></text>
  100. </staticText>
  101. <staticText>
  102. <reportElement x="400" y="4" width="70" height="20" uuid="36ecb5c6-a88e-42a0-9c1f-81cfff86a915"/>
  103. <textElement textAlignment="Left" verticalAlignment="Middle">
  104. <font fontName="SansSerif" isBold="true"/>
  105. </textElement>
  106. <text><![CDATA[Cod. SIA]]></text>
  107. </staticText>
  108. <staticText>
  109. <reportElement x="5" y="24" width="50" height="20" uuid="f26b8c14-83d6-41c9-ac27-3db808e27296"/>
  110. <textElement textAlignment="Left" verticalAlignment="Middle">
  111. <font fontName="SansSerif" isBold="true"/>
  112. </textElement>
  113. <text><![CDATA[Indirizzo]]></text>
  114. </staticText>
  115. <staticText>
  116. <reportElement x="260" y="24" width="54" height="20" uuid="25806dc1-4140-4964-82f4-61b9629553c3"/>
  117. <textElement textAlignment="Left" verticalAlignment="Middle">
  118. <font fontName="SansSerif" isBold="true"/>
  119. </textElement>
  120. <text><![CDATA[CAP]]></text>
  121. </staticText>
  122. <staticText>
  123. <reportElement x="315" y="24" width="154" height="20" uuid="d36b9574-4ba9-4145-bd73-15d2467495c8"/>
  124. <textElement textAlignment="Left" verticalAlignment="Middle">
  125. <font fontName="SansSerif" isBold="true"/>
  126. </textElement>
  127. <text><![CDATA[Comune]]></text>
  128. </staticText>
  129. <staticText>
  130. <reportElement x="470" y="24" width="80" height="20" uuid="b84673e3-c8cd-4551-8d0b-ea8fbe11f814"/>
  131. <textElement textAlignment="Left" verticalAlignment="Middle">
  132. <font fontName="SansSerif" isBold="true"/>
  133. </textElement>
  134. <text><![CDATA[Provincia]]></text>
  135. </staticText>
  136. </band>
  137. </columnHeader>
  138. <detail>
  139. <band height="47" splitType="Stretch">
  140. <textField isBlankWhenNull="true">
  141. <reportElement x="5" y="1" width="245" height="18" uuid="dc8a5780-a9ec-4d26-ad60-ebd86d3aacbc">
  142. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c772debf-40a4-4772-b77b-c5df478156b8"/>
  143. </reportElement>
  144. <textElement verticalAlignment="Middle"/>
  145. <textFieldExpression><![CDATA[$F{ordinante}]]></textFieldExpression>
  146. </textField>
  147. <textField isBlankWhenNull="true">
  148. <reportElement x="5" y="19" width="245" height="20" uuid="26ee7148-6dc5-4c80-a85a-7b5a41942b01">
  149. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8830dc69-c9f8-435e-adfe-5ad7af013ffe"/>
  150. </reportElement>
  151. <textElement verticalAlignment="Middle"/>
  152. <textFieldExpression><![CDATA[$F{indirizzo}]]></textFieldExpression>
  153. </textField>
  154. <textField isBlankWhenNull="true">
  155. <reportElement x="260" y="19" width="54" height="20" uuid="8c96191b-9424-4b6e-a760-4b2e5cf61500">
  156. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8830dc69-c9f8-435e-adfe-5ad7af013ffe"/>
  157. </reportElement>
  158. <textElement verticalAlignment="Middle"/>
  159. <textFieldExpression><![CDATA[$F{cap}]]></textFieldExpression>
  160. </textField>
  161. <textField isBlankWhenNull="true">
  162. <reportElement x="260" y="1" width="54" height="18" uuid="693e0d86-2880-49aa-942c-57aa36aab962">
  163. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c772debf-40a4-4772-b77b-c5df478156b8"/>
  164. </reportElement>
  165. <textElement verticalAlignment="Middle"/>
  166. <textFieldExpression><![CDATA[$F{codiceCucOrdinante}]]></textFieldExpression>
  167. </textField>
  168. <textField isBlankWhenNull="true">
  169. <reportElement x="315" y="19" width="154" height="20" uuid="8d51909d-aafc-4ee2-8c50-1f4b0b49f59b">
  170. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8830dc69-c9f8-435e-adfe-5ad7af013ffe"/>
  171. </reportElement>
  172. <textElement verticalAlignment="Middle"/>
  173. <textFieldExpression><![CDATA[$F{comune}]]></textFieldExpression>
  174. </textField>
  175. <textField isBlankWhenNull="true">
  176. <reportElement x="315" y="1" width="84" height="18" uuid="01ba1bd4-f035-426c-981b-45f330e7f3ca">
  177. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c772debf-40a4-4772-b77b-c5df478156b8"/>
  178. </reportElement>
  179. <textElement verticalAlignment="Middle"/>
  180. <textFieldExpression><![CDATA[$F{codiceFiscale}]]></textFieldExpression>
  181. </textField>
  182. <textField isBlankWhenNull="true">
  183. <reportElement x="400" y="1" width="68" height="18" uuid="07177902-bb31-47dd-97a0-1c130d117e18">
  184. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c772debf-40a4-4772-b77b-c5df478156b8"/>
  185. </reportElement>
  186. <textElement verticalAlignment="Middle"/>
  187. <textFieldExpression><![CDATA[$F{codiceSia}]]></textFieldExpression>
  188. </textField>
  189. <textField isBlankWhenNull="true">
  190. <reportElement x="470" y="18" width="80" height="20" uuid="b8e48d87-bc5e-42b6-9a5a-bcc8d124cacb">
  191. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8830dc69-c9f8-435e-adfe-5ad7af013ffe"/>
  192. </reportElement>
  193. <textElement verticalAlignment="Middle"/>
  194. <textFieldExpression><![CDATA[$F{provincia}]]></textFieldExpression>
  195. </textField>
  196. <textField isBlankWhenNull="true">
  197. <reportElement x="470" y="0" width="80" height="18" uuid="8b6214fc-4a3c-4d7c-be28-ce730cb0e20b">
  198. <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c772debf-40a4-4772-b77b-c5df478156b8"/>
  199. </reportElement>
  200. <textElement verticalAlignment="Middle"/>
  201. <textFieldExpression><![CDATA[$F{firmaEmittente}]]></textFieldExpression>
  202. </textField>
  203. <line>
  204. <reportElement x="-1" y="43" width="550" height="1" uuid="6acec4f6-bb88-48c3-87c2-e7a1356bb22c">
  205. <property name="com.jaspersoft.studio.unit.height" value="px"/>
  206. </reportElement>
  207. </line>
  208. </band>
  209. </detail>
  210. <pageFooter>
  211. <band height="54" splitType="Stretch">
  212. <textField evaluationTime="Report">
  213. <reportElement x="260" y="12" width="100" height="30" uuid="ce0b2135-1448-4ca1-acc3-4d4984a352e6"/>
  214. <textElement textAlignment="Left">
  215. <font fontName="SansSerif"/>
  216. </textElement>
  217. <textFieldExpression><![CDATA[" di " + $V{PAGE_NUMBER}]]></textFieldExpression>
  218. </textField>
  219. <textField>
  220. <reportElement x="160" y="12" width="100" height="30" uuid="1d58713d-e61e-4255-9e77-b8c7fcf6868c"/>
  221. <textElement textAlignment="Right">
  222. <font fontName="SansSerif"/>
  223. </textElement>
  224. <textFieldExpression><![CDATA["Pagina " + $V{PAGE_NUMBER}]]></textFieldExpression>
  225. </textField>
  226. </band>
  227. </pageFooter>
  228. <summary>
  229. <band height="42" splitType="Stretch">
  230. <staticText>
  231. <reportElement x="290" y="11" width="120" height="20" uuid="b47edf31-5cba-4549-9211-8f2feb3242dd"/>
  232. <textElement textAlignment="Left" verticalAlignment="Middle">
  233. <font fontName="SansSerif" size="12" isBold="true"/>
  234. </textElement>
  235. <text><![CDATA[Numero ordinanti:]]></text>
  236. </staticText>
  237. <textField pattern="#,##0.###">
  238. <reportElement x="410" y="10" width="124" height="20" uuid="43e38b80-4d9e-4095-ad35-48bea35b923d"/>
  239. <textElement textAlignment="Right" verticalAlignment="Middle">
  240. <font size="12"/>
  241. </textElement>
  242. <textFieldExpression><![CDATA[$V{cnt}]]></textFieldExpression>
  243. </textField>
  244. </band>
  245. </summary>
  246. </jasperReport>