henryedsl

Hi all, I have a report designed with iReport 5.0.1 which is OK except that when it returns about 10000 or more rows from database, returns the next error: GRAVE: Error executing SQL statement for : rep_asignacion_inicialnet.sf.jasperreports.engine.JRException: Error executing SQL statement for : rep_asignacion_inicial at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:849) at org.openxava.actions.JasperReportBaseAction.execute(JasperReportBaseAction.java:105) at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:374) at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:291) at org.openxava.controller.ModuleManager.execute(ModuleManager.java:251) at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:177) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66) at org.openxava.web.dwr.Module.getURIAsStream(Module.java:182) at org.openxava.web.dwr.Module.request(Module.java:63) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283) at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52) at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101) at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.admon.db.globales.modelo.FiltroUsuarioLifeRay.doFilter(FiltroUsuarioLifeRay.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.insisto.general.security.utils.LifeTimeFilter.doFilter(LifeTimeFilter.java:143) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:662)Caused by: org.postgresql.util.PSQLException: Ran out of memory retrieving query results. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1857) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 58 moreCaused by: java.lang.OutOfMemoryError: Java heap space at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:359) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1854) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:849) at org.openxava.actions.JasperReportBaseAction.execute(JasperReportBaseAction.java:105) at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:374) at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:291) at org.openxava.controller.ModuleManager.execute(ModuleManager.java:251) at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:177) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)[/code] I set net.sf.jasperreports.jdbc.fetch.size property to different values with no success. This report is executed from a java web application. I am using a PostgreSQL database, and jdbc4. I'd really appreciate any help. Thanks in advance.

I even copied the jasperreports-fonts-4.1.3.jar located in iReport-4.1.3/ireport/modules/ext into the WEB-INF/lib folder of my application -replacing the one that I created- and still getting the same error.

Hello, I've created a report where I'm using different fonts such as Arial, Verdana etc. I'm getting the error "Font Verdana is not available to the JVM"... so I created Font Extensions using iReport. I added the generated .jar to the WEB-INF/lib of my web application. When I put the font_extensions.jar I created into the lib folder I'm getting an error which I've not been able to solve after searching and searching the web and the forums. I attached the font_extensions.jar and the .jrxml just in case you want to take a look. I appreciate your time and help. Best regards... PS: I'm using iReport-4.1.3 and jasperreports-4.1.3. This is the error that I'm getting: Code: Post Edited by henryedsl at 01/26/2012 22:12

Hi! Here i found the solution that worked for me: jasperforge.org/plugins/espforum/view.php Here you can find another post which although didn't work for me maybe could be usefull for someone else: jasperforge.org/plugins/espforum/view.php God bless you all. Best regards, Henry

Hi! A certain field in my report must be displayed only when the total number of pages is greater than 1, displayed in every page of the report. If the report has only 1 page, then there is no need to display this field. I know that PAGE_NUMBER with evaluationTime="Report" will display the number of pages in the report, but the problem is that i need this in the printWhenExpression of the field. Is there a way to do something like: new Boolean($V{TOTAL_PAGE_NUMBER}.intValue() > 1) So this field is displayed in every page only when the total number of pages is greater than 1? I didn't fint anything in the forums. Thanks in advance. Best regards, Henry

Hello! I need to set the number of rows per page to a certain number, say 3. For example, how can i do to set the number of rows displayed per page to 3? I found this thread: jasperforge.org/plugins/espforum/view.php There, one of the users said to add a manual page break and use the Record_Count to enable the break every X records. I'm using iReport 4.0.0 but i haven't been able to insert a page break, i can't find that option in iReport, in fact i'm not sure whether that option is available yet. Best regards, Henry

Above, i meant that the report footer is displayed at the bottom of each page in the report.

Hello! I have something like an invoice report. I have placed a detail band, a group footer which is getting displayed once per group, a column footer and a report footer which is displayed at the bottom of the report. Everything works fine, but i have not been able to fill the space left between the column footer and the report footer when the report has only a few records printed in the detail band. I attached two files, in the first one you can see the space that i don't want in my report, and in the second file you can see the report i'm trying to design, the good one, there, you can't see any space, in fact, it seem that the lines are drawn to fill the spaces. PD: excuse me that the attached files are in spanish, but i think you can get the idea. Best regards, Henry

By the way, i attach the jar file i added to my application, in case it helps. I also have to say that i packaged up my font extension in a separate JAR.

I forgot the attached file with the error.

I just realized that i'm getting an error in tomcat logs, i attached the file with the error. I guess it has to do with the fact that i added my jar file generated with iReport to the classpath of my application.

Ohh excuse me, the last attched file should have been "installing arial" :)

Hello! I have created a JasperReports report with the bold fonts in the iReport. The PDF preview in the iReport is OK, but when i export to PDF in my application, all font properties get lost and the text looks like plain text. This is what i tried to do with no success: 1. Using iReport, i made sure that all the fonts i used in my report have been defined in iReport. I went to Tools -> Options -> iReport -> Fonts, and installed Verdana, which is one of the fonts i'm using. When installing this font, i made sure to check "Embed this font in PDF document" checkbox. 2. Once all the fonts were installed, i selected all the fonts i used in my report and then clicked the “Export as extension” button to create a jar file. 3. Finally i added the created jar file to the classpath of my application, at this point i thought i was done :( But, after doing all this and runnind my application, i realized that the problem was still there, and the worst part is that i don't know what else to do. Am i missing something? What do i have to do so that bold fonts show properly in PDFs exported from my application? Some additional data: I have OpenSuSe as OS. I have attached three documents so that you can see the good report, the bad report, and the window where i installed the trutype fonts. I'm using iReport 3.7.2 Thanks in advance for your time and help. Best regards... Post Edited by henryedsl at 01/25/2011 19:56

Hello! I solved my problem, i dont know whether it's been the best solution or not, but it's working for me :) This is what i did: In the SQL sentence a created 3 extra columns, like this: SELECT *, case when continent_id = 1 then 'America' else null end as america_country, case when continent_id = 2 then 'Europe' else null end as europe_country, case when continent_id = 3 then 'Asia' else null end as asia_country, FROM countries; Now, in the report this is what i set to every variable i created: TOTAL_AMERICA_COUNTRIES Type: Integer Calculation: Count Reset type: Report Variable Expression: $F{america_country} TOTAL_EUROPE_COUNTRIES Type: Integer Calculation: Count Reset type: Report Variable Expression: $F{europe_country} TOTAL_ASIA_COUNTRIES Type: Integer Calculation: Count Reset type: Report Variable Expression: $F{asia_country} Best regards.

Hello guys. I'm gonna try to explain my issue with a little example. Let's suposse i have a report that shows countries from all over the world, like this: Country - Continent USA - America Canada - America England - Europe Spain - Europe France - Europe Japan - Asia China - Asia In the Summary section of the report, i want to show the number of countries per continent. According to the example above, the report should show something like this: America total countries: 2 Europe total countries: 3 Asia total countries: 2 I have 3 variables: TOTAL_AMERICA_COUNTRIES, TOTAL_EUROPE_COUNTRIES, TOTAL_ASIA_COUNTRIES Type: Integer Calculation: Count Reset type: Report But i dont know how to exactly make this variables to show the number of countries per continent. I hope you can give me a hand. Thanks a lot for your help. Best regards.