Create pageless (continuous) report

[devboyx]

 Hi,

New to iReport. I want to create an 'excel friendly' report, meaning it should not bet paged but rather be a table with column headers and a long list of records. This is so the end user consuming this report will be able to turn it into a pivot table easily. Is there a way to 'join' the pages so it's continuous?

 

Cheers,

DB 

[svenn]

What do you mean by "'join the pages so it's continuous"?

[devboyx]

 Well, currently I used the column header and detail sections. The query attached to the report generates a lot more records than can be displayed in one page. The result is a report comprised of multiple pages, each with the column headers. Furthermore when exported to excel, each 'page' is separated by a couple of empty excel sheet rows. I don't want the column headers more than once and I don't want row spaces between blocks of records.

The idea is (in this specific report) is to give the end user a UI to basically do a select out of the DB, dump it to an excel sheet and process from there.

 

Hope I explained well enough.

 

 

 

[svenn]

Instead of using the column header put your header information in the title band. It will be created once at the begining of the report.

Check out this FAQ for making an Excel friendly report

http://jasperforge.org//uploads/publish/jasperreportswebsite/trunk/faq.html#FAQ9

 

 

[devboyx]

 Hi again Svenn,

 

I tried what you proposed which got rid of the recurring column headers, but there is still a gap in the excel file a a few rows where the data switches pages. You can see in the attached a snapshot of how the HTML render looks like. The excel render simply places empty rows instead of this gap.

Any ideas?

Cheers,

DB

 

 

[devboyx]

Resolved!

The answer was actually a setting in OpenReports which I am using to serve my jasper files. Actually I think it is telling the jasper export engine to do something but I don't know if/what the exact jasper setting is.

There is a checkbox under  Administration -> Reports ->  Jasper Export Options, called 'Remove empty spaces between rows'. It needs to be checked and the export drops these empty rows.

 

Cheers,

DB

[mrpatch]

In the page dimensions for your report, set an improbably large height; this will suppress your page breaks and any associated headers/footers

[Filip.decock]

I had the same problem (10 years later :-) ), and found the parameter in Jaspersoft Studio.
In the 'Design' tab, go to the page setup and check the 'Ignore Pagination' parameter.
That's it.