Using Sub report in jaspersoft studio 5.6.1

[bini]

I created the report using domain and my report has 1 sub report.When I preview the report in studio works fine but when i export it to server its giving me this error.

 

 

Error Message

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: java.lang.IllegalArgumentException: resource id: revenueRank does not exist

Error Trace

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: java.lang.IllegalArgumentException: resource id: revenueRank does not exist at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:848) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:383) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:358) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2026) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:754) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:124) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:540) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:882) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:838) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1727) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1082) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1011) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:904) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: net.sf.jasperreports.engine.JRException: java.lang.IllegalArgumentException: resource id: revenueRank does not exist at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:165) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) ... 3 more Caused by: java.lang.IllegalArgumentException: resource id: revenueRank does not exist at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.resolveDataSet(DomainDataStrategy.java:286) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getBaseQueryDataSet(DomainDataStrategy.java:182) at com.jaspersoft.ji.adhoc.strategy.DomainQueryDataStrategy.getBaseQueryDataSet(DomainQueryDataStrategy.java:38) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:690) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery(CommonDomainDataStrategy.java:636) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1135) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1123) at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:156) ... 11 more

Error Message

net.sf.jasperreports.engine.JRException: java.lang.IllegalArgumentException: resource id: revenueRank does not exist

Error Trace

net.sf.jasperreports.engine.JRException: java.lang.IllegalArgumentException: resource id: revenueRank does not exist at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:165) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.IllegalArgumentException: resource id: revenueRank does not exist at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.resolveDataSet(DomainDataStrategy.java:286) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getBaseQueryDataSet(DomainDataStrategy.java:182) at com.jaspersoft.ji.adhoc.strategy.DomainQueryDataStrategy.getBaseQueryDataSet(DomainQueryDataStrategy.java:38) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:690) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery(CommonDomainDataStrategy.java:636) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1135) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1123) at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:156) ... 11 more

Error Message

java.lang.IllegalArgumentException: resource id: revenueRank does not exist

Error Trace

java.lang.IllegalArgumentException: resource id: revenueRank does not exist at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.resolveDataSet(DomainDataStrategy.java:286) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getBaseQueryDataSet(DomainDataStrategy.java:182) at com.jaspersoft.ji.adhoc.strategy.DomainQueryDataStrategy.getBaseQueryDataSet(DomainQueryDataStrategy.java:38) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:690) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery(CommonDomainDataStrategy.java:636) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1135) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1123) at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:156) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) 

 

[gert_1]

Don't know what you mean with 'used Domain'? But here are some options from most likely to less likely:

 

• When you upload to server, it asks you to overwrite resources. Do not use 'overwrite = false'. I don't know why but it makes the report mess up. Alway do 'Overwrite = true'.
• If that doesn't work, login to server en remove all resources (right-click on report unit -> edit -> tab 'resources'). After that repeat step1, it may remove some junk and upload it the right way.
• Upgrade to newest workspace (you should do this anyway, new releases always eliminate some bugs) newest version is 6.0.3.

HHope it helps, let me know!

 

And PS. what version is your server on? (if these steps do not help)

[bini]

do I have to make any changes in sub report properties only these 2 options have values in it

Expression : "SUT.jasper"

 

Connection Expression: $P{REPORT_CONNECTION}

 

[akthar.itzme]

Hey I am also facing the same issue. Could anybody help me??? Its urgent!!!!!.

I am creating report book with another report as subreport which has domain as data source. It runs good in jasper studio but when expoted to server it throws below error.

java.lang.IllegalArgumentException: resource id: customerName does not exist  at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.resolveDataSet(DomainDataStrategy.java:286) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getBaseQueryDataSet(DomainDataStrategy.java:182) at com.jaspersoft.ji.adhoc.strategy.DomainQueryDataStrategy.getBaseQueryDataSet(DomainQueryDataStrategy.java:38) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:690) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery(CommonDomainDataStrategy.java:636) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1135) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1123) at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:156) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) 

help me soon pls...........

[bini]

Hi Akhtar

Insert the sub report in the main report and highlight the sub report to get the properties and click “Parameters” and add the 2 parameters mention below

slFactory $P{slFactory}

slSchema $P{slSchema}

Thats how i resolved my issuse.

 

[bini]

Hi Akhtar

 

Insert the sub report in the main report and highlight the sub report to get the properties and click “Parameters” and add the 2 parameters mention below

 

slFactory $P{slFactory}

 

slSchema $P{slSchema}

 

Thats how i resolved my issuse.

 

[akthar.itzme]

Its great bini. I got it at last. Thank you very much.

 

I need to add another question to it. If you pls reply it.

I need to create report book in jasper studio using the reports created from domain and adhoc view in the jasper server. Kindly help me, How to add the server reports to report book and run it?

[littleredshack]

I had exactly the same problem with a report that uses a domain data source in a reportbook. Added the two paramters slSchema and slFactory and hey presto.

 

Does anyone ever test this product before releasing it ??