dirai

While running my reports on the server in Red Prairie database, I often get the error for some of the reports as "Run Task Error: Report template file does not exist" What could be the reason?

Hi, How can I make use of the unix environment variable DCS_USERRPTDIR within an ireport? I need to set the JR_TEMPLATE_DIR to this value. Please help A.S.A.P! Thanks.

Duro, Please leave it. It is because of multiple table definition in the same query. Sorry!: )

Hi Doru, I did and that works. Can you have a look with this query and let me know what's wrong: /************************************************ */ /* MC30 - Stock Check Audit Report */ /* */ /* REBELJ01 11-APR-2011 ORIGINAL QUERY Written for */ /* Swindon RDC Project. */ /* */ /************************************************ */ SELECT itl.site_id, itl.sku_id, itl.location_id, TO_CHAR(MAX(dstamp), 'DD-MON-YYYY') latest_check_date, COUNT(1) total_stock_checks FROM (SELECT itl_current.site_id, itl_current.from_loc_id location_id, itl_current.sku_id, itl_current.dstamp FROM inventory_transaction itl_current WHERE itl_current.code = 'Stock Check' AND itl_current.site_id = NVL($P{site_id}, itl_archive.site_id) AND itl_current.dstamp >= to_timestamp_tz($P{fromdate},'DD-MON-YYYY') AND itl_current.dstamp <= to_timestamp_tz($P{todate},'DD-MON-YYYY') UNION SELECT itl_archive.site_id, itl_archive.from_loc_id location_id, itl_archive.sku_id, itl_archive.dstamp FROM inventory_transaction_archive itl_archive WHERE itl_archive.code = 'Stock Check' AND itl_archive.site_id = NVL($P{site_id}, itl_archive.site_id) AND itl_archive.dstamp >= to_timestamp_tz($P{fromdate},'DD-MON-YYYY') AND itl_archive.dstamp <= to_timestamp_tz($P{todate},'DD-MON-YYYY') )itl GROUP BY itl.site_id, itl.sku_id, itl.location_id ORDER BY 1,2

Hi Forum, Please help me to resolve the problem mentioned in the attached report. A.S.A.P. I guess there is some problem with the input parameters I am passing to this report. Dipak. Code:Caused by: java.sql.SQLException: ORA-00911: invalid character

Hi Guilio, iReport Forum, I am trying to install iReports in my new workstation. I copied all the files: C:\Program Files\Jaspersoft\iReport-3.0.0. When I click on the iReport icon in the C:\Program Files\Jaspersoft\iReport-3.0.0, it gives the error message "Java has not been found on your computer." I checked in command prompt for the java version.It shows jre 1.4.2 installed. I guess I need the jdk toolkit as well. Do I? Is Java Tool Kit jdk really required for iReports? What are the software specifications for installing iReports (apart from clicking on the download link in the sourceforge website)? Please help me with a detailed answer here. Thanks.

After creating a new report and running it I get the following error: Error filling print... Could not resolved style(s): Arial Unicode, Arial net.sf.jasperreports.engine.JRRuntimeException: Could not resolved style(s): Arial Unicode, Arial at net.sf.jasperreports.engine.fill.JRFillObjectFactory.checkUnresolvedReferences(JRFillObjectFactory.java:1610) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.setStyles(JRFillObjectFactory.java:1537) at net.sf.jasperreports.engine.fill.JRBaseFiller.loadStyles(JRBaseFiller.java:962) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:835) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:910) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource... What can be the cause for this? Please help. Code:<?xml version="1.0" encoding="UTF-8" ?><!-- Created with iReport - A designer for JasperReports --><!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"><jasperReport name="MC2" language="groovy" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="650" pageHeight="595" columnWidth="610" columnSpacing="0" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false" isIgnorePagination="true"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="fromdate" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA[$P{fromdate}]]></defaultValueExpression> </parameter> <parameter name="todate" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA[$P{todate}]]></defaultValueExpression> </parameter> <parameter name="site_id" isForPrompting="true" class="java.lang.String"/> <parameter name="vendor_id" isForPrompting="false" class="java.lang.String"/> <parameter name="supplier_id" isForPrompting="false" class="java.lang.String"/> <parameter name="JR_TIME_ZONE_NAME" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Europe/London"]]></defaultValueExpression> </parameter> <parameter name="JR_LANGUAGE" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["EN_GB"]]></defaultValueExpression> </parameter> <parameter name="JR_TEMPLATE_DIR" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["C:/DCSI/sandboxes/dlxwhsr_20072_branch/server/run/jrtemplates"]]></defaultValueExpression> </parameter> <queryString><![CDATA[sELECT bookdet.supplier_id supplier_id, bookhead.site_id site_id, count(1) num_deliveriesFROM booking_in_diary_details bookdet,booking_in_diary bookheadWHERE NOT EXISTS (SELECT 1 FROM upi_receipt_header WHERE upi_receipt_header.bookref_id = bookhead.bookref_id )AND bookhead.due_dstamp > sysdate - 60AND bookhead.status IN ('Released', 'In Progress') and bookhead.bookref_id = bookdet.bookref_idAND bookhead.due_dstamp >= to_timestamp_tz($P{fromdate},'DD-MON-YYYY')AND bookhead.due_dstamp <= to_timestamp_tz($P{todate},'DD-MON-YYYY')AND bookhead.site_id = nvl($P{site_id},bookhead.site_id)GROUP BY bookdet.supplier_id, bookhead.site_idorder BY bookdet.supplier_id, bookhead.site_id]]></queryString> <field name="SUPPLIER_ID" class="java.lang.String"/> <field name="SITE_ID" class="java.lang.String"/> <field name="NUM_DELIVERIES" class="java.math.BigDecimal"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="60" isSplitAllowed="true" > <staticText> <reportElement style="Arial Unicode" x="0" y="0" width="610" height="40" key="ReportTitle"/> <box> <pen lineWidth="1.0" lineStyle="Solid"/> <topPen lineWidth="1.0" lineStyle="Solid"/> <leftPen lineWidth="1.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="1.0" lineStyle="Solid"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="18" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[booked Deliveries With No UPI Advice]]></text> </staticText> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Page" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="0" y="40" width="610" height="20" key="FromdateToTodate"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="10" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{fromdate} + " To " + $P{todate}]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="28" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="422" y="0" width="188" height="28" forecolor="#000000" backcolor="#FFFFFF" key="textNumberOfDeliveries"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="9" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Number of Deliveries"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="0" y="0" width="214" height="28" forecolor="#000000" backcolor="#FFFFFF" key="textSiteId"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="9" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Site Id"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="214" y="0" width="208" height="28" forecolor="#000000" backcolor="#FFFFFF" key="textVendor"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="9" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Vendor"]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="27" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="0" y="0" width="214" height="27" forecolor="#000000" backcolor="#FFFFFF" key="textSiteId"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="9" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="214" y="0" width="208" height="27" forecolor="#000000" backcolor="#FFFFFF" key="textVendor"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="9" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{SUPPLIER_ID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="422" y="0" width="188" height="27" forecolor="#000000" backcolor="#FFFFFF" key="textNumberOfDeliveries"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" pdfFontName="Arialuni.ttf" size="9" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DELIVERIES}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="42" isSplitAllowed="true" > </band> </summary></jasperReport>

