ujjawalkhare11

Hi, Please help me to pass a parameter in my ireport so that i can use a multiselect query with the use of parameter. in my report i am using $x{IN,ADMIN1,admins} but getting error that wrong type java.lang.string for parameter admins, admins should be an array or collection. parameter admins: class: java.util.Collection Default Value Expression: "select admin from sccp_raw group by admin"

Here is the solution: 1. login to jasperserver. 2. Go to View-->Repositry 3. Right click on Reports-->Add Resource-->File-->jrxm 4. Choose below: a. Type of File: JRXML b. Upload subreport.jrxml from your system (if more then one subreports then upload one by one after you complete procedure of uploading frist jrxml file.) c. Give a name for your jrxml file in name field. (In my case i gave name as report8_subreport1, report8_subreport2 and report8_subreport3 d. save loacation: /reports and click on submit. 5. After you upload all subreports now its time to edit subreport dir in main.jrxml file. Follow the steps below. Note. Name given to subreport jrxml files is actually should be involved in jrxml dir path. so here our path of subreports should follow below patterns: "repo:/reports/<name_of_subreport>" so in my case this path will be : "repo:/reports/report8_subreport2" so in main.jrxml file i will have to mention like below: <subreportExpression><![CDATA["repo:/reports/report8_subreport1"]]></subreportExpression> <subreportExpression><![CDATA["repo:/reports/report8_subreport2"]]></subreportExpression> <subreportExpression><![CDATA["repo:/reports/report8_subreport3"]]></subreportExpression> Be noted that in DefaultValueExpression field we need to give local path of our system where main.jrxml file is saved. for reference i am also attaching my main.jrxml file here (report10-Copy.jrxml) 6. Now once editing of main.jrxml is done again follow the steps that were used to upload subreport.jrxml files. 7. Now its time to create a link with database to run our report: a. Go to report-->Add Resource-->JasperReport b. Give a name to report (this name will be the link to run your report) c. choose "select a jrxml from repositry" and under brouse in "Reports" you can find your main.jrxml file as a namethat was choosen by you while uploaded main.jrxml. d. click on datasource and choose a database connection from which you are retrieving the report. e. Click on submit. Now your report is ready to run. Just click on link of you final setup (will appear under "Reports") and your report will run. "HAVE FUN"

Hi I have changed path as suggested by you and now it says:- "Repository file resource ////reports////subreports////report8_subreport1.jrxml could not be loaded" My jrxml file entry is as below: $P{REPORT_CONNECTION} "repo:////reports////subreports////report8_subreport1.jrxml"

Hi Attached is the copy of my jasper report which has 3 subreports in it. While running it I am getting below errors: Please help to crossveryfy the rxml and let me know if this error is due to subreport path or I need any other modification ? Error Message com.jaspersoft.jasperserver.api.JSException: Error filling report Error Trace com.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1030) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:211) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:733) 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:695) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1474) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:874) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:754) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:329) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:359) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:287) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:457) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:337) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:273) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:144) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) ... 9 more Error Message net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml Error Trace net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:329) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:359) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:287) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:457) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:337) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:273) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:144) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:733) 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:695) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1474) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:874) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:754) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)

Hi Updated SUBDIR path as :- <subreportExpression class="java.lang.String"><![CDATA["C://Users//ukhare//Desktop//report//report8_subreport2.jasper"]]></subreportExpression> Now getting below error: The server has encountered an error. Please excuse the inconvenience. Error Messagenet.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist. Error Tracenet.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:646) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:661) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148) at Updated main jrxml is also attached.

Hi I am trying to populate a report using jasperserver. My main report has 3 subreports while running this report on ireport it works fine but in jasperserver it is throwing below exceptions: The server has encountered an error. Please excuse the inconvenience. Error Messagecom.jaspersoft.jasperserver.api.JSException: Error filling report Error Tracecom.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1030) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:211) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:733) at Error Messagenet.sf.jasperreports.engine.JRException: Resource not found at : report8_subreport1.jasper Error Tracenet.sf.jasperreports.engine.JRException: Resource not found at : report8_subreport1.jasper at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:329) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:359) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate Attaches is my main.jrxml file. be noted that when giving subreports parameter as $P{SUBREPORTS_DIR} + "report8.subreport.jasper" ---> Its throwing DATABASE_TIMEZONE error. so by both methods I am getting error. Please suggest a possible modification.