"Page null of 2" printed for page number ?

2002 JI Open Discussion posted a topic in Products

By: wilson Justin - wilsonjust "Page null of 2" printed for page number ? 2003-11-26 22:45 Hi, While generating group Report. "Page null of 2" gets printed in the first page but in the subsequent pages I get proper page numbers like "Page 2 of 2". I am using JasperReports 0.5. can any one help me to fix this problem. With Best Regards Wilson Justin By: Teodor Danciu - teodord RE: "Page null of 2" printed for page number 2003-11-28 11:45 Hi, Are you using subreports? Can you provide me with a simplified version of your files presenting the problem? teodord@hotmail.com Thank you, Teodor By: wilson Justin - wilsonjust RE: "Page null of 2" printed for page number ? 2003-12-04 05:10 Hello, Thanks for responding I am using subreports and that too multiple subreports. I have mailed my main report xml file for your view. just tell me why I get this null problem. according to me I get the null value when the group starts a new page I have mailed my XML file to your email ID With best Regards Wilson Justin By: Teodor Danciu - teodord RE: "Page null of 2" printed for page number 2003-12-13 10:54 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor By: pandu - pandu16 "Page null of 2" printed for page number ? 2004-01-22 16:07 Page null of 2" gets printed in the first page but in the subsequent pages I get proper page numbers like "Page 2 of 2". I am using JasperReports 0.5. can any one help me to fix this problem. Can any one please post the answer please. By: Teodor Danciu - teodord RE: "Page null of 2" printed for page number 2004-01-22 23:31 Hi, This was fixed in 0.5.1. Thank you, Teodor
- August 19, 2006
- - JasperReports Library
Newbie: No Subreport

2002 JI Open Discussion posted a topic in Products

