lukengup

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

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.

You might need to go to Your System Preferences and choose security and privacy: Under the general tab : tick the radio App Store and identified developers under the Allow App downloaded from title then click on the button open anyway. Thanks, Hope it does help

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>