JRCsvExporter - Header vs Data Columns

[2006 IR Open Discussion]

By: Andrew - affriedl

JRCsvExporter - Header vs Data Columns

2003-05-21 11:45

I just noticed that on my first real export to CSV that the header columns, and the data columns are out of sync.

 

column 1, is correct

column 2, is empty

column 3, contains only the header

column 4, contains only the data (no header)

column n, contains only the header

column n + 1, contains only the header

Column (final) is correct (header + data)

 

Now that I think about it... I believe something similar is occurring on my XLS reports too.

 

Thanks.

 

 

 

 

By: Andrew - affriedl

RE: JRCsvExporter - Header vs Data Columns

2003-05-22 11:38

This boils down to report design. If the headers and detal fields are even slightly off, CSV output will be off in the result.

 

 

 

 

By: Andrew - affriedl

RE: JRCsvExporter - Header vs Data Columns

2003-05-22 11:42

Forgot to mention, I wrote a class called JRRowDataFiller.java and compiled it into the core. I pass a variable in with the parameters to indicate that the report is only interested in ROWDATA (fields and column headers).

 

IS_ROW_DATA_ONLY = True

 

This java class ignores everything but the column header footer and data.

 

I find that this produces about the best CSV (and Raw XLS) output I have seen.

 

One problem I cannot seem to resolve is the problem of excessive spaces being appended to the end of the output.