By: L. Yeung - len-yeung Newbie: No Subreport 2003-11-04 01:23 Hi Im writing a simple subreport. After compiling, filling and viewing only my master report comes out but my subreport doesnt. Thank you for your help. my master report: <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="BillingStatement" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="538" columnSpacing="0" leftMargin="28" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <parameter name="BillingStatementDetailsSubreport" isForPrompting="true" class="dori.jasper.engine.JasperReport"/> <queryString><![CDATA[select * from billings]]></queryString> <field name="LastName" class="java.lang.String"> <fieldDescription><![CDATA[Patient Last Name]]></fieldDescription> </field> <field name="FirstName" class="java.lang.String"> <fieldDescription><![CDATA[Patient First Name]]></fieldDescription> </field> <field name="MiddleName" class="java.lang.String"> <fieldDescription><![CDATA[Patient Middle Name]]></fieldDescription> </field> <field name="Billing_DateTime" class="java.util.Date"> <fieldDescription><![CDATA[billing Date Time]]></fieldDescription> </field> <field name="CaseNo" class="java.lang.String"> <fieldDescription><![CDATA[Case Number]]></fieldDescription> </field> <field name="BillingId" class="java.lang.Long"> <fieldDescription><![CDATA[billing Id]]></fieldDescription> </field> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="69" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="117" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="0" width="556" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[bILLING STATEMENT]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="27" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Patient's Name:]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="203" y="19" width="148" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Opaque" x="99" y="27" width="308" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{LastName} + ", " + $F{FirstName} + " " + $F{MiddleName}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="100" y="46" width="309" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="414" y="27" width="34" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Date:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="MM/dd/yyyy hh:mm" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="447" y="27" width="109" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{Billing_DateTime}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="447" y="46" width="109" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="0" y="47" width="65" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Room No:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="66" y="47" width="198" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="66" y="66" width="198" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="1" y="87" width="90" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Date Admitted:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="284" y="47" width="63" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[sex:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="349" y="47" width="207" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="351" y="67" width="204" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="92" y="87" width="173" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="284" y="87" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Date Discharged:]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="91" y="107" width="173" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="383" y="87" width="173" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="383" y="107" width="172" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="0" y="67" width="64" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Case No:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="66" y="67" width="199" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{CaseNo}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="66" y="86" width="198" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="284" y="67" width="64" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Reference:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="349" y="68" width="207" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression> </textField> <line direction="BottomUp"> <reportElement mode="Opaque" x="348" y="86" width="207" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </pageHeader> <columnHeader> <band height="40" isSplitAllowed="true" > <staticText> <reportElement mode="Transparent" x="0" y="0" width="277" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="277" y="0" width="92" height="40" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Hospital Bill]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="370" y="0" width="92" height="40" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[PhilHealth Account]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="463" y="0" width="92" height="40" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Patient's Account]]></text> </staticText> </band> </columnHeader> <detail> <band height="33" isSplitAllowed="true" > <subreport isUsingCache="true"> <reportElement mode="Opaque" x="0" y="0" width="556" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="false" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <subreportParameter name="BillingId"> <subreportParameterExpression><![CDATA[$F{BillingId}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="dori.jasper.engine.JasperReport"><![CDATA[$P{BillingStatementDetailsSubreport}]]></subreportExpression> </subreport> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="34" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="25" isSplitAllowed="true" > </band> </summary> </jasperReport> my subreport: <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="BillingStatementDetailsSubreport" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="538" columnSpacing="0" leftMargin="28" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <field name="SourceName" class="java.lang.String"> <fieldDescription><![CDATA[source Name]]></fieldDescription> </field> <field name="Price" class="java.lang.Double"> <fieldDescription><![CDATA[Product Price]]></fieldDescription> </field> <field name="Descn" class="java.lang.String"> <fieldDescription><![CDATA[Product Description]]></fieldDescription> </field> <field name="Qty" class="java.lang.Double"> <fieldDescription><![CDATA[Product Quantity]]></fieldDescription> </field> <field name="Discount" class="java.lang.Double"> <fieldDescription><![CDATA[Product Discount]]></fieldDescription> </field> <field name="Extended" class="java.lang.Double"> <fieldDescription><![CDATA[Extended Price]]></fieldDescription> </field> <field name="PhilHealthAmt" class="java.lang.Double"> <fieldDescription><![CDATA[PhilHealth Amount]]></fieldDescription> </field> <field name="PatientAccount" class="java.lang.Double"> <fieldDescription><![CDATA[Patient's Account]]></fieldDescription> </field> <group name="SourceGroup" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="true" minHeightToStartNewPage="200" > <groupExpression><![CDATA[null]]></groupExpression> <groupHeader> <band height="50" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="556" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Department: " + $F{SourceName}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="21" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="111" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{Descn}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="111" y="0" width="55" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{Qty}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="166" y="0" width="55" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{Price}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="221" y="0" width="55" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{Discount}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="277" y="0" width="92" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{Extended}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="19" width="110" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="113" y="19" width="52" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="370" y="0" width="92" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{PhilHealthAmt}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="463" y="0" width="92" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{PatientAccount}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="168" y="19" width="52" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="223" y="19" width="52" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="277" y="19" width="91" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="370" y="19" width="91" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="464" y="19" width="90" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="1" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport> By: L. Yeung - len-yeung RE: Newbie: No Subreport 2003-11-06 02:27 Which source file should I put? By: Teodor Danciu - teodord RE: Newbie: No Subreport 2003-11-12 22:00 Hi, You are supplying a connection to your subreport, but it does not have a query of its own. So it does not have any records to iterate on and by default the engine does not generate anything for your subreport. Use whenNoDataType="AllSectionsNoDetail" in your subreport template. I hope this helps. Teodor By: Gene Garcia - genegc RE: Newbie: No Subreport 2003-11-04 13:49 I haven't looked through your report, but I had a similar problem. It turned out that the sql statement I was using wasn't returning any records - so I never got into the 'detail' portion of my report so the subreport was never added. Remember that you can always debug by putting printout stmts in the jasperreports code and rebuilding it. By: tim smal - tcs777 subreport help 2004-01-13 08:46 i got an error "cannot load subreport from location". this is the master: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="NewReport" columnCount="1" pageWidth="612" pageHeight="792" whenNoDataType="BlankPage" columnWidth="540" columnSpacing="0" leftMargin="36" rightMargin="36" topMargin="36" bottomMargin="36"> <queryString><![CDATA[select "hello" as hello]]></queryString> <field name="hello" class="java.lang.String" /> <title> <band height="0" /> </title> <pageHeader> <band height="36" /> </pageHeader> <columnHeader> <band height="0" /> </columnHeader> <detail> <band height="481"> <subreport> <reportElement positionType="Float" mode="Transparent" x="2" y="3" width="536" height="434" isRemoveLineWhenBlank="true" /> <connectionExpression>$P{REPORT_CONNECTION}</connectionExpression> <subreportExpression>"sub.jasper"</subreportExpression> </subreport> </band> </detail> <columnFooter> <band height="0" /> </columnFooter> <pageFooter> <band height="36" /> </pageFooter> <summary> <band height="0" /> </summary> </jasperReport> By: Tobias Gaekle - ike987 RE: subreport help 2004-01-13 09:10 try to provide the full path to your sub.jasper, e.g. "c:\Templates\sub.jasper" By: Teodor Danciu - teodord RE: subreport help 2004-01-13 12:13 Hi, You could also add "sub.jasper" to the classpath. I hope this helps. Teodor
- August 19, 2006
- - JasperReports Library
New user pls help dynamically create xml

2002 JI Open Discussion posted a topic in Products

By: Wendy Hsi - whsi New user pls help dynamically create xml 2003-12-23 14:58 Hi, I was wondering if you can create a default xml templete and dynamically change it depends on the data. My data would be from a database. And i want to be able to change the columns dynamically. I have been looking at the samples, but they all seem to specify the column names in the xml template. Pls help. Thanks so much!!! Wendy By: Teodor Danciu - teodord RE: New user pls help dynamically create xml 2004-01-09 14:19 Hi, I think you overlooked the "noxmldesign" sample. Thank you, Teodor
- August 19, 2006
- - JasperReports Library
Problem with subreports+page breaks+threads

2002 JI Open Discussion posted a topic in Products

By: Carlos Costa e Silva - carloscs Problem with subreports+page breaks+threads 2003-12-11 06:27 Report with two subreports generating a pdf file. Mater report: <queryString .../> <pageHeader .../> <group isStartNewPage="true" isReprintHeaderOnEachPage="true"> ... group by an expression, has group header and group footer </group> <detail> ....<band height="..." isSplitAllowed="false"> ........<textfields .../> ........<subreport isUsingCache="true" .../> ........<subreport isUsingCache="true" .../> ....</band> </detail> <pageFooter .../> SubReport (there is only one, the subreport parameters filter the query): <queryString .../> <group by some expression/> <detail .../> <summary with printWhen always false to prevent page breaks/> With the test dataset, the report produces 81 pages. In almost all the pages the subreports overflowed, the isSplitAllowed correctly entered in action leaving an empty space at the bottom of the page and moving the detail to the new page. Problems: 1. First noticed that on two occasions that an overflow occured, the detail printed in the next page was missing some lines - always in the left subreport. 2. Run the report some times with the same data: a very few times the report has all the data, sometimes data is missing on only one overflow, sometimes data is missing in two overflows. 3. Run the report 20 times keeping a backup of the generted pdf files: no two files have the same size: size varies from a few hundred bytes to several kbytes. 4. Stopped to think: the program is the same, the data is the same how can the results be different? 5. Debug jasper reports: notice that: -> 1. Each subreport runs in it's own thread. -> 2. When an overflow occurs and a page break is needed, the subreport thread notifies the parent report and wait's for a notification to continue. Seems like there's a problem in the wait/notify code: more than one thread woken? wrong notify order? ...? Workaround: Removed the query strings from both the report and the subreports. Passed linked JRRewindableDataSource's as the data sources for the master and subreports. Don't know why but using rewindable datasources made the problem disappear (the default datasource used by Jasper for queryString's is not rewindable). By: Teodor Danciu - teodord RE: Problem with subreports+page breaks+threa 2004-01-09 13:57 Hi, There are two different issues here: a) Subreports placed on non-splitting bands should receive rewindable data sources. I'm considering the possibility of raising a runtime exception instead of the existing console warning when such scenario is encoutered. b) There is a know problem with the non-splitting band and the subreports related to the thread management. I'll try to fix it as soon as possible. Thank you, Teodor By: Teodor Danciu - teodord RE: Problem with subreports+page breaks+threa 2004-01-10 11:59 Hi, I think that the fix found in the CVS repository solves the problem with the subreports on the non-splitting bands. I'm waiting for feeback on this. Thank you, Teodor
- August 19, 2006
- - JasperReports Library
A weird XLS bug (7E0345 --> 1.7977E+308)

2002 JI Open Discussion posted a topic in Products

By: Tuan Le - lesoft A weird XLS bug (7E0345 --> 1.7977E+308) 2003-12-15 10:51 In our Excel report we have one String field that displays our company job code, and the Excel report returns all the job code correctly with the exception of any job code starting with 1Exxxx. For example, in database, job code is 7E0345 in Excel output, job code is 1.7977E+308 It seems that whenever we have a job cod starting with 1E, JasperReport/Excel converts it into an expontial value. How do we prevent that to happens? The job code is a field of type String. Thanks, Tuan By: Tuan Le - lesoft RE: A weird XLS bug (7E0345 --> 1.7977E+308) 2003-12-19 12:56 Can some one please confirm whether this is a bug in the JasperReport, POI, or some thing that I missed. I'm sure that some one has generated a report with a text value of 1Exxxxxxx in a String type cell before. Thanks, Tuan By: Carlos Costa e Silva - carloscs RE: A weird XLS bug (7E0345 --> 1.7977E+308) 2003-12-19 16:11 Probably excel is handling 7E0345 as a number: same as 7.0E+345 (and probably overflowing also, that's why the +308). Try either formmating the field as text or setting the value with a starting quote: cell.setString("'" + job_code); By: Tuan Le - lesoft RE: A weird XLS bug (7E0345 --> 1.7977E+308) 2003-12-19 16:32 Carlos - Thanks for your reply. We have tried to format the Excel column as text but that didn't help. By adding a starting quote in the Job Code column is not a good option for our report since the user may take this Excel report and import into another database. Thanks, Tuan By: Teodor Danciu - teodord RE: A weird XLS bug (7E0345 --> 1.7977E+308) 2004-01-10 11:52 Hi, The XLS exporter found in the CVS repository has now a parameter IS_AUTO_DETECT_CELL_TYPE which allows you to avoid such behavior. Set this exporter parameter to Boolean.FALSE and all the cells will be of type text. Thank you, Teodor
- August 19, 2006
- - JasperReports Library
Passing Values From Subreport to Master

2002 JI Open Discussion posted a topic in Products

By: Brandon Goodin - phasews Passing Values From Subreport to Master 2003-12-16 11:27 Greetings, I have a few subreports that each have a summary of records and associated totals. Is is possible to pass the total values associated with each subreport back up to the master report to be used in a calculation in the master report. By: Teodor Danciu - teodord RE: Passing Values From Subreport to Master 2004-01-10 10:15 Hi, This is explained here: https://sourceforge.net/forum/message.php?msg_id=1746736 I hope this helps. Teodor
- August 19, 2006
- - JasperReports Library
Dead lock in subreports

2002 JI Open Discussion posted a topic in Products

By: Yuriy Morgunov - yuriy_morgunov Dead lock in subreports 2003-10-02 02:01 Hi, The same master and subreports as in the last topic "Infinite loop creating new page in subreports" from 2003-10-02 08:44 cause dead lock situation in case other input data provided. The thread dump looks like this: "main" prio=5 tid=0x00234930 nid=0x340 in Object.wait() [6f000..6fc40] at java.lang.Object.wait(Native Method) - waiting on <02C2E9F8> (a dori.jasper.engine.fill.JRHorizontalFiller) at java.lang.Object.wait(Object.java:426) at dori.jasper.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:496) - locked <02C2E9F8> (a dori.jasper.engine.fill.JRHorizontalFiller) at dori.jasper.engine.fill.JRFillBand.prepareElements(JRFillBand.java:562) at dori.jasper.engine.fill.JRFillBand.fill(JRFillBand.java:479) at dori.jasper.engine.fill.JRFillBand.fill(JRFillBand.java:450) at dori.jasper.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1148) at dori.jasper.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:649) at dori.jasper.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:295) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:186) - locked <03C7B658> (a dori.jasper.engine.fill.JRVerticalFiller) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:524) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:159) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:350) Has anyone any idea to fix this problem?? Yuriy. By: Teodor Danciu - teodord RE: Dead lock in subreports 2004-01-09 14:01 Hi, Have you placed the subreport inside a band with isSplitAllowed="false"? Thank you, Teodor
Variables and Report Info

