Connect a linked server to MS Reporting Service? I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server? 

How do I connect it to Reporting Services?
I don't see any problems generating reports the usual way, as long as you use the 4 part name:
'select top 10 col1, col2 from server.database.schema.table' in the code used to get the data for your reports.