Jump to content
We've recently updated our Privacy Statement, available here ×

Issues with rendering table when Jasper report is exported to ODT format


Recommended Posts

Hi All,

Facing issues, with exporting Jasper Reports to ODT format. In the  generated ODT file the table element is not getting rendered at all. Any help on the same, will be appreciated.This is the code snippet that I am using to export the jrxml to ODT format

JROdtExporter odtExporter = new JROdtExporter();odtExporter.setParameter(JRExporterParameter.JASPER_PRINT,jp);destinationOdtPath = prop.getProperty("destinationOdtPath");odtExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,destinationOdtPath);odtExporter.exportReport();[/code]

Also , please find below  the jrxml file that I am using

<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="table" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Error">   <property name="ireport.zoom" value="1.0"/>   <property name="ireport.x" value="0"/>   <property name="ireport.y" value="686"/>   <property name="Expiry Date" value="25-May-2013"/>   <style name="table">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 1">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 2">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 3">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 4">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 4_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 4_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <subDataset name="Order" whenResourceMissingType="Error">      <parameter name="ORDER #" class="java.lang.String" />      <parameter name="QTY" class="java.lang.String"/>      <parameter name="ITEM DESCRIPTION" class="java.lang.String"/>      <parameter name="UNIT PRICE IN Rs" class="java.lang.String"/>      <parameter name="TOTAL" class="java.lang.String"/>      <parameter name="PROPOSED SHIPPING DATE" class="java.lang.String"/>      <field name="ORDER #" class="java.lang.String"/>      <field name="QTY" class="java.lang.String"/>      <field name="ITEM DESCRIPTION" class="java.lang.String"/>      <field name="UNIT PRICE IN Rs" class="java.lang.String"/>      <field name="TOTAL" class="java.lang.String"/>      <field name="PROPOSED SHIPPING DATE" class="java.lang.String"/>   </subDataset>   <parameter name="Org_Address" class="java.lang.String"/>   <parameter name="Org_Email" class="java.lang.String"/>   <parameter name="Org_Phone" class="java.lang.String"/>   <parameter name="Org_Name" class="java.lang.String"/>   <parameter name="ReusltSet" class="java.sql.ResultSet"/>   <parameter name="ITEM DESCRIPTION" class="java.lang.String"/>   <parameter name="ORDER #" class="java.lang.String"/>   <parameter name="QTY" class="java.lang.String"/>   <parameter name="TOTAL" class="java.lang.String"/>   <parameter name="UNIT PRICE IN Rs" class="java.lang.String"/>   <parameter name="PROPOSED SHIPPING DATE" class="java.lang.String"/>   <!--<queryString language="SQL">      <![CDATA[]]>   </queryString>   <field name="resultSet" class="net.sf.jasperreports.engine.JRResultSetDataSource"/>-->   <background>      <band splitType="Stretch"/>   </background>   <title>      <band height="153" splitType="Stretch">         <image>            <reportElement x="10" y="10" width="41" height="40"/>            <imageExpression><![CDATA["D:\My Received Files\imagesCAKQYA3C.jpg"]]></imageExpression>         </image>         <staticText>            <reportElement x="51" y="10" width="268" height="35"/>            <textElement>               <font size="18" isBold="true"/>            </textElement>            <text><![CDATA[information Technologies Limited]]></text>         </staticText>         <staticText>            <reportElement x="384" y="45" width="35" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Name:]]></text>         </staticText>         <textField>            <reportElement x="434" y="45" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Name}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="384" y="76" width="50" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Phone:]]></text>         </staticText>         <textField>            <reportElement x="434" y="76" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Phone}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="384" y="106" width="50" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[E-mail:]]></text>         </staticText>         <textField>            <reportElement x="434" y="106" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Email}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="210" y="50" width="154" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Primary Business Address:]]></text>         </staticText>         <textField>            <reportElement x="210" y="76" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Address}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="22" y="126" width="100" height="19"/>            <textElement>               <font size="14" isBold="true" isItalic="true"/>            </textElement>            <text><![CDATA[Quotation]]></text>         </staticText>      </band>   </title>   <pageHeader>      <band height="76" splitType="Stretch">         <staticText>            <reportElement x="48" y="10" width="100" height="20"/>            <textElement>               <font size="14"/>            </textElement>            <text><![CDATA[To:]]></text>         </staticText>         <staticText>            <reportElement x="48" y="30" width="138" height="20"/>            <textElement/>            <text><![CDATA[Type address here]]></text>         </staticText>         <staticText>            <reportElement x="310" y="10" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Quotation #:]]></text>         </staticText>         <staticText>            <reportElement x="310" y="30" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Date:]]></text>         </staticText>         <staticText>            <reportElement x="310" y="50" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Customer ID:]]></text>         </staticText>      </band>   </pageHeader>   <columnFooter>      <band height="573">         <!--<printWhenExpression><![CDATA[$V{REPORT_COUNT}.intValue()>2]]></printWhenExpression>-->         <componentElement>            <reportElement key="table 4" style="table 4" x="0" y="0" width="540" height="80"/>            <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">               <datasetRun subDataset="Order">                  <datasetParameter name="ORDER #">                     <datasetParameterExpression><![CDATA[$P{ORDER #}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="QTY">                     <datasetParameterExpression><![CDATA[$P{QTY}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="PROPOSED SHIPPING DATE">                     <datasetParameterExpression><![CDATA[$P{PROPOSED SHIPPING DATE}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="TOTAL">                     <datasetParameterExpression><![CDATA[$P{TOTAL}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="UNIT PRICE IN Rs">                     <datasetParameterExpression><![CDATA[$P{UNIT PRICE IN Rs}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="ITEM DESCRIPTION">                     <datasetParameterExpression><![CDATA[$P{ITEM DESCRIPTION}]]></datasetParameterExpression>                  </datasetParameter>                  <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JRResultSetDataSource($P{ReusltSet})]]></dataSourceExpression>                  <!-- <dataSourceExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></dataSourceExpression>-->               </datasetRun>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{ORDER #}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <!-- <jr:columnHeader style="table 4_TH" height="30">                     <staticText>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font size="12"/>                        </textElement>                        <text><![CDATA[ORDER #:]]></text>                     </staticText>                  </jr:columnHeader>                  <jr:columnHeader style="table 4_TH" height="30">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$P{ORDER #}]]></textFieldExpression>                     </textField>                  </jr:columnHeader>-->                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{ORDER #}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{QTY}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{QTY}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{ITEM DESCRIPTION}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{ITEM DESCRIPTION}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{UNIT PRICE IN Rs}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{UNIT PRICE IN Rs}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{TOTAL}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{TOTAL}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="110" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="110" height="30"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{PROPOSED SHIPPING DATE}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{PROPOSED SHIPPING DATE}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>            </jr:table>         </componentElement>         <textField evaluationTime="Report">            <reportElement x="304" y="285" width="100" height="20"/>            <textElement/>            <textFieldExpression><![CDATA["total count"+$V{REPORT_COUNT}.toString()]]></textFieldExpression>         </textField>      </band>   </columnFooter>   <summary>      <band height="469" splitType="Stretch">         <subreport>            <reportElement x="27" y="27" width="200" height="100"/>            <subreportExpression><![CDATA["D:\IReport\Subreport.jasper"]]></subreportExpression>         </subreport>      </band>   </summary></jasperReport>

