API tools faq
paste
Guest User

Untitled

a guest
Jan 20th, 2019
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.37 KB | None | 0 0
raw download clone embed print report
  1. > mian report
  2.  
  3.  
  4. <?xml version="1.0" encoding="UTF-8"?>
  5. <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="printBillReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" scriptletClass="com.reporter.jasper.ConvertToWord" uuid="bd072f9e-2dda-451a-b0a1-13e9f2aa0d3b">
  6. <property name="ireport.zoom" value="1.0"/>
  7. <property name="ireport.x" value="0"/>
  8. <property name="ireport.y" value="0"/>
  9. <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
  10. <defaultValueExpression><![CDATA["C:\Users\windows\Documents\NetBeansProjects\SteplizerElectronics\src\steplizerelectronics\"]]></defaultValueExpression>
  11. </parameter>
  12. <parameter name="cusID" class="java.lang.Integer"/>
  13. <queryString>
  14. <![CDATA[select *from sale where cus_id=$P{cusID}]]>
  15. </queryString>
  16. <field name="ID" class="java.lang.Integer">
  17. <fieldDescription><![CDATA[]]></fieldDescription>
  18. </field>
  19. <field name="cat_name" class="java.lang.String">
  20. <fieldDescription><![CDATA[]]></fieldDescription>
  21. </field>
  22. <field name="model_no" class="java.lang.String">
  23. <fieldDescription><![CDATA[]]></fieldDescription>
  24. </field>
  25. <field name="cus_name" class="java.lang.String">
  26. <fieldDescription><![CDATA[]]></fieldDescription>
  27. </field>
  28. <field name="cus_id" class="java.lang.Integer">
  29. <fieldDescription><![CDATA[]]></fieldDescription>
  30. </field>
  31. <field name="user_id" class="java.lang.Integer">
  32. <fieldDescription><![CDATA[]]></fieldDescription>
  33. </field>
  34. <field name="comp_name" class="java.lang.String">
  35. <fieldDescription><![CDATA[]]></fieldDescription>
  36. </field>
  37. <field name="cus_cell" class="java.lang.String">
  38. <fieldDescription><![CDATA[]]></fieldDescription>
  39. </field>
  40. <field name="sel_price" class="java.lang.Integer">
  41. <fieldDescription><![CDATA[]]></fieldDescription>
  42. </field>
  43. <field name="qty" class="java.lang.Integer">
  44. <fieldDescription><![CDATA[]]></fieldDescription>
  45. </field>
  46. <field name="amount" class="java.lang.Integer">
  47. <fieldDescription><![CDATA[]]></fieldDescription>
  48. </field>
  49. <field name="payable" class="java.lang.Integer">
  50. <fieldDescription><![CDATA[]]></fieldDescription>
  51. </field>
  52. <field name="borrow" class="java.lang.Integer">
  53. <fieldDescription><![CDATA[]]></fieldDescription>
  54. </field>
  55. <field name="status" class="java.lang.String">
  56. <fieldDescription><![CDATA[]]></fieldDescription>
  57. </field>
  58. <field name="regdate" class="java.lang.String">
  59. <fieldDescription><![CDATA[]]></fieldDescription>
  60. </field>
  61. <variable name="amount_1" class="java.lang.Integer" calculation="Sum">
  62. <variableExpression><![CDATA[$F{amount}]]></variableExpression>
  63. </variable>
  64. <variable name="qty_1" class="java.lang.Integer" calculation="Sum">
  65. <variableExpression><![CDATA[$F{qty}]]></variableExpression>
  66. </variable>
  67. <variable name="borrow_1" class="java.lang.Integer" calculation="Sum">
  68. <variableExpression><![CDATA[$F{borrow}]]></variableExpression>
  69. </variable>
  70. <variable name="payable_1" class="java.lang.Integer" calculation="Sum">
  71. <variableExpression><![CDATA[$F{payable}]]></variableExpression>
  72. </variable>
  73. <variable name="grandTotall" class="java.lang.Double"/>
  74. <variable name="total_amount" class="java.lang.Double" calculation="Sum">
  75. <variableExpression><![CDATA[$F{amount}]]></variableExpression>
  76. </variable>
  77. <background>
  78. <band splitType="Stretch"/>
  79. </background>
  80. <title>
  81. <band height="123" splitType="Stretch">
  82. <staticText>
  83. <reportElement x="137" y="80" width="66" height="20" uuid="3b4ea294-f433-491e-9803-2c36e8092e59"/>
  84. <textElement>
  85. <font size="11" isBold="true"/>
  86. </textElement>
  87. <text><![CDATA[Manufactur:]]></text>
  88. </staticText>
  89. <rectangle radius="10">
  90. <reportElement x="1" y="1" width="555" height="118" uuid="f86b54e6-471d-4395-acda-da815bae56ae"/>
  91. <graphicElement>
  92. <pen lineWidth="2.0" lineStyle="Double"/>
  93. </graphicElement>
  94. </rectangle>
  95. <staticText>
  96. <reportElement x="10" y="113" width="112" height="3" uuid="f3df3b93-035d-4379-8635-c5947bdd4f62"/>
  97. <textElement>
  98. <font size="9"/>
  99. </textElement>
  100. <text><![CDATA[14-DS Main Bund Road, Near Chohan Road, Islam Pura, Lahore.]]></text>
  101. </staticText>
  102. <line>
  103. <reportElement x="310" y="97" width="1" height="19" uuid="fab4c957-2174-44a7-a773-945807f51b60"/>
  104. </line>
  105. <staticText>
  106. <reportElement x="118" y="8" width="258" height="22" uuid="1bbc2106-275b-45be-ae87-cd4607dc8c04"/>
  107. <textElement>
  108. <font fontName="Audiowide" size="14"/>
  109. </textElement>
  110. <text><![CDATA[AONE ELECTRONICS FACTORY]]></text>
  111. </staticText>
  112. <image>
  113. <reportElement x="1" y="3" width="102" height="68" uuid="94d07030-0eae-424a-a92e-b2c80f63d49e"/>
  114. <imageExpression><![CDATA["C:\Users\windows\Desktop\aone.png"]]></imageExpression>
  115. </image>
  116. <staticText>
  117. <reportElement x="11" y="71" width="48" height="16" uuid="52f2829b-19ca-4269-bec6-80bdb9951674"/>
  118. <textElement>
  119. <font size="11" isBold="true"/>
  120. </textElement>
  121. <text><![CDATA[Address:]]></text>
  122. </staticText>
  123. <staticText>
  124. <reportElement x="285" y="99" width="83" height="14" uuid="85f72593-8c79-49ec-81b1-a266a1fbe68e"/>
  125. <text><![CDATA[M/S]]></text>
  126. </staticText>
  127. <line>
  128. <reportElement x="279" y="73" width="274" height="1" uuid="b0e7d11d-efc3-4833-a07b-bb5ffc4f3f63"/>
  129. </line>
  130. <line>
  131. <reportElement x="279" y="74" width="1" height="44" uuid="c4a74d99-3a03-469d-972b-f4319ae837ec"/>
  132. </line>
  133. <staticText>
  134. <reportElement x="396" y="-14" width="35" height="16" uuid="93706ffc-0443-4a0c-9a78-8ae0258beeca"/>
  135. <text><![CDATA[Date]]></text>
  136. </staticText>
  137. <staticText>
  138. <reportElement x="142" y="89" width="136" height="30" uuid="30a5b94f-a0a3-44d1-8e81-b8d5bdc70719"/>
  139. <text><![CDATA[Automatic Voltage steplizer Regulators & UPS]]></text>
  140. </staticText>
  141. <componentElement>
  142. <reportElement x="373" y="7" width="177" height="31" uuid="088518ef-edd8-4c30-a126-e9514f1b13d2"/>
  143. <jr:barbecue xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" type="Code39 (Extended)" drawText="false" checksumRequired="false">
  144. <jr:codeExpression><![CDATA[$F{cus_name}+$F{cus_id}]]></jr:codeExpression>
  145. </jr:barbecue>
  146. </componentElement>
  147. <textField>
  148. <reportElement x="321" y="98" width="234" height="16" uuid="edbc7887-c6f6-4209-bcf3-68ad5be80ec8"/>
  149. <textFieldExpression><![CDATA[$F{cus_name}]]></textFieldExpression>
  150. </textField>
  151. <staticText>
  152. <reportElement x="143" y="73" width="60" height="16" uuid="abaf5bdb-61f6-4148-92c8-eafe2e5e6a9e"/>
  153. <textElement>
  154. <font size="11" isBold="true"/>
  155. </textElement>
  156. <text><![CDATA[Steplizers]]></text>
  157. </staticText>
  158. <staticText>
  159. <reportElement x="285" y="77" width="100" height="16" uuid="c440daa7-1411-4e51-9750-6531b35acbd4"/>
  160. <textElement>
  161. <font size="11"/>
  162. </textElement>
  163. <text><![CDATA[Credit Sale]]></text>
  164. </staticText>
  165. </band>
  166. </title>
  167. <columnHeader>
  168. <band height="27" splitType="Stretch">
  169. <rectangle>
  170. <reportElement x="1" y="0" width="552" height="26" uuid="ab9bb588-6c52-4e6f-858a-f64555e9c482"/>
  171. <graphicElement>
  172. <pen lineWidth="2.0" lineStyle="Solid"/>
  173. </graphicElement>
  174. </rectangle>
  175. <staticText>
  176. <reportElement x="10" y="2" width="26" height="20" uuid="cee00939-18a0-43a9-8f7b-8ef37c3c8136"/>
  177. <textElement>
  178. <font size="12" isBold="true"/>
  179. </textElement>
  180. <text><![CDATA[ID]]></text>
  181. </staticText>
  182. <staticText>
  183. <reportElement x="69" y="3" width="100" height="20" uuid="c5555982-8ed2-486b-9b20-c820ea2d6303"/>
  184. <textElement>
  185. <font size="12" isBold="true"/>
  186. </textElement>
  187. <text><![CDATA[PARTICULARS]]></text>
  188. </staticText>
  189. <staticText>
  190. <reportElement x="334" y="2" width="68" height="20" uuid="444d348c-5aec-47d9-9b8b-8a0df7d5d9cc"/>
  191. <textElement>
  192. <font size="12" isBold="true"/>
  193. </textElement>
  194. <text><![CDATA[UNIT RATE]]></text>
  195. </staticText>
  196. <staticText>
  197. <reportElement x="416" y="2" width="31" height="20" uuid="e03d0e0f-fee8-48f6-b649-d29122dae87b"/>
  198. <textElement>
  199. <font size="12" isBold="true"/>
  200. </textElement>
  201. <text><![CDATA[QTY]]></text>
  202. </staticText>
  203. <staticText>
  204. <reportElement x="452" y="2" width="88" height="20" uuid="4b3c8b66-6b26-4b2c-bfa4-58917ad61092"/>
  205. <textElement>
  206. <font size="12" isBold="true"/>
  207. </textElement>
  208. <text><![CDATA[Amount Rs]]></text>
  209. </staticText>
  210. </band>
  211. </columnHeader>
  212. <detail>
  213. <band height="18" splitType="Stretch">
  214. <line>
  215. <reportElement x="1" y="-1" width="1" height="18" uuid="46636ee5-05ef-4ed0-98b3-8b3cdb0e388b"/>
  216. <graphicElement>
  217. <pen lineWidth="2.0" lineStyle="Solid"/>
  218. </graphicElement>
  219. </line>
  220. <line>
  221. <reportElement x="50" y="-2" width="1" height="18" uuid="df3f7753-0f5e-4ff0-bf2c-a3ae8a1d29dc"/>
  222. <graphicElement>
  223. <pen lineWidth="1.0" lineStyle="Solid"/>
  224. </graphicElement>
  225. </line>
  226. <line>
  227. <reportElement x="325" y="-2" width="1" height="19" uuid="ff6ab656-efe5-47d2-b6cc-7560cef1f5f4"/>
  228. <graphicElement>
  229. <pen lineWidth="1.0" lineStyle="Solid"/>
  230. </graphicElement>
  231. </line>
  232. <line>
  233. <reportElement x="411" y="-1" width="1" height="18" uuid="c6ecd5da-b343-441e-983f-b2414fa30583"/>
  234. <graphicElement>
  235. <pen lineWidth="1.0" lineStyle="Solid"/>
  236. </graphicElement>
  237. </line>
  238. <line>
  239. <reportElement x="445" y="-1" width="1" height="18" uuid="0dabdb94-9868-4f7e-935a-0fa235ce0a13"/>
  240. <graphicElement>
  241. <pen lineWidth="1.0" lineStyle="Solid"/>
  242. </graphicElement>
  243. </line>
  244. <line>
  245. <reportElement x="553" y="-1" width="1" height="18" uuid="0bc274c2-5f26-4f5d-b68d-e21bc2c4c888"/>
  246. <graphicElement>
  247. <pen lineWidth="2.0" lineStyle="Solid"/>
  248. </graphicElement>
  249. </line>
  250. <textField>
  251. <reportElement x="10" y="1" width="26" height="14" uuid="63a319b2-8afe-4318-bab9-878b61ad4a82"/>
  252. <textElement verticalAlignment="Middle">
  253. <font size="11"/>
  254. </textElement>
  255. <textFieldExpression><![CDATA[$F{ID}]]></textFieldExpression>
  256. </textField>
  257. <textField>
  258. <reportElement x="70" y="1" width="255" height="14" uuid="cf463437-6041-457b-800b-b7d4917676f6"/>
  259. <textElement verticalAlignment="Middle">
  260. <font size="11" isBold="false"/>
  261. </textElement>
  262. <textFieldExpression><![CDATA[$F{cat_name}+", "+$F{model_no}]]></textFieldExpression>
  263. </textField>
  264. <textField pattern="#,##0.00">
  265. <reportElement x="335" y="1" width="72" height="14" uuid="10d9300e-83f3-4942-836a-c547e02d8c7d"/>
  266. <textElement verticalAlignment="Middle">
  267. <font size="11"/>
  268. </textElement>
  269. <textFieldExpression><![CDATA[$F{sel_price}]]></textFieldExpression>
  270. </textField>
  271. <textField>
  272. <reportElement x="417" y="1" width="32" height="14" uuid="d744148c-6afe-46dc-b14f-c1ba4d6859c0"/>
  273. <textElement verticalAlignment="Middle">
  274. <font size="11"/>
  275. </textElement>
  276. <textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression>
  277. </textField>
  278. <textField pattern="#,##0.00">
  279. <reportElement x="452" y="1" width="89" height="14" uuid="b1d2ce72-c35f-4507-bb93-6f3e06b80a00"/>
  280. <textElement verticalAlignment="Middle">
  281. <font size="11"/>
  282. </textElement>
  283. <textFieldExpression><![CDATA[$F{amount}]]></textFieldExpression>
  284. </textField>
  285.  
  286.  
  287. <line>
  288. <reportElement x="50" y="-26" width="1" height="26" uuid="465616a8-77d2-4347-9290-149936abb9e7"/>
  289. <graphicElement>
  290. <pen lineWidth="1.0" lineStyle="Solid"/>
  291. </graphicElement>
  292. </line>
  293. <line>
  294. <reportElement x="325" y="-28" width="1" height="26" uuid="704a8402-1a4e-42a0-9ce3-673c8a9bc69b"/>
  295. <graphicElement>
  296. <pen lineWidth="1.0" lineStyle="Solid"/>
  297. </graphicElement>
  298. </line>
  299. <line>
  300. <reportElement x="411" y="-26" width="1" height="26" uuid="e4128970-6640-4c7b-9677-6b349dbfa0da"/>
  301. <graphicElement>
  302. <pen lineWidth="1.0" lineStyle="Solid"/>
  303. </graphicElement>
  304. </line>
  305. <line>
  306. <reportElement x="445" y="-27" width="1" height="26" uuid="4a2e897b-cd91-4573-a76d-a4f32b4cd077"/>
  307. <graphicElement>
  308. <pen lineWidth="1.0" lineStyle="Double"/>
  309. </graphicElement>
  310. </line>
  311. </band>
  312. </detail>
  313. <pageFooter>
  314. <band height="39" splitType="Stretch">
  315. <rectangle>
  316. <reportElement x="-21" y="9" width="599" height="30" backcolor="#333333" uuid="8634a9b7-fcf3-4881-82c3-6679dbc18552"/>
  317. </rectangle>
  318. <staticText>
  319. <reportElement x="141" y="15" width="244" height="12" forecolor="#FFFFFF" uuid="274941d4-cc0e-4fb4-997b-382c827badc9"/>
  320. <textElement>
  321. <font size="9"/>
  322. </textElement>
  323. <text><![CDATA[Software Provided by Ph# +923024712782]]></text>
  324. </staticText>
  325. <staticText>
  326. <reportElement x="142" y="27" width="244" height="12" forecolor="#FFFFFF" uuid="a4ff6425-a7f1-4fff-b0ab-a92da8a2dcb5"/>
  327. <textElement>
  328. <font size="9"/>
  329. </textElement>
  330. <text><![CDATA[www.ultronhouse.com]]></text>
  331. </staticText>
  332. <textField>
  333. <reportElement x="434" y="18" width="80" height="20" forecolor="#FFFFFF" uuid="d1d8921f-151b-44c9-8d12-4b82cb993ffe"/>
  334. <textElement textAlignment="Right"/>
  335. <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
  336. </textField>
  337. <textField evaluationTime="Report">
  338. <reportElement x="514" y="18" width="40" height="20" forecolor="#FFFFFF" uuid="f31b2a21-d3fd-470f-9527-f998b02be397"/>
  339. <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
  340. </textField>
  341. <textField pattern="EEEEE dd MMMMM yyyy">
  342. <reportElement x="-1" y="17" width="100" height="20" forecolor="#FFFFFF" uuid="34d4b240-cfb4-41d0-af4e-815e9e099d74"/>
  343. <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
  344. </textField>
  345. </band>
  346. </pageFooter>
  347. <summary>
  348. <band height="315" splitType="Stretch">
  349. <rectangle>
  350. <reportElement x="326" y="0" width="228" height="80" uuid="51ca5430-c464-4742-a4d6-178c75f4f4f8"/>
  351. <graphicElement>
  352. <pen lineWidth="2.0"/>
  353. </graphicElement>
  354. </rectangle>
  355. <rectangle>
  356. <reportElement x="0" y="0" width="325" height="22" uuid="e65cff7a-3ed1-450f-bfa7-585c580cfe60"/>
  357. <graphicElement>
  358. <pen lineWidth="1.0"/>
  359. </graphicElement>
  360. </rectangle>
  361. <textField pattern="">
  362. <reportElement x="63" y="5" width="263" height="20" uuid="102cb181-c6f9-4bf5-98cc-50333c2f9efa"/>
  363. <textElement>
  364. <font size="10" isBold="true"/>
  365. </textElement>
  366. <textFieldExpression><![CDATA[$P{REPORT_SCRIPTLET}.readNumber($V{amount_1})]]></textFieldExpression>
  367. </textField>
  368. <staticText>
  369. <reportElement x="7" y="6" width="48" height="20" uuid="1d88c6eb-ba59-45f2-b1af-b5b1cf1634b0"/>
  370. <textElement>
  371. <font size="11" isBold="true"/>
  372. </textElement>
  373. <text><![CDATA[Ruppies:]]></text>
  374. </staticText>
  375. <line>
  376. <reportElement x="327" y="60" width="226" height="1" uuid="95c9a5f3-5fed-4813-8bc1-076f9b658c09"/>
  377. </line>
  378. <staticText>
  379. <reportElement x="333" y="3" width="77" height="20" uuid="fd70b399-0bf9-4840-87b9-c398765cd363"/>
  380. <textElement>
  381. <font size="11" isBold="true"/>
  382. </textElement>
  383. <text><![CDATA[Total]]></text>
  384. </staticText>
  385. <staticText>
  386. <reportElement x="334" y="22" width="77" height="20" uuid="494a0fe7-85be-4220-9959-fbf09672ac68"/>
  387. <textElement>
  388. <font size="11" isBold="true"/>
  389. </textElement>
  390. <text><![CDATA[QTY]]></text>
  391. </staticText>
  392. <staticText>
  393. <reportElement x="334" y="61" width="110" height="20" uuid="fcb0a54c-5ecb-4e49-b7f0-0cd819c89a6c"/>
  394. <textElement>
  395. <font size="11" isBold="true"/>
  396. </textElement>
  397. <text><![CDATA[Grand Total]]></text>
  398. </staticText>
  399. <textField pattern="#,##0.00;#,##0.00-">
  400. <reportElement x="453" y="3" width="100" height="20" uuid="62437a3a-407d-46a6-9531-4c445ecd0c98"/>
  401. <textElement verticalAlignment="Top">
  402. <font size="11" isBold="false"/>
  403. </textElement>
  404. <textFieldExpression><![CDATA[$V{amount_1}]]></textFieldExpression>
  405. </textField>
  406. <textField pattern="#,##0.00;#,##0.00-">
  407. <reportElement x="454" y="22" width="100" height="20" uuid="65b192d8-375b-4f1b-b90e-7802d3fdb6eb"/>
  408. <textElement verticalAlignment="Top">
  409. <font size="11" isBold="false"/>
  410. </textElement>
  411. <textFieldExpression><![CDATA[$V{qty_1}]]></textFieldExpression>
  412. </textField>
  413. <textField evaluationTime="Report" pattern="#,##0.00;#,##0.00-">
  414. <reportElement isPrintRepeatedValues="false" x="456" y="62" width="100" height="20" uuid="87f1c4f0-44ec-42a4-9416-527113afb9ed"/>
  415. <textElement>
  416. <font size="11" isBold="true"/>
  417. </textElement>
  418. <textFieldExpression><![CDATA[($V{grandTotall}+$V{total_amount})-$V{total_amount}]]></textFieldExpression>
  419. </textField>
  420. <subreport>
  421. <reportElement x="136" y="2" width="192" height="21" uuid="ffdec19a-5213-44a4-a6e4-a874bb2b6578"/>
  422. <subreportParameter name="cusID">
  423. <subreportParameterExpression><![CDATA[$F{cus_id}]]></subreportParameterExpression>
  424. </subreportParameter>
  425. <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
  426. <returnValue subreportVariable="grandTotall" toVariable="grandTotall"/>
  427. <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "printBill_subreport.jasper"]]></subreportExpression>
  428. </subreport>
  429. <staticText>
  430. <reportElement x="335" y="41" width="108" height="20" uuid="f4b88757-b2f9-4c43-abd2-1d458137016e"/>
  431. <textElement>
  432. <font size="11" isBold="true"/>
  433. </textElement>
  434. <text><![CDATA[Previous Balance]]></text>
  435. </staticText>
  436. <textField evaluationTime="Report" pattern="#,##0.00;(#,##0.00)">
  437. <reportElement x="455" y="43" width="100" height="20" uuid="1ed3c932-ce63-4a21-9624-a60f22720620"/>
  438. <textElement>
  439. <font size="11" isBold="false"/>
  440. </textElement>
  441. <textFieldExpression><![CDATA[$V{grandTotall}-$V{amount_1}]]></textFieldExpression>
  442. </textField>
  443. <textField evaluationTime="Report">
  444. <reportElement x="86" y="60" width="100" height="20" uuid="d38785b9-638e-4e10-a9e2-b664205694e1"/>
  445. <textFieldExpression><![CDATA[($V{total_amount}+1+$V{grandTotall})-$V{total_amount}]]></textFieldExpression>
  446. </textField>
  447. </band>
  448. </summary>
  449. </jasperReport>
  450.  
  451. <?xml version="1.0" encoding="UTF-8"?>
  452. <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="printBill_subreport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="40d765ae-ceb6-47eb-a59b-aa232f876bb6">
  453. <property name="ireport.zoom" value="1.5"/>
  454. <property name="ireport.x" value="0"/>
  455. <property name="ireport.y" value="0"/>
  456. <parameter name="cusID" class="java.lang.Integer"/>
  457. <queryString>
  458. <![CDATA[select *from ac_balance where cus_id=$P{cusID} and status='UnClear']]>
  459. </queryString>
  460. <field name="ID" class="java.lang.Integer">
  461. <fieldDescription><![CDATA[]]></fieldDescription>
  462. </field>
  463. <field name="cus_name" class="java.lang.String">
  464. <fieldDescription><![CDATA[]]></fieldDescription>
  465. </field>
  466. <field name="cus_id" class="java.lang.Integer">
  467. <fieldDescription><![CDATA[]]></fieldDescription>
  468. </field>
  469. <field name="sale_id" class="java.lang.Integer">
  470. <fieldDescription><![CDATA[]]></fieldDescription>
  471. </field>
  472. <field name="qty" class="java.lang.Integer">
  473. <fieldDescription><![CDATA[]]></fieldDescription>
  474. </field>
  475. <field name="payable" class="java.lang.Integer">
  476. <fieldDescription><![CDATA[]]></fieldDescription>
  477. </field>
  478. <field name="borrow" class="java.lang.Integer">
  479. <fieldDescription><![CDATA[]]></fieldDescription>
  480. </field>
  481. <field name="receiveable" class="java.lang.Integer">
  482. <fieldDescription><![CDATA[]]></fieldDescription>
  483. </field>
  484. <field name="total" class="java.lang.Integer">
  485. <fieldDescription><![CDATA[]]></fieldDescription>
  486. </field>
  487. <field name="status" class="java.lang.String">
  488. <fieldDescription><![CDATA[]]></fieldDescription>
  489. </field>
  490. <field name="regdate" class="java.lang.String">
  491. <fieldDescription><![CDATA[]]></fieldDescription>
  492. </field>
  493. <variable name="borrow_1" class="java.lang.Integer" calculation="Sum">
  494. <variableExpression><![CDATA[$F{borrow}]]></variableExpression>
  495. </variable>
  496. <variable name="grandTotall" class="java.lang.Double">
  497. <variableExpression><![CDATA[$V{borrow_1}]]></variableExpression>
  498. </variable>
  499. <background>
  500. <band splitType="Stretch"/>
  501. </background>
  502. <title>
  503. <band height="52" splitType="Stretch"/>
  504. </title>
  505. <summary>
  506. <band height="42" splitType="Stretch"/>
  507. </summary>
  508. </jasperReport>
  509.  
  510. here below some screen shots of reports properties bellow.
  511. [Sub-report Image1][1]
  512. [main-report Image2][2]
  513. [output print3][3]
  514. [image4][4]
  515.  
  516.  
  517. [1]: https://i.stack.imgur.com/Gqdi4.png
  518. [2]: https://i.stack.imgur.com/j7OoC.png
  519. [3]: https://i.stack.imgur.com/k6LG4.png
  520. [4]: https://i.stack.imgur.com/EQALD.png
Add Comment
Please, Sign In to add comment
Public Pastes
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!