how could i generate a report uing with Hibernate Annotation POJO's

[vseerla]

i am trying to generate a report using with hibernate annotaion pojo's

the following query trying to execute...

select mo.currentTask as currentTak,count(*) as total from MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2010' and lower(mo.status) in ('in-effect','cancel-complete','complete') group by mo.curentTask

 

but i am gettig Error:,expected in SELECT[select mo.currentTask as currentTak,count(*) as total from com.ngb.persist.entity.MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2010' and lower(mo.status) in ('in-effect','cancel-complete','complete') group by mo.curentTask]

 

please do the needful....

thanks in advance

venkat