VORiAND

Empty document but MySQL Workbench is returning the rows

VORiAND replied to VORiAND's topic in Products

Okay, so it's also NOT the adapter, I tried with the 1. schema and it's blank there too. So it must be something with the query itself (or with the parameter formats, execution time...?), because in MySQL Workbench the results are there.

Empty document but MySQL Workbench is returning the rows

VORiAND replied to VORiAND's topic in Products

Thank you, I already fixed that, but this is not the problem (sadly...). I think the main problem is with the ADAPTER itself. I have 10 schemas in my database and right now I want to print this report from the 2. schema. If I create one adapter for this schema is Jaspersoft Studio, I get the results in preview, no problem. But if I want to print this report from my application I get one blank page. I set the connetion (from the application) the same way as for my other 20-30 reports, so I don't understand what is here wrong: JasperFillManager.fillReport(url.getPath(), parameters, connection); The connection gets the right schema, I debugged that.

Empty document but MySQL Workbench is returning the rows

VORiAND posted a topic in Products

Hi! I'm a little confused. Right now my Jasper report is giving me empty document with the same parameters as my native SQL query and in MySQL Wokrbench I see the result but in Jasper report don't. This is my native query (removed two CASE fields for the better transparency): select f.FORM_NR, p.NAME, p.MEASURING_UNIT, p.EAN, p.ITEM_NR, IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF, IF(f.DIRECTION = 2, fi.QUANTITY, -1 * fi.QUANTITY)) AS VAL_QUANTITY, IF(IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF, fi.QUANTITY)>0,fi.GROSS_MONEY,0) as VAL_GROSS_MONEY, f.FORM_DATE, f.FORM_TYPE, f.DIRECTION, pd.NAME as PARTNER_NAME, ad.CITYfrom inventory_log log, partner_data pd, address_data ad, product p join form_item fi on p.id = fi.PRODUCT_ID join form f on fi.FORM_ID = f.ID where p.id = 34413 AND fi.ID IN (SELECT DISTINCT l.FORM_ITEM_ID FROM inventory_log l, inventory_item i, product p WHERE l.INVENTORY_ITEM_ID = i.ID AND i.PRODUCT_ID = p.ID AND p.ID = 34413 )AND log.ID IN (SELECT MAX(l.ID) FROM inventory_log l, inventory_item i WHERE l.FORM_ITEM_ID = fi.ID AND i.PRODUCT_ID = 34413)AND f.PARTNER_DATA_ID = pd.IDAND f.ADDRESS_DATA_ID = ad.IDAND f.status > 1 AND (f.FORM_DATE BETWEEN '2019-05-01' AND '2019-07-13' )order by f.FORM_DATE[/code]and this is the query in Jasper report (removed two CASE fields for the better transparency): select f.FORM_NR, p.NAME, p.MEASURING_UNIT, p.EAN, p.ITEM_NR, IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF, IF(f.DIRECTION = 2, fi.QUANTITY, -1 * fi.QUANTITY)) AS VAL_QUANTITY, IF(IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF, fi.QUANTITY)>0,fi.GROSS_MONEY,0) as VAL_GROSS_MONEY, f.FORM_DATE, f.FORM_TYPE, f.DIRECTION, pd.NAME as PARTNER_NAME, ad.CITYfrom inventory_log log, partner_data pd, address_data ad, product p join form_item fi on p.id = fi.PRODUCT_ID join form f on fi.FORM_ID = f.ID where p.id = $P!{product_id} AND fi.ID IN (SELECT DISTINCT l.FORM_ITEM_ID FROM inventory_log l, inventory_item i, product p WHERE l.INVENTORY_ITEM_ID = i.ID AND i.PRODUCT_ID = p.ID AND p.ID = $P!{product_id} )AND log.ID IN (SELECT MAX(l.ID) FROM inventory_log l, inventory_item i WHERE l.FORM_ITEM_ID = fi.ID AND i.ID = $P!{product_id} )AND f.PARTNER_DATA_ID = pd.IDAND f.ADDRESS_DATA_ID = ad.IDAND f.status > 1 AND (f.FORM_DATE BETWEEN $P{start_date} AND $P{end_date} )order by f.FORM_DATE[/code]This is the complete jrxml: <?xml version="1.0" encoding="UTF-8"?><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="product_history" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ed1e2ef5-a2cb-4827-b94b-2d2042b7ceae"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MANUFACT_ADAPTER"/> <subDataset name="initial_stocks" uuid="0167a744-a508-40cd-bdd1-1b3280f376e8"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MANUFACT_ADAPTER"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <parameter name="product_id" class="java.lang.String"/> <parameter name="start_date" class="java.util.Date"/> <queryString> <![CDATA[SELECT SUM((l.QUANTITY_DIFF * -1)/1000) as "initial_stocks" , MAX(p.MEASURING_UNIT) as "MEASURING_UNIT"FROM inventory_log l, inventory_item i, product p, form f, form_item fiWHERE l.INVENTORY_ITEM_ID = i.IDAND l.FORM_ITEM_ID = fi.IDAND fi.FORM_ID = f.IDAND i.PRODUCT_ID = p.IDAND ( f.FORM_DATE < $P{start_date} )AND p.ID = $P{product_id}]]> </queryString> <field name="initial_stocks" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="initial_stocks"/> </field> <field name="MEASURING_UNIT" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="MEASURING_UNIT"/> </field> </subDataset> <subDataset name="summary" uuid="1f6c5e6b-1341-4a2f-9949-597cf79976b5"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="357"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="633"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MANUFACT_ADAPTER"/> <parameter name="product_id" class="java.lang.String"/> <parameter name="start_date" class="java.util.Date"/> <parameter name="date_end" class="java.util.Date"/> <queryString language="SQL"> <![CDATA[select SUM(IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF/1000, IF(f.DIRECTION = 2, fi.QUANTITY/1000, -1 * fi.QUANTITY/1000))) as "sum", MAX(p.MEASURING_UNIT) as "MEASURING_UNIT"from inventory_log log, partner_data pd, address_data ad, product p join form_item fi on p.id = fi.PRODUCT_ID join form f on fi.FORM_ID = f.ID where p.id = $P{product_id} AND fi.ID IN (SELECT DISTINCT l.FORM_ITEM_ID FROM inventory_log l, inventory_item i, product p WHERE l.INVENTORY_ITEM_ID = i.ID AND i.PRODUCT_ID = p.ID AND p.ID = $P{product_id} )AND log.ID IN (SELECT MAX(l.ID) FROM inventory_log l, inventory_item i WHERE l.FORM_ITEM_ID = fi.ID AND i.PRODUCT_ID = $P{product_id} )AND f.PARTNER_DATA_ID = pd.IDAND f.ADDRESS_DATA_ID = ad.IDAND f.status > 1 AND (f.FORM_DATE BETWEEN $P{start_date} AND $P{date_end} )order by f.FORM_DATE]]> </queryString> <field name="sum" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="sum"/> </field> <field name="MEASURING_UNIT" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="MEASURING_UNIT"/> </field> </subDataset> <parameter name="product_id" class="java.lang.Integer"> <parameterDescription><![CDATA[]]></parameterDescription> </parameter> <parameter name="end_date" class="java.util.Date"/> <parameter name="start_date" class="java.util.Date"/> <queryString> <![CDATA[select f.FORM_NR, p.NAME, p.MEASURING_UNIT, p.EAN, p.ITEM_NR, IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF, IF(f.DIRECTION = 2, fi.QUANTITY, -1 * fi.QUANTITY)) AS VAL_QUANTITY, IF(IF(f.FORM_TYPE = 'InventoryList', log.QUANTITY_DIFF, fi.QUANTITY)>0,fi.GROSS_MONEY,0) as VAL_GROSS_MONEY, f.FORM_DATE, f.FORM_TYPE, f.DIRECTION, pd.NAME as PARTNER_NAME, ad.CITY,case f.FORM_TYPE when 'Quotation' then 'Árajánlat' when 'Invoice' then 'Számla' when 'Shipment' then 'Szállító' when 'Orders' then 'Megrendelés' when 'FacilityForm' then 'Raktári' when 'InventoryList' then 'Leltár' else 'Egyéb' end as FORM_TYPE_HU,case when (f.DIRECTION = 1 AND f.FORM_TYPE <> 'InventoryList') then 'Értékesítés' when (f.DIRECTION = 2 AND f.FORM_TYPE <> 'InventoryList') then 'Bevétel' when (f.DIRECTION = 3 AND f.FORM_TYPE <> 'InventoryList') then 'Áthelyezés' else 'Egyéb' end as DIRECTION_HUfrom inventory_log log, partner_data pd, address_data ad, product p join form_item fi on p.id = fi.PRODUCT_ID join form f on fi.FORM_ID = f.ID where p.id = $P!{product_id} AND fi.ID IN (SELECT DISTINCT l.FORM_ITEM_ID FROM inventory_log l, inventory_item i, product p WHERE l.INVENTORY_ITEM_ID = i.ID AND i.PRODUCT_ID = p.ID AND p.ID = $P!{product_id} )AND log.ID IN (SELECT MAX(l.ID) FROM inventory_log l, inventory_item i WHERE l.FORM_ITEM_ID = fi.ID AND i.ID = $P!{product_id} )AND f.PARTNER_DATA_ID = pd.IDAND f.ADDRESS_DATA_ID = ad.IDAND f.status > 1 AND (f.FORM_DATE BETWEEN $P{start_date} AND $P{end_date} )order by f.FORM_DATE]]> </queryString> <field name="FORM_NR" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="FORM_NR"/> <property name="com.jaspersoft.studio.field.tree.path" value="form"/> </field> <field name="NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="NAME"/> <property name="com.jaspersoft.studio.field.tree.path" value="product"/> </field> <field name="MEASURING_UNIT" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="MEASURING_UNIT"/> <property name="com.jaspersoft.studio.field.tree.path" value="product"/> </field> <field name="EAN" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="EAN"/> <property name="com.jaspersoft.studio.field.tree.path" value="product"/> </field> <field name="ITEM_NR" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="ITEM_NR"/> <property name="com.jaspersoft.studio.field.tree.path" value="product"/> </field> <field name="VAL_QUANTITY" class="java.lang.Long"> <property name="com.jaspersoft.studio.field.label" value="VAL_QUANTITY"/> </field> <field name="VAL_GROSS_MONEY" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="VAL_GROSS_MONEY"/> </field> <field name="FORM_DATE" class="java.sql.Date"> <property name="com.jaspersoft.studio.field.label" value="FORM_DATE"/> <property name="com.jaspersoft.studio.field.tree.path" value="form"/> </field> <field name="FORM_TYPE" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="FORM_TYPE"/> <property name="com.jaspersoft.studio.field.tree.path" value="form"/> </field> <field name="DIRECTION" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="DIRECTION"/> <property name="com.jaspersoft.studio.field.tree.path" value="form"/> </field> <field name="PARTNER_NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="PARTNER_NAME"/> <property name="com.jaspersoft.studio.field.tree.path" value="partner_data"/> </field> <field name="CITY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CITY"/> <property name="com.jaspersoft.studio.field.tree.path" value="address_data"/> </field> <field name="FORM_TYPE_HU" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="FORM_TYPE_HU"/> </field> <field name="DIRECTION_HU" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="DIRECTION_HU"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="104" splitType="Stretch"> <staticText> <reportElement x="182" y="20" width="198" height="30" uuid="64b7d7a9-d37d-4a4d-befd-64659fff3f2c"/> <textElement textAlignment="Center"> <font fontName="DejaVu Sans" size="16" isBold="true"/> </textElement> <text><![CDATA[Termék történelem]]></text> </staticText> <textField> <reportElement x="0" y="50" width="80" height="15" uuid="699a12bc-e30b-4407-8cc6-9c8613b68adf"/> <textElement> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Kezdő dátum:"]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="66" width="80" height="15" uuid="f16aef14-fca9-430f-b4e3-02fba31a6826"/> <textElement> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Vége dátum:"]]></textFieldExpression> </textField> <textField> <reportElement x="80" y="50" width="100" height="15" uuid="bb2937f2-3754-43d8-9016-df4aaaa42c9c"/> <textElement textAlignment="Center"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("yyyy.MM.dd").format($P{start_date})]]></textFieldExpression> </textField> <textField> <reportElement x="80" y="66" width="100" height="15" uuid="e3d2104e-2605-45b0-86a4-750e77cfdf8b"/> <textElement textAlignment="Center"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("yyyy.MM.dd").format($P{end_date})]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band height="90" splitType="Stretch"> <textField> <reportElement x="10" y="4" width="534" height="30" uuid="3d0e9ca9-ac6d-441a-8b8a-76f75d052a12"/> <textElement verticalAlignment="Top"> <font fontName="DejaVu Sans" size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> <line> <reportElement x="0" y="34" width="555" height="1" forecolor="#918A8A" backcolor="#918A8A" uuid="c8d4e75a-c7a9-4bd7-bc3e-0c7e3e7d4c7c"/> <graphicElement> <pen lineWidth="0.5" lineColor="#918A8A"/> </graphicElement> </line> <textField> <reportElement x="0" y="53" width="90" height="30" uuid="7213b60d-7a5c-48b3-a466-2816d432d0dc"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Kezdő készlet:"]]></textFieldExpression> </textField> <componentElement> <reportElement x="90" y="53" width="50" height="30" uuid="434597cf-7745-4340-9eac-1f67fe83df0d"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> </reportElement> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="initial_stocks" uuid="ac3900c6-af12-43c3-90f9-661604020ece"> <datasetParameter name="product_id"> <datasetParameterExpression><![CDATA[$P{product_id}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="start_date"> <datasetParameterExpression><![CDATA[$P{start_date}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="30" width="50"> <textField pattern="#,##0.##"> <reportElement x="0" y="0" width="50" height="30" uuid="7920d330-4912-4466-bbf4-96d6531efe11"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="DejaVu Sans" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{initial_stocks}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> <componentElement> <reportElement x="143" y="53" width="100" height="30" uuid="5e2082d7-ffea-4f66-8730-1be8cc44b8aa"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> </reportElement> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="initial_stocks" uuid="86e60e1e-576a-48d9-982d-5683e29c6bcd"> <datasetParameter name="product_id"> <datasetParameterExpression><![CDATA[$P{product_id}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="start_date"> <datasetParameterExpression><![CDATA[$P{start_date}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="30" width="100"> <textField> <reportElement x="0" y="0" width="100" height="30" uuid="82b5e370-456b-4f29-b9e7-db49df12841a"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{MEASURING_UNIT}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </band> </pageHeader> <columnHeader> <band height="30" splitType="Stretch"> <staticText> <reportElement x="92" y="0" width="90" height="20" uuid="bcdc46c3-f367-40e2-902c-65a5f078b26d"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <text><![CDATA[Kelt]]></text> </staticText> <staticText> <reportElement x="182" y="0" width="80" height="20" uuid="e969bb7d-ecb5-456d-9cda-370a06010bf5"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <text><![CDATA[Bizonylat típus]]></text> </staticText> <staticText> <reportElement x="264" y="0" width="70" height="20" uuid="b9ba4535-b6be-4989-8394-3e7bc068cb8a"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <text><![CDATA[Mennyiség]]></text> </staticText> <staticText> <reportElement x="334" y="0" width="88" height="20" uuid="aa476bf3-a376-45b7-8800-cbe23affc81e"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <text><![CDATA[Bruttó összeg]]></text> </staticText> <staticText> <reportElement x="422" y="0" width="132" height="20" uuid="f8abf85e-9536-4eca-86ab-ae2c0bdbd073"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <text><![CDATA[Ügyfél / Település]]></text> </staticText> <staticText> <reportElement x="0" y="0" width="92" height="20" uuid="e191ac8d-bfa4-41b7-ad5b-ed69cb106c9a"/> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans" isBold="true"/> </textElement> <text><![CDATA[Sorszám]]></text> </staticText> </band> </columnHeader> <detail> <band height="35" splitType="Stretch"> <textField pattern="yyyy.MM.dd" isBlankWhenNull="false"> <reportElement x="92" y="5" width="90" height="30" uuid="b2e20c7e-ee43-43a3-8019-bcb4b87c7809"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{FORM_DATE}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="264" y="5" width="70" height="30" uuid="069fe138-7f26-4eaa-9d20-bca90f6a45f6"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{VAL_QUANTITY} == null ? 0 : BigDecimal.valueOf($F{VAL_QUANTITY} / 1000d)]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="334" y="5" width="88" height="30" uuid="67f3e26f-3d10-4605-b21f-fba546f9115b"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[($F{VAL_GROSS_MONEY} != null) ? new java.text.DecimalFormat("#,##0.#").format($F{VAL_GROSS_MONEY}) :"0"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="422" y="5" width="133" height="14" uuid="b841c614-7f47-4184-a807-99ee252abf64"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{PARTNER_NAME}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="422" y="19" width="133" height="16" uuid="66099654-9c2d-45f3-a62f-06fde4956d7b"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{CITY}]]></textFieldExpression> </textField> <textField> <reportElement x="182" y="5" width="82" height="14" uuid="7553e155-0ab5-4466-b8e5-c245f4049b86"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{FORM_TYPE_HU}]]></textFieldExpression> </textField> <textField> <reportElement x="182" y="20" width="82" height="14" uuid="359673e4-a5d2-4c4f-8c22-58aef73637ce"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{DIRECTION_HU}]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="5" width="92" height="30" uuid="f593efc3-6704-4e29-97fb-39d9f9fd2d8e"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{FORM_NR}]]></textFieldExpression> </textField> <line> <reportElement x="0" y="0" width="555" height="1" forecolor="#918A8A" backcolor="#918A8A" uuid="22a6185d-0474-4de4-880f-320ee299a61a"/> <graphicElement> <pen lineWidth="0.5" lineColor="#918A8A"/> </graphicElement> </line> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="4" width="194" height="16" uuid="ab92b4c2-e8aa-42df-ac8f-814b9dd6a32f"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <text><![CDATA[EVO Plus - Az ügyvitel EVOluciója]]></text> </staticText> <line> <reportElement x="0" y="3" width="555" height="1" forecolor="#918A8A" backcolor="#918A8A" uuid="0e60e4f9-1ce1-4e34-90b2-850c8f91b016"/> <graphicElement> <pen lineWidth="0.5" lineColor="#918A8A"/> </graphicElement> </line> <textField pattern="yyyy.MM.dd"> <reportElement x="230" y="4" width="100" height="16" uuid="b8c86b83-fe11-4344-a9c0-79cbaa48474c"/> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement x="455" y="3" width="100" height="16" uuid="6f126be0-6ed5-409f-a254-7baff91ce2ff"/> <textElement textAlignment="Right"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}+ ". oldal"]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="83" splitType="Stretch"> <textField> <reportElement x="174" y="0" width="90" height="30" uuid="846ac53a-0cd9-45c3-83a0-cb6be701f540"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Összesen:"]]></textFieldExpression> </textField> <componentElement> <reportElement x="264" y="0" width="50" height="30" uuid="afed92ad-7b33-482a-9c34-1cb24a1a472e"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> </reportElement> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="summary" uuid="042af01b-7d4c-4e84-b4cb-d3eadddf5742"> <datasetParameter name="product_id"> <datasetParameterExpression><![CDATA[$P{product_id}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="start_date"> <datasetParameterExpression><![CDATA[$P{start_date}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="date_end"> <datasetParameterExpression><![CDATA[$P{end_date}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="30" width="50"> <textField pattern="#,##0.##"> <reportElement x="0" y="0" width="50" height="30" uuid="31e46972-771c-490c-95ec-1667c5025235"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{sum}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> <componentElement> <reportElement x="317" y="0" width="100" height="30" uuid="65f55706-3da0-43c8-a20c-77acdc7c29e1"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="summary" uuid="13324226-5816-49b9-89bb-0cb928c28f5a"> <datasetParameter name="product_id"> <datasetParameterExpression><![CDATA[$P{product_id}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="start_date"> <datasetParameterExpression><![CDATA[$P{start_date}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="date_end"> <datasetParameterExpression><![CDATA[$P{end_date}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="30" width="100"> <textField> <reportElement x="0" y="0" width="100" height="30" uuid="cc6b7655-3e48-48e4-9b22-6c12826f5e1a"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{MEASURING_UNIT}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </band> </summary></jasperReport>[/code]Also the Data preview is giving me 0 results... The type of the parameters: product_id: java.lang.Integer start_date: java.util.Date end_date: java.util.Date What am I missing?! Thank you!

