jhopkinsjorbe.com

Ok, that worked once I fixed my typing errors. Same properties as Excel just replace xls with csv and pagination is removed on export. Thanks, Joe

Thanks for the link...that's exactly what I need...

Oops.. I meant .csv. in the above code sample. :-) # this gets rid of the repeating column headers and footers in CSV exports net.sf.jasperreports.export.csv.exclude.origin.band.1=columnHeader net.sf.jasperreports.export.csv.exclude.origin.band.2=pageFooter # keep the first column header on export to CSV net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1=columnHeader

How do you remove pagination from CSV exports? I got it working in Excel from your suggestions but I still get a reapeating footer when exporting to CSV. Here are my jasperreports.properties #Jdbc Timezone execution factory net.sf.jasperreports.query.executer.factory.sql=com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory #limit the crosstab bucket/measure count to prevent out of memory errors net.sf.jasperreports.crosstab.bucket.measure.limit=100000 # suppress page headers and footers when exporting to XLS net.sf.jasperreports.export.exclude.origin.band.1=pageHeader net.sf.jasperreports.export.exclude.origin.band.2=pageFooter # this gets rid of the repeating column headers and footers in excel exports net.sf.jasperreports.export.xls.exclude.origin.band.1=columnHeader net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter # keep the first column header on export to XLS net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1=columnHeader # this gets rid of the repeating column headers and footers in CVS exports net.sf.jasperreports.export.cvs.exclude.origin.band.1=columnHeader net.sf.jasperreports.export.cvs.exclude.origin.band.2=pageFooter # keep the first column header on export to CVS net.sf.jasperreports.export.cvs.exclude.origin.keep.first.band.1=columnHeader # report exporter hints override export parameters net.sf.jasperreports.export.parameters.override.report.hints=false # use the workaround for the Sun JDK Glyph synchronization bug net.sf.jasperreports.text.measurer.factory=net.sf.jasperreports.engine.util.JdkGlyphFixTextMeasurerFactory # the fast/single line text measurer factory net.sf.jasperreports.text.measurer.factory.single.line=com.jaspersoft.jasperserver.api.engine.jasperreports.util.SingleLineTextMeasurerFactory # other excel options (applicationContext.xml overrides these settings) #net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true #net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true #net.sf.jasperreports.export.xls.detect.cell.type=true #net.sf.jasperreports.export.xls.create.custom.palette=true Thanks, Joe

Ths solution worked along with these settings in my jasperreports.properties file. net.sf.jasperreports.query.executer.factory.sql=com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory #limit the crosstab bucket/measure count to prevent out of memory errors net.sf.jasperreports.crosstab.bucket.measure.limit=100000 # suppress page headers and footers when exporting to XLS net.sf.jasperreports.export.exclude.origin.band.1=pageHeader net.sf.jasperreports.export.exclude.origin.band.2=pageFooter # this gets rid of the repeating column headers and footers in excel exports net.sf.jasperreports.export.xls.exclude.origin.band.1=columnHeader net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter # keep the first column header on export net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1=columnHeader # report exporter hints override export parameters net.sf.jasperreports.export.parameters.override.report.hints=false # use the workaround for the Sun JDK Glyph synchronization bug net.sf.jasperreports.text.measurer.factory=net.sf.jasperreports.engine.util.JdkGlyphFixTextMeasurerFactory # the fast/single line text measurer factory net.sf.jasperreports.text.measurer.factory.single.line=com.jaspersoft.jasperserver.api.engine.jasperreports.util.SingleLineTextMeasurerFactory # other excel options #net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true #net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true #net.sf.jasperreports.export.xls.detect.cell.type=true #net.sf.jasperreports.export.xls.create.custom.palette=true Thanks, Joe

I have many reports written in JasperReports and deployed on the JasperServer. I need the html version onscreen to paginate and the excel/CSV exports to not paginate. Pagination in excel exports doesn't make any sense to me. Is there an option to turn off pagination for excel exports on the JasperServer? My users want to use the excel exports for analysis and with the page headers embeded in the output it makes that impossible without going through and removing all the headers. I have looked around in the code and can see where I could possibly add a property to the xmlExporterBean and then pass that along to the excel export logic. If there is no way to turn this off out-of-the-box any help/insight into making the code changes would be appriciated. I have attached a sample export. Cheers, Joe