• Post Reply Bookmark Topic Watch Topic
  • New Topic

Display all records in single excel page  RSS feed

 
Rajendra Prakash
Ranch Hand
Posts: 293
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I developed a Servlet application to generate report from a database using JasperReport to create the reports
With small report all works, but when generating a large report (about 200000 rows of 15 coloums splitted in two or more sheets of 65536 rows, using the MAX_ROW_PER_ SHEET property in JasperReport) the Out of Memory bring up!
i want to display all records in single sheet
 
prem pillai
Ranch Hand
Posts: 87
Java Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Add more details to understand the overall probelm context ; For example you haven't specified , how is this report going to be accessed by user , capacilty of the production hardware etc.

Generating report fragments and then combining them would be one way of doing it. But need more details around the problem domain to check the feasibility of such solutions.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!