To generate excel report without page break with virtualizer enabled

0

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.
prooban's picture
Joined: Jun 24 2013 - 5:52am
Last seen: 6 years 3 weeks ago

1 Answer:

1

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

Thomas Zimmer's picture
Joined: Oct 2 2012 - 1:35am
Last seen: 5 days 11 hours ago

Hi Thomas,

Thank you very much. The solution is working fine.

prooban - 6 years 4 months ago
Feedback
randomness