k_tripura

I fixed it myself, It is all good now I resolved this issue finally ... The reason why it was throwing error is My iReport Langauge property is set to "Groovy" instead of "Java" NOT in tools-> Options-> Language- Java BUT for Language in Activity Report Properties ->Language ->Java (THIS IS THE CHANGE that resolved my issue)

I resolved this issue finally ... The reason why it was throwing error is My iReport Langauge property is set to "Groovy" instead of "Java" NOT in tools-> Options-> Language- Java BUT for Language in Activity Report Properties ->Language ->Java (THIS IS THE CHANGE that resolved my issue)

$X{IN, MyColumn, MyCollectionParameter} --- this in not working for me in 5.0.4 version of iReport, I have been struggling to fix it I am trying with a very basic select query. Still no luck so far, Any help mdahlman???

$X{IN, MyColumn, MyCollectionParameter} --- this in not working for me in 5.0.4 version of iReport, I have been struggling to fix it

Added the error details

I changed my report completely and now this is where I stand My client_list variable in iReport is a collection and is using something like this new ArrayList(Arrays.asList(new String[] {"test"})) I changed my client_list variable name in Jasper Server to a "Multi-Select Query" and added the query and it is populating all the entries from the database (which is a good sign) Now when I run the report, I am able select the begin_date, end_date and multiple clients But When I click OK, I am getting the below error The server has encountered an error. Please excuse the inconvenience. Error Message net.sf.jasperreports.engine.JRRuntimeException: No clause function for id IN found Error Trace net.sf.jasperreports.engine.JRRuntimeException: No clause function for id IN found at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.resolveFunction(JRAbstractQueryExecuter.java:288) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.appendClauseChunk(JRAbstractQueryExecuter.java:531) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.appendQueryChunk(JRAbstractQueryExecuter.java:383) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.parseQuery(JRAbstractQueryExecuter.java:358) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.(PlSqlQueryExecuter.java:96) at com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory.createQueryExecuter(PlSqlQueryExecuterFactory.java:108) at net.sf.jasperreports.engine.util.JRQueryExecuterUtils$WrappingQueryExecuterFactory.createQueryExecuter(JRQueryExecuterUtils.java:155) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1083) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) 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:859) 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:821) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1622) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1005) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:881) 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:722) I am not able to understand this error and what they mean? (I can post the screen shots if the can help to give better picture)

I tried it all ready and I did some more changes too. still I am not able to execute the query in iReport using $X{} format I can post that changes here, can you take a look at it?

I tried it all ready and I did some more changes too. still I am not able to execute the query in iReport using $X{} format

You are trying to set a string value to TimeZone variable amma. If you want a TimeZone variable, check for TimeZone API and see how to pass string value to it. hope that helps.

un-installing everything, clearing the registry entities and reinstalling in root directory and setting up Java_Home solved my issue.

Few things that you need to check 1>Is Title on a new page check box checked ? 2>Is your Summary on a new page check box checked? 3> Is there too much empty space in you design view between footer and detail bands, If yes take out the extra spaces between footer and detail bands. Hope any of the helps to resolve the issue and that too much empty space on the left side of the page is intentional?

I am not sure if this answer helps but just adding my points(hope it help) In your iReport , go to Tools-> Options -> Compilation and execution -> Look for Reprot Time Zone, may be it is creating conflict with yours, do you need to override it or something

Have you tried increasing the width of your report, I mean Page Width in the properties section (in iReport)

Have you tried using $V{PAGE_NUMBER} in the footer and update your "Evaluation Time" and "Evaluation Group" accordingly and it should work ( I guess) Or you need to create a new "Text Field" and define the grouping and use page_number

Hi What Ankur.gupta.aug said is correct, you need to have groups and Look at this video This has the step by step approach to create subtotal I tested the appraoch mentioned in the video and it work like a charm.. Good luck