Hi Matt, We are using a RedPrairie database to interact with for these reports. And iReport 3.6.2 is the compatible one. Are there any serious reasons to worry about with 3.6.2? Please advise. Thanks!

Hi, I am trying to install a new version of iReport 3.6.2. On clicking on the link Tools --> Import Settings it asks for an existing version. When I give the already installed version 3.0.0 it does not pick up the path. What is the correct path to be given here so that the settings are directly imported? Please reply ASAP. Thanks!

Dear Forum, I want the column headers to be displayed only on the first page of the report. So I write in the xml file for the band <columnHeader> <printWhenExpression><![CDATA[($V{PAGE_NUMBER}.equals(new Integer(1))? Boolean.TRUE:Boolean.FALSE)]]></printWhenExpression> However, this is the backend xml code. From the user interface how can I achieve the same for the <columnHeader> Code:<columnHeader> <band height="40" isSplitAllowed="true" > <printWhenExpression><![CDATA[($V{PAGE_NUMBER}.equals(new Integer(1))? Boolean.TRUE:Boolean.FALSE)]]></printWhenExpression> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" mode="Opaque" x="0" y="0" width="245" height="40" forecolor="#000000" backcolor="#FFFFFF" key="textVendorId"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Vendor Name"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="245" y="0" width="100" height="40" forecolor="#000000" key="textAsn"/> <box> <pen lineWidth="1.25"/> <topPen lineWidth="1.25" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.25" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.25" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.25" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["PO/ASN No"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="345" y="0" width="70" height="40" forecolor="#000000" key="textDueDate"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Due Date"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="415" y="0" width="60" height="40" forecolor="#000000" key="textLinesDue"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Lines Due"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="565" y="0" width="60" height="40" forecolor="#000000" key="textPalletType"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Pallet Type"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="625" y="0" width="75" height="40" forecolor="#000000" key="textEstimatedPallets"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Estimated Pallets"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="475" y="0" width="45" height="40" forecolor="#000000" key="textNumPalts"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Nbr of Pallets"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement style="Arial" x="520" y="0" width="45" height="40" forecolor="#000000" key="textNumTotes"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial Unicode MS" pdfFontName="Arialuni.ttf" size="10" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Nbr of Totes"]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="20" isSplitAllowed="true" > <textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="0" y="0" width="245" height="20" key="textVendorId"/> <box> <leftPen lineWidth="1.0" lineStyle="Solid"/></box> <textElement> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{SUPPLIER_NAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="245" y="0" width="100" height="20" key="textAsn"/> <box></box> <textElement textAlignment="Left"> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{ASN_ID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="345" y="0" width="70" height="20" key="textDueDate"/> <box></box> <textElement textAlignment="Left"> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DUE_DSTAMP}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="415" y="0" width="60" height="20" key="textLinesDue"/> <box></box> <textElement textAlignment="Right"> <font size="10"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{LINES_DUE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="475" y="0" width="45" height="20" key="textNumPalts"/> <box></box> <textElement textAlignment="Right"> <font size="10"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PALLET_COUNT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="520" y="0" width="45" height="20" key="textNumTotes"/> <box></box> <textElement textAlignment="Right"> <font size="10"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TOTE_COUNT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="565" y="0" width="60" height="20" key="textPalletType"/> <box></box> <textElement textAlignment="Center"> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{PALLET_TYPE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="625" y="0" width="75" height="20" key="textEstimatedPallets" isPrintInFirstWholeBand="true"/> <box> <rightPen lineWidth="1.0"/></box> <textElement textAlignment="Right"> <font size="10"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ESTIMATED_PALLETS}]]></textFieldExpression> </textField> </band>