Hi,

i am trying to generate a report using hibernate

the following query is in the JRXM file...

select mo.currentTask, count(*) from MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2011'
and lower(mo.status) in('in_effect','cancel_completed','completed') group by mo.currenttask


after excecuting the report in IReport Tool or jasperserver ... i am getting the following exception

net.sf.jasperreports.engine.JRRuntimeException : Unknown HQL return alias "currentTask"

I got a solution proublem is i query

we need to modify the HQ query

select count(mo) as total, mo.currentTask from MasterOrder as mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2011'
and lower(mo.status) in('in_effect','cancel_completed','completed') group by mo.currenttask