Blank Query Result

0

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.id
And  items.sales_id = sales.id
AND items.product_id = products.id
AND  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>
lukengup's picture
Joined: Aug 3 2010 - 2:11am
Last seen: 2 days 17 hours ago

3 Answers:

0

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

lukengup's picture
Joined: Aug 3 2010 - 2:11am
Last seen: 2 days 17 hours ago
0

Have you checked the connectivity between the windows machine and the data source?

sanderse's picture
652
Joined: Jul 31 2017 - 3:51pm
Last seen: 2 days 7 hours ago
0

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. 

lukengup's picture
Joined: Aug 3 2010 - 2:11am
Last seen: 2 days 17 hours ago
Feedback