Wrong pagination and no header on second page with subreport

VORiAND replied to VORiAND's topic in Products

Okay, so with the "Last page footer" it seems to work, but this subreport is now on the bottom of the page, which is not very beautiful... But the bigger probem is, that I got also on the last page the column headers, which shouldn't be there, because there are not details on this page: How can I remove the column headers from the last page?

June 11, 2019
6 replies
- jasper report
- subreports
- (and 3 more)
  Tagged with:

Wrong pagination and no header on second page with subreport

VORiAND replied to VORiAND's topic in Products

The header is also in the TITLE and also in the PAGE HEADER band included, isn't that okay so? What do you mean by "Try to create group footer"? How can I do that?

June 11, 2019
6 replies
- jasper report
- subreports
- (and 3 more)
  Tagged with:

Wrong pagination and no header on second page with subreport

VORiAND posted a topic in Products

Hi All! I have one report which includes one summary subreport on the end in the "Summary" band. My problem is, if it has many elements in the "Details" band, the subreport gets on the second page, but on the second page there is no header, the page number is also missing and the signatures are also on the first page, but they should be on the last page. .. So it seems it's a "glitch", but I don't know how can I fix this: This is my report source: https://pastebin.com/UrdsU1ni (sorry had to use pastebin...) This is my subreport source: <?xml version="1.0" encoding="UTF-8"?><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="vat_sum" pageWidth="340" pageHeight="300" orientation="Landscape" columnWidth="300" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fd6b586b-3b38-484e-879a-f47a65d681ec"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MANUFACT_ADAPTER"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <parameter name="INVOICE_ID" class="java.lang.Integer"/> <parameter name="NET_SUM" class="java.math.BigDecimal"/> <parameter name="VAT_SUM" class="java.math.BigDecimal"/> <parameter name="GROSS_SUM" class="java.math.BigDecimal"/> <parameter name="CURRENCY" class="java.lang.String"/> <parameter name="PAYMENT_TYPE" class="java.lang.Integer"> <parameterDescription><![CDATA[]]></parameterDescription> </parameter> <parameter name="NET_TOTAL" class="java.lang.String"/> <parameter name="VAT" class="java.lang.String"/> <parameter name="VAT_TOTAL" class="java.lang.String"/> <parameter name="GROSS_TOTAL" class="java.lang.String"/> <parameter name="TOTAL_WITH_COLON" class="java.lang.String"/> <parameter name="TOTAL_PRICE" class="java.lang.String"/> <parameter name="reverse_charge" class="java.lang.Integer"/> <parameter name="DAILY_RATE" class="java.math.BigDecimal"/> <queryString> <![CDATA[sELECT form_item.`VAT_RATE`,sum(form_item.NET_PRICE) AS NET_PRICE, sum(form_item.`VAT_MONEY`) AS VAT_MONEY, sum(form_item.`GROSS_MONEY`) AS GROSS_MONEYFROM form_itemWHERE form_item.`FORM_ID` = $P{INVOICE_ID} ANDform_item.`DELETED` <> 'deleted'GROUP BY form_item.`VAT_RATE`]]> </queryString> <field name="VAT_RATE" class="java.lang.Integer"/> <field name="NET_PRICE" class="java.math.BigDecimal"/> <field name="VAT_MONEY" class="java.math.BigDecimal"/> <field name="GROSS_MONEY" class="java.math.BigDecimal"/> <background> <band height="3" splitType="Stretch"/> </background> <columnHeader> <band height="29" splitType="Prevent"> <line> <reportElement x="-16" y="28" width="332" height="1" uuid="07818547-1a8c-473a-a65c-f3599887fdd4"/> <graphicElement> <pen lineWidth="0.5"/> </graphicElement> </line> <line> <reportElement x="-16" y="4" width="332" height="1" uuid="1c776d8e-b433-4f5c-8a9f-1640caef9736"/> <graphicElement> <pen lineWidth="0.5"/> </graphicElement> </line> <textField> <reportElement mode="Opaque" x="65" y="4" width="81" height="24" backcolor="#CFCFCF" uuid="0eb994e5-84a9-4e9c-8f15-0462b2aa19fd"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{NET_TOTAL}]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="146" y="4" width="80" height="24" backcolor="#CFCFCF" uuid="47f0fa71-1cbe-4731-9ae1-091d5c898246"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{VAT_TOTAL}]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="226" y="4" width="90" height="24" backcolor="#CFCFCF" uuid="7558bf9f-bdbc-49d2-a744-97e213b6604a"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{GROSS_TOTAL}]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="-16" y="4" width="81" height="24" backcolor="#CFCFCF" uuid="619e510c-7928-47f7-8d68-b63eb2b10bd0"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{VAT}]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="22" splitType="Prevent"> <textField pattern="#,##0.##"> <reportElement x="-16" y="0" width="81" height="22" uuid="1902154e-2578-4951-b36c-bca47359e3d4"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[($P{reverse_charge} == 1 ? "FAD " : "") + $F{VAT_RATE} + "%"]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="65" y="0" width="81" height="22" uuid="89b79230-4abd-4fe2-98d0-850419b86d48"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$F{NET_PRICE}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="146" y="0" width="80" height="22" uuid="d793763c-7d64-4e2f-a530-a35a3adf121f"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$F{VAT_MONEY}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="226" y="0" width="90" height="22" uuid="0235855a-96cb-4b9b-8e7d-c8839c74c4fb"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$F{GROSS_MONEY}]]></textFieldExpression> </textField> </band> </detail> <lastPageFooter> <band height="70" splitType="Prevent"> <line> <reportElement x="-16" y="0" width="332" height="1" uuid="7b7970a5-5fc2-45b6-b5f7-4673e8bc1314"/> <graphicElement> <pen lineWidth="0.5"/> </graphicElement> </line> <textField pattern="#,##0.##"> <reportElement x="65" y="3" width="81" height="20" uuid="5e1221ca-617a-4cc6-9df3-50b2ab29e9f8"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{NET_SUM}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="122" y="29" width="168" height="20" uuid="e6275194-7a1b-4f7c-8a8f-0e5017a0c308"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{GROSS_SUM}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="146" y="3" width="80" height="20" uuid="c58e6de9-f9b1-4a61-b34b-52c280390023"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{VAT_SUM}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="-16" y="3" width="81" height="20" uuid="064ec625-fefc-4b94-aadd-a1a641859def"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{TOTAL_WITH_COLON}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="-16" y="29" width="138" height="20" uuid="ed559e1e-f125-445f-ba37-d892fa3e3e10"/> <textElement> </textElement> <textFieldExpression><![CDATA[$P{TOTAL_PRICE}]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="226" y="3" width="90" height="20" uuid="e3ecd6a6-0d89-4186-9797-552a062fda8e"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{GROSS_SUM}]]></textFieldExpression> </textField> <textField> <reportElement x="-16" y="49" width="138" height="20" uuid="8d73fe0f-a403-4607-aa83-4acf512f2178"/> <textElement> </textElement> <textFieldExpression><![CDATA[!$P{CURRENCY}.equals("HUF") ? "VAT Total in HUF / Áfa érték Forintban: " : ""]]></textFieldExpression> </textField> <textField pattern="#,##0.##"> <reportElement x="122" y="49" width="194" height="20" uuid="abad0a43-5526-4bad-a553-6aec739559ef"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{PAYMENT_TYPE}.equals(1) && !$P{CURRENCY}.equals("HUF") ? ($P{DAILY_RATE}.multiply($P{VAT_SUM}).divide(new BigDecimal(5)).setScale(0, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(5)).intValue()) : !$P{CURRENCY}.equals("HUF") ? $P{DAILY_RATE}.multiply($P{VAT_SUM}).setScale(0, BigDecimal.ROUND_HALF_UP) + " Forint" : ""]]></textFieldExpression> </textField> <textField> <reportElement x="291" y="29" width="25" height="20" uuid="24e5ca6d-08e8-433b-a523-b0e7f644b28e"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{CURRENCY}]]></textFieldExpression> </textField> </band> </lastPageFooter></jasperReport>[/code]Thank you very much!

