XLS / CSV Exporter - Element Supression

[2006 IR Open Discussion]

By: Andrew - affriedl

XLS / CSV Exporter - Element Supression

2003-05-21 09:02

I would be very nice to be able to suppress individual elements (like the Report Title, footers and headers) in CSV and XLS exports. Could this be added via parameters? My company may be able to provide me the time to work on this.

 

Also, having CSV all in one page would be helpful as well.

 

 

 

 

By: Gregory A. Swarthout - gswarthout

RE: XLS / CSV Exporter - Element Supression

2003-05-21 10:32

I pass in the outputType as a parameter and then do the following:

 

<columnHeader>

<band height="32">

<printWhenExpression>

new Boolean($V{PAGE_NUMBER}.intValue() == 1 ||

(!$P{outputType}.equalsIgnoreCase("xls") <![CDATA[&&]]> !$P{outputType}.equalsIgnoreCase("csv")))

</printWhenExpression>

etc...

 

so that for XLS and CSV files the column header is only printed once

 

 

 

 

By: Andrew - affriedl

RE: XLS / CSV Exporter - Element Supression

2003-05-21 11:13

Thanks for the idea, I'm sure that I can make that work.

 

Andrew

 

 

 

 

By: Andrew - affriedl

RE: XLS / CSV Exporter - Element Supression

2003-05-21 11:16

Thanks for the idea, I'm sure that I can make that work.

 

Andrew