Availability-Group Report as CSV has additional lines and meaningless empty columns at the end

Products

• Spectrum

Issue/Introduction

Exporting the Availability-Group Report in CSV format the file contains after the last field value a new line with several comma (,,,,,)
example:
<some-customer-name>-<home>-<itemName>,Pingable,5 Days + 19:18:03,2,81.277%,
,,,,,                                        
<some-customer-name>-<home>-<itemName>,SwCiscoIOS,1 Day + 05:03:10,5,96.095%,
,,,,,    
Why? Is it possible to remove these new lines?
 

Environment

Jaspersoft 6.4.3, Spectrum 10.3

Resolution

The Linefeed at the end of each row in the csv format is due to Jasper's limitation.

---> When exporting the Jasper Report to a .csv file, each line has a "Linefeed" at the end. (It is because of the condition status what we show in Red/Green/Yellow color in a text field inside a text field. It is the Jasper design limitation.)
---> Because of the design (where the Condition color is placed in the text field inside a text field), to maintain the gap and distinguish between two rows (two colors) the inner text field is adjusted to fit in the row textbox and maintained a gap to top and bottom alignments.. Jasper creates a new row when it finds this kind of gap and translates this as the Row splitter when we export to Excel / CSV.

This is a known anomaly in Jasper Design.

This has been discussed with CABI team also. If we want to remove that extra line then the UI look and feel will be changed. Below are screenshots of both current and new changes. With that new design, the new line feeds/extra line in the csv / excel will be removed.

Note that this modification would require a code fix.

What showed above was just a one time solution for that specific case and Spectrum and CABI versions. This was obtained removing the space around the text box by expanding the width to row length. 

However, because of the fix, the UI look will also change and would then require to apply the same design to all other reports for consistency. 

For this reason a code fix was not delivered, and will not be created, because the UI design will be changed as well, and this has to be consistent across all the reports.