parthbhagat Posted January 22, 2018 Share Posted January 22, 2018 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? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now