harish0191

I am using iReport 5.6.0. i have generated few reports using it in the past week. Now nothing is possible to do with that. I set jdkhome="C:/Program Files/Java/jdk1.7.0_79" in ireport.conf file. Eventhough the issue exists. Please can anyone provide solution Thanks and regards, Harish Selvaraj

i have tried giving value in different format but nothing is working out #example 1default value of $P{From_Date} : new java.util.Date(2010,01,01)default value of $P{To_Date} : new java.util.Date(2016,11,11)#example 2 $P{From_Date} : 1.1.2013$P{To_Date} : 11.11.2016QUERY:selecttbl1.cantReqNo as OrderNumb, tbl2.empname as Employee,tbl1.canteen as ServicePlace, convert(datetime,tbl1.serviceDate,103) as ServiceDate,tbl3.itemName as FoodItem, tbl1.totalAmt as Cost,tbl1.status as Status,tbl4.deptname as DepartmentfromcanteenRequisition tbl1 , employee tbl2,canteenRequstionDetails tbl3, department tbl4wheretbl1.empNo=tbl2.empno and tbl1.cantReqNo=tbl3.cantReqNo and tbl4.Deptid=tbl1.createdDept and tbl1.empNo=200045 and replace(tbl1.canteen,' ','')= 'sitecanteen'and tbl1.serviceDate > $P{From_Date} and tbl1.serviceDate < $P{To_Date}group bytbl1.cantReqNo, tbl2.empname ,tbl1.canteen ,tbl1.serviceDate,tbl3.itemName , tbl1.totalAmt,tbl1.status,tbl4.deptname

i have found solution ... there was compile error because duplicate jrxml files

Compiling to file... C:Usersswdevreport1.jasper Errors compiling C:Usersswdevreport1.jasper! Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@750edae4 net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:calculator_report1_1479814685364_290597: 164: expecting ')', found 'of' @ line 164, column 30.1 error at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:113) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:201) at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:354) at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:270) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:563) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:528) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:calculator_report1_1479814685364_290597: 164: expecting ')', found 'of' @ line 164, column 30.1 error at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:302) at org.codehaus.groovy.control.ErrorCollector.addFatalError(ErrorCollector.java:149) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:119) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:131) at org.codehaus.groovy.control.SourceUnit.addError(SourceUnit.java:359) at org.codehaus.groovy.antlr.AntlrParserPlugin.transformCSTIntoAST(AntlrParserPlugin.java:141) at org.codehaus.groovy.antlr.AntlrParserPlugin.parseCST(AntlrParserPlugin.java:107) at org.codehaus.groovy.control.SourceUnit.parse(SourceUnit.java:236) at org.codehaus.groovy.control.CompilationUnit$1.call(CompilationUnit.java:161) at org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:900) at org.codehaus.groovy.control.CompilationUnit.doPhaseOperation(CompilationUnit.java:564) at org.codehaus.groovy.control.CompilationUnit.processPhaseOperations(CompilationUnit.java:540) at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:517) at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:109) ... 7 more[/code]