<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="table" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Error">   <property name="ireport.zoom" value="1.0"/>   <property name="ireport.x" value="0"/>   <property name="ireport.y" value="686"/>   <property name="Expiry Date" value="25-May-2013"/>   <style name="table">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 1">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 2">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 3">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 4">      <box>         <pen lineWidth="1.0" lineColor="#000000"/>      </box>   </style>   <style name="table 4_TH" mode="Opaque" backcolor="#F0F8FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 4_CH" mode="Opaque" backcolor="#BFE1FF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF">      <box>         <pen lineWidth="0.5" lineColor="#000000"/>      </box>   </style>   <subDataset name="Order" whenResourceMissingType="Error">      <parameter name="ORDER #" class="java.lang.String" />      <parameter name="QTY" class="java.lang.String"/>      <parameter name="ITEM DESCRIPTION" class="java.lang.String"/>      <parameter name="UNIT PRICE IN Rs" class="java.lang.String"/>      <parameter name="TOTAL" class="java.lang.String"/>      <parameter name="PROPOSED SHIPPING DATE" class="java.lang.String"/>      <field name="ORDER #" class="java.lang.String"/>      <field name="QTY" class="java.lang.String"/>      <field name="ITEM DESCRIPTION" class="java.lang.String"/>      <field name="UNIT PRICE IN Rs" class="java.lang.String"/>      <field name="TOTAL" class="java.lang.String"/>      <field name="PROPOSED SHIPPING DATE" class="java.lang.String"/>   </subDataset>   <parameter name="Org_Address" class="java.lang.String"/>   <parameter name="Org_Email" class="java.lang.String"/>   <parameter name="Org_Phone" class="java.lang.String"/>   <parameter name="Org_Name" class="java.lang.String"/>   <parameter name="ReusltSet" class="java.sql.ResultSet"/>   <parameter name="ITEM DESCRIPTION" class="java.lang.String"/>   <parameter name="ORDER #" class="java.lang.String"/>   <parameter name="QTY" class="java.lang.String"/>   <parameter name="TOTAL" class="java.lang.String"/>   <parameter name="UNIT PRICE IN Rs" class="java.lang.String"/>   <parameter name="PROPOSED SHIPPING DATE" class="java.lang.String"/>   <!--<queryString language="SQL">      <![CDATA[]]>   </queryString>   <field name="resultSet" class="net.sf.jasperreports.engine.JRResultSetDataSource"/>-->   <background>      <band splitType="Stretch"/>   </background>   <title>      <band height="153" splitType="Stretch">         <image>            <reportElement x="10" y="10" width="41" height="40"/>            <imageExpression><![CDATA["D:\My Received Files\imagesCAKQYA3C.jpg"]]></imageExpression>         </image>         <staticText>            <reportElement x="51" y="10" width="268" height="35"/>            <textElement>               <font size="18" isBold="true"/>            </textElement>            <text><![CDATA[information Technologies Limited]]></text>         </staticText>         <staticText>            <reportElement x="384" y="45" width="35" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Name:]]></text>         </staticText>         <textField>            <reportElement x="434" y="45" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Name}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="384" y="76" width="50" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Phone:]]></text>         </staticText>         <textField>            <reportElement x="434" y="76" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Phone}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="384" y="106" width="50" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[E-mail:]]></text>         </staticText>         <textField>            <reportElement x="434" y="106" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Email}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="210" y="50" width="154" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Primary Business Address:]]></text>         </staticText>         <textField>            <reportElement x="210" y="76" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{Org_Address}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="22" y="126" width="100" height="19"/>            <textElement>               <font size="14" isBold="true" isItalic="true"/>            </textElement>            <text><![CDATA[Quotation]]></text>         </staticText>      </band>   </title>   <pageHeader>      <band height="76" splitType="Stretch">         <staticText>            <reportElement x="48" y="10" width="100" height="20"/>            <textElement>               <font size="14"/>            </textElement>            <text><![CDATA[To:]]></text>         </staticText>         <staticText>            <reportElement x="48" y="30" width="138" height="20"/>            <textElement/>            <text><![CDATA[Type address here]]></text>         </staticText>         <staticText>            <reportElement x="310" y="10" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Quotation #:]]></text>         </staticText>         <staticText>            <reportElement x="310" y="30" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Date:]]></text>         </staticText>         <staticText>            <reportElement x="310" y="50" width="100" height="20"/>            <textElement>               <font size="12"/>            </textElement>            <text><![CDATA[Customer ID:]]></text>         </staticText>      </band>   </pageHeader>   <columnFooter>      <band height="573">         <!--<printWhenExpression><![CDATA[$V{REPORT_COUNT}.intValue()>2]]></printWhenExpression>-->         <componentElement>            <reportElement key="table 4" style="table 4" x="0" y="0" width="540" height="80"/>            <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">               <datasetRun subDataset="Order">                  <datasetParameter name="ORDER #">                     <datasetParameterExpression><![CDATA[$P{ORDER #}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="QTY">                     <datasetParameterExpression><![CDATA[$P{QTY}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="PROPOSED SHIPPING DATE">                     <datasetParameterExpression><![CDATA[$P{PROPOSED SHIPPING DATE}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="TOTAL">                     <datasetParameterExpression><![CDATA[$P{TOTAL}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="UNIT PRICE IN Rs">                     <datasetParameterExpression><![CDATA[$P{UNIT PRICE IN Rs}]]></datasetParameterExpression>                  </datasetParameter>                  <datasetParameter name="ITEM DESCRIPTION">                     <datasetParameterExpression><![CDATA[$P{ITEM DESCRIPTION}]]></datasetParameterExpression>                  </datasetParameter>                  <dataSourceExpression>                     <![CDATA[new net.sf.jasperreports.engine.JRResultSetDataSource($P{ReusltSet})]]>                  </dataSourceExpression>                  <!-- <dataSourceExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></dataSourceExpression>-->               </datasetRun>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{ORDER #}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <!-- <jr:columnHeader style="table 4_TH" height="30">                     <staticText>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font size="12"/>                        </textElement>                        <text><![CDATA[ORDER #:]]></text>                     </staticText>                  </jr:columnHeader>                  <jr:columnHeader style="table 4_TH" height="30">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$P{ORDER #}]]></textFieldExpression>                     </textField>                  </jr:columnHeader>-->                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{ORDER #}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{QTY}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{QTY}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{ITEM DESCRIPTION}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{ITEM DESCRIPTION}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{UNIT PRICE IN Rs}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{UNIT PRICE IN Rs}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="90" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{TOTAL}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{TOTAL}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>               <jr:column width="110" >                  <jr:tableHeader style="table 4_TH" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="110" height="30"/>                        <textElement>                           <font isBold="true"/>                        </textElement>                        <textFieldExpression><![CDATA[$P{PROPOSED SHIPPING DATE}]]></textFieldExpression>                     </textField>                  </jr:tableHeader>                  <jr:tableFooter style="table 4_TH" height="30" rowSpan="1"/>                  <jr:detailCell style="table 4_TD" height="30" rowSpan="1">                     <textField>                        <reportElement x="0" y="0" width="90" height="20"/>                        <textElement/>                        <textFieldExpression><![CDATA[$F{PROPOSED SHIPPING DATE}]]></textFieldExpression>                     </textField>                  </jr:detailCell>               </jr:column>            </jr:table>         </componentElement>         <textField evaluationTime="Report">            <reportElement x="304" y="285" width="100" height="20"/>            <textElement/>            <textFieldExpression><![CDATA["total count"+$V{REPORT_COUNT}.toString()]]></textFieldExpression>         </textField>      </band>   </columnFooter>   <summary>      <band height="469" splitType="Stretch">         <subreport>            <reportElement x="27" y="27" width="200" height="100"/>            <subreportExpression><![CDATA["D:\IReport\Subreport.jasper"]]></subreportExpression>         </subreport>      </band>   </summary></jasperReport>

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...