riesvantwisk

Hello, iReport just says 'Generating Report' after 30 minutes I stopped the process, how can I debug this and how to figure out why this takes so long. Sometimes this happens when I changes something, and I can revert it back, However this time I asked somebody else to make the report so I have no idea where to look for the solution, if there is any.

hello! I am making a second version of a report I created in the past. The first report works fine with a XML datasource. My second report doesn't work good where I see some sub-reports repeated (but not all parts). Data is good as I see, just empty pages, or blank sub-reports. I am looking for a Jasper Reports + xpath person that can solve this and explain to me what I am doing wrong. My best estimate would be that he/she can explain this to me in a couple of hours (3-4) I will supply the XML files and working report, aswell as my new XML files and my new report jrxml files. Anybody the can give me a hand here? Please mail me at ries@vantwisk.nl Ries quito/Ecuador

I can second this on 3.7.1 what do people do to solve this? I can only assume lot's of people would complain.... Is there already a know run-around? Ries

hey All, I am using a subreport to generate additional data for a report. My subreport generates a graph and calls up additional sub-reports to create additional tables. Here are my options I tested: 1) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=7 or @pageno=6]") 2) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=7]") 3) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=6]") 4) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=6] | //page[@pageno=7]") 5) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page") 1) Does print my table, but my graph is empty2) Does print my table, but my graph is empty3) Does print my graph, but table is empty4) Does print my table, but my graph is empty5) Doesn't print graph or table data - The graph xpath expressions have been tested with full and partial XML data, so even when page7 is included, the data get's generated.- All xpath expressions have been tested in xpanther under firefox, I know not a authority on xpath correctness, but all expressions have been looked up against specifications.- No errors during report generation. I honestly don't understand why I cannot pass a sub data source consist of my two pages, afterall.. it's just XML, right? How would debug this problem? Usually I would step through code and find the problem, but iReport doesn't seem to have this capability using debuggers, or any way to output more sensible data, can it do that? My main problem now is, how to debug instead of trial and error changing things around? Ladtly, if I cannot figure it out. Anybody know a good company who can? (Against a normal hourly rate....) Ries

hey All, what is the best way to importy large XML files? I need to process XML files in the site of 500MB, but I keep on getting out of memory errors. Besides, processing XML looks a bit slow aswell (but it's not teh mayor problem). Ries

Teodor, well.. luckily there are more people that found the same sort of ghost so the ghost is quite visible however I will try to make a self-contained test case for you to checkout. Ries

Same problem here, try to use JExcelApiExporter and see if that solves your problem. I also tried jasperReports 3.1.4 with POI 3.2 final, but that didn't solve the problem. Ries

Same problem here, I started to use JExcelApiExporter instead of using JRXlsExporter, for the same report I have some color problem (rather colors that shift to a different color) but currently my client reports that it works better. BTW: In open office I don't have any problems opening the reports. Ries

I found the possible cauze, but I don't understand wyet why. Apparently when I use JExcelApiExporter I don't have the problem so it looks like there is a bug in JRXlsExporter or in the poi library?? is it correct to say that JRXlsExporter uses the POI libs?? Can anybody confirm/know something about this? Ries

I just updated to 3.1.4 with POI 3.2 with no change in the results. Question: Is it possible to tell jasperreports the output version of excel?? Ries

Hey All, I am getting the below error sometimes for my Escel 2003/excel2007 users. Excel found unreadable content in 'report.xml' Do you wsnt to recover the contents of this workbook? If you trust the source of this workblook click yes However open office opens that same document perfectly fine. Currently I have no idea why this happens, below the core I use to generate a report: All my data is in UTF-8, but I am sure that that couldn't be a issue.. When the users send me the repaired report, then at line xxx I see some garbaged characters, and that's all... in my own dataset I don't see anything that might cauze an issue (Data comes from PostgreSQL). Hopefully somebody has a clue what's going on. Ries Code: public String getJasperReport(List<Map<String, Object>> data, String basename, String reportname, String type) throws Exception { JasperReport jasperReport; JasperPrint jasperPrint; String filename=""; basename = basename + "_" + String.valueOf(ACL.getUserID()); JRListMapDataSource ds = new JRListMapDataSource(data); // Get path relative to our current deployment to find the temp directory Map<String, Object> params = new HashMap<String, Object>(); URL U = Thread.currentThread().getContextClassLoader().getResource("../../tmp"); // Load report InputStream strm = Thread.currentThread().getContextClassLoader().getResourceAsStream("../../jrxml/"+reportname+".jrxml"); jasperReport = JasperCompileManager.compileReport(strm); jasperPrint=JasperFillManager.fillReport(jasperReport, params, ds); // generates PDF if (type.compareTo("PDF") == 0) { filename = basename+".pdf"; JasperExportManager.exportReportToPdfFile(jasperPrint, U.getPath() + filename); } // generate XLS if (type.compareTo("XLS") == 0) { filename = basename+".xls"; JRXlsExporter exporterXLS = new JRXlsExporter(); File destFile = new File(U.getPath() + filename); exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint); exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_FILE_NAME, destFile.toString()); exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); exporterXLS.exportReport(); } return filename; }

Hey All, would it be better to close this forum and post questions in the general Jasper forums? Bobody seems to be here anyways Ries

From what I understand you are trying to put some values into a table. One of this tables cannot old the value you are trying to insert. Try changing some types in your oracle table to old teh value you are inputting. Ries

Hey All, I need command line switch to delete files, or not, For example I would like to run a job like this: java -Xms25......... --contect=windows --deletetmpfiles=true When deletetmpfiles is set to true I want to delete theses file, if set to false I want to keep them. See my image, I do have a component ok attached to the FileDelete_4? My idea is to read the switch using using some java and put that into a context, but I am not 100% sure how I can read that context and execute tFileDelete_4 or not.. Anybody got a good plan of attac for this? Ries

Like what anandharaj was saying, it's mostly resources that are un-available. It's currently kinda hard to explain to our client what they are seeing is really there fault. They have questions how to get back (back button doesn't always work in that case), and they have questions why it cannot tell us what was wrong. I can currently think of two solutions: 1) Don't run the report in the web context, but seperate so that the exception can be caught and shown within the application rather then the application bailing out completely, 2) Do a pre-flight check on the jrxml to see if everything is available to run the report. If not show a message of what was wrong. So far it seems to be only a case of missing re-sources though. Ries