Inconsistencies seen in CSV export of JasperSoft reports.

Document ID : KB000007506
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When I make an alarm group report and export to csv, we see inconsistencies in formatting, that we cannot script and automate.

1. extra commas,,, 

2. spaces on 1 line that are not on the other. 

3. the date format does not zero fill all single digits e.g. 05/2/2017 instead of 05/02/2017 causing a difference with 05/30/2017 

however it does zero fill leading numbers 05/2/2017 

Environment:
Spectrum 10.x with Jasper 6.3
Cause:

There are formatting differences between the two products. There is also a bug in the Jaspersoft reports that causes the data to not align with the column headers.

Resolution:

To fix the column headers for Spectrum 10.2 and Jaspersoft 6.3 please request the following fix from CA Spectrum Support:

Spectrum_10.02.00.PTF_10.2.038

To fix the column headers for Spectrum 10.2.1 and Jaspersoft 6.3 please request the following fix from CA Spectrum Support:

Spectrum_10.02.01.PTF_10.2.102

To cause the Jaspersoft CSV export format to match that of BOXI's with no additional column headers or page breaks please follow these steps:

On the JasperSoft server make a backup copy of the $BOINST\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\WEB-INF\classes\jasperreports.properties file.

Once the file has been backed up please edit the original jasperreports.properties

Add the following properties to the jasperreports.properties

 

net.sf.jasperreports.export.csv.remove.empty.space.between.rows=true 

net.sf.jasperreports.export.csv.remove.empty.space.between.columns=true 

net.sf.jasperreports.export.csv.exclude.origin.band.1=pageHeader 

net.sf.jasperreports.export.csv.exclude.origin.report.1=* 

net.sf.jasperreports.export.csv.exclude.origin.band.2=pageFooter 

net.sf.jasperreports.export.csv.exclude.origin.report.2=* 

net.sf.jasperreports.export.csv.exclude.origin.band.3=columnHeader 

net.sf.jasperreports.export.csv.exclude.origin.report.3=* 

net.sf.jasperreports.export.csv.exclude.origin.band.4=columnFooter 

net.sf.jasperreports.export.csv.exclude.origin.report.4=* 

net.sf.jasperreports.export.csv.exclude.origin.band.5=lastPageHeader 

net.sf.jasperreports.export.csv.exclude.origin.report.5=* 

net.sf.jasperreports.export.csv.exclude.origin.band.6=summaryPageHeader 

net.sf.jasperreports.export.csv.exclude.origin.band.7=groupHeader 

net.sf.jasperreports.export.csv.exclude.origin.group.7=* 

net.sf.jasperreports.export.csv.exclude.origin.report.7=* 

net.sf.jasperreports.export.csv.exclude.origin.band.8=groupFooter 

net.sf.jasperreports.export.csv.exclude.origin.band.9=lastPageFooter 

net.sf.jasperreports.export.csv.exclude.origin.report.9=* 

net.sf.jasperreports.export.csv.exclude.origin.band.10=summaryPageFooter 

net.sf.jasperreports.export.csv.exclude.origin.band.11=summary 

net.sf.jasperreports.export.csv.exclude.origin.report.11=* 

net.sf.jasperreports.export.csv.exclude.origin.band.12=title 

net.sf.jasperreports.export.csv.exclude.origin.report.12=* 

net.sf.jasperreports.export.csv.parameters.override.IgnorePagination=true 

 

 

Once these changes have been made please save the jasperreports.properties file. 

Restart the Apache Tomcat server.  Test the reports with the export.