Inconsistencies seen in CSV export of JasperSoft reports.

Document ID:  TEC1138171
Last Modified Date:  08/11/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Spectrum

Releases

  • CA Spectrum:Release:10.2

Components

  • REPORTING:SPCRPT
  • CERTIFICATION:SPCCRT
Problem:

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. 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >