csv format: how to get carriage returns at the end of the lines?

[angie.zhou]

 Hi

When we generate a report in csv format, there is No carriage returns at the end of the lines.

Jasper: csv

standard csv

 

[hozawa]

Set the following property:

net.sf.jasperreports.export.csv.record.delimiter

FYI, there's also following property to set character to delimit fields:

net.sf.jasperreports.export.csv.field.delimiter

[LuttermJ]

After many frustrating hours, trying to solve the exact same problem ... I have a "simple" solution:

1. Open the "properties" for your project (<abc>.jrxml)
2. Select Jaspersoft Studio
3. Select Exporters
4. Select CSV Exporter
5. Choose whether you want to make this change globally (i.e. Workspace), or only for the "Project", or only for the "File"
6. In the "Record Delimiter" field enter "rn" (without quotes)

I found that when entering "nr", as recommended by Jaspersoft ... then the .CSV file contains <LF><CR>, which is not properly interpreted/displayed by Windows ... causing the very long line without apparent breaks.

Jon