2002 JI Open Discussion posted a topic in Products

By: Kurt Hansen - poidog Variables and Report Info 2003-12-30 09:13 Relatively new to JasperReports, so please forgive my ignorance. Questions: 1 - Is it possible to explicitly set a variable, while a report is running? For example, while running a report showing user information, could I set a flag that tells me if a particular person was found? (something like: if ($F{userName}.equals("Bill")) isFound = new Boolean(Boolean.TRUE) ). 2 - Is there some way to know if all the data from the data source has been processed? For example, from a group footer, can JasperReports tell if this is the last group footer? Any help is very much appreciated. Thanks. By: Mike Warne - mwarne RE: Variables and Report Info 2004-01-09 13:27 you might be able to create a Boolean variable with the expression like new Boolean(($F{userName}).equals("Bill")) Then later you might be able test the variable like this ($V{isBill}).booleanValue() I probably don't have the syntax right.. go ahead experiment..
- August 19, 2006
- - JasperReports Library
Does text overflow hava a limit?

2002 JI Open Discussion posted a topic in Products

By: Mauricio Hernandez - micho2001 Does text overflow hava a limit? 2003-12-24 08:01 Hi! I'm currently using Jasper to generate an 11 page contract from a custom JRDatasource (one row). It worked like a charm. I made the report with multiple textfields with overlflow and float positioning. I have a problem though, the first three pages of the report look great, but from the 6 page it begins to be broken up in the middle, leaving the half the page empty... Any ideas, suggestions out there? Thanks in advance! By: Mauricio Hernandez - micho2001 Report xml 2003-12-24 08:36 <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Subcontract" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <field name="signature_date" class="java.lang.String"/> <field name="company_name" class="java.lang.String"/> <field name="project_description" class="java.lang.String"/> <field name="contact_address" class="java.lang.String"/> <field name="contact_phone" class="java.lang.String"/> <field name="nit" class="java.lang.String"/> <field name="total_english" class="java.lang.String"/> <field name="total" class="java.lang.String"/> <field name="form_of_payment_english" class="java.lang.String"/> <field name="scope_english" class="java.lang.String"/> <field name="start_date" class="java.lang.String"/> <field name="end_date" class="java.lang.String"/> <field name="contract_first_name" class="java.lang.String"/> <field name="contact_last_name" class="java.lang.String"/> <field name="cc" class="java.lang.String"/> <field name="proposal_date" class="java.lang.String"/> <field name="total_spanish" class="java.lang.String"/> <field name="form_of_payment_spanish" class="java.lang.String"/> <field name="scope_spanish" class="java.lang.String"/> <field name="customer_name" class="java.lang.String"> <fieldDescription><![CDATA[Name of the Project customer]]></fieldDescription> </field> <field name="Field" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="46" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="15" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="8" isSplitAllowed="false" > </band> </columnHeader> <detail> <band height="626" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="2" y="1" width="257" height="24" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["This agreement is made as of "+$F{signature_date} +", by and between Contracting Consulting Engineering LLC (CCE) (Contractor) and "+$F{company_name} +"(Subcontractor) to perform the Work identified in Article 2 in accordance with the Project's Contract Documents. n"+ "PROJECT: "+$F{project_description} +"n"+ "OWNER: "+ $F{customer_name} + "nCONTRACTOR: Contracting, Consulting, Engineering, LLC (CCE), P.O. Box 81, St. Michaels Maryland 21663, USA.n" + "SUBCONTRACTOR: "+$F{company_name} +" "+$F{contact_address} +" Tel. "+$F{contact_phone} +" Nit. "+$F{nit} +"n"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="2" y="26" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 1n"+ "CONTRACT PAYMENT."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="3" y="45" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["The Contractor agrees to pay Subcontractor for satisfactory performance of Subcontractor's Work an amount, not to exceed "+$F{total_english} +" PESOS ("+$F{total} +"). The form of payment is described as follows: "+$F{form_of_payment_english} +". These payments are subject to receipt of such lien waivers, affidavits, warranties, and guarantees required by the Contract Documents or Contractor."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="2" y="64" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 2 n"+ "SCOPE OF WORK."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="2" y="85" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Subcontractor agrees to commence Subcontractor's Work herein described upon notification by Contractor to do so, and to perform and complete such Work in accordance with the Contract Documents and under the general direction of Contractor in accord with Contractor's schedule and the approved Subcontract Schedule. This shall include all work necessary or incidental to "+$F{scope_english}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="4" y="108" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 3 n"+ "SCHEDULE OF WORK."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="127" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Time is of the essence. The subcontractor will perform work 24 hours per day, 7 days per week, if required by the Contractor in order to meet the project schedule. Such work will be at no extra cost to the Contractor. The work will be completed according with the following dates: "+$F{start_date} +" Thru "+$F{end_date} +" completion work. The Contractor will provide the Subcontractor access to the work site on "+$F{start_date} +" Subcontractor shall provide Contractor with any requested scheduling information of Subcontractor's Work, including a detailed bar chart schedule which, upon approval by the Contractor, shall be the Subcontract Schedule. The Subcontract Schedule shall be approved by the Contractor and may only be revised with the approval of the Contractor.Subcontractor recognizes that changes may be made by the Contractor in the Contractor?s Schedule of Work and agrees to make revisions to the Subcontract Schedule so as to comply with such Schedule of Work changes without additional compensation. Subcontractor shall coordinate its work with all other contractors, subcontractors, and suppliers on the Project so as not to delay or damage their performance, work, or the Project."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="4" y="146" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 4n"+ "CHANGES."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="4" y="167" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Contractor, without nullifying this Agreement, may direct Subcontractor in writing to make changes to Subcontractor's Work. No changes to the Work or Contract Documents shall be effective unless directed by the Contractor?s authorized Site Representative. Adjustment, if any, in the contract price or contract time resulting from such changes shall be set forth in a Subcontract Changes Order pursuant to the Contract Documents. Any modification or change to the Contract Documents shall be effective only if made in a written document signed by authorized representatives of both Parties."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="3" y="191" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 5 n"+ "FAILURE OF PERFORMANCE."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="4" y="210" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Should Subcontractor fail to satisfy contractual deficiencies within three (3) working days from receipt of Contractor's written notice, then the Contractor, without prejudice to any right or remedies, shall have the right to take whatever steps it deems necessary to correct said deficiencies, including but not limited to termination of all or part of the Subcontract Work and assignment of such terminated Work to another subcontractor, and charge the cost thereof to Subcontractor, who shall be liable for payment of same, including reasonable overhead, profit and attorneys fees. Any such costs may be deducted by the Contractor from any payments due to the Subcontractor for work performed pursuant to this Subcontract."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="3" y="229" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 6 n"+ "INSURANCE."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="3" y="250" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Prior to the start of Subcontractor's Work, Subcontractor shall procure and maintain in force for the duration of the Work, Worker's Compensation Insurance, Mandatory Health Insurance (EPS), Mandatory Insurance for Professional Risks (ARP), Employer's Liability Insurance, Comprehensive General Liability Insurance and all insurance required of Contractor under the Contract Documents and Colombian laws and regulations. Contractor shall be named as additional insured on each of these policies, except for Worker's Compensation."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="273" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 7 n"+ "INDEMNIFICATION."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="6" y="292" width="257" height="16" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" To the fullest extent permitted by law, Subcontractor shall indemnify and hold harmless Owner and Contractor from all damages, losses, or expenses, including attorneys fees, from any claims or damages for bodily injury, sickness, disease, or death, or from claims for damage to tangible property, other then the Work itself. This indemnification shall extend to claims resulting from performance of this Subcontract and shall apply only to the extent that the claim or loss is caused in whole or in part by any negligent act or omission of Subcontractor or any of its agents, employees, or subcontractors."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="311" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 8 n"+ "WARRANTY."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="332" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Subcontractor warrants its work against all deficiencies and defects in materials and/or workmanship and agrees to satisfy same without cost to Owner or Contractor for a period of three (3) years from the date of Final Acceptance of the Project or per Contract Documents, whichever is longer."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="353" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 9 n"+ "SPECIAL PROVISIONS."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="6" y="372" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" 9.1 Supplementary Scope of Work "+$F{scope_english}.toString()+". See annex A 9.2 Contract Documents The Contract Documents include: a. This Subcontract Agreement. b. Contract Specifications, including, by reference, all codes, standards and specifications listed therein. c. Final proposal submitted by "+$F{company_name}.toString()+" "+$F{proposal_date}.toString()+". (Attachment No. 1) d. Contract Schedules "+ " 9.3 Contract Schedule All Work under this Subcontract is to be completed by the "+$F{end_date}.toString()+ ". 9.4 Bonding Before starting the Work, the Subcontractor shall provide a Performance Bond in a form acceptable to the Contractor in the amount of 40% of the Contract Price. The Performance Bond will be effective during the duration of the contract and three additional months. The Subcontractor shall remain responsible for corrective work required under any remaining term of the Subcontractor?s warranty as set forth in Article 8."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="471" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 10 n"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="5" y="492" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["The Subcontractor certifies that no employee of the Contractor has received a commission or any other payment as a result of the awarding of this subcontract."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="7" y="515" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Article 11 n"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="8" y="534" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["The Contractor reserves the right to terminate the services of any of the Subcontractors employees, at any time, without written justification or notice and without penalty to the Contractor or Subcontractor."+ "In witness whereof, the Parties have executed this Agreement under Seal, as of the date first written above."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="7" y="553" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Subcontractor: Dr. "+$F{contract_first_name} +" "+$F{contact_last_name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="7" y="574" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" Representante Legal C.C "+$F{cc} +" "+$F{company_name} +". "+$F{contact_address} +" Tel. "+$F{contact_phone} +" Nit. "+$F{nit} +" MALCOM NOEL LEVINE DIRECTOR OF OPERATIONS CCE Contracting, Consulting, Engineering LLC Carrera 11 # 87-51 Oficina 301, Tel: 6407997, fax: 6407998"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="4" y="597" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" (Contractor) Attachments No. 1 Final Proposal presented by "+$F{company_name} +", dated "+$F{proposal_date}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="272" y="1" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["El presente contrato se realiza el dí¡"+$F{signature_date}+", por y entre Contracting, Consulting, Engineering LLC (CCE) (Contratista) y "+$F{company_name}+"(Subcontratista) para realizar el trabajo identificado en el artí£µlo 2 en concordancia con los Documentos del Proyecto del Contrato.n"+ "PROYECTO: "+$F{project_description}+ "nPROPIETARIO: " + $F{customer_name} + "nCONTRATISTA: Contracting, Consulting, Engineering, LLC (CCE) P.O. Box 81,St MIchaels Maryland 21663, USA."+ "nSUBCONTRATISTA: "+$F{company_name}+" "+$F{contact_address}+" Tel. "+$F{contact_phone}+" Nit. "+$F{nit} + "n"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="271" y="21" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Articulo 1 n"+ "FORMA DE PAGO DEL CONTRATO."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="271" y="41" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" El contratista acuerda en pagar al subcontratista por un desempeñ¯³atisfactorio de su trabajo la suma que no exceda de "+$F{total_spanish}+" PESOS M/CTE ("+$F{total}+"). El contrato se pagara de la siguiente forma: "+$F{form_of_payment_spanish}+" Dichos pagos está®sujetos a la recepció®¤e cada excepció®¬declaració®ªuramentada, garantí¡y demá³garantí¡³ exigidas por los documentos contractuales del contratista."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="273" y="65" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Articulo 2 n"+ "ALCANCE DE LA OBRA."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="273" y="86" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" El subcontratista acuerda empezar su trabajo aquí¤escrito y a desarrollarlo y completar tal trabajo en concordancia con los Documentos del Contrato y bajo la direcció®§eneral del Contratista en concordancia con su horario y con la aprobació®¤el horario presentado por el Subcontratista. Este deberá©ncluir todo el trabajo necesario o incidental para completar lo siguiente: "+$F{scope_spanish}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="272" y="110" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Articulo 3 n"+ "CRONOGRAMA DE TRABAJO."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="273" y="129" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" El tiempo es esencial El Subcontratista desarrollara su trabajo durante las 24 horas del dí¡¬ 7 dí¡³ a la semana, si es requerido por el Contratista con miras a cumplir el cronograma de trabajo, dicho trabajo no generara horas extras al Contratista. El cronograma se cumplirá´eniendo en cuenta las siguientes fechas de entrega: "+$F{start_date}+" al "+$F{end_date}+" fecha de entrega. El contratista deberá°roveer al Subcontratista de los permisos necesarios para ingresar al sitio de trabajo el "+$F{start_date}+" El Subcontratista deberá¥ntregar al Contratista cualquier informació®³olicitada sobre el horario de trabajo del mismo, el cual debe contar con la aprobació®¤el Contratista, este deberá³er el Cronograma del Subcontratista. El cronograma del Subcontratista deberá³er aprobado por el Contratista y solamente podrá³er modificado con la aprobació®¤el mismo. El Subcontratista reconoce que los cambios puedan ser realizados por el Contratista en el Cronograma de Trabajo y acuerda hacer revisiones al mismo, cumpliendo con los cambios realizados sin recibir una compensació®¡dicional. El Subcontratista deberá£oordinar su trabajo con todos los demá³contratistas, subcontratistas y proveedores del proyecto, de tal forma que no se retrase ni dañ¥³u desempeñ¯¬trabajo o el Proyecto."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="272" y="148" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Articulo 4 n"+ "CAMBIOS."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="272" y="169" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" El Contratista, sin anular este acuerdo, puede en escrito dirigido al Subcontratista realizar cambios en el Cronograma de Trabajo. Ning?mbio en el trabajo o en los Documentos del Contrato deberá®ser autorizados si no cuentan con autorizació®¤el Contratista o de su representante. Ajustes, si hay alguno en el precio del contrato, o en el cronograma del contrato, tales cambios deberá®ser enunciados en la Orden de Cambios del Subcontrato de conformidad con los documentos del Contrato. Cualquier modificació®¯ cambio en los Documentos del Contrato será®efectivas solamente si está®consignados en un documento escrito firmado y autorizado por los representes de ambas partes. "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="274" y="192" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Articulo 5 n"+ "FALLAS EN EL DESEMPEÑ."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="275" y="211" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" El Subcontratista deberá³olucionar las deficiencias del contrato, dentro de los tres dí¡³ há¢©les siguientes a la recepció®¤el aviso escrito del Contratista, despué³de estos, el contratista, sin necesidad de prevenir al Subcontratista, tendrá¥l derecho a tomar cualquier paso que considere necesario para corregir dichas deficiencias, incluyendo, pero no limitado por la terminació®¤e todo o de parte del trabajo del Subcontrato o la asignació®¤e la terminació®¤e dicho trabajo a otro Subcontratista , y cargar el costo de esto al Subcontratista, quien deberá³er responsable por el pago del Subcontrato, incluyendo gastos adicionales, ganancias y honorarios de abogados. Cualquiera de estos costos será®deducidos por el Contratista de cualquiera de los pagos debidos al Subcontratista por el trabajo ejecutado de conformidad con este Subcontrato."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="274" y="230" width="257" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["n Articulo 6 n"+ "SEGURO."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque&quot
- August 19, 2006
- - JasperReports Library
JasperViewer shows only the first page

2002 JI Open Discussion posted a topic in Products

By: marcopar - marcopar JasperViewer shows only the first page 2003-12-23 09:14 Hi, i'm doing some simple tests on JasperReports and i'm having a problem with the viewer. It only shows the first page of the report. The page count is correct but all pages except the first are completely blank. Pdx, html and xls are correctly generated. Below there's the simple code i've used. Thanks ciao JasperReport rep = JasperManager.loadReport("rep2.jasper"); JasperPrint jp = JasperFillManager.fillReport(rep, new HashMap(), AWVectorDataSource.getSampleDataSource()); JasperViewer.viewReport(jp, false); //pdf JasperExportManager.exportReportToPdfFile(jp, "ex.pdf"); //html JasperExportManager.exportReportToHtmlFile(jp, "ex.html"); //excel JRXlsExporter ex = new JRXlsExporter(); ex.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,"ex.xls"); ex.setParameter(JRExporterParameter.JASPER_PRINT,jp); ex.exportReport(); By: marcopar - marcopar RE: JasperViewer shows only the first page 2003-12-29 09:14 More information. Commenting the piece of code shown below solves the problem. I don't know why but it seems to corrupt the JasperPrint object. If i use a dedicated JasperPrint object for the xls exporter, i can get all the stuff to work correctly. I will be very happy yo know why this thing is happening. The version of JasperReports i'm using is 0.5.0 Here's the code that corrupts the JasperPrint (jp) object: //excel JRXlsExporter ex = new JRXlsExporter(); ex.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,"ex.xls"); ex.setParameter(JRExporterParameter.JASPER_PRINT,jp2); ex.exportReport(); By: Arun Kumar M - arunkumarm RE: JasperViewer shows only the first page 2004-01-02 03:21 Hi, The problem is with JRXlsExporter Class What is happening is that, the y position of elements inside the pages in the JasperPrint Object are shifted by PageHeight * PageNumber. This corrupts the JasperPrint Object for further use. In JRXlsExporter.exportReportToStream (line no: 353) page = (JRPrintPage)pages.get(i); elements = page.getElements(); if (elements != null && elements.size() > 0) { for(Iterator it = elements.iterator(); it.hasNext();) { element = (JRPrintElement)it.next(); //Here Element is modified, which corrupts //the JasperPrint Object element.setY(element.getY() + jasperPrint.getPageHeight() * i); allPages.addElement(element); } } Teodord, I am also stuck, please have a look. Thanks, Arun Kumar M By: Teodor Danciu - teodord RE: JasperViewer shows only the first page 2004-01-06 06:44 Hi, This is solved in the CVS repository version. Thank you, Teodor
- August 19, 2006
- - JasperReports Library
Class Scriptlet Not Found

2002 JI Open Discussion posted a topic in Products

By: Pattraporn - plain_text Class Scriptlet Not Found 2003-12-28 19:42 Hi... In Sample Scriptlet , When I compile the XML code , there's an error like this 'Class Scriptlet Not Found' . What should i do ? The Attribute scriptletClass="Scriptlet" and there is Scriptlet class file in the same folder with this sample report. Thanks in advance.. By: Teodor Danciu - teodord RE: Class Scriptlet Not Found 2003-12-29 01:06 Hi, The class representing your scriptlet should be present in the classpath. In this case, the directory containig the "Scriptlet" class file should be added to the classpath. If you use "Ant", just launch "ant compile" from the command prompt and the classpath ant the other settings are already set. I hope this helps. Teodor By: Pattraporn - plain_text RE: Class Scriptlet Not Found 2004-01-05 18:27 I added this path into classpath C:JasperReportsdemosamplesscriptlet but I still get same error. What should i do ? Did i do anything wrong? Thanks for your help.
- August 19, 2006
- - JasperReports Library
Median Calculation

2002 JI Open Discussion posted a topic in Products

By: Joe Siedlecki - joesiedlecki Median Calculation 2004-01-05 13:50 Are there any plans to add median to the list of calculated functions? If not, I suspect it can be calculated in a scriptlet. Does anyone know the most efficient way to claculate it? Thanks.
Subreports

2002 JI Open Discussion posted a topic in Products

By: Bruno Cardoso - morcegopt Subreports 2004-01-02 02:02 Hey, I have a MasterReport with one SubReport, both reports have different datasources. Until here, everything is ok, both PDF, HTML and XML versions are OK! Now, If I add another subreport into my master, in the PDF version only the values of the second (and last) subreport are showed. The HTML and XML version remais OK! Then, if I add a third subreport, in the PDF version only the values of the third (and last) report appear. In the HTML version only the values of the first and third subreport appear. Anyone had this problem before? Anyone know why this happens? By: Bruno Cardoso - morcegopt RE: Subreports 2004-01-02 02:40 I increased the height of the subreports boxs and now everything shows up OK! Isnt there any way to make this boxs auto-resize as much as needed for the subreport to fill in the master? Thanks By: Teodor Danciu - teodord RE: Subreports 2004-01-03 14:43 Hi, Are you talking about the <subreport> element height or about the <textField> elements inside the subreport? Thank you, Teodor By: Bruno Cardoso - morcegopt RE: Subreports 2004-01-05 01:17 Hey teodord, I'm talking about the <subreport> element tag. I'm using iReport to create my xml files, in the subreports I use a String argument to define the path to my subreports, do you think I should change to a JasperReport parameter? do you think it has anything to do with it? The truth is that if I increase the height of the <subreport> box all the data appear OK! Basically, it's not resizing as it should. Thanks By: Teodor Danciu - teodord RE: Subreports 2004-01-05 04:30 Hi, Where have you placed the subreport? Is it placed in the <pageFooter> or the <columnFooter> of the master report? Thank you, Teodor By: Bruno Cardoso - morcegopt RE: Subreports 2004-01-05 07:15 No, it's placed in the <detail>. Here is the source of the Master Report XML: <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="HRPersonalData" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <parameter name="MyDatasource1" isForPrompting="true" class="dori.jasper.engine.JRDataSource"/> <parameter name="MyDatasource2" isForPrompting="true" class="dori.jasper.engine.JRDataSource"/> <parameter name="MyDatasource3" isForPrompting="true" class="dori.jasper.engine.JRDataSource"/> <parameter name="SUBREPORT1" isForPrompting="true" class="dori.jasper.engine.JasperReport"/> <parameter name="SUBREPORT2" isForPrompting="true" class="dori.jasper.engine.JasperReport"/> <parameter name="SUBREPORT3" isForPrompting="true" class="dori.jasper.engine.JasperReport"/> <field name="HRId" class="java.lang.String"/> <field name="HRFirstName" class="java.lang.String"/> <field name="HRLastName" class="java.lang.String"/> <field name="HRMiddleNames" class="java.lang.String"/> <variable name="CMD01" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["pt.ibs.hctt.base.cmds.usr.hr.GetHRCmd"]]></initialValueExpression> </variable> <variable name="CMD02" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["pt.ibs.hctt.base.cmds.usr.hr.GetHRAddressCmd"]]></initialValueExpression> </variable> <variable name="CMD03" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["pt.ibs.hctt.base.cmds.usr.hr.GetHRDisciplinaryEventsColCmd"]]></initialValueExpression> </variable> <variable name="CMD04" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["pt.ibs.hctt.base.cmds.usr.hr.GetHRIdentificationCmd"]]></initialValueExpression> </variable> <variable name="SUBREPORTNAME1" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["HRAddress.jasper"]]></initialValueExpression> </variable> <variable name="SUBREPORTNAME2" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["HRDisciplinaryEvents.jasper"]]></initialValueExpression> </variable> <variable name="SUBREPORTNAME3" class="java.lang.String" resetType="Report" calculation="Nothing"> <initialValueExpression><![CDATA["HRIdentification.jasper"]]></initialValueExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="25" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="0" width="535" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[hr PERSONAL DATA]]></text> </staticText> </band> </title> <pageHeader> <band height="4" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="16" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="0" y="0" width="73" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[hrId]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="73" y="0" width="136" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[hrFirstName]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="209" y="0" width="134" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[hrLastName]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="343" y="0" width="155" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[hrMiddleNames]]></text> </staticText> </band> </columnHeader> <detail> <band height="89" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="0" y="0" width="73" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{HRId}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="208" y="0" width="135" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{HRLastName}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="343" y="0" width="155" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{HRMiddleNames}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="74" y="0" width="133" height="15" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{HRFirstName}]]></textFieldExpression> </textField> <subreport isUsingCache="true"> <reportElement mode="Opaque" x="5" y="26" width="525" height="17" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="false" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <dataSourceExpression><![CDATA[$P{MyDatasource1}]]></dataSourceExpression> <subreportExpression class="dori.jasper.engine.JasperReport"><![CDATA[$P{SUBREPORT1}]]></subreportExpression> </subreport> <subreport isUsingCache="true"> <reportElement mode="Opaque" x="5" y="46" width="525" height="16" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="false" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <dataSourceExpression><![CDATA[$P{MyDatasource2}]]></dataSourceExpression> <subreportExpression class="dori.jasper.engine.JasperReport"><![CDATA[$P{SUBREPORT2}]]></subreportExpression> </subreport> <subreport isUsingCache="true"> <reportElement mode="Opaque" x="5" y="66" width="525" height="16" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="false" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <dataSourceExpression><![CDATA[$P{MyDatasource3}]]></dataSourceExpression> <subreportExpression class="dori.jasper.engine.JasperReport"><![CDATA[$P{SUBREPORT3}]]></subreportExpression> </subreport> </band> </detail> <columnFooter> <band height="8" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="7" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="7" isSplitAllowed="true" > </band> </summary> </jasperReport>
- August 19, 2006
- - JasperReports Library
Printing array values in report

