Jump to content
We've recently updated our Privacy Statement, available here ×

JasperReport CSV export has extra comma for stretched textfields


parthbhagat

Recommended Posts

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.

nLlj0.png

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?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...