Report not generating due to large volume data

[saha.nabajyoti]

Hi Gurus,
 
I have a report which should give around 18000 pages after exporting as the query returns 6 lakh rows of record. It is giving me “Java heap space:out of memory” error after running. I have applied Virualization but it's also not working after trying different combination of max and min memory. I also tried with increasing the heap memory size in tomcat server but after increasing the size the server is not starting. It's giving saying “JasperserverTomacat cannot start”. Again we have a very complex design which includes 130 around variables ,so it is very diffult to handle it from database query side.Please suggest some solution so that we can run such large volume report in ireport designer/jasper server.
Please advice.