2002 JI Open Discussion posted a topic in Products

By: Ritesh - sharmaritesh Printing array values in report 2004-01-02 03:12 Hi ! I am a newbie to jasper report and am working of generation of pdf reports thru jasper APIs. To give an idea of how i am going about the whole thing...All my data, required for printing the report, is read from the database(multiple tables). I consolidate this data and store it into a single data bean and i pass this object to the report as a parameter. In place of the datasource i just pass a dummy object. The api being used is JasperRunManager.runReportToPdf(...) To print the value of any attribute in the report, i use the corresponding getter method. This whole thing works fine for most of the reports... Now, one report i have is such that it requires a list of names and numbers to be printed. This list is available as a string array (two dim) in the databean. Can anyone please help me with the simplest way to do this... I did go thru some of the solutions provided in earlier messages in this forum but most of them have talked about using a data source. I have a few points.. 1) Being new to this application I am not all that comfortable with using datasource for printing my report. 2) Since there is only one field in my databean which needs to be printed like this in a loop, for all values in it(all others are printed once)... thanx in advance... By: Vinod Kumar Singh - vinodsingh RE: Printing array values in report 2004-01-03 03:54 I never used databeans with jasper reports, but I think your report could be easily filled if you supply the sql query to the report and put your repetitive fields in detail section. By: Ritesh - sharmaritesh RE: Printing array values in report - Urgent 2004-01-04 22:15 Thanx Vinod for ur reply..i understand that the report can be easily filled if i have the query in the report itself but as i mentioned, the data i need for the report is varied and is present in multiple tables (around 10 of them)...So what i do is retrieve all of it and populate in an object. I then pass this object to the report....Also as i mentioned, there is ONLY one field that needs to be repeatedly printed (as in a for loop)...my other data is printed one time only.... Can anyone please throw some light on..it's kind of urgent and this is the only thing that is holding my progress..... will appreciate any help from the 'stalwarts' of jasper reports :-) F1..F1... By: Vinod Kumar Singh - vinodsingh RE: Printing array values in report 2004-01-05 02:37 Put the value you want to be printed repeatedly in detail section as will iterate for all values. The remaining values to be put in header section where it will be printed once (set printRepeatedValues to false). I hope this will work.
- August 19, 2006
- - JasperReports Library
Performance problems with really big reports

