not familiar with SSRS. my fav of that bunch is Sisense, and n.b. I would always recommend setting up a local database (mysql or otherwise) server to pull the data via ODBC on a periodic basis (daily, weekly, whatever is needed), and then running your reports off of the local db - much faster