how to generate excel data report without breakup

[anupp1983]

 Hi,

      I am using jasper report3.6.I want to generate Excel Report in jasper .and my data is 500.so problem is In excel report 30 record after that new column header&page number is coming.So i want to generate no break up in Excel report.So plz help me where i m missing .I m waiting for ur response.

I m sending jrxml and java code also.

 

 

Thanks in advance

Anup

Code:

Post Edited by anupp1983 at 01/14/2011 06:29

[ozone0644]

Ref http://jasperforge.org/website/jasperreportswebsite/trunk/config.reference.html?group_id=252

In the sample code below I put the property code to exclude some segments in each export format.

 

<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="abc" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" resourceBundle="ReportResources">
    <property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1" value="columnHeader"/>
    <property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="pageHeader"/>
    <property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/>
    <property name="net.sf.jasperreports.export.xls.exclude.origin.band.3" value="lastPageFooter"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1" value="columnHeader"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.1" value="pageHeader"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.2" value="pageFooter"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.3" value="lastPageFooter"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.group.6" value="B"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.6" value="groupFooter"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.group.7" value="C"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.7" value="groupFooter"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.group.8" value="D"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.8" value="groupFooter"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.9" value="summary"/>
    <property name="ireport.zoom" value="1"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <style name="style1" fontName="Tahoma" fontSize="7" isBold="false" pdfFontName="tahoma.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
    <parameter name="paramDocType" class="java.lang.String" isForPrompting="false"/>
    <parameter name="paramDocDateFrom" class="java.lang.String" isForPrompting="false"/>

hope this help :)

ozone

Post Edited by ozone0644 at 01/14/2011 07:10