June 11, 2019
6 replies
- jasper report
- subreports
- (and 3 more)
  Tagged with:

How to pass string parameter without quotes?

VORiAND posted a topic in Products

Hi! I have a very simple query in my report which has an ORDER BY at the end with one parameter: ORDER BY $P{form_item_order}[/code]My problem is very simple. The ORDER BY is not wokring. The query looks like this: product_data.`NAME` AS PRODUCT_NAME,product_data.`ITEM_NR` AS ITEM_NR,product_data.`EAN` AS EAN,[/code]... if I give the parameter in, in the preview and if I execute it in my app, it's not working, because it's a string and it gets quotes. If I enter my query in MySQLWorkbench end execute it without any quote like this: ORDER BY PRODUCT_NAME it's working... I don't know why. But it looks like I need to pass a string without quotes. Is it possible?

April 18, 2019
1 reply
- sql
- mysql
- (and 3 more)
  Tagged with:
  - sql
  - mysql
  - jasper
  - parameters
  - Jaspersoft Studio

Why is my details band not repeating?

VORiAND replied to VORiAND's topic in Products

The solution was this: replace this: product.`ID` in ( $P{id_list} ) with this: product.`ID` in ( $P!{id_list} )

Why is my details band not repeating?

VORiAND replied to VORiAND's topic in Products

