Repeating column headers in excel

[sudha_ramaiah]

We have three different reports PDF,EXCEL and html.Paginaiton has to be done for PDF whearas in Excel it should not.In excel,it has to fill continuosly till the max rows allowed in the excel and then it has to move on to the next sheet.

I tried with the IS_ONE_PAGE_PER_SHEET making false and also isIgnorePagination for Excel.It worked but the column headers repeat inbetween.I tried moving the column headers to page headers but it not work out.Please help me in avoiding the repeating colum headers in excel.

[bep]

I'm having the exact same problem.

[wegnerk]

I had a similar problem and i solved it by a parameter fileformat and the pagenumber.

 

the fileformat is a parameter which comes from my java application and contains pdf, xls or something.

 

Now, i used the printWhenExpression for the bands pageheader/columnheader. So, if the fileformat is xls and the pagenumber is higher than 1, don't print these bands. For pdf, print it always.

 

When exporting to xls, i also used the

Code:

(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE)

 

I hope this helps a bit