Jump to content
Changes to the Jaspersoft community edition download ×

Extra commas begin attached in CSV Export


ashok_jasper

Recommended Posts

In my report i have 3 bands

Title

[/ol]

Column Header[/ol]

Detail[/ol]

 

title has field format

 

field1,field2

field1,field2,field3,field4

field1,field2,field3,field4

field1,field2

field1,field2

 

column header and is detail

 

field1,field2field3,field4

 

 

But the final CSV export report is coming like this...

 

Report Name,top_evt_aggr_devices_ids,,,,,,

Customer,Guradant QA,, Report Date,,04/09/2007 03:42 PM,,

Start Date,01/01/2007 12:00 AM,, End Date,,07/01/2005 12:00 AM,,

Site,"Site 1, Site 2, Site 3, Site 1, Site 2, Site 3, Site 1, Site 2, Site 3, Site 1, Site 2, Site 3, Site 1, Site 2, Site 3, Site 1, Site 2, Site 3, Site 1, Site 2, Site 3, Site 1, Site 2, Site 3",,,,,,

Service,"Service 1, service 2",,,,,,

Devices Selected,"Device 1, Device 2, Device 3, Device 4, Device 5, Device 6, Device 7, Device 8, Device 9, Device 1, Device 2, Device 3, Device 4, Device 5, Device 6, Device 7, Device 8, Device 9, Device 1, Device 2, Device 3, Device 4, Device 5, Device 6, Device 7, Device 8, Device 9, Device 1, Device 2, Device 3, Device 4, Device 5, Device 6, Device 7, Device 8, Device 9",,,,,,

Note : All dates are displayed in UTC format,,,,,,,

Event Type,, Event Count,, % of Top 20,, % of All,

Built inbound TCP connection id for faddr,,1443163,,7.34,,3.11,

Built outbound UDP connection id for,,1139787,,5.8,,2.45,

URL accessed,,1059803,,5.39,,2.28,

Link to comment
Share on other sites

  • 2 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi,

 

The CSV exporter is a grid exporter and it tries to place everything in a grid. Empty cells are used for reproducing the alignment of the original page content.

If you don't want to see empty cells in your CSV file, than you have to make sure everything aligns perfectly in your initial JRXML template, like explained here:

http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/FAQ9

 

I hope this helps.

Teodor

Link to comment
Share on other sites

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...