Okay, so the problem is with the list handling. If I remove this from the Query: "AND product.`ID` in ( $P{id_list} )" the preview is giving me more results. I enter parameters like this: "1,2,3". Isn't this so correct?

Why is my details band not repeating?

VORiAND replied to VORiAND's topic in Products

Oh, my god... You are right. It only delivers one row, but why and how?! I debugged my SQL query hundred times in MySQLWorkbench and the results are there okay.

Why is my details band not repeating?

VORiAND replied to VORiAND's topic in Products

I downgraded my Jasper version in my webapp to 6.5.1: <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports</artifactId> <version>6.5.1</version> </dependency> <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports-fonts</artifactId> <version>6.0.0</version> </dependency> Changed nothing, there is only one product label in the resulting pdf :( Also downgraded my JasperSoft Studio to 6.5.1 version and the preview there is sadly also the same :(

Why is my details band not repeating?

VORiAND replied to VORiAND's topic in Products

Hm... If I take the SQL query and put it into MySQLWorkbench AND input the parameters as I enter in the preview: SELECT product.ID, LOWER(c.COMPANY_NAME) AS COMPANY_NAME, price1.GROSS_PRICE as price1, price2.GROSS_PRICE as price2, price3.GROSS_PRICE as price3, product.`item_nr`, product.`NAME`, IF(product.`EAN` REGEXP ('^[0-9]+$'), IF(LENGTH(product.`EAN`) > 12, SUBSTRING(product.`EAN`, 1, 12), NULL), NULL) AS EAN_NORM, price.`NET_UNIT_PRICE`, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE", price.`PRICELIST`FROM (SELECT PRODUCT_ID, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE" FROM price WHERE pricelist = 1) price1, (SELECT PRODUCT_ID, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE" FROM price WHERE pricelist = 2) price2, (SELECT PRODUCT_ID, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE" FROM price WHERE pricelist = 3) price3, (SELECT DISTINCT NAME AS COMPANY_NAME from company LIMIT 0,1) c, price INNER JOIN product ON price.`PRODUCT_ID` = product.`ID` WHERE product.`ID` in (115,116,117) and price.`PRICELIST` = 1 AND price1.PRODUCT_ID = price.`PRODUCT_ID` AND price3.PRODUCT_ID = price.`PRODUCT_ID` AND price2.PRODUCT_ID = price.`PRODUCT_ID` ORDER BY product.`EAN`[/code]I get three rows, so not only one. I am missing really something I guess :)

