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

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 , 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.