How to configure jasper reports server to only get records to fill current page (HTML format).

[rick251082]

I am using jasper reprots server (html format) to display report in my webapplication and this report is bringing in 100,000 records.

We have pagination available on top to the viewReport.jsp but i report is filling first with 100,000 records and then in html only displaying first 20 records which it can fit into first page as per report layout(we are using table element). It is taking a lot of time, what can be done to improve the responsiveness in this scenario and configure jasper pagination to just get first 20 records from DB instead of all the records and at the same time when we use option to export it to PDF, Excel it should run the whole query and render report using all the 100,000 records. Any help is appreciated.

[rick251082]

I was wrong. It does it page by page and as soon as first page is generated, it is ready at the frontend and engine continues to process further pages.

That way it is very responsive and it boils down to query how fast is it running.

[rajesh.majoju]

You using jasper reprots server (html format) to display report in my web application.

We need same requirement. Can you please tell me how can we develop reports in html format.

[rajesh.majoju]

You using jasper reprots server (html format) to display report in my web application.

We need same requirement. Can you please tell me how can we develop reports in html format.

 

[rick251082]

http://community.jaspersoft.com/wiki/embedding-using-http-api use this.