export "Detailed Event Log: Group" jasper report in CSV file repeated date columns

Products

• CA Spectrum

Issue/Introduction

Exporting the "Detailed Event Log: Group" jasper report in a CSV file you may get in the middle of the output the following columns header eg:

How is it possible to remove these and have them only on the first page at beginning of report but not in the middle of the output csv file?

 

Environment

Release : 10.4.1

Component : Spectrum Core / SpectroSERVER

Resolution

Modify the jasperreport.properties file and add the following lines:

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.keep.first.band.1=groupHeader
net.sf.jasperreports.export.csv.exclude.origin.keep.first.group.1=Group Name
net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.1=Detailed Event Log Group
net.sf.jasperreports.export.csv.parameters.override.IgnorePagination=true