2002 JI Open Discussion posted a topic in Products

By: Diego Buzzalino - chuza Performance problems with really big reports 2003-09-03 09:49 im having problems with big reports because of the high use of heap of Jasper. I made many tests with the options -Xms:100m -Xmx:350m and all worked fine during mid-load tests. But for really big tests, all hang-up for hours. Using a profiler I could define that: - 5% of the time is the process of compiliation (.xml to .jasper) - 60% is the time of filling the report IN MEMORY (.jasper to .jrprint) - 35% is the export to PDF (.jrprint to .pdf) the question is.. is there an easy way of avoid filling the report in memory and try to do that in the .jrprint file? (It will take a little more time, but It wil never be running out of resources) Has anyone done something like this? Changed the Jasper code? let me now... thanks in advance By: Barra - booleong RE: Performance problems with really big reports 2004-01-05 02:36 I had the same problem. However I am not as patient as you, waiting for it to finish hours after. I thought it hung. The weird thing is, I didn't have this problem before. Modified some of my sub reports and suddenly exporting to a file takes ages. Also, if I export to a HTML file, it takes up few hundred Mbytes to more than 1GByte !! Really have no idea what's happening.
- August 19, 2006
- - JasperReports Library
Performance problems with really big reports

2002 JI Open Discussion posted a topic in Products

