CSV export without header line on every page

[Michael.Boehm]

Hi,

I am trying to create a report that will finally be exportet into csv.

When doing that, I always get the table header on every page, which disturbs the final processing of the csv.

Is there any way to export a report into csv without page-breaks (when exporting into Excel, this is one of the options).

Or what else can I do to remove these additional lines?

Thanks, Michael

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[anish.rai]

Thank you for your patience, we have not forgotten you.  
We need a little more time with our team of experts to come up with a solution. We will respond back with an answer as quickly as we can.

[anish.rai]

 

Thank you for your patience, we need a little more time with our team of experts to come up with a solution. We will respond back as soon as we have an answer to your question.

 

[psaripal]

Thank you for your patience. The answer to your question has been updated.

[psaripal]

Hi Michael,

Please use the following property in the jrxml file to avoid column header repeating in csv file.

net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name}

Example

<property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1" value="columnHeader"/>

Here is a reference to community article on how to suppress headers and footers exporting to Excel.

https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-an...

[Michael.Boehm]

Thanks for the answer - everything is working fine with this modification in the report.