lotion46

Not so easy to say... this is impacted by many parameters but the more RAM the better and don't forget to release the RAM for iR. have also look to this tread: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=50622

So the error happens while report generation. I tried it with the virtualizer (all kinds) but the report still won't be created. In 2.04 it takes round about 15 minutes to get the report but 3.5.2 has even after two hours not finished.

I would try to manage that within the SQL statement using a case when function. Then set both textfields to "print in first whole band"

Hi, I also get an "out of memory" error while generating an excel export. Above mentioned hints are not working or respectively it's not clear to me what to do exactly. But I´m surprised that my report works with IR 2.04 but not with IR 3.5.2. Post Edited by lotion46 at 07/23/2009 10:45

Nothing special. Just display the filter so the report is fully prepared to work with. Otherwise everybody who is using the report have to display the filter for every page on his own. A pre-definition of the filter is not necessary in this case. (see attachment) Also nice would be a similar function to fix the header (simple excel function)

Dear all, I'm looking for a option how to set the Autofilter in Excel. We provide our reports via a web application based on Websphere 6. For our users it would be great if this filter is already set since we have some reports with many worksheets within one workbook. In Excel produced XML it's quiet easy but how to tell iReport or Jasper: </WorksheetOptions> <AutoFilter x:Range="R1C1:R1C2" xmlns="urn:schemas-microsoft-com:office:excel"> </AutoFilter> Has anybody an idea or is impossible? Post Edited by lotion46 at 07/22/2009 15:15