lukengup Posted February 22, 2021 Share Posted February 22, 2021 Hi, I am writting a pos software: below the jrxml to generate the receipt, when I compile and run its prints fine on a mac book amd on a window pc the result query is empty as in the attached image. Any Ideas on what is the problem?<?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="Bill Receipt" pageWidth="164" pageHeight="623" columnWidth="124" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a98f55bb-9691-4a3a-a461-f05b15972097"> <property name="ireport.zoom" value="3.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="sales_id" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="pay" class="java.lang.Double"/> <parameter name="balance" class="java.lang.Double"/> <parameter name="teller" class="java.lang.String"/> <parameter name="logo_path" class="Object" isForPrompting="false"> <parameterDescription><![CDATA[The logo]]></parameterDescription> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT items.qty , items.unit_price, items.line_total, products.name, CONCAT (users.name,' ', users.surname) as user, sales.id as sales_id , sales.total_amount FROM sales,items,users, products WHERE sales.user_id = users.idAnd items.sales_id = sales.idAND items.product_id = products.idAND sales.id = $P{sales_id}]]> </queryString> <field name="qty" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="unit_price" class="java.lang.Double"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="line_total" class="java.lang.Double"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="name" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="user" class="java.lang.String"/> <field name="sales_id" class="java.lang.Integer"/> <field name="total_amount" class="java.lang.Double"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <variable name="line_total_1" class="java.lang.Double" resetType="Group" resetGroup="Sales" calculation="Sum"> <variableExpression><![CDATA[$F{line_total}]]></variableExpression> </variable> <group name="Sales"> <groupExpression><![CDATA[$F{sales_id}]]></groupExpression> <groupFooter> <band height="89"> <staticText> <reportElement x="39" y="9" width="30" height="10" uuid="d55c3805-b8f2-4602-bf49-f58558a483b5"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> <text><![CDATA[Total]]></text> </staticText> <staticText> <reportElement x="39" y="22" width="30" height="10" uuid="92f660b2-2dcc-4dce-b46e-a76442e4c3e9"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> <text><![CDATA[Pay]]></text> </staticText> <staticText> <reportElement x="39" y="34" width="30" height="10" uuid="312427e0-9f41-41bb-ab63-0b94fa36432e"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> <text><![CDATA[balance]]></text> </staticText> <line> <reportElement x="0" y="65" width="124" height="1" uuid="1a8c74f8-07ed-4e29-aea3-ed37b392d847"/> <graphicElement> <pen lineWidth="0.5" lineStyle="Dashed"/> </graphicElement> </line> <staticText> <reportElement x="4" y="65" width="120" height="20" uuid="9eb000c4-7254-4175-8454-83246297ff68"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8"/> </textElement> <text><![CDATA[ Thank you for your support ]]></text> </staticText> <line> <reportElement x="0" y="85" width="124" height="1" uuid="440339aa-20b2-4de4-8b55-f9e53d9124a3"/> <graphicElement> <pen lineWidth="0.5" lineStyle="Dashed"/> </graphicElement> </line> <textField> <reportElement x="69" y="22" width="54" height="10" uuid="791994a5-f960-4c47-9bc3-0fb31953ef6b"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$P{pay}]]></textFieldExpression> </textField> <textField> <reportElement x="69" y="34" width="54" height="10" uuid="89dfab20-0441-49ca-aa32-82bb1503543d"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$P{balance}]]></textFieldExpression> </textField> <staticText> <reportElement x="39" y="46" width="30" height="10" uuid="419f9e7c-37f8-448b-a268-92ac93777b28"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> <text><![CDATA[Teller]]></text> </staticText> <textField> <reportElement x="69" y="46" width="55" height="10" uuid="db45299b-bc79-4c8f-9794-8262a2f0d3bd"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$P{teller}]]></textFieldExpression> </textField> <textField> <reportElement x="69" y="9" width="54" height="10" uuid="d8d0c44c-4526-4f79-a12b-391ea264263c"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{line_total_1}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="39" splitType="Stretch"> <image isUsingCache="true" isLazy="true"> <reportElement x="39" y="0" width="46" height="34" uuid="da9e171d-fbb5-469d-a59d-802662be7a29"/> <imageExpression><![CDATA[$P{logo_path}]]></imageExpression> </image> <line> <reportElement x="0" y="38" width="124" height="1" uuid="11d0405a-9ef2-4c7c-9d79-cdf154a9e261"/> <graphicElement> <pen lineWidth="0.5" lineStyle="Dashed"/> </graphicElement> </line> </band> </title> <pageHeader> <band height="18" splitType="Stretch"> <staticText> <reportElement x="3" y="3" width="121" height="11" uuid="7a73f0bb-4881-4217-befe-7dcfa35034d0"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8"/> </textElement> <text><![CDATA[bMPOS System 1.0 ]]></text> </staticText> <line> <reportElement x="0" y="17" width="124" height="1" uuid="feca8879-3f8f-4589-97af-12ef8046192d"/> <graphicElement> <pen lineWidth="0.5" lineStyle="Dashed"/> </graphicElement> </line> </band> </pageHeader> <columnHeader> <band height="15" splitType="Stretch"> <staticText> <reportElement x="3" y="3" width="36" height="10" uuid="698b90b1-6446-4d72-aae8-a9f1ee6efa63"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="39" y="3" width="30" height="10" uuid="6f6664a7-5868-4eb5-886a-1b1a841a1646"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Qty]]></text> </staticText> <staticText> <reportElement x="69" y="3" width="25" height="10" uuid="09ed3919-364c-4114-b080-ca181b609416"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Price]]></text> </staticText> <staticText> <reportElement x="94" y="3" width="30" height="10" uuid="5aeab3d8-c73c-4428-a6be-723c73df249a"/> <textElement verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Total]]></text> </staticText> </band> </columnHeader> <detail> <band height="15" splitType="Stretch"> <textField> <reportElement stretchType="RelativeToTallestObject" x="3" y="3" width="36" height="10" uuid="8ba7abdf-d53b-4e24-b4e1-03be8dfbe8d6"/> <textElement verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <textField> <reportElement x="39" y="3" width="30" height="10" uuid="2bcc8594-7f46-4d4e-a8c6-cc14301ea57d"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression> </textField> <textField> <reportElement x="69" y="3" width="25" height="10" uuid="cde48031-22cc-43fb-8555-cc546ab160e5"/> <textElement verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{unit_price}]]></textFieldExpression> </textField> <textField> <reportElement x="94" y="3" width="30" height="10" uuid="c9fa534c-ef51-4f42-8f08-786a8fec08db"/> <textElement verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{line_total}]]></textFieldExpression> </textField> <line> <reportElement x="0" y="14" width="124" height="1" uuid="00566ede-6630-476f-bde8-df0970d7abef"/> <graphicElement> <pen lineWidth="0.25" lineStyle="Dashed"/> </graphicElement> </line> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="67" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary></jasperReport> Link to comment Share on other sites More sharing options...
Scott Andersen Posted February 23, 2021 Share Posted February 23, 2021 Have you checked the connectivity between the windows machine and the data source? Link to comment Share on other sites More sharing options...
lukengup Posted February 24, 2021 Author Share Posted February 24, 2021 Yes I did and from the log I can see that it is connecting to the right data source. But it still produce blank data. Link to comment Share on other sites More sharing options...
Solution lukengup Posted February 25, 2021 Author Solution Share Posted February 25, 2021 Hi,I have figured out that Windows does not like band height too small. I have increased and now the report is printing fine even on windows Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now