Recently I tried doing a report in Open Reports using JXLS. In my query I had used alias for columns and these columns would just not appear in the result.
After digging in the sourceforge forums I found this thread
It tells us that it is a problem with mysql connector and we should use “?useOldAliasMetadataBehavior=true” after the jdbc url
This is what is mentioned in the post.
Most likely you must be using MySQL Connector/J 5.1.x and it must be due to some upgrade issues http://dev.mysql.com/doc/refman/5.0/en/connector-j-installing-upgrading.html#connector-j-installing-upgrading-5-1 , but it worked for me when I put ?useOldAliasMetadataBehavior=true at the end of connection url in DataSources, so when you specify connection url for datasources it should look like jdbc:mysql://serverName:3306/databaseName?useOldAliasMetadataBehavior=true
Finally it works.