[Converting Business Objects Reports to Jaspersoft]

Hi,

I am working on same module.

Do you have find any solution for migrating BO reports in Jasper.

Please let me know if you have find any solution.

 

Thanks in advance.

Sandesh

[Subreport in Subreport help]

Thanks a lot for urgent Reply.

 

I tried with repor:SubReport name but it's not working.Can you please suggest hwat should be exact <SubReport Expression> so that it will compile properly. Actually I am creating new JRXMLs in iReport and Deployed(Running) on JasperServer.When I tring to run on jasperserver then it's giving Exception as net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist.

 

Please help me.

Thanks.

[Subreport in Subreport help]

I am stuck on one Sub report issue.

Issue details are as  follows.

If I give Sub Report path in  iReport as  $P{SUBREPORT_DIR} + "AERSINJASPER_SITES.jasper"   then in Jasper server  gives

this exception:-

Error Trace:  

net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist.

net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist.

at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:491)

at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:506)

at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:146)

at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:130)

at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.<init>(JSControlledJdbcQueryExecuter.java:64)

at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuterFactory.createQueryExecuter(JSControlledJdbcQueryExecuterFactory.java:25)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:678)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:601)

at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1247)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826)

at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:557)

at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)

at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)

at java.lang.Thread.run(Thread.java:595)

 

For this exception I searched on Internet and found that  path should be  “repo: AERSINJASPER_SITES” but with this path it is not compiling in iReport.

So I am stuck on exactly what Sub Report path need to give in Sub Report expression.

Please Help me.

 

Thanks in Advance  :)