rajil

Can you tell me what should i set in FlashVars. I have following directory structure. Tomcat | | -webapps | | -<project root dir> | | jasperreports-flash-3.0.0.swf | | -jspfiles(folder) | | - report.jsp I put .swf file in root folder of my apps. __________________________________________________ report.jsp file <% JasperPrint jp=(JasperPrint)request.getSession().getAttribute(BaseHttpServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE) ; out.print("<br> total pages :"+jp.getPages().size()); %> <object width="550" height="400"> <param name="movie" value="jasperreports-flash-3.0.0.swf"/> <embed src="jasperreports-flash-3.0.0.swf" FlashVars="jrpxml=servlets/xml?" width="550" height="400"> </embed> </object> __________________________________________________ report.jsp show me number of pages but flash viewer remain blank.

Hello, I tried above property to remove blank column.But still I am facing same problem. i.e. Excel file show blank columns. Details: List of Library that I used to generate report. 1. jxl-2.6.jar 2. poi-3.0.1-FINAL-20070705.jar 3. jasperreports-3.0.0.jar I attach 2 excel file with this post. 1. JRXlsExporter.xls generated using JRXlsExporter 2. JExcelApiExporter.xls generated using JExcelApiExporter To generate report I set following properties 1. IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS =true 2. IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS = true 3. IS_COLLAPSE_ROW_SPAN = true [file name=reports-0e556dbe2a7191f38e940f42fc1773cb.zip size=5065]

Hi lucianc, Thank you for this solution. - It works fine. I generated report arround 40,000 pages with small amount of memory usage and the file size is arround 130 MB. - Thanks again.

Well, Manual Serialization and De-serialization can be done. - But I found another problem. I am able to create and maintain JasperPrint Objects in memory and storing them in JasperPrintList. But BATCH EXPORT goes out of memory while exporting them. - There are around 1000+ jasper print objects and 9000+ pages. I can process even more pages and store them in List. But while BATCH EXPORT it goes out of memory. Is then any solution for this now? - I have tried following with 540 MB HeapSize (results of report run) - Result of 1st Run: Number of Pages : 7456 Total Time Taken : 9 Minutes (6 Mins to Query + 3 Minutes to Export) Generated File Size : 23.3 MB Average Database CPU Usage : < 10% Average Application CPU Usage: 40-60 % - Result of 2nd Run: Number of Pages : 8000 (Number of Jasper Print Objects in memory = 952 ) Total Time Taken : 64 Minutes (9 Mins to Query + 56 Minutes to Export) Generated File Size : 26.5 MB Average Database CPU Usage : < 10% Average Application CPU Usage: 40-60 % - More than 8000 Pages it goes out of Memory while Batch Export. - Also if I serialize the JasperPrint Objects. I will have to de-serialize them back to Print them using BatchExport in a List. But the BatchExport is not able to handle this many objects.

Hi. Thanks your reply. I want to use virtualizer because i am using BATCH_EXPORT feature of Jasper. I have lots of report to be exported in a single file. And there is only way to generate single file using multiple Jasper Print objects is to use BATCH_EXPORT. Now. Without using virtualizer, it works fine. But it consumes lots of memory due to List of Jasper Print objects of each report resides in memory in order to use BATCH_EXPORT. So. it would be better to use virtualizer using smaller amount of HeapSize to generate single file of Multiple JasperPrint objects using BATCH_EXPORT. Or any other suggestion to generate single file from multiple JasperPrint object would also be appreciated. But what i don't understand is why it goes out of memory if I use virtualizer.

Hi. I am facing some problem while creating JasperPrint objects using Virtualizer. Actually, i have total 5000 reports to generate. each having 2 pages. (5000*2 = 10000 Pages). I am using Batch Export to generate report in a single file. To do this i am saving all 5000 JasperPrint objects into an Array List and Export them to a single file. I am running this under Windows XP, Tomcat4.1, JDK 1.4, Jasper 3.0. Now, it consumes lots of memory. Arround 600 MB of HeapSize. I tried using all 3 Virtualizer, but it goes out of memory after processing only 2700 JasperPrint Objects even after setting HeapSize to 1.6 GB. But without using Virtualize its working fine. Also, I tried in both ways, using seperate Virtualizer Object for all JasperPrints (MaxSize=1) as well as using the same Virtualizer Object for all JasperPrints Objects (MaxSize=5001). But in both cases it goes out of memory. Can you suggest the solution.

Hi. I am facing some problem while creating JasperPrint objects using Virtualizer. Actually, i have total 5000 reports to generate. each having 2 pages. I am using Batch Export to generate report in a single file. To do this i am saving all 5000 JasperPrint objects into an Array List. and Export them to a single file. I am running this under Tomcat4.1, JDK 1.4, Jasper 3.0. Now, it consumes lots of memory. Arround 600 MB of HeapSize. I tried using all 3 Virtualizer, but it goes out of memory after processing only 2700 JasperPrint Objects even after setting HeapSize to 1.6 GB. But without using Virtualize its working fine. Also, I tried in both ways, using seperate Virtualizer Object for all JasperPrints (MaxSize=1) as well as using the same Virtualizer Object for all (MaxSize=5001). But in both cases it goes out of memory. Can you suggest the solution.