By: Diego Buzzalino - chuza Performance problems with really big reports 2003-09-03 09:49 im having problems with big reports because of the high use of heap of Jasper. I made many tests with the options -Xms:100m -Xmx:350m and all worked fine during mid-load tests. But for really big tests, all hang-up for hours. Using a profiler I could define that: - 5% of the time is the process of compiliation (.xml to .jasper) - 60% is the time of filling the report IN MEMORY (.jasper to .jrprint) - 35% is the export to PDF (.jrprint to .pdf) the question is.. is there an easy way of avoid filling the report in memory and try to do that in the .jrprint file? (It will take a little more time, but It wil never be running out of resources) Has anyone done something like this? Changed the Jasper code? let me now... thanks in advance By: Barra - booleong RE: Performance problems with really big reports 2004-01-05 02:36 I had the same problem. However I am not as patient as you, waiting for it to finish hours after. I thought it hung. The weird thing is, I didn't have this problem before. Modified some of my sub reports and suddenly exporting to a file takes ages. Also, if I export to a HTML file, it takes up few hundred Mbytes to more than 1GByte !! Really have no idea what's happening.
- August 19, 2006
- - JasperReports Library
Exception while export large report to HTML

2002 JI Open Discussion posted a topic in Products

By: Yuriy Stepanyuk - ystep Exception while export large report to HTML 2003-03-24 06:53 I have export servlet that works fine on reports 300 records long. But on 10000 records report it raises exception for HTML, XLS ,CSV XML. For PDF works fine. What might be a problem? Exception stack trace is: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125) at java.lang.Thread.run(Thread.java:536) By: Jeremie Weldin - jweldin RE: Exception while export large report to HTML 2003-09-02 10:47 Did you ever get an answer for this? By: Teodor Danciu - teodord RE: Exception while export large report to HTML 2003-10-03 14:31 Hi, An HTML document containig 10000 records is huge I guess as the HTML format is very verbose comparing to PDF. Consider paginating your HTML documents when displaying them, like in the "webapp" sample provided. I hope this helps. Teodor By: Barra - booleong RE: Exception while export large report to HTML 2004-01-05 01:29 Can HTML output be paginated if the Application is standalone java, and not a web application ?
- August 19, 2006
- - JasperReports Library
How can I use stylus printer to print bill?

