I'm using mySql, using the latest jdbc driver, I've created a query on a data source, and it previews fine. Everything I expected. However, on the right side, under data sets the query doesn't show any of the columns from the table. I need the individual columns so I can drag them onto my report. If I use a text or number field directly, the fields will not show there either.

I've attached a picture of my data source.Name:  Screen Shot 2017-09-07 at 2.22.51 PM.png
Views: 67
Size:  10.9 KB

I've already done some searching and the only issue I found was adding a limit statement to the sql query (which I did), and to make sure your mysql jdbc driver is up to date and installed, which it is.

Thank you,
Valeri