To generate excel report without page break with virtualizer enabled

[prooban]

Hi,

 

I want to generate excel report without page break and only showing column header in the first page.

As my report size is big one, I am using virtualizer (JRSwapFileVirtualizer). In order to make the virtualizer work I need to set the JRParameter.IS_IGNORE_PAGINATION to false.

 

But if I set JRParameter.IS_IGNORE_PAGINATION to false then report is getting generated with page break and column header in each page.

 

So how to generate report without page break and without repeating column header in  each page (one long report) with virtualizer enabled?

 

I have attached the report which I am getting.

[Thomas Zimmer]

This issue was addressed several times: http://community.jaspersoft.com/jasperreports-library/issues/4594 , http://community.jaspersoft.com/questions/530836/ignore-pagination-and-virtualizers

However, I can not see a solution in the discussions.

Did you try to use band filters? With them, you could achive the same xls-view without pagination:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}

and 

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name}

But I do not know how it works in conjunction with file virtualizer (but i don't think that should make problems)

Cheers, Thomas

http://www.thomaszimmer.net

[prooban]

Hi Thomas,

 

Thank you very much. The solution is working fine.