One time display of Crosstab headers in Excel/CSV

[atmaling]

Hi,

I want to hide crosstab headers (or show only once) while exporting to Excel or CSV.

I applied following properties but its not working. Column Headers are repeating.

net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1 =pageHeader
net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.2 =columnHeader

Is there any other property so that Cross-Tab Column headers will be displayed only once in Excel/CSV .

 

Thanks in Advance..!!!

[ajinkya_c]

Try to export report with Ignore_Pagination properety check. So that whole report display in one page and when you export it then report header also display once.

[atmaling]

With the Ignore_Pagination property, report is coming fine in CSV.

But in PDF its coming in Single page.

So how to Igonore pagination while exporting to CSV only ?

[cameron_1]

Have you managed to find a resolution to this yet? Turning off pagination isn't really appropriate for larger reports where people want to view it both online and in CSV/XLS.