suppressing page headers and footers when exporting to XLS not working

0

i'm developing report using jasper 4.7.1 and iReport Desinger which is exported to different formats according to user selection, in case of exporting in xls format i need to suppress page header, i've added this line to xml 

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="pageHeader"/>

but when i preview the report from within iReport Designer or deploy it to server page header is not suppressed.

i believe the problem is in the template i'm using this snippet of page header template 

<pageHeader>  <band height="50">   <staticText>    <reportElement uuid="c1e5bcff-0d5e-4a14-adb8-9b8c2c8112fe" style="Title" mode="Opaque" x="255" y="11" width="157" height="27" backcolor="#CCCCCC"/>    <textElement>     <font isBold="true"/>    </textElement>    <text><![CDATA[Portfolio Evaluation As of]]></text>   </staticText>   <textField pattern="dd/MM/yyyy">    <reportElement uuid="63fd1e4d-d14d-4050-9013-981b79706e72" style="Title" mode="Opaque" x="411" y="11" width="100" height="27" backcolor="#CCCCCC"/>    <textElement>     <font isBold="true"/>    </textElement>    <textFieldExpression><![CDATA[$P{P_AS_OF_DATE}]]></textFieldExpression>   </textField>  </band> </pageHeader>

please help

shehab.sherif's picture
Joined: Aug 20 2013 - 1:05am
Last seen: 4 years 10 months ago

0 Answers:

No answers yet
Feedback