2

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?

1
  • In your comment below you mention Report Model, there is a good bit of difference between a Report Model project and a Report Server project. Jan 27, 2011 at 17:20

2 Answers 2

3

You can create a stored procedure which selects the desired data and call it from your report as you call any other procedure. If you want to avoid having stored procedure just put the query directly into the report. You do need to use Mysql provider, just use a sql provider.

3

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.

1
  • But, when I create a Report Model project, I don't seem to have the option to use my connection to MYSQL as a data source? I only seem to have two provider options - 'SQLClientDataProvider' and 'OracleClientDataProvider'. Jan 24, 2011 at 12:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.