Open Reports JXLS and Column Alias

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
http://sourceforge.net/projects/oreports/forums/forum/187722/topic/1913461

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.