Why is my details band not repeating?

VORiAND posted a topic in Products

Hi All! I have one products label report, where I want to print all the selected products, with barcode and name. This was working fine until now, there was two labels beside each other and many under each other, so it filled the A4 paper. But something changed and I don't know what... Right now it only prints the last resulting row as far as I can tell, not more, only this one. I'm searching since hours, but can't fnd the settings which is leading to this... This is my report code: <?xml version="1.0" encoding="UTF-8"?><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="products_label" columnCount="2" printOrder="Horizontal" pageWidth="595" pageHeight="842" columnWidth="267" columnSpacing="20" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="899f8e9c-f50e-4b4d-8793-c60f859f5da3"><property name="com.jaspersoft.studio.data.sql.tables" value=""/><property name="com.jaspersoft.studio.data.defaultdataadapter" value="MANUFACT_ADAPTER"/><style name="barcode-style" mode="Opaque" forecolor="#000000" hTextAlign="Center" hImageAlign="Center" vTextAlign="Bottom" vImageAlign="Bottom" markup="styled" fontName="barcode" fontSize="8"/><parameter name="id_list" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription></parameter><parameter name="price" class="java.lang.String"/><queryString><![CDATA[sELECTproduct.ID,LOWER(c.COMPANY_NAME) AS COMPANY_NAME, price1.GROSS_PRICE as price1, price2.GROSS_PRICE as price2, price3.GROSS_PRICE as price3,product.`item_nr`,product.`NAME`,IF(product.`EAN` REGEXP ('^[0-9]+$'),IF(LENGTH(product.`EAN`) > 12,SUBSTRING(product.`EAN`, 1, 12), NULL),NULL) AS EAN_NORM,price.`NET_UNIT_PRICE`,(price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE",price.`PRICELIST`FROM (SELECT PRODUCT_ID, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE" FROM price WHERE pricelist = 1) price1, (SELECT PRODUCT_ID, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE" FROM price WHERE pricelist = 2) price2, (SELECT PRODUCT_ID, (price.`NET_UNIT_PRICE` + (price.`VAT_RATE`/100 * price.`NET_UNIT_PRICE`)) AS "GROSS_PRICE" FROM price WHERE pricelist = 3) price3, (SELECT DISTINCT NAME AS COMPANY_NAME from company LIMIT 0,1) c,priceINNER JOIN product ONprice.`PRODUCT_ID` = product.`ID`WHERE product.`ID` in ( $P{id_list} ) and price.`PRICELIST` = $P{price} AND price1.PRODUCT_ID = price.`PRODUCT_ID` AND price3.PRODUCT_ID = price.`PRODUCT_ID` AND price2.PRODUCT_ID = price.`PRODUCT_ID`ORDER BY product.`EAN`]]></queryString><field name="ID" class="java.lang.Integer"><property name="com.jaspersoft.studio.field.label" value="ID"/><property name="com.jaspersoft.studio.field.tree.path" value="product"/></field><field name="COMPANY_NAME" class="java.lang.String"><property name="com.jaspersoft.studio.field.label" value="COMPANY_NAME"/><property name="com.jaspersoft.studio.field.tree.path" value="company"/></field><field name="price1" class="java.math.BigDecimal"><property name="com.jaspersoft.studio.field.label" value="price1"/></field><field name="price2" class="java.math.BigDecimal"><property name="com.jaspersoft.studio.field.label" value="price2"/></field><field name="price3" class="java.math.BigDecimal"><property name="com.jaspersoft.studio.field.label" value="price3"/></field><field name="item_nr" class="java.lang.String"><property name="com.jaspersoft.studio.field.label" value="item_nr"/><property name="com.jaspersoft.studio.field.tree.path" value="product"/></field><field name="NAME" class="java.lang.String"><property name="com.jaspersoft.studio.field.label" value="NAME"/><property name="com.jaspersoft.studio.field.tree.path" value="product"/></field><field name="EAN_NORM" class="java.lang.String"><property name="com.jaspersoft.studio.field.label" value="EAN_NORM"/></field><field name="NET_UNIT_PRICE" class="java.math.BigDecimal"><property name="com.jaspersoft.studio.field.label" value="NET_UNIT_PRICE"/><property name="com.jaspersoft.studio.field.tree.path" value="price"/></field><field name="GROSS_PRICE" class="java.math.BigDecimal"><property name="com.jaspersoft.studio.field.label" value="GROSS_PRICE"/></field><field name="PRICELIST" class="java.lang.String"><property name="com.jaspersoft.studio.field.label" value="PRICELIST"/><property name="com.jaspersoft.studio.field.tree.path" value="price"/></field><background><band splitType="Stretch"/></background><detail><band height="151"><property name="com.jaspersoft.studio.unit.height" value="cm"/><property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/><textField><reportElement x="5" y="10" width="255" height="70" uuid="25652973-1537-4d37-a5a2-7b42a49d97de"/><textElement></textElement><textFieldExpression><![CDATA[(($F{NAME} != null) ? $F{NAME} : "")]]></textFieldExpression></textField><line><reportElement x="-7" y="-1" width="28" height="1" uuid="d3ca5612-8578-4d0e-91fb-52486bb4392d"><property name="com.jaspersoft.studio.unit.width" value="cm"/><property name="com.jaspersoft.studio.unit.height" value="pixel"/></reportElement><graphicElement><pen lineWidth="0.6" lineStyle="Solid"/></graphicElement></line><line><reportElement key="" x="-7" y="-1" width="1" height="28" uuid="0f02b6db-f6fe-4840-9bf7-a1148dff0658"><property name="com.jaspersoft.studio.unit.width" value="cm"/><property name="com.jaspersoft.studio.unit.height" value="cm"/></reportElement><graphicElement><pen lineWidth="0.6" lineStyle="Solid"/></graphicElement></line><line><reportElement key="" x="274" y="123" width="1" height="28" uuid="0efc54d4-0caf-4fe2-a0c4-c7e2d2225964"><property name="com.jaspersoft.studio.unit.width" value="pixel"/><property name="com.jaspersoft.studio.unit.height" value="cm"/><property name="com.jaspersoft.studio.unit.y" value="pixel"/></reportElement><graphicElement><pen lineWidth="0.6" lineStyle="Solid"/></graphicElement></line><line><reportElement x="246" y="150" width="28" height="1" uuid="b8b0504f-e9c0-4f77-bef5-9e9722b20283"><property name="com.jaspersoft.studio.unit.width" value="cm"/><property name="com.jaspersoft.studio.unit.height" value="pixel"/></reportElement><graphicElement><pen lineWidth="0.6" lineStyle="Solid"/></graphicElement></line><textField><reportElement x="140" y="111" width="120" height="30" uuid="ac22f508-b234-423f-9bfa-9a55df558dd1"/><textElement textAlignment="Right" verticalAlignment="Middle"></textElement><textFieldExpression><![CDATA[( $F{GROSS_PRICE} != null) ? new java.text.DecimalFormat("#,##0.##").format($F{GROSS_PRICE} .setScale(0, BigDecimal.ROUND_HALF_UP).intValue()) + " Ft" : "0 Ft"]]></textFieldExpression></textField><componentElement><reportElement x="0" y="111" width="140" height="30" uuid="92b7f4ee-135c-4b31-a92c-a1ee25832a33"><printWhenExpression><![CDATA[( $F{EAN_NORM} != null )]]></printWhenExpression></reportElement><c:EAN13 xmlns:c="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" textPosition="bottom" checksumMode="auto"><c:codeExpression><![CDATA[($F{EAN_NORM} != null ? $F{EAN_NORM} : null)]]></c:codeExpression></c:EAN13></componentElement><textField><reportElement x="5" y="80" width="255" height="30" uuid="ae7748b8-812a-4f47-96bb-5bc9c7d33d08"/><textElement textAlignment="Right" verticalAlignment="Middle"/><textFieldExpression><![CDATA[($F{COMPANY_NAME} .contains("bétalox") ? new java.text.DecimalFormat("#,##0.##").format($F{price1}) + " * " + new java.text.DecimalFormat("#,##0.##").format($F{price3}) : "")]]></textFieldExpression></textField></band></detail></jasperReport>[/code] What am I missing? Thank you!

