CSV export incompatibilities between Business Objects and JasperSoft

Document ID:  TEC1049352
Last Modified Date:  06/07/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Spectrum

Releases

  • CA Spectrum:Release:10.2
  • CA Spectrum:Release:10.2.1

Components

  • JASPERSOFT FOR CA SPECTRUM:SPCJSP
  • REPORTING:SPCRPT
Issue:

The CSV data export option produces different output . The exported data in BOXI has only one set of column headers all neatly aligned with the data below. In Jaspersoft, the column headers don't properly align with the data below. Also, column headers are repeated throughout the export as well as page numbers.

Environment:
Spectrum 10.2.x CABI 4.3 (Business Objects) CABI 6.3 (Jaspersoft)
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.columns=true

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.band.8=groupFooter

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

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

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

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

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

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

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

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

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

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

 

Run the reports with the export. The format should now match that of Business Objects.

 

 

 

 

 

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 >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing