[iReport 5.6.0 hanging issue]

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

[error in passing date value in sql query - not executing]

i have tried giving value in different format but nothing is working out

 

#example 1

default 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.2016

QUERY:

select

tbl1.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 Department

from

canteenRequisition tbl1 , employee tbl2,canteenRequstionDetails tbl3, department tbl4

where

tbl1.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 by

tbl1.cantReqNo, tbl2.empname ,tbl1.canteen ,tbl1.serviceDate,

tbl3.itemName ,  tbl1.totalAmt,tbl1.status,tbl4.deptname

 

 

[my first report is not able to run.. please help me. i have mention error below]

i have found solution ...

there was compile error because duplicate jrxml files

 

[my first report is not able to run.. please help me. i have mention error below]

 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]