Make one page report

[sandyclawz]

I want one page export in Excel. When I export from JasperServer to excel it make repeating header each 104 rows on one sheet.

In file $JASPER_ROOT/WEB-INF/applicationContext.xml and $JASPER_ROOT/WEB-INF/applicationContext-report-scheduling.xml. in "export parameters" section is special setting:

<property name="onePagePerSheet" value="true"/>But it make each page on separate sheet. So it even worse.For example I wanna all 2000 rows to be placed in a single Excel file. Is it possible, maybe with settings: [/code]

<property name="paginatorItemsPerPage" value="20"></property><property name="paginatorPagesRange" value="3"></property><property name="reportLevelConfigurable" value="false"/><property name="paginationForSinglePageReport" value="false"/>[/code]

[mmflynn]

Hi sandyclawz,

 

Try this:

 

Open your report in iReport. Under Report Properties, select  "Ignore Pagination". Save the file to JasperServer. The next time you run the report, everything will be on one page. Note the "Ignore Pagination" setting applies to all export formats, including HTML.

 

Good luck,

Mary

[sandyclawz]

Thanks for your answer!