To generate excel report without page break with virtualizer enabled

Posted on June 24, 2013 at 6:16am

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.
Attachments: 
Office spreadsheet icon bettu_24.06.13_18-07.xls
JasperReports® Library
prooban's picture
prooban
5
Joined: Jun 24 2013 - 5:52am
Last seen: 9 years 5 months ago

1 Answer:

Posted on June 24, 2013 at 11:06am

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
Thomas Zimmer
4099
Joined: Oct 2 2012 - 1:35am
Last seen: 10 hours 34 min ago

Hi Thomas,

Thank you very much. The solution is working fine.

prooban - 9 years 8 months ago
add comment
Feedback