Unknown column error after publish to Jasperserver

[manshack_one]

I created a very simple report in iReport. Here's the query:

SELECT
call_detail.`Unit` AS call_detail_Unit,
call_detail.`DialedNumber` AS call_detail_DialedNumber,
call_detail.`Rate` AS call_detail_Rate,
call_detail.`Minutes` AS call_detail_Minutes,
call_detail.`Last` AS call_detail_Last,
call_detail.`First` AS call_detail_First,
call_detail.`Revenue` AS call_detail_Revenue,
call_detail.`Commission` AS call_detail_Commission
FROM
`call_detail` call_detail
WHERE
call_detail.`call2` LIKE "Complete"

It compiles and runs fine in iReport. However, when I publish it to jasperserver and try to run it I get this error:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Unknown column name : call_detail_Unit

Both iReport and jasperserver are pointing to the same datasource. I have a feeling it's something to do with the alias it's using. However I've tried changing the query to leave out the alias's and the dot notation on the columns and get the same error. I've also tried creating the report and instead of pushing it to the server, going into jasperserver and pulling it in using the new report wizard. Same result either way. How do I get them to talk to the database the same way?

[manshack_one]

no ideas? Seems like it would be a common problem.

[elvermg]

 I have the same error, please help!!!

Thanks in advance...