Barcode text is empty using Barbecue

VORiAND replied to VORiAND's topic in Products

I tried to make the barcode element bigger, but nothing changed. What do you mean by "Fixing barbeque and replacing it" ? What exactly did you do? This is my JasperSoft Studio editor view. The barcode elements dimensions are now: width: 140px, height: 51px

November 16, 2018
2 replies
- java
- jasper
- (and 2 more)
  Tagged with:

Barcode text is empty using Barbecue

VORiAND posted a topic in Products

I want to show on my Jasper Report one EAN13 barcode WITH numbers. So far the preview in JasperSoft Studio 6.5.1 is working great, I see the barcode and the text under it: This is the code part of it in my .jrxml: <componentElement> <reportElement positionType="FixRelativeToBottom" x="0" y="111" width="130" height="30" uuid="48d9d636-7e04-43df-9fa2-5c3f6edf27da"/> <c:barbecue xmlns:c="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" type="EAN13" drawText="true" checksumRequired="false"> <c:codeExpression> <![CDATA[$F{EAN}]]> </c:codeExpression> </c:barbecue></componentElement>[/code]My problem is, that if I build this .jasper report and deploy is to my Java webapp and print it out into .pdf the text under the barcode is empty or white, but I see there nothing, only the barcode: What do I need to change to view the text also in the webapp version of the report? Thank you.

November 15, 2018
2 replies
- java
- jasper
- (and 2 more)
  Tagged with:

Sign In

Posts

Joined

Last visited

VORiAND's Achievements

Apprentice (3/14)

Recent Badges

Reputation

Empty document but MySQL Workbench is returning the rows

Empty document but MySQL Workbench is returning the rows

Empty document but MySQL Workbench is returning the rows

Wrong pagination and no header on second page with subreport

Wrong pagination and no header on second page with subreport

Wrong pagination and no header on second page with subreport

How to pass string parameter without quotes?

Why is my details band not repeating?

Why is my details band not repeating?

Why is my details band not repeating?

Why is my details band not repeating?

Why is my details band not repeating?

Why is my details band not repeating?

Barcode text is empty using Barbecue

Barcode text is empty using Barbecue

Activity

Products

Explore