senthil_teen

Hi all, I have a Main report and subreport and i will pass a parameter to the subreport query from the main report query. In the Main Report i have some space in the place of the subreport if the subreport have no data for the corresponding parameter passed. Please find the PDF and the XML for the main report attatched...... In the PDF file attached,check from the last page there are empty pages since the subreport has no data. Can anyone provide me a solution??? Thanks in advance Senthil [file name=Output.pdf size=19062]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Output.pdf[/file]

Hi all, I want to design a report which has many pages... Static Contents differs in each page.I don know how to design that in IReport. Iam using IReport 1.2.8.... Can anyone provide me a solution with an example???? Thanks in advance Senthil

Hi all, I don know how to design a report which has more than 5 or 6 pages. which is similar to the following Param1 field1 Param2 field2 Param3 field3 ------- ----- Param1 is static and field is retreived from query. Iam using IReport 1.2.8 I got stuck in this situation. Can Anyone help me in this situation clearly. Thanks in advance Senthil

Hi Teodor, Thanks for ur reply.... This is wat i did. i created a simple report in Ireport 1.2.8 with a simple query which has 12 fields in it.(Just wanna print the 12 values in 12 different pages). I tested by creating 12 groups as follows <group name="g1" isStartNewPage="true" > <groupExpression><![CDATA[$V{REPORT_COUNT}]] ></groupExpression> <groupHeader> I did the same for all the 12 Groups. But it din work.... Is my approach is correct?? can u correct if am wrong??? Please check the XML file attached for the sample report. Thanks and Regards Senthil [file name=ContentTesting.xml size=25776]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ContentTesting.xml[/file]

Hi all, I hav a Problem.I have to display many pages of static content.I don know how to do that???? Is that possible????? Can anyone provide me a solution in this situation????? Thanks in advance Senthil

Hi , Iam encountering a strange problm in my project. Here is the situation. I have a screen where i execute multiple select,insert queries.At the same time if another user connects to the same server and runs a report encorporated in my project designed using IReports. i get an STRANGE EXCEPTION.I get this only when when i run the above mentioned screen. In my Project i use the following code to get the connection to excecute the queries for my logic and not for executing the report query.... public static Connection getConnection() throws SQLException{ if(con != null && !(con.isClosed())) { return con; } DataSource ds = null; try{ ds = (DataSource)ContextWrapper.lookup("java:/PostgresDS"); con = ds.getConnection(); } catch(Exception e){ e.printStackTrace(); } return con; } THE EXCEPTION WHICH I GET IN THE SERVER IS at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.j ava:164) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter. java:103) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:673 ) at net.sf.jasperreports.engine.fill.JRFillDataset.setDatasource(JRFillDataset.java:610) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:599) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:683) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:641) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:203) at com.htc.egov.framework.report.servlet.ReportServlet.generatePDF(Unknown Source) at com.htc.egov.framework.report.servlet.ReportServlet.process(Unknown Source) at com.htc.egov.framework.report.servlet.ReportServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.jav a:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.htc.egov.framework.web.AuthorizationFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.jav a:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.jav a:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java :153) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Pro tocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Connection handle has been closed and is unusable at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:737) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:7 21) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:2 02) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.j ava:142) ... 52 more net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : AT THE SAME TIME THE MESSAGE WHICH I GET IN THE REPORT WINDOW IS net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : select period_name, ORGS.ORGS_ID, PRS.PRS_ID, PRS.PERSON, RO.RO_DESCRIPTION, PMG.GRD_ID, ACPS.D_AMOUNT, PRS.PRS_DATE_OF_JOIN, RGNO.REGISTRATION_NUMBER from vu_pma_persons prs left outer join pma_grade pmg on prs.prs_grd_sk = pmg.grd_sk, actual_payslip ACPS, pay_period pp, PMA_ORG_PERSON_ROLES OPR, PMA_ORGANIZATION_STRUCTURES ORGS, PMA_ROLES RO, E_D_TYPE EDT, PMA_NATURE_OF_JOBS NOJ, bp_business_partner bp, bp_registration_number RGNO, bp_registration_type RGT where bp.business_partner_sk = prs.prs_bpc_party_sk and ACPS.pay_period_sk = pp.pay_period_sk and ACPS.prs_sk = prs.prs_sk and OPR_PRS_SK = PRS.PRS_SK and OPR.OPR_ORGS_SK = ORGS.ORGS_SK and OPR.OPR_RO_SK = RO.RO_SK and ACPS.E_D_TYPE_SK = EDT.E_D_TYPE_SK and EDT.E_D_TYPE_CODE = 'CTDRD' and PRS.prs_noj_sk = NOJ.NOJ_SK AND RO.RO_IS_SALARIED ='Y' and OPR.OPR_PRIMARY_FLAG ='Y' and pp.pay_period_sk = 12 and rgno.business_partner_sk = bp.business_partner_sk AND RGT.REGISTRATION_TYPE = 'RD_NUMBER' AND RGT.REGISTRATION_TYPE_SK=RGNO.REGISTRATION_TYPE_SK and acps.arrear_flag = 'N' and ORGS.ORGS_IS_PAY_APPLICABLE='Y' order by PRS.PRS_ID Can Anyone Help me in this situation....... Thanks in advance Post edited by: senthil_teen, at: 2007/01/22 05:35

Hi, Is the exception ("ERROR IN PREPARING STATEMENT") is solved???? Even i get the same exception even when iam not using subreport. Please reply....

Hi Allan, I also get the same exception "Statement is closed" while running a report. I went thru the steps which is mentioned in ur thread.But iam not able to undestand. Can u tell me to solve the steps in DETAIL..... Thanks in Advance....

Hi all, am beginner to IReport.my project uses IReport 0.4.0. I need to use a scriplet when the Page initialises. can tell me the steps in doin it.... Thanks in advance...... Senthil

Do i have that option in IReport 0.4.0. because in subreport(others) i have an option to enter the subreport parameters. if yes can u explain me how to do that????? Here is the scenario In main report i have two sub reports and the subreport queries return a single value(totally 2 values).I will display those two values in the main report and finally i hav to add those displayed values in the main report......... How do we go about it??????? Thanks in advance Senthil Post edited by: senthil_teen, at: 2006/08/18 11:05

Hi all, I have one Main Report and two subreports which is included in the main report. In both the subreports iam usin a count query which i will be displaying in the main report.In the Main report i need to add those two values whih i got from two different sub reports.