2002 JI Open Discussion posted a topic in Products

By: DanielChen - jiebao How can I use stylus printer to print bill? 2003-12-26 18:59 I am useing jasperreports ,and I must use stylus printer to print bill(at least three copys once), How can I Improve quality of scaled images and character? By: DanielChen - jiebao RE: How can I use stylus printer to print bill? 2004-01-01 22:47 need your help Thank you! By: DanielChen - jiebao RE: How can I use stylus printer to print bill? 2004-01-01 22:47 up By: Alexander Wallace - aows RE: How can I use stylus printer to print bill? 2004-01-02 07:40 I'm pretty sure the settings to improve the quality are related to the software you are using to print and not to the reporting engine. Check the resolution, of the printer using your drivers and printer manager. By: DanielChen - jiebao RE: How can I use stylus printer to print bill? 2004-01-02 17:57 I can print very clarity in MS Word. By: Vinod Kumar Singh - vinodsingh RE: How can I use stylus printer to print bil 2004-01-03 02:59 try printing pdf file exported through JasperReports. By: DanielChen - jiebao RE: How can I use stylus printer to print bill? 2004-01-03 07:11 It is same. By: DanielChen - jiebao RE: How can I use stylus printer to print bill? 2004-01-04 17:39 up up
- August 19, 2006
- - JasperReports Library
How to encrypt PDF? and got several pages?

2002 JI Open Discussion posted a topic in Products

By: Mauricio Alarcon - mauralar How to encrypt PDF? and got several pages? 2003-10-01 10:09 Hello, Well, I made a report but I need encrypt this report into a PDF in the way that the user only could see and print, but no copy and paste the contents to another application, is this posible??? And I used this xml descriptor, but the results is only one page, why?? --- <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport SYSTEM "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="PruebaTXT" pageHeight="842" pageWidth="595" bottomMargin="30" leftMargin="20" topMargin="30" rightMargin="20" orientation="Portrait"> <parameter name="line" class="java.lang.String"/> <detail> <band height="700"> <textField> <reportElement x="0" y="0" width="500" height="700"/> <textFieldExpression>$P{line}</textFieldExpression> </textField> </band> </detail> </jasperReport> --- Any ideas will be welcome Thanks Mauricio Alarcon By: Teodor Danciu - teodord RE: How to encrypt PDF? and got several pages 2003-10-05 05:11 Hi, The iText library that we use to generate PDF supports encryption. You might consider creating a customized JasperReports PDF exporter that adds this layer of encryption. I'll be glad to have such contribution added to the main version. Thank you, Teodor By: Teodor Danciu - teodord RE: How to encrypt PDF? and got several pages 2004-01-04 09:29 Hi, The PDF encryption functionality is now available in the CVS repository version. There is also a "pdfencrypt" sample provided. Thank you, Teodor
- August 19, 2006
- - JasperReports Library
Please Suggest! This is very Important!

2002 JI Open Discussion posted a topic in Products

By: Arun Kumar PG - pgarunkumar Please Suggest! This is very Important! 2003-12-30 22:52 Hi all! Can any 1 tell me how to get the summary section at the bottom of a page. Actually, I have a design where I have a detail band and after that I have a summary band. The problem is that when the Detail does not contains anything the summary band rises above the bottom of the page and therefore a gap is created between the botton of the page and summary. It looks awkward! Here is how the page looks: ------START REPORT------ _________________________ Page header _________________________ Group A _________________________ Detail _________________________ GROUP A FOOTER (This a line) _________________________ SUMMARY _________________________ --------END REPORT------ GAP COMES HERE when no detail present (it looks awkward!) _________________________ PAGE FOOTER _________________________ What I want is this: ------START REPORT------ _________________________ Page header _________________________ Group A _________________________ Detail _________________________ GROUP A FOOTER (This a line) _________________________ GAP CAN COME HERE if no detail is present (Itz okie) _________________________ SUMMARY _________________________ PAGE FOOTER _________________________ ------END REPORT------ Can any 1 tell me how to get rid off the first type of Report shown above! Thankz in advance Arun By: Teodor Danciu - teodord RE: Please Suggest! This is very Important! 2003-12-31 06:25 Hi, This can only ba achieved using a trick like the following: Place your summary elements in the page footer at a negative Y coordinate so that they actually appear above the top of the page footer. Use their <printWhenExpression> based on a boolean flag to suppress these elements on all pages except the last. To indicate that the report generation reached the last page, use an invisible element (white line) in the actual summary section that would have a dummy <printWhenExpression> of its own whose only purpose is to set your last page flag to true. I hope this helps. Teodor By: Arun Kumar PG - pgarunkumar RE: Please Suggest! This is very Important! 2004-01-01 03:44 Thankz Teodor for the prompt reply! I appreciate that. Well lemme try that. But I have a doubt Will the Japer XML file be compiled if I place the element at a negative Y coordinate. Thankz in advance Arun By: Vinod Kumar Singh - vinodsingh RE: Please Suggest! This is very Important! 2004-01-02 00:30 I have tested fields with -ve Y value but it does not throw any error and compiles successfully. Would you elaborate the error you are getting? Vinod By: Arun Kumar PG - pgarunkumar RE: Please Suggest! This is very Important! 2004-01-01 06:38 Dear Teodord! I tried that but itz giving me a compilation error. stating: Element out of band. Actually I am using iReport for the XML design creation. When I set a negative Y value for the items that I want to be printed as summary it gives me an error. Teodord I'll be grateful to you if you could giv me a sample chunk of XML depicting the solution. Thankz in Advance!! Arun P.S. REPLY ANTICIPATED By: Teodor Danciu - teodord RE: Please Suggest! This is very Important! 2004-01-03 14:07 Hi, As far as the reporting engine is concerned, an element should not cross or be placed below the bottom of the band. But a negative Y coordinate is perfectly OK. I think it is iReport which adds this constraint. You'll probably have to edit and compile your XML outside iReport to get around this. I hope this helps. Teodor By: Arun Kumar PG - pgarunkumar RE: Please Suggest! This is very Important! 2004-01-04 00:01 Hi! Thankx for the replyTedor. I'll edit the design XML manually and will submit it to the Reporting engine. Thankx once again! Arun
- August 19, 2006
- - JasperReports Library
Filling the report several times

