I am calling JasperReport from a
servlet. I am sending two strings as parameters. The report fails and returns this message:
SystemOut O 5/1/2008
SystemOut O 5/5/2008
SystemOut O net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query :
Select ftdatem, task, webprddt6.resmngt3.projindex, jobno, assigned, hours2, remhours From webprddt6.resmngt3 Join webprddt6.resmngt2 On webprddt6.resmngt3.projindex = webprddt6.resmngt2.recseq Join webprddt6.resmngt3b On webprddt6.resmngt3b.taskindex = webprddt6.resmngt3.recseq Where deptno = ? And ftdatem >= ? And ftdatem < ? Group By ftdatem, task, webprddt6.resmngt3.projindex, jobno, assigned, hours2, remhours Order By ftdatem
This is my Select
string:
Select ftdatem, task, webprddt6.resmngt3.projindex, jobno, assigned, hours2, remhours From webprddt6.resmngt3 Join webprddt6.resmngt2 On webprddt6.resmngt3.projindex = webprddt6.resmngt2.recseq Join webprddt6.resmngt3b On webprddt6.resmngt3b.taskindex = webprddt6.resmngt3.recseq Where deptno = $P{deptno} And ftdatem >= $P{sd1} And ftdatem < $P{fd1} Group By ftdatem, task, webprddt6.resmngt3.projindex, jobno, assigned, hours2, remhours Order By ftdatem