JasperReport CSV export has extra comma for stretched textfields

0

With Jasper Report 6.3.0, I am trying to export report to PDF & CSV format. With PDF format, it exports fine, I am facing an issue with CSV export.

Here is the snapshot of my report file.

Please note that there are some fields are extended to multiple fields.

Now when I export report to CSV, it shows as many commas as the fields are merged form other band. So for in stance in above scenario exported CSV has content like:

`12/19/2017 00:00 IST`,`All Segments`,`1`,`1 (100.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`
`Totals for instance`,,`1`,`1 (100.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`
`Totals`,,`5`,`5 (100.00 %)`,`0 (0.00 %)`,`0 (0.00 %)`,`4 (80.00 %)`,`0 (0.00 %)`
`Jan 10, 2018 7:16:40 PM`,,,,`Page 1 of`,` 1`,,

I have set field enclosure to (`)

Any idea how can we nullify extra commas in CSV export?

parthbhagat's picture
Joined: Aug 22 2010 - 11:26pm
Last seen: 1 year 4 months ago

0 Answers:

No answers yet
Feedback
randomness