felipinVzla

Well i have two questions about crosstab. 1.- Always iReport assume that we want show the column headers for each page?. If i put this value as false and save the report it never change, to do this i have to put this directly in the xml source file 'isRepeatColumnHeaders="false"'. The problem appear when i save the report again with iReport, the text isRepeatColumnHeaders="false" vanish from the xml source file. 2.- Why not add the total condition for news rowGroups or columnGroups?. Remember that the crosstab iReport wizard only allow 2 rowGroups or columGroups, but if need more this by default don't show the objects of the total cell. To solve that we need to put directly in the xml source file the text 'totalPosition="End"' for each row or column group that we want to see their totals. iReport don't do that second poitn by default?. For the first question why iReport don't keep the value checked in the select of "Repeat column headers", wetheaver it be?. The checked value for "Repeat row headers" works fine, it keeping in the xml source file. Regards.

Guys i think that the problem is this: I compare the groups, looking the xml source file and find that. The declaration of the row groups that is showing the total values include this propertie 'totalPosition="End"' and the others (the news row groups) don't do that. I put this value manually in the xml and now the total is showed fine. Regards.

At first, sorry for my english, sometimes is very bad. I'm using JR 1.3.1 and iReport 1.3.1. The report have a crosstab in the summary band. In the wizard of iReport i only can indicate two row groups but i need more, then i make the crosstab fisrtly with two row groups and after i add the news row groups. Until here all is ok. Then for the new row groups i edit the cell properties to add the total cell for the news row groups. The problem is happening when i export the report. For the new total cell of the news row groups the values aren't showed. In the xml estructure i don't see any problem. Well this is the xml source file for the report. Regards. [file name=DailySmsTraffic.xml size=34992]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/DailySmsTraffic.xml[/file]

greghilton wrote: teodord wrote: So we optimized memory consumption in JasperReports by using a report virtualizer, but we cannot do the same for the exporters, because we rely on third-party libraries such as POI or JExcelAPI which do not seem to have similar mechanisms. I was running into the same issue, so I took a look at JRXlsAbstractExporter. I believe I have come up with an approach that optimizes memory consumption even when IS_ONE_PAGE_PER_SHEET is false. The approach basically consists of making two passes over the pages in exportReportToStream. The first pass simply calculates all the xCut values. On the second pass, exportPage is called once per page rather than once at the end. The pre-calculated xCut values are passed to exportPage, and then on to the JRGridLayout constructor. JRGridLayout need only calculate the yCut values for that page. It can use the pre-calculated xCut values. This allows each page to be exported as it is hit rather than all elements on all pages being collected and exported at one time. This seems to work well for me, however, there may be side-effects that I haven't considered. I can provide the modified source code if this is something that interests you. Ok, good, please i like you provide me the modified source code. Many regards... :)

Well i can't replicate this error only is generated from a tomcat proyect that return a csv, html or excel file to the request user. And occurs few times. The issue is, i want to know if is possible, the common cause for this Exception. Thanks a lot...... I hope that you understand :) java.lang.ClassCastException: java.lang.Integer at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1029) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1050) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveReportBoundElements(JRBaseFiller.java:1067) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:821) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:259) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:135) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)

Hi, i'm using the jasperReports 1.2.5 and when fill a report of 40000 records results in a out of memory exception. The report use a DataSource not a DataBase connection. This problem is happening running the fill in my machine. Also this implementation take the rows in segments of 5000, using the methods of JRAbstractBeanDataSource class. I'm look the sample in demo/samples/virtualizer and the problem still. The jdk is 1.5.06 and the tomcat 5.5.17. And i want to know if the exportReport() method of JRAbstractExporter kepp the report in memory to do the export. Because exporting a excel a report of 65000 records don't work and repeat the out of memory exception. To the excel export i'm using JExcelApiExporter class. This problem is happening doing the report request to a server. Thanks...