kiran_raja

I was able to view the popup on right clicking and selecting the "format cells" option in the excel file you have uploaded. I am using office 2003. Well recently i had faced a similar issue in the excel files exported from jasper reports. In jrxml file for <textfield> tag i had either not given a foreground color for the text or in some cases set the foreground color to "black"(forecolor="black"). This was the issue, when i set for all the <statictext> and <textfield> the forecolor as #060404, everything worked perfectly well.

Hi, Is there a minimum RAM size requirement to run Jasper reports engine. We are generating jasper reports which is exported to excel files (which run up to 9000+ rows per sheet[has 5 sheets]) and we infrequently face memory issues. Is there a minimum RAM requirement specified by jasper, so that we will not get these error at all? Thanks

i am using jasper reports 3.1.0 Found that if we use forecolor="black" for report element in TextField , then this issue is faced. So i changed the forecolor to "#060404" and the issue was solved.

Hi, I have generated/exported the jasper report to an excel file. When i open in MSExcel an try to format the cell format manually there is no change at all. That is I first try to bold the cell value, then try to Italized the font in the cell, there is no changes. Also if i right click the cell value with the mouse and select "Format Cells" from the menu, then no popup appears. Now If i first underline the value in the cell and then select to bold the text in the cell. Then it works fine. that is, all the formatting works :) , only if i first underline the cell value and then apply other formatting changes. So i have to first underline and then do other changes.This is a work around only. I want to know how i can bold the text in the cell at first selection only. Thanks in advance. Post Edited by kiran_raja at 04/06/2010 03:52

I am facing the same problem. As mentioned in the post before post. The popup doesnt appear on right clicking and selecting the format cells option. I have attached a sample file for your reference.

Hi, I have a peculiar problem. After jasper creates report in excel format. when i open the report and print preview the sheets. The fonts appear in different colours. That is, the colour of fonts in my reports are black. But when i print preview the reports sheets, the font appears in blue or green or red . If i am using a black and white printer. Then print preview shows the font colour as white or light grey. Can any body help me to resolve this issue. Thanks in advance, Regards Kiran

Hi, Further research as taken me to the thread http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=57166. Which i believe can slove my problem. Any other method to reduce jasperprint size is highly appreciated. Thanks Kiran

Hi all, I have gone a step further and serialized my jasperprint objects in the primary storage. I saw a example code posted by Lucian on this forum about a serialized list. This list picks the serialized files one by one during export , hence the memory used is considerably reduced and reports are generated for 40,000 records like a charm.(My Application memory heap size is 512MB) Now , in my application, i came across a scenario where i have to handle some 50,000 records. I am getting the out of memory error again. I saw that the jasperprint objects size created is 40MB+ each. Now when the exporter deserializes the file to genrate the final report , i am getting this error. Can anything be done to reduce the Jasperprint object size. that will help the exporter to use lesser memory space. Any help would be greatly appreciated. I also had a question, whether the virtualizer can be used while exporting the report. If yes, can anyone share the procedure/code. Thanks in advance, - Kiran Post Edited by kiran_raja at 11/06/2009 11:23

Hi , I have an requirement where my datasource contains lists of list,that is, i have created a list containing 3 lists. And each list values must be listed in 3 different sheets(there are about 9000+ records in each list). All the three sheets make use the same jrxml file. Is there a way that i can pass my datasource to JasperFillManager and it creates 3 sheets in one call.Please help. I am presently, iterating the list and calling JasperFillManagert to create 3 JasperPrint Objects. And then merging them into in one report by setting the JRExporterParameter.JASPER_PRINT_LIST parameter.This is taking a lot of memory, and in some instances goes out of memory. I need to avoid creating three jasperprint objects and the filling has to be done in one call so that i have only one jasper print object to export. Thanks, Kiran