[Space in the output when subreport has no data]

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]

[Reports with more pages]

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

[Report more than one page]

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

[displaying many pages with static content]

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]

[displaying many pages with static content]

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

[Exception in running a report]

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

[Error preparing statement executing report]

Hi,

Is the exception ("ERROR IN PREPARING STATEMENT") is solved????

 

Even i get the same exception even when iam not using subreport.

 

Please reply....

[Closed Statement Error]

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....

[Need Help in Scriplet]

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

[doubt in sub report]

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

[doubt in sub report]

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.