gmadhavi Posted March 20, 2009 Share Posted March 20, 2009 Hi friends,Please let me know which attribute to change inorder to display column names on all pages of Jasper report while printing..ThanksMadhavi Link to comment Share on other sites More sharing options...
dnvsrikanth Posted March 20, 2009 Share Posted March 20, 2009 Hi Madhavi, If your report doesn't contain any groups, the column headers will be printed automatically in all the pages of the report. On the other hand if you have groups created in the report place the column headders in the group header which is exactly above the Clolumn Header band and set the property isReprintHeaderOnEachPage of that group to true. If you do so dont forget to decrease the height of the column header band to 0 DNV Srikanth.Code:isReprintHeaderOnEachPage="true" Link to comment Share on other sites More sharing options...
gmadhavi Posted March 20, 2009 Author Share Posted March 20, 2009 Hi Srikanth, Thanks for ur reply. I dont have groups in my report,but still column headers are not printed in all the pages of the report. Link to comment Share on other sites More sharing options...
dnvsrikanth Posted March 20, 2009 Share Posted March 20, 2009 Hi Madhavi, Can u attach the jrxml file here so that I can find where the problem is.... DNV Srikanth. Link to comment Share on other sites More sharing options...
gmadhavi Posted March 20, 2009 Author Share Posted March 20, 2009 Thanks.. Code:<?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="ShipConsole.jrxml" pageWidth="2000" pageHeight="2000" whenNoDataType="AllSectionsNoDetail" columnWidth="1984" leftMargin="8" rightMargin="8" topMargin="20" bottomMargin="20"> <parameter name="IP_ORG_ID" class="java.lang.Integer"/> <parameter name="IP_INV_ORGANIZATION_ID" class="java.lang.Integer"/> <parameter name="IP_CARRIER_CODE" class="java.lang.Integer"/> <parameter name="IP_FROM_DATE" class="java.util.Date"/> <parameter name="IP_TO_DATE" class="java.util.Date"/> <parameter name="IP_USER_METHOD_MEANING" class="java.lang.String"/> <queryString> <![CDATA[select * from aasc_exporttoexcel_report_view where organization_id = $P{IP_ORG_ID} AND inv_organization_id = $P{IP_INV_ORGANIZATION_ID} and carrier_code = $P{IP_CARRIER_CODE} and user_shipmethod_meaning = NVL ($P{IP_USER_METHOD_MEANING}, user_shipmethod_meaning) and shipment_date between $P{IP_FROM_DATE} and $P{IP_TO_DATE} order by shipment_date desc]]> </queryString> <field name="VOID_FLAG" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="SHIPMENT_DATE" class="java.sql.Timestamp"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="COUNT" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="CUSTOMER_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="REFERENCE1" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ORDER_NUMBER" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DELIVERY_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PACKAGE_VOID_FLAG" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="TOTAL_PKG_WEIGHT" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WEIGHT" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WAYBILL_NUMBER" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="CARRIER_PAY_CODE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="FREIGHT_CHARGES" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="SHIP_FLAG" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ORGANIZATION_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="INV_ORGANIZATION_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="CARRIER_CODE" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="USER_SHIPMETHOD_MEANING" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <title> <band height="66"> <line> <reportElement x="0" y="0" width="1947" height="1"/> </line> <staticText> <reportElement x="460" y="13" width="523" height="25"/> <textElement> <font size="18" isBold="true"/> </textElement> <text><![CDATA[Carrier Shipment Activity Detail Report]]></text> </staticText> <line> <reportElement x="0" y="49" width="1947" height="1"/> </line> </band> </title> <pageHeader> <band/> </pageHeader> <columnHeader> <band height="21"> <staticText> <reportElement mode="Opaque" x="0" y="-2" width="154" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT VOID INDICATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="165" y="-2" width="136" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT PICKUP DATE]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="386" y="-2" width="103" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[NO. OF PACKAGES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="499" y="-2" width="127" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIP TO CUSTOMER ID]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="638" y="-2" width="131" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE REFERENCE1]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="779" y="-2" width="145" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE REFERENCE2]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="934" y="-2" width="135" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE REFERENCE3]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1082" y="-2" width="155" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11" isUnderline="false"/> </textElement> <text><![CDATA[PACKAGE VOID INDICATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1247" y="-2" width="162" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT BILLABLE WEIGHT]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1419" y="-2" width="105" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE WEIGHT]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1534" y="-2" width="116" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT ID]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1662" y="-2" width="152" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT BILLING OPTION]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1832" y="-2" width="115" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[FREIGHT_CHARGES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="312" y="-2" width="62" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIP FLAG]]></text> </staticText> </band> </columnHeader> <detail> <band height="21"> <textField> <reportElement x="0" y="-5" width="154" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{VOID_FLAG}]]></textFieldExpression> </textField> <textField pattern=""> <reportElement x="165" y="-5" width="136" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{SHIPMENT_DATE}]]></textFieldExpression> </textField> <textField> <reportElement x="386" y="-5" width="103" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COUNT}]]></textFieldExpression> </textField> <textField> <reportElement x="499" y="-5" width="127" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CUSTOMER_ID}]]></textFieldExpression> </textField> <textField> <reportElement x="638" y="-5" width="131" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{REFERENCE1}]]></textFieldExpression> </textField> <textField> <reportElement x="779" y="-5" width="145" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ORDER_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement x="934" y="-5" width="135" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DELIVERY_ID}]]></textFieldExpression> </textField> <textField> <reportElement x="1082" y="-5" width="155" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{PACKAGE_VOID_FLAG}]]></textFieldExpression> </textField> <textField> <reportElement x="1247" y="-5" width="162" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TOTAL_PKG_WEIGHT}]]></textFieldExpression> </textField> <textField> <reportElement x="1419" y="-5" width="105" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{WEIGHT}]]></textFieldExpression> </textField> <textField> <reportElement x="1534" y="-5" width="116" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{WAYBILL_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement x="1662" y="-5" width="152" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{CARRIER_PAY_CODE}]]></textFieldExpression> </textField> <textField> <reportElement x="1832" y="-5" width="115" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{FREIGHT_CHARGES}]]></textFieldExpression> </textField> <textField> <reportElement x="312" y="-5" width="62" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{SHIP_FLAG}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band/> </columnFooter> <pageFooter> <band height="28"/> </pageFooter> <summary> <band/> </summary></jasperReport> Link to comment Share on other sites More sharing options...
dnvsrikanth Posted March 20, 2009 Share Posted March 20, 2009 Hi Madhavi, I have changed the text fields that are in detail section and decreased the height of the fields that were kept in column header band. Check whether this works fineor not...if not let me know, i'll check whether it has any another issue.... DNV Srikanth. Link to comment Share on other sites More sharing options...
gmadhavi Posted March 20, 2009 Author Share Posted March 20, 2009 Hi Srikanth..Your code is working fine..Thankyou very much.If you know anything about this,please help me out.In html format,Unable to get page break for multiple pages Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now