2002 JI Open Discussion posted a topic in Products

By: Bruno Cardoso - morcegopt Filling the report several times 2003-12-22 03:28 Is it possible to fill one report several times? Dont ask me why but I need to do this. Thanks By: Teodor Danciu - teodord RE: Filling the report several times 2003-12-22 06:49 Hi, Report templates, either in XML form or compiled form (JasperReport objects) are made for filling multiple time. This is what reporting in general is about. I hope this helps. Teodor By: Bruno Cardoso - morcegopt RE: Filling the report several times 2003-12-22 07:00 I think I was not clear enough with my question. What I ment was, is it possible to fill several times the same report? I need to fill my report using several different Datasources. The fillReport method only receives one datasource and returns a JasperPrint object so I lose the first JasperPrint when I call the method for the second time for a different datasource. Anyone have a solution for this problem? Thanks By: Teodor Danciu - teodord RE: Filling the report several times 2004-01-03 14:22 Hi, You can include your original report as a subreport inside a master report. In the master report you will iterate through some dummy data source that would allow you to fill the same subreport multiple times using several different data sources. I hope this helps. Teodor
- August 19, 2006
- - JasperReports Library
How to convert ROWS into Columns in iReports

2002 JI Open Discussion posted a topic in Products

By: pandu - pandu16 How to convert ROWS into Columns in iReports 2004-01-02 16:54 Hi, I've got a table that looks like this: Product Year Sales ------------------------------- A 1999 1000 A 2000 1500 A 2001 1200 A 2002 2000 B 1999 500 B 2000 1200 B 2001 1700 B 2002 1800 Who knows how to turn this table into: Product Sales 1999 Sales 2000 ----------------------------------------------- A 1000 1500 B 500 1200 Thanks Pandu By: Vinod Kumar Singh - vinodsingh RE: How to convert ROWS into Columns in iRepo 2004-01-03 03:38 do it yourself
- August 19, 2006
- - JasperReports Library
How to convert ROWS into Columns in iReports

2002 JI Open Discussion posted a topic in Products

By: pandu - pandu16 How to convert ROWS into Columns in iReports 2004-01-02 16:54 Hi, I've got a table that looks like this: Product Year Sales ------------------------------- A 1999 1000 A 2000 1500 A 2001 1200 A 2002 2000 B 1999 500 B 2000 1200 B 2001 1700 B 2002 1800 Who knows how to turn this table into: Product Sales 1999 Sales 2000 ----------------------------------------------- A 1000 1500 B 500 1200 Thanks Pandu By: Vinod Kumar Singh - vinodsingh RE: How to convert ROWS into Columns in iRepo 2004-01-03 03:38 do it yourself
- August 19, 2006
- - JasperReports Library
Problem with same Subreport Multiple times

2002 JI Open Discussion posted a topic in Products

By: Ashish - ashisharte Problem with same Subreport Multiple times 2004-01-02 15:43 Hello All, I am having difficulty producing a report which has a same subreport appearing multiple times. For instance Master Report A has subreport B in its columnfooter and the same subreport B in page footer. ( I have to do so that I can send my client one section of the report and I can keep the other one for my records ). I implemented this by storing the subreport's data ( from a custom datasource that implements all the methods properly) in a hashmap ( SubReportDataSrc ) so that at runtime it is populated according to the master report's id. I was expecting Jasper to populate both subreports ( since they are identical and have the same data source), but it appears to populate only one subreport while the other one is empty ( it gets an empty data source, since the subreports other sections do print ). The subreport section of the columnfooter looks like this: .... .... <dataSourceExpression> <![CDATA[(dori.jasper.engine.JRDataSource)$P{SubReportDataSrc}.get( $F{reportid} )]]> </dataSourceExpression> <subreportExpression class="java.lang.String"> <![CDATA[$P{SUB_REPORT}]]> </subreportExpression> ... ... And that of the page footer which is identical looks like this : ... .... <dataSourceExpression> <![CDATA[(dori.jasper.engine.JRDataSource)$P{SubReportDataSrc}.get( $F{reportid} )]]> </dataSourceExpression> <subreportExpression class="java.lang.String"> <![CDATA[$P{SUB_REPORT}]]> </subreportExpression> ... ... Dear Teodord , any pointers on what I am doing wrong ? Sincerely Ashish By: Vinod Kumar Singh - vinodsingh RE: Problem with same Subreport Multiple time 2004-01-03 03:34 After printing the sub-report first time cursor goes beyond the last row that is why no records are printed second time. You have to rewind the result set before calling the sub-report second time.
- August 19, 2006
- - JasperReports Library
Daily Schedule Report

2002 JI Open Discussion posted a topic in Products

By: Jeffrey Hood - jhood Daily Schedule Report 2004-01-02 03:42 I am pretty new to JasperReports, and can't seem to get anything to work with what I'm trying to do... I have a table that has daily schedule entries, with a start time and duration... I also have a default appointment length, which I can pass into the report as a parameter, along with the starting time for the day and the ending time for the day... What I need to do is have Jasper create a table and have the appointments show on the appropriate starting time cell, and hopefully color the cell(s) until the ending time of the appointment (starting time + duration)... basically I'm trying to duplicate a daily event list ala Outlook, etc... If anyone has done something like this and can point me in the right direction, I would greatly appreciate it... or if it isn't possible, let me know... Thanks in advance... JH By: Andy Deighton - andyxr RE: Daily Schedule Report 2004-01-02 08:35 I've done something similar. I have a report that colours a "cell" if the value displayed is within a certain tolerance. I'm sure a similar thing could apply in your case. Firstly, make sure you're happy with your query (in that it answers rows in the correct order, gets grouped etc.). Then you can use the $P stuff in Jasper to pass in whatever parameters to your query to make it dynamic, so to speak. For colouring cells, I had to use rectangles that I then chose to display based on certain values. I don't think you can just colour the background of a "cell" dynamically. I effectively had to show or hide one of three different coloured rectangles that were stacked up behind my text cell. For example, within my RED rectangle definition, I add the following: <printWhenExpression><![CDATA[boolean.valueOf($F{CellColour}.intValue() == 2)]]></printWhenExpression> In my case, I read the value of a table column ("CellColour") and see if it's set to 2. If so, the rectangle gets displayed. I'm sure you can do what you want using the <printWhenExpression> tag. I hope that helps! Andy UK By: Vinod Kumar Singh - vinodsingh RE: Daily Schedule Report 2004-01-03 03:24 for an alternate solution look at the Tips & Tricks section of JasperReports docs
- August 19, 2006
- - JasperReports Library

Prev
3
4
5
6
7
8
9
10
11
12
13
Next
Page 8 of 60

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Everything posted by 2002 JI Open Discussion

Products

Explore