I have an adhoc report where we would like to include more than 100 columns and export it as Excel/CSV for analysis. However, whenever I add more than 100 columns, the report's resultset suddenly becomes 0 rows and no data is returned. I have turned my log4j debug level up to DEBUG, but no new error message appears in the log file. I did extract the SQL query from the log files and the query is valid and returns 16 rows with 100+ columns when run directly against mysql. However, the adhoc tool still displays no data in the report's output.


Is there a maximum number of columns in an adhoc report? If so, is the limit 100 columns?