Extra commas begin attached in CSV Export

[ashok_jasper]

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